MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The command to remove rows from a table ‘CUSTOMER’ is ____
A
DROP FROM CUSTOMER
B
UPDATE FROM CUSTOMER
C
REMOVE FROM CUSTOMER
D
DELETE FROM CUSTOMER WHERE
Explanation: 

Detailed explanation-1: -To remove rows from a table, use the DELETE command. You can use the DELETE command to remove specific rows or all rows from a table. To delete rows, specify the table and an optional search condition (WHERE) that specifies which rows to delete.

Detailed explanation-2: -We can also use the TRUNCATE command to delete all the records from a table.

Detailed explanation-3: -The DROP TABLE statement is used to drop an existing table in a database.

There is 1 question to complete.