nerdexam
Oracle

1Z0-082 · Question #93

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

The correct answer is 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 F. It can be used only from SQL*Plus. See the full explanation below for the reasoning.

SQL and PL/SQL

Question

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

Options

  • AIt displays the PRIMARY KEY constraint for any column or columns that have that constraint
  • BIt can be used from SQL Developer
  • CIt displays the NOT NULL constraint for any columns that have that constraint
  • DIt can be used to display the structure of an existing view
  • EIt displays all constraints that are defined for each column
  • FIt can be used only from SQL*Plus

How the community answered

(24 responses)
  • A
    4% (1)
  • B
    13% (3)
  • C
    75% (18)
  • E
    8% (2)

Topics

#DESCRIBE command#SQL*Plus#table structure#NOT NULL constraint

Community Discussion

No community discussion yet for this question.

Full 1Z0-082 Practice