Examine these statements from a block of code:

Which two are true? (Choose two.)

• A.The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.
• B.The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
• C.Only the PRICE column can be updated in the PRODUCTS table.
• D.An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
• E.The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.

Comment: *

Name: *

Email: *

Verification: *