Multiple choice technology databases

%ROWTYPE attribute is used to declare a variable and associate it's data type with the TABLE/CURSOR object.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

%ROWTYPE attribute declares a variable that inherits the entire row structure from a table or cursor, including all column names and data types. This provides automatic synchronization if the table structure changes.

AI explanation

The %ROWTYPE attribute lets you declare a PL/SQL variable (usually a record) whose structure automatically matches the columns of a specified table or the columns returned by a cursor. This is convenient because the variable's shape stays in sync with the underlying table or cursor definition without you having to list each column and datatype manually, so the statement is true.

Keep practicing — related questions