CoolInterview.com - World's Largest Collection of Interview Questions
Send Free SMS
 Interview Questions  
 Our Services  


INTERVIEW QUESTIONS DATABASE SQL SERVER DETAILS
Question :
How many types of system privileges are there, Can we add or delete privileges?
Category SQL Server Interview Questions
Rating (0.0) By 0 users
Added on 4/3/2008
Views 391
Rate it!
Answers:

There are over 80 distinct system privileges. Each system privilege allows a user to perform a particular database operation or class of database operations.

Such as:- 1. ANALYZE ANY
2. CREATE CLUSTER
3. CREATE ANY CLUSTER
4. ALTER ANY CLUSTER
5. DROP ANY CLUSTER
6. ALTER DATABASE
7. CREATE ANY INDEX
8. ALTER ANY INDEX
9. DROP ANY INDEX
10. GRANT ANY PRIVILEGE





If you have the better answer, then send it to us. We will display your answer after the approval.
Name :*
Email Id :*
Answer :*
Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
Process Verification  Enter the above shown code:*
Inform me about updated answers to this question

   
Related Questions
View Answer
Write a SQL Stored Procedure to create a GUID and add it to a table. Make that GUID an OUTPUT of that Procedure
View Answer
Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.
View Answer
I was asked in an interview...
"Suppose u have a field with UNIQUE KEY. can u leave two or more cells NULL in SQL Server 2005...If Yes then Why...if NOT then Why.....
View Answer
What is a "trigger"?
View Answer
How do you optimize stored procedures ?
View Answer
What is different between int and bint?
View Answer
How to remove duplicate records from a table?
View Answer
What is the difference between "procedure" and "function"?
View Answer
How will you copy the structure of a table without copying the data?
View Answer
What is DESCRIBE command in SQL Server?What is its purpose?How to use it?
View Answer

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email:

View ALL SQL Server Interview Questions

User Options
Sponsored Links


Copyright ©2003-2010 CoolInterview.com, All Rights Reserved.
Privacy Policy | Terms and Conditions
Page URL: http://www.coolinterview.com/interview/14949/default.asp?cachecommand=bypass


Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Free SMS | Dedicated Servers | Joke of the Day

0.75