Buy Questpond's video subscriptions on
huge discount
.
Online: 1827
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
Your manager has asked you to create a new user on SQL Server 2008 that has a specific permission set. This person will only be responsible for restoring, dropping and sometimes creating new databases. Which server role should you give the person?
Posted by
Bandi
on 7/2/2014 | Category:
Sql Server Interview questions
| Views: 2018 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Select from following answers:
dbcreator
bulkadmin
diskadmin
processadmin
All Above
dbCreator permission is enough to create/alter/drop the database and to have backup/restore
Show Correct Answer
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
Side by side upgrades are a common choice when ins ...
Next > :
What is the name given to the column or combinatio ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
What is the name given to the column or combination of columns whose v ...
A developer in your organization has added a new table to the company ...
Your company has just launched a new in-house application for call mon ...
SQL Server Agent allows you to schedule jobs to perform any number of ...
What is the process of copying, at set intervals, a log backup from a ...
What is the name given to the process of replacing a table with multip ...
A database administrator working at your company has defined a startup ...
You are worried that your SQL 2008 master database is corrupted. Howev ...
Latest Interview Questions
What will happen if we execute below queries? Select emp_id,employe ...
What will happen if we execute below query?Will it compile or will it ...
How to disable Mouse right click on web page?
How to disable cut,copy & paste in TextBox using jQuery?
How to disable mouse right click using jQuery?
How to Disable Copy Paste and Cut in a ASP.NET Webpage TextBox?
How to disable Caching on the browsers?
How to disable Browser Back button through jQuery?
More ...