> > Database MCQs > SQL Server DBA MCQs

SQL Server DBA MCQ

1. ____ allow a web site to store information on the client computer for later retrieval.

Phishing

Cache

Proxies

Answer

Correct Answer: Cookies

Note: This Question is unanswered, help us to find answer for this one

2. When SQL server is installed, which of the following databases are created by default?

Model

Root

Master

Master and Model

Answer

Correct Answer: Master and Model

Note: This Question is unanswered, help us to find answer for this one

3. For every unique constraint on a column, SQL server will creat

Index for that column

Non-clustered index for that column

Clustered index for that column

Does not create any index

Answer

Correct Answer: Non-clustered index for that column

Note: This Question is unanswered, help us to find answer for this one

4. What is the syntax for creating new login on the SQL sevrer?

CREATE LOGIN login_id WITH PASSWORD password

CREATE LOGIN login_id WITH USE password

CREATE LOGIN login_id USE password

USE LOGIN login_id WITH PASSWORD password

Answer

Correct Answer: CREATE LOGIN login_id WITH PASSWORD password

Note: This Question is unanswered, help us to find answer for this one

5. Can we temporarily disable a login name?

Yes

Answer

Correct Answer: Yes

Note: This Question is unanswered, help us to find answer for this one

6. Which of the following are valid database states?

EMERGENCY

All

SUSPECT

OFFLINE

Answer

Correct Answer: All

Note: This Question is unanswered, help us to find answer for this one

7. An index can be defined for a single column.

True

False

Answer

Correct Answer: False

Note: This Question is unanswered, help us to find answer for this one

8. In which database state, the database is in single-user mode and may be repaired or restored?

OFFLINE

SUSPECT

All

EMERGENCY

Answer

Correct Answer: EMERGENCY

Note: This Question is unanswered, help us to find answer for this one

9. What type of user is the default in sql server?

RESTRICTED_USER

MULTI_USER

ROOT_USER

SINGLE_USER

Answer

Correct Answer: MULTI_USER

Note: This Question is unanswered, help us to find answer for this one

10. What is a MULTI_USER in sql server?

Only some members are allowed to access the database.

Only the system admin and some members are allowed to access the database.

Users that have the appropriate permissions to connect to the database are allowed.

One user at a time is allowed to connect to the database.

Answer

Correct Answer: Users that have the appropriate permissions to connect to the database are allowed.

Note: This Question is unanswered, help us to find answer for this one

11. How do we delete a login?

DELETE LOGIN login_name

A login cannot be deleted but only disabled

DISABLE LOGIN login_name

DROP LOGIN login_name

Answer

Correct Answer: DROP LOGIN login_name

Note: This Question is unanswered, help us to find answer for this one

12. Stored procedures are safe from SQL injection attacks.

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

13. How many mandatory parameters a CREATE DATABASE has?

None

Answer

Correct Answer: 1

Note: This Question is unanswered, help us to find answer for this one

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

DISABLE database

Rename database

DELETE database

DROP database

Answer

Correct Answer: Rename database

Note: This Question is unanswered, help us to find answer for this one

15. What is the difference between adhoc queries from stored procedures?

None

Adhoc queries are placed embedded in the business logic code.

There is no difference as both are fired on the databases.

Stored procedures are placed embedded in the business logic code.

Answer

Correct Answer: Adhoc queries are placed embedded in the business logic code.

Note: This Question is unanswered, help us to find answer for this one

Database MCQs | Topic-wise

MCQ on Advance Database	MCQ on Basic Database
MCQ on Database Administration	MCQ on Database Application
MCQ on Database Concepts	MCQ on Database Management System
MCQ on Database Management System (DBMS)	MCQ on Database Organization & Design
MCQ on Introduction to Database	MCQ on Modern Database Management
MCQ on SQL Server DBA	MCQ on SQL Server Database
MCQ on Window Server 2003	General Database MCQs