Question 16 of 32beginner🔧 ApplyShort Answer1 mark

Show the structure of the table TEAM using a SQL statement.

Correct Answer

DESCRIBE TEAM;

OR

DESC TEAM;

Exercise: EXERCISE | Q: 4(d) | (Page 48)
For More Understanding

Explanation

The textbook explains in section 9.4.3 that we can view the structure of an already created table using the DESCRIBE statement or DESC statement. The syntax is 'DESCRIBE tablename;' where tablename is the name of the table whose structure we want to view. Since the question asks to show the structure of the TEAM table, the correct SQL statement would be 'DESCRIBE TEAM;' or its short form 'DESC TEAM;'.

Solution Steps

  1. Step 1: Identify the command to view table structure - DESCRIBE or DESC

  2. Step 2: Apply the syntax by adding the table name 'TEAM' after the command

PreviousNext