Question

The ____________________ TABLE command can be used to delete and release the storage space of all data contained in a database table, while still retaining the table's structure.

a) DROP
b) CREATE
c) ALTER
d) UPDATE

Answer 1

The TRUNCATE TABLE command is used to remove all data from a database table while retaining its structure. It is different from the DROP command which completely removes the table and schema.

Step-by-step explanation:

The command used to delete and release the storage space of all data contained in a database table, while still retaining the table's structure, is the TRUNCATE TABLE command. Unlike the DROP command, which removes the table and its structure from the database, the TRUNCATE TABLE command deletes all rows from a table, but the table itself remains with its schema unchanged. This is particularly useful when you want to clear all records from a table without affecting the table's design and constraints.