Which two statements are true about the %ROWTYPE attribute? (Choose two.)
A. It is used to declare a record that can hold multiple rows of a table.
B. The attributes of fields in the record with the %ROWTYPE attribute can be modified manually.
C. The attributes of fields in the record take their names and data types from the columns of the table, view, cursor, or cursor variable.
D. It ensures that the data types of the variables that are declared with the %ROWTYPE attribute change dynamically when the underlying table is altered.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
I also think that CD are correct
Reference:
https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/rowtype_attribute.htm#LNPLS01342
Not A: “The %ROWTYPE attribute lets you declare a record that represents a row in a table or view.” Not multiple rows
C: “For each column in the referenced table or view, the record has a field with the same name and data type. ”
D: “If the referenced item table or view changes, your declaration is automatically updated. You need not change your code when, for example, columns are added or dropped from the table or view.”