MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The ____ command is used to completely remove a table from the database.
A
INSERT
B
ALTER
C
DROP
D
CREATE
Explanation: 

Detailed explanation-1: -The DROP TABLE statement is used to drop an existing table in a database.

Detailed explanation-2: -The DROP DATABASE command deletes the database contents and log files for the database, uncatalogs the database, and deletes the database subdirectory.

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

Detailed explanation-4: -The SQL DROP TABLE statement is used to remove a table definition and all the data, indexes, triggers, constraints and permission specifications for that table.

There is 1 question to complete.
Previous
Next