Question

You need to remove all the data from the employee table while leaving the table definition intact. You want to be able to undo this operation. How would you accomplish this task? Select one: a. Delete from employee; b. This task cannot be accomplished. C. Drop table employee; d. Truncate table employee;

Answer 1

Answer:

Option (b) DELETE FROM Employee

Explanation:

The DELETE statement is used in SQL to remove rows from the table permanently. It is a DML statement. This statement has a simple syntax:

                      DELETE FROM table_name

                      Where condition;

A WHERE clause can be used to remove some rows from your table. If no WHERE condition is specified all rows will be removed.

For example, we can delete a specific employee from the table:

                      DELETE FROM Employees

                      Where ID= 1

DELETE FROM Employees will leave an empty table. It still exist but hold no records.

Answer 2

Answer:

Delete from employee;

Explanation: