Database-Management-System

Question 409

Which of the following statements about the “DELETE” command is FALSE?

A	It removes tuples from a relation (table).
B	It removes tuples as well as the relation (table).
C	A missing WHERE clause specifies that all tuples in the relation are to be deleted.
D	Depending on the number of tuples selected by the condition in the WHERE clause, zero, one or several tuples can be deleted by a single DELETE command.

Database-Management-SystemSQLCIL Part – B

Question 409 Explanation:

→The DELETE statement is used to delete existing records in a table.
→DELETE Syntax
DELETE FROM table_name WHERE condition;

Correct Answer: B

Question 409 Explanation:

→The DELETE statement is used to delete existing records in a table.
→DELETE Syntax
DELETE FROM table_name WHERE condition;