MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which command will delete your table from the database?
A
DROP
B
DELETE
C
TRUNCATE
D
MERGE
Explanation: 

Detailed explanation-1: -Syntax. DROP TABLE table name; Note: Be careful before dropping a table. Deleting a table will result in loss of complete information stored in the table!

Detailed explanation-2: -DROP is a Data Definition Language (DDL) command which removes the named elements of the schema like relations, domains or constraints and you can also remove an entire schema using DROP command.

Detailed explanation-3: -The DROP DATABASE command is used to delete an existing SQL database.

Detailed explanation-4: -The DELETE command deletes one or more existing records from the table in the database. The DROP Command drops the complete table from the database.

There is 1 question to complete.