COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Drop table statement
|
|
deletes the table structure only
|
|
|
deletes the table structure along with the table data
|
|
|
works whether or not referential integrity constraints would be violated
|
|
|
is not an SQL statement
|
Explanation:
Detailed explanation-1: -We use the SQL DROP Table command to drop a table from the database. It completely removes the table structure and associated indexes, statistics, permissions, triggers and constraints. You might have SQL Views and Stored procedures referencing to the SQL table.
Detailed explanation-2: -The DROP TABLE statement is used to drop an existing table in a database.
Detailed explanation-3: -Option e is correct. The table structure and its deleted data cannot be rolled back and restored once the DROP TABLE command is executed.
There is 1 question to complete.