COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
DBMS languages have different syntaxes. However, which of the following is an example of deleting a database?
|
drop database database ____ name
|
|
delete database ____ name
|
|
delete database database ____ name
|
|
drop database ____ name
|
Explanation:
Detailed explanation-1: -Syntax. DROP DATABASE databasename; Note: Be careful before dropping a database. Deleting a database will result in loss of complete information stored in the database!
Detailed explanation-2: -The DROP statement destroys the objects like an existing database, table, index, or view. A DROP statement in SQL removes a component from a relational database management system (RDBMS).
Detailed explanation-3: -Detailed Solution. 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.
Detailed explanation-4: -The DELETE command is used to delete existing records in a table.
There is 1 question to complete.