COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
____ Command is used to delete a database.
|
|
DELETE DATABASE DATABASE____NAME
|
|
|
DELETE DATABASE____NAME
|
|
|
DROP DATABASE DATABASE____NAME
|
|
|
DROP DATABASE____NAME
|
Explanation:
Detailed explanation-1: -Dropping a database deletes the database from an instance of SQL Server and deletes the physical disk files used by the database. If the database or any one of its files is offline when it is dropped, the disk files are not deleted. These files can be deleted manually by using Windows Explorer.
Detailed explanation-2: -The DELETE command deletes one or more existing records from the table in the database. The DROP Command drops the complete table from the database. The TRUNCATE Command deletes all the rows from the existing table, leaving the row with the column names.
There is 1 question to complete.