Multiple choice technology databases

The Syntax to declare a record of a User-defined datatype is:

  1. table_name record_type_name;

  2. column_name record_type_name;

  3. record_type_name record_name;

  4. record_name record_type_name;
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In PL/SQL record declarations, the syntax follows the pattern 'record_name record_type_name' where the variable name comes first, followed by its type. This is consistent with how other variables are declared in PL/SQL.

Keep practicing — related questions