Oracle Database Administration I — Question 12

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

Answer options

• 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

Correct answer: B, C, D

Explanation

The correct answers are B, C, and D because the DESCRIBE command can indeed be executed in SQL Developer, shows NOT NULL constraints, and reveals the structure of views. Options A and E are incorrect as they pertain to specific constraints that are not displayed by the DESCRIBE command, and option F is wrong since the command is not limited to SQL*Plus.