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:
|
|
REMOVE FROM CUSTOMER ____
|
|
|
DROP FROM CUSTOMER ____
|
|
|
DELETE FROM CUSTOMER WHERE ____
|
|
|
UPDATE FROM CUSTOMER ____
|
Explanation:
Detailed explanation-1: -Detailed Solution. All rows in the table will be deleted using the SQL TRUNCATE command. A where clause cannot be used in this.
Detailed explanation-2: -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.
Detailed explanation-3: -The DELETE command is used to delete existing records in a table.
There is 1 question to complete.