COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following SQL clauses is used to DELETE tuples from a database table?
|
DELETE
|
|
REMOVE
|
|
DROP
|
|
CLEAR
|
Explanation:
Detailed explanation-1: -The DELETE statement is used to delete existing records in a table.
Detailed explanation-2: -The DELETE Statement in SQL is used to delete existing records from a table.
Detailed explanation-3: -Detailed Solution. The correct answer is Drop. DROP-It is a Data Definition Language(DDL) Command which is used to delete, tables, views, triggers, etc from a database. A DROP statement in SQL removes a component from a relational database management system (RDBMS).
Detailed explanation-4: -The DROP TABLE statement is used to drop an existing table in a database.
There is 1 question to complete.