Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Location Chicago IL, USA

Exam 1z0-071 topic 2 question 35 discussion

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

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

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

Suggested Answer: ABF

Comments

feiyu
Highly Voted 1 year, 1 month ago
ADF is correct.
upvoted 24 times
...
teja11
Highly Voted 1 year ago
ADF is correct.
upvoted 7 times
...
foxygrandpa
Most Recent 4 days, 14 hours ago
D is not correct. The DEFINE command can be used in SQL Plus and SQL Developer. Not exclusively one or the other.
upvoted 1 times
foxygrandpa
4 days, 14 hours ago
Meant to say B
upvoted 1 times
...
...
Eli93
4 months, 4 weeks ago
I think it's B and not D
upvoted 1 times
...
narizudo
10 months, 2 weeks ago
ADF correct
upvoted 2 times
...
silsilgn
10 months, 4 weeks ago
Yep ADF is correct
upvoted 5 times
silsilgn
10 months, 4 weeks ago
DESCRIBE gives you a list of columns in the table or view, along with its resulting datatypes, lengths, and nullability. If you need to know more, such as whether a column has a default value, you will need to query the data dictionary directly.
upvoted 2 times
...
...

SaveCancel