What is the advantage of using the %ROWTYPE datatype? – McqOptions

MCQOPTIONS

1.	What is the advantage of using the %ROWTYPE datatype?
A.	It is useful to retrieve an entire row from a table. If you do not use the %ROWTYPE datatype, then you have to declare variables for each column separ
B.	It can be used even if data type of the table columns is not known.
C.	It ensures that data type of the variable changes dynamically if the underlying table is altered.
D.	All mentioned above
E.	Both A & B
Answer» E. Both A & B

Discussion

No Comment Found

Related MCQs

Which operations cannot be performed on cursor expressions?
Which Operator Returns TRUE if a subquery returns at least one row?
Which operator tests set membership?
Which operators combine the results of two queries into one result?
Which Package lets you use database triggers to alert an application when specific database values change?
Which package lets PL/SQL programs read and write operating system (OS) text files?
Which parameter acts like a constant inside the subprogram?
Which PL/SQL warning categories gives Messages for conditions that do not have an effect on performance or correctness, but that you might want to change to make the code more maintainable, such as unreachable code that can never be executed?
Which statement associates a cursor variable with a multi-row query, executes the query, and identifies the result set?
Which statement chooses from a sequence of conditions, and executes a corresponding statement?