COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?
|
|
Delete
|
|
|
Drop
|
|
|
Remove
|
|
|
All of the above
|
Explanation:
Detailed explanation-1: -The correct answer is Drop. DROP-It is a Data Definition Language(DDL) Command which is used to delete, tables, views, triggers, etc from a database. A DROP statement in SQL removes a component from a relational database management system (RDBMS).
Detailed explanation-2: -Example of DML commands: INSERT, DELETE etc. Explanation: delete commands can be used to delete a relation schema if it is not needed anymore.
Detailed explanation-3: -2 Answers. Drop table command is used to remove a relation from SQL database.
There is 1 question to complete.