MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The command to eliminate a table from a database is:
A
REMOVE TABLE CUSTOMER;
B
DROP TABLE CUSTOMER;
C
DELETE TABLE CUSTOMER;
D
UPDATE TABLE CUSTOMER;
Explanation: 

Detailed explanation-1: -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.

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

Detailed explanation-3: -The command to remove rows from a table customer is Delete from customer where. The SQL DROP TABLE statement is used to delete a table definition as well as all associated data, indexes, triggers, constraints, and permissions.

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

Detailed explanation-5: -To delete an entire table including all of its rows, issue the drop table command followed by the tablename. drop table is different from deleting all of the records in the table. Deleting all of the records in the table leaves the table including column and constraint information.

There is 1 question to complete.
Previous
Next