1Z0-062 · Question #15
1Z0-062 Question #15: Real Exam Question with Answer & Explanation
The correct answer is A: The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible. Explanation: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 DESCRI
Question
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.
Explanation
Explanation: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 SQL*Plus * %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.
Community Discussion
No community discussion yet for this question.