COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Select DDL commands from among the options ____
|
|
SELECT
|
|
|
ALTER
|
|
|
DROP
|
|
|
DELETE
|
Explanation:
Detailed explanation-1: -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-2: -The SELECT statement is a limited form of DML statement in that it can only access data in the database.
There is 1 question to complete.