ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam
Go to Exam

Exam 1z0-062 topic 1 question 34 discussion

Actual exam question from Oracle's 1z0-062
Question #: 34
Topic #: 1
[All 1z0-062 Questions]

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? (Choose three.)

  • A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
  • B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
  • C. Referential integrity constraint cannot be set on the invisible column.
  • D. The invisible column cannot be made visible and can only be marked as unused.
  • E. A primary key constraint can be added on the invisible column.
Show Suggested Answer Hide Answer
Suggested Answer: ABE 🗳️
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)
Incorrect:
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.
References:
by _gio_ at Oct. 1, 2021, 1:14 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
sela
2 years, 4 months ago
a,b,e correction 12C New Feature : Invisible Columns (Doc ID 1566790.1) https://oracle-base.com/articles/12c/invisible-columns-12cr1
upvoted 1 times
...
sela
2 years, 4 months ago
a,d,e 12C New Feature : Invisible Columns (Doc ID 1566790.1) https://oracle-base.com/articles/12c/invisible-columns-12cr1
upvoted 1 times
...
jackymak
3 years ago
If the column cannot be found by DESCRIBE, how do I know the invisible column is invisible but not 'not existed'
upvoted 1 times
jackymak
3 years ago
SQL> SET COLINVISIBLE ON SQL> DESC tab1
upvoted 1 times
...
...
_gio_
3 years, 4 months ago
I have tried to reference with foreign key constraint a invisible columns and it works
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago