Structure of the ORDERS table

-Which of the following statements can be used to view the structure of the ORDERS table?
A) SELECT * FROM orders;
B) LIST ORDERS;
C) DESCRIBE ORDERS
D) none of the above

Question

Structure of the ORDERS table
 
-Which of the following statements can be used to view the structure of the ORDERS table?​
A) ​SELECT * FROM orders; 
B) ​LIST ORDERS; 
C) ​DESCRIBE ORDERS 
D) ​none of the above

Quizplus · Accepted Answer

The correct statement to view the structure of a table in SQL is "DESCRIBE table_name". Therefore, option C is the correct answer. Option A will display all the data in the table, while option B is not a valid SQL statement. Option D is also incorrect as at least one of the given options is correct.

Structure of the ORDERS Table