1Z0-149 Practice Questions - Oracle Database Program With PL SQL (1Z0-149) Exam

Which statement about anchored declarations using %TYPE is correct?

%TYPE copies the column data type but not NOT NULL constraints or default values %TYPE inherits NOT NULL constraints and default values from the referenced column %TYPE can only be used to reference local PL/SQL variables, not table columns %TYPE evaluates the data type once at compile time and freezes it permanently

Correct Answer:

%TYPE copies the column data type but not NOT NULL constraints or default values

Access more questions from this quiz

Continue to 1Z0-149 Practice Questions - Oracle Database Program with PL SQL (1Z0-149) Exam for more practice questions and the full quiz experience.

Access More Questions