200+ TOP SQL SERVER DBA Online Quiz Questions – Exam Test

SQL SERVER DBA Online Test and Answers Pdf Download :-

These are very useful & Most Asked Questions in your certification Exam. Read all Online Mock Test Exam Question Bank for Beginners Freshers & Experienced.

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
Answer: 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
Answer: C

3. CREATE DATABASE has how many mandatory parameters?
A. 1
B. 2
C. 3
D. None
Answer: 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
Answer: 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
Answer: D

6. What is the syntax for creating new login on the SQL sevrer?
A. USE LOGIN login_id WITH PASSWORD password
B. CREATE LOGIN login_id WITH USE password
C. CREATE LOGIN login_id USE password
D. CREATE LOGIN login_id WITH PASSWORD password
Answer: D

7. An index can be defined for a single column
A. True
B. False
Answer: B

8. Why type of user is the default in sql server?
A. SINGLE_USER
B. MULTI_USER
C. RESTRICTED_USER
D. ROOT_USER
Answer: B

SQL SERVER DBA Objective type Questions with Answers

9. When SQL server is installed, which of the following databases are created by default?
A. Master
B. Model
C. Both a and b
D. Root
Answer: C

10. Stored procedures are safe from SQL injection attacks
A. True
B. False
Answer: A

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

12. Can we temporarily disable a login name?
A. Yes
B. No
Answer: 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
Answer: 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
Answer: A

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

SQL SERVER DBA Questions and Answers pdf Download