MCQ IN COMPUTER SCIENCE & ENGINEERING

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?
A
DELETE
B
REMOVE
C
DROP
D
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.