Which of the following is the correct way to rename a user database?

 Posted by vishalneeraj-24503 on 7/1/2014 | Category: Sql Server Interview questions | Views: 652 | Points: 40
Select from following answers:
  1. ALTER DATABASE <Old DB Name> RENAME <New DB Name>
  2. ALTER DATABASE <Old DB Name> ALTER NAME = <New DB Name>
  3. ALTER DATABASE <Old DB Name> MODIFY NAME = <New DB Name>
  4. EXECUTE [dbo].[sp_changedbname] '<Old DB Name>', '<New DB Name>'
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response