Question 180
An engineer needs the column names and data types of ORDERS. What command directly inspects that object?
Explanation
Correct Answer
Correct: DESCRIBE TABLE column information. DESCRIBE TABLE reports column and related metadata for a specified table.
Incorrect Answers
Not correct for this case: SHOW TABLES lists tables visible to the current role within requested scope; the scenario specifically needs DESCRIBE TABLE column information.
Not correct for this case: INFORMATION_SCHEMA views expose SQL-queryable metadata within a database; the scenario specifically needs DESCRIBE TABLE column information.
Not correct for this case: ACCOUNT_USAGE views provide account-wide historical usage and metadata with documented latency; the scenario specifically needs DESCRIBE TABLE column information.