Question: Which of the following is a SQL server role that can change server - wide configuration options and shut down servers? A . dbcreator B

Which of the following is a SQL server role that can change server-wide configuration options and shut down servers?
A. dbcreator
B. serveradmin
C. dbadmin
D. sysadmin

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

The project is going well so far, and the analysis and discussion of the vulnerabilities was well-received. You realize that when vulnerability scanning takes place, employees need to know what the...

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

(A) ii. Install a virtual machine on your computer to be used as a testing environment iii. For windows, either one of these are fine 1. VMWare Workstation by VMware (preferred for Windows) 2. Oracle...

Q:

Fixing the payment system at Alvalade XXI: a case on IT project risk management Ramon O'Callaghan Tilburg University, The Netherlands Correspondence: AO'Callaghan, School of Economics and Business...

Q:

I need a 10 page paper for my MIS class. Please do not copy and paste as my school is getting stricter on plagiarism. I have attached the assignment and the sample \fData Analytic Thinking 1 Data...

Q:

Wine Tasting Facilitator Guide Welcome and Training Agenda Today, we will be training on seasonal wines that will now be offered at Buca di Beppos. We are doing this training to help our all front of...

Q:

Lab 1 - Installing Exchange 2016 In this set of exercises, you will configure a computer to function as a domain controller to support the deployment of Exchange Server 2016 and then configure the...

Q:

MARK J EFFER'r'r A&D High Tech (A): Managing Projects for Success In his twelve years as a technology project manager at A&D High Tech, Chris Johnson had a strong track record of delivering projects...

Q:

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Q:

Write 350 words on Cloud Computing. Chapter 22. Digital Platforms Standalone digitalized business processes, local business platforms and global business platforms are enabled and supported by the...

Q:

What are the three most important insights you gained from studying this feature? Which of these insights surprised you, and why?

Q:

We dig out the following for Company A for the month of May. The company uses FIFO and the perpetual method of inventory. Date Description Units / $s May 1 Beg. Inventory 150 units @ $10.00 May 5...

Q:

Effective annual interest rates reflect the effects of compounding frequency. True False

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

How does the team fit into the overall management structure of the organization, classroom, and so on?

Q:

5. The computer imposes a discipline of linear thinking. Organizations will need to find ways to encourage and protect nonlinear thinking and communicating.

Q:

7. Where Do We Begin?