Q17
Which SQL statement is used to delete data FROM a database?
A.
COLLAPSE
B.
REMOVE
C.
ALTER
D.
DELETE
AnswerAnswer: Option D
Solution
Answer: Option D
Solution:
The SQL statement used to delete data from a database is DELETE. Here's a brief explanation of each option:Option A:
COLLAPSEThere is no standard SQL command called
COLLAPSE for deleting data from a database.Option B:
REMOVEREMOVE is not a standard SQL command used for deleting data. It's not typically used in SQL for data deletion.Option C:
ALTERThe
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:
DELETEThe
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.