Examveda
Examveda

Which SQL statement is used to delete data FROM a database?

A. COLLAPSE

B. REMOVE

C. ALTER

D. DELETE

Answer: Option D

Solution(By Examveda Team)

The SQL statement used to delete data from a database is DELETE. Here's a brief explanation of each option:

Option A: COLLAPSE
There is no standard SQL command called COLLAPSE for deleting data from a database.

Option B: REMOVE
REMOVE is not a standard SQL command used for deleting data. It's not typically used in SQL for data deletion.

Option C: ALTER
The ALTER command is used to modify the structure of a database, such as adding, modifying, or deleting columns. It is not primarily used for data deletion.

Option D: DELETE
The DELETE command is specifically designed to remove rows or records from a database table based on specified conditions.

So, the correct SQL statement to delete data from a database is Option D: DELETE.

This Question Belongs to SQL >> Sql Miscellaneous

Join The Discussion

Related Questions on Sql Miscellaneous