Oracle Database 11g: Program with PL/SQL — Question 25

Which statement is true about transactions in PL/SQL?

Answer options

• A. A transaction can span multiple blocks.
• B. A block can contain only a single transaction.
• C. SERVERPOINTS cannot be created in a PL/SQL block.
• D. The END keyword signals the end of a PL/SQL block and automatically commits the transaction in the block.

Correct answer: A

Explanation

Option A is correct because a transaction in PL/SQL can indeed span multiple blocks, allowing for more complex operations. Option B is incorrect as a block can encompass multiple transactions. Option C is wrong since SERVERPOINTS can be created in a PL/SQL block. Finally, option D is also incorrect because the END keyword does not automatically commit the transaction; explicit commit statements are required.