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
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
No comments:
Post a Comment