Machine-translated by Google. Questions are authored in English.
Top

Discussion

To obtain the structure of an Oracle table, the command to use is:

  • A.STRUCTURE [TableName].
  • B.DESCRIBE [TableName].
  • C.DESCRIBE STRUCTURE [TableName].
  • D.DESC TABLE [TableName].

Answer: B

Correct answer: DESCRIBE [ TableName ].

DESCRIBE, or DESC for short, lists the columns of a table or view with their datatypes and whether they accept nulls. It is a SQL*Plus command rather than SQL, so it takes no semicolon, and it works on views and procedures as well as tables.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.