Oracle Exam 1Z0-149 Topic 1 Question 8 Discussion

Actual exam question for Oracle's 1Z0-149 exam

Question #: 8
Topic #: 1

Examine these statements from a block of code:

Which two are true? (Choose two.)

AThe lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.

BOnly the PRICE column can be updated in the PRODUCTS table.

CThe FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.

DThe WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.

EAn OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.

Show Suggested Answer

Suggested Answer: A, D

by Lucina at Apr 24, 2023, 07:11 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!