Sunday 6 September 2015

SQL Server DBA Multiple Choice Questions And Answers

11.  Which of the following below are valid database states?
A. OFFLINE
B. SUSPECT
C. EMERGENCY
D. All of the above
Ans:  D

12. Can we temporarily disable a login name?
A. Yes
B. No
Ans:  A

13. What is a MULTI_USER in sql server?
A. users that have the appropriate permissions to connect to the database are allowed
B. One user at a time is allowed to connect to the database
C. Only some members are allowed to access the database
D. Only the system admin and some members are allowed to access the database
Ans:  A

14. What is the difference between adhoc queries from stored procedures?
A. Adhoc queries are placed embedded in the business logic code
B. Stored procedures are placed embedded in the business logic code
C. There is no difference as both are fired on the databases
D. None of the above
Ans:  A

15. A candidate key cannot be regarded as a possible primary key
A. True
B. False
Ans:  B

More Questions & Answers:-
Page1 Page2 Page3

No comments:

Post a Comment