1Z0-149 Web TestEngine demo

Examine these statements from a block of code:

Which two are true? (Choose two.)

Select all that apply.

• A

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

• B

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

• C

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

• D

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

• E

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