1Z0-060 · Question #22
Examine the following command: Which three statements are true about using an invisible column in the PRODUCTS table?
The correct answer is A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output. E. A primary key constraint can be added on the invisible column. AB: You can make individual table columns invisible. Any generic access of a table does not show the invisible columns in the table. For example, the following operations do not display invisible columns in the output: SELECT FROM statements in SQL DESCRIBE commands in SQLPlus…
Question
Examine the following command:
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 column
- 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.
How the community answered
(36 responses)- A94% (34)
- C3% (1)
- D3% (1)
Explanation
AB: You can make individual table columns invisible. Any generic access of a table does not show the invisible columns in the table. For example, the following operations do not display invisible columns in the output: *SELECT * FROM statements in SQL DESCRIBE commands in SQLPlus *%ROWTYPE attribute declarations in PL/SQL *Describes in Oracle Call Interface (OCI) Not D: You can make invisible columns visible. You can make a column invisible during table creation or when you add a column to a table, and you can later alter the table to make the same column visible.
Topics
Community Discussion
No community discussion yet for this question.