COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Create table, Insert into, Drop table
|
|
Alter table, Update, Drop table
|
|
Drop table, Alter table, Create table
|
|
None of the above
|
Detailed explanation-1: -Following are the five DDL commands in SQL: DROP Command. ALTER Command. TRUNCATE Command. RENAME Command.
Detailed explanation-2: -DROP is a type of DDL Command. Using the DROP statement, the objects are permanently deleted or lost from a database, and they cannot be rolled back. Unlike TRUNCATE, this command deletes the information of the table or the database, and it removes the entire structure/schema of the table or the entire database.
Detailed explanation-3: -The CREATE TABLE is a DDL statement which is used to create tables in the database. The table gets created as soon as the CREATE TABLE script is executed and is ready to hold the data onwards. The user must have the CREATE TABLE system privilege to create the table in its own schema.