FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

WHAT IS DATABASE MANAGEMENT

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

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?

A	Delete
B	Drop
C	Remove
D	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: -Therefore the “drop” command is used to delete a relation form a database instead of using the “delete” command.

Detailed explanation-3: -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-4: -2 Answers. Drop table command is used to remove a relation from SQL database.

There is 1 question to complete.