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: Distinguish between DELETE and DROP.
- DELETE: This command removes rows (data) from a table, but the table's structure is preserved.
- DROP TABLE: This command permanently deletes both the data and the table structure from the database.

Step 2: Evaluate each option.
- Option 1: Incorrect → This action removes records, but the table persists.
- Option 2: Incorrect → The SQL syntax is invalid; "DROP TABLE" must be used.
- Option 3: Correct → This option permanently deletes the table.
- Option 4: Incorrect → The syntax is incorrect (\texttt{DELETE } is not valid SQL).

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