Oracle
1Z0-062 · Question #15
Examine the following command: CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #15. The question stem and answer options stay visible for context.
Managing Schema Objects
Question
Examine the following command:
CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in the PRODUCTS table?
Options
- AThe %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible
- BThe DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
- CReferential integrity constraint cannot be set on the invisible column.
- DThe invisible column cannot be made visible and can only be marked as unused.
- EA primary key constraint can be added on the invisible column.
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Invisible columns#Table creation#PL/SQL %ROWTYPE#Constraints