Top 15 SQL Server DBA Objective type Questions and Answers

1. How do we delete a login ?
A. DELETE LOGIN login_name
B. DROP LOGIN login_name
C. A login cannot be deleted but only disabled
D. DISABLE LOGIN login_name
Ans:  B
2. In which database state, the database is in single-user mode and may be repaired or restored.
A. OFFLINE
B. SUSPECT
C. EMERGENCY
D. All of the above
Ans:  C

3. CREATE DATABASE has how many mandatory parameters?
A. 1
B. 2
C. 3
D. None
Ans:  A

4. For every unique constraint on a column, SQL server will create
A. Does not create any index
B. clustered index for that column
C. index for that column
D. non-clustered index for that column
Ans:  D

5. Which operation, when performed on a database can throw an error

A. “The database could not be exclusively locked to perform the operation”

B. DELETE database
C. DROP database
D. Rename database
E. DISABLE database
Ans:  D

More Questions & Answers:-
Page1 Page2 Page3