Oracle Database: Advanced PL/SQL — Question 49

Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)

Answer options

• A. CREATE
• B. DROP
• C. UPDATE
• D. SELECT
• E. DELETE
• F. ALTER
• G. INSERT

Correct answer: C, D, G

Explanation

The correct answers are C (UPDATE), D (SELECT), and G (INSERT) because these operations often involve manipulating or retrieving entire rows from a table, making %ROWTYPE beneficial for handling the data structure. The other options, A (CREATE), B (DROP), E (DELETE), and F (ALTER), either do not require row structures or are not typically associated with the use of %ROWTYPE.