SQL Server DBA Objective type Questions and Answers

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
Ans:  D

7. An index can be defined for a single column
A. True
B. False
Ans:  B
8. Why type of user is the default in sql server?
A. SINGLE_USER
B. MULTI_USER
C. RESTRICTED_USER
D. ROOT_USER
Ans:  B
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
Ans:  C

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

More Questions & Answers:-
Page1 Page2 Page3