Question

Ms Ritika wants to delete the table 'sports' permanently. Help her in selecting the correct SQL command from the following.

• A. DELETE FROM SPORTS;
• B. DROP SPORTS;
• C. DROP TABLE SPORTS;
• D. DELETE FROM SPORTS;

Hint:

Use \texttt{DELETE} for removing rows, \texttt{TRUNCATE} for clearing all rows but keeping structure, and \texttt{DROP TABLE} for permanent deletion.

Answer 1

The Correct Option is C

Step 1: Differentiate between DELETE and DROP.
- DELETE: Removes rows (data) from a table but keeps the table structure intact.
- DROP TABLE: Permanently deletes both the data and the table structure from the database.

Step 2: Check each option.
- Option 1: Incorrect → Removes records, table remains.
- Option 2: Incorrect → Invalid SQL syntax, must use "DROP TABLE".
- Option 3: Correct → Permanently deletes the table.
- Option 4: Incorrect → Wrong syntax (\texttt{DELETE } is not valid SQL).

Final Answer: \[ \boxed{\text{DROP TABLE SPORTS;}} \]