Oracle Database SQL — Question 72

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

Answer options

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

Correct answer: A, D, F

Explanation

The correct answers are A, D, and F because the DESCRIBE command can indeed be executed in SQL Developer, shows NOT NULL constraints, and can display the structure of views. Options B and C are incorrect as DESCRIBE does not provide a comprehensive list of all constraints for each column.