Which operation, when performed on a database can throw an error

“The database could not be exclusively locked to perform the operation”

Options
- DELETE database
- DROP database
- Rename database
- DISABLE database


CORRECT ANSWER : Rename database

Discussion Board
Rename Database

SQL RENAME DATABASE is used when you need to change the name of your database. Sometimes it is used because you think that the original name is not more relevant to the database or you want to give a temporary name to that database.
Syntax: RENAME DATABASE old_db_name TO new_db_name;

Prajakta Pandit 03-10-2017 04:26 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement