exam questions

Exam 1z0-082 All Questions

View all questions & answers for the 1z0-082 exam

Exam 1z0-082 topic 1 question 35 discussion

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

Which three statements are true about the DESCRIBE command? (Choose three.)

  • A. It displays the PRIMARY KEY constraint for any column or columns that have that constraint
  • B. It can be used from SQL Developer
  • C. It displays the NOT NULL constraint for any columns that have that constraint
  • D. It can be used to display the structure of an existing view
  • E. It displays all constraints that are defined for each column
  • F. It can be used only from SQL*Plus
Show Suggested Answer Hide Answer
Suggested Answer: BCD 🗳️

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
husseinyounes
Highly Voted 4 years, 1 month ago
BCD is the correct ans
upvoted 20 times
SimoneF
3 years, 7 months ago
But F is also definitely true.
upvoted 1 times
SimoneF
3 years, 7 months ago
Sorry my mistake, I didn't read "only". BCD it is :)
upvoted 1 times
...
...
Ekos
3 years, 7 months ago
i agree
upvoted 1 times
...
...
NowOrNever
Highly Voted 3 years, 11 months ago
BCD are correct
upvoted 6 times
...
Oracle2020
Most Recent 3 months ago
I agree BDC, Checked
upvoted 1 times
...
nautil2
9 months, 1 week ago
Selected Answer: BCD
A - FALSE; describe displays only NOT NULL constraint B - TRUE; C - TRUE; see A D - TRUE; e.g. DESC user_cons_columns; E - FALSE; dictionary views USER_CONS_COLUMNS, ALL_CONS_COLUMNS and DBA_CONS_COLUMNS shows constraints, not DESCRIBE F - FALSE; it can be used from SQL Developer
upvoted 1 times
...
Tsie
1 year, 1 month ago
BCD is correct
upvoted 1 times
...
raferen10
1 year, 7 months ago
Selected Answer: BCD
B C D are correct
upvoted 1 times
...
LeandroHPN
1 year, 9 months ago
Selected Answer: BCD
BCD are correct
upvoted 1 times
...
ryuah
2 years, 6 months ago
B,C,D is correct
upvoted 2 times
...
tko86
4 years ago
It can be used in SQL developer as well as SQL Plus. I tried it as well.
upvoted 5 times
...
danito
4 years, 1 month ago
I use describe comand in sqldeveloper, i guess the answers are not totaly right
upvoted 4 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago