Multiple choice

To obtain the structure of an Oracle table, the command used is _______.

  1. STRUCTURE [TableName]

  2. DESCRIBE [TableName]

  3. DESCRIBE STRUCTURE [TableName]

  4. DESC TABLE [TableName]
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The DESCRIBE command (or DESC for short) is the correct SQL*Plus command to display the structure of a table, showing column names, data types, nullability, and other metadata. Option C adds an unnecessary STRUCTURE keyword, and options A and D use incorrect syntax.

Keep practicing — related questions