AMU 2026 — Computer PYQ

• II. DROP (Data Definition Language - DDL):

  This command completely deletes the table definition along with all its data, indexes, triggers, and constraints from the database schema. Once executed, the table ceases to exist.

  $$\text{DROP TABLE table\_name;}$$

  $$\text{Result: Table Structure}=\varnothing ,\text{Table Data}=\varnothing$$

• III. TRUNCATE (Data Definition Language - DDL):

  While TRUNCATE does not delete the structure of the table itself, it instantly removes all rows (data) from the table and deallocates the data pages used by it. Since the structure remains intact, it clears the table rather than removing the table object from the schema.

  $$\text{TRUNCATE TABLE table\_name;}$$

  $$\text{Result: Table Structure remains},\text{Table Data}=\varnothing$$

• I. DELETE (Data Manipulation Language - DML):

  This command is used to remove specific rows from a table using a WHERE clause. Even if you use it without a filter to clear all rows, it processes rows one by one, logs transaction details, and retains the container structure.

  $$\text{DELETE FROM table\_name;}$$

• IV. REMOVE:

  This is not a valid keyword or command in SQL for deleting tables or rows.

Conclusion

• If the question strictly means removing the table object completely from existence, only II (DROP) is correct.

• If the question implies clearing the table's records completely out of the system, both II (DROP) and III (TRUNCATE) satisfy high-speed table resetting operations. Following the pen-mark indication in the reference image, option (b) II and III is targeted by the examiner under the premise of full data-purging actions.