Question

Which of the following keywords is used to remove a row in a table? (Points : 2) DROP

Answer 1

Answer:

DELETE

Explanation:

DELETE keyword is used to remove a row in a table. The actual syntax is as follows:

DELETE from <TableName> where <Condition>;

For example:

DELETE FROM employee where name='Peter';

This will remove employee with the name Peter from the Employee table.

DROP on the other hand is used to delete the entire table without focussing on a particular row.DROP syntax is as follows:

DROP TABLE <TableName>;