> > Database MCQs > SQL Server DBA MCQs

SQL Server DBA MCQ

____ 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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