Microsoft SQL Server MCQs (Chapterwise Multiple Choice Questions)

What are the three Transact-SQL statements that are related to authorization?

ALLOW, DENY, and REMOVE

ALLOW, DENY, and REVOKE

ADMIT, REMOVE, and REVOKE

GRANT, DENY, and REVOKE

Answer & Explanation

Correct Answer: GRANT, DENY, and REVOKE

Note: This Question is unanswered, help us to find answer for this one
The SETCERT.EXE utility can be used to do what?

Create a security certificate for the SQL server

All of these

Cross check a security certificate with the owner organization

Specify the certificate used by the SQL server

Answer & Explanation

Correct Answer: Specify the certificate used by the SQL server

Note: This Question is unanswered, help us to find answer for this one
A sysadmin user is allowed to perform what actions?

Set user accounts

Edit databases

Any action in SQL server

Change security settings

Answer & Explanation

Correct Answer: Any action in SQL server

Note: This Question is unanswered, help us to find answer for this one
What is the name of the database that gets created in SQL Server 2012 when you create an "Integration Services Catalog"?

SSISDB

SSISCatalog_Temp

SSISDB_Temp

SSISCatalog

SSISTempDB

Answer & Explanation

Correct Answer: SSISDB

Note: This Question is unanswered, help us to find answer for this one
Which of the following statements prevents users from performing actions?

REVOKE

REMOVE

UNGRANT

DENY

Answer & Explanation

Correct Answer: DENY

Note: This Question is unanswered, help us to find answer for this one
Which statement is allowed inside of a User Defined Function?

DECLARE

INSERT

TRY....CATCH

DELETE

EXECUTE

Answer & Explanation

Correct Answer: DECLARE

Note: This Question is unanswered, help us to find answer for this one
a FOREIGN KEY constraint can reference a UNIQUE constraint

True

False

Answer & Explanation

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one
Which of the following is not a valid string constant or hexadecimal constant?

'02143'

'New York"

"Somerville, MA 02143"

'Boston'

Answer & Explanation

Correct Answer: 'New York"

Note: This Question is unanswered, help us to find answer for this one
Which statement adds a row to a table?

ADD

UPDATE

RESERT

INSERT INTO

Answer & Explanation

Correct Answer: INSERT INTO

Note: This Question is unanswered, help us to find answer for this one
Backup and restore history is stored in which database?

backuphist

msdb

master

bckhist

Answer & Explanation

Correct Answer: msdb

Note: This Question is unanswered, help us to find answer for this one
Microsoft SQL Server Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.

Microsoft SQL Server MCQ

Microsoft SQL Server Quick Quiz

What are the three Transact-SQL statements that are related to authorization?

The SETCERT.EXE utility can be used to do what?

A sysadmin user is allowed to perform what actions?

What is the name of the database that gets created in SQL Server 2012 when you create an "Integration Services Catalog"?

Which of the following statements prevents users from performing actions?

Which statement is allowed inside of a User Defined Function?

a FOREIGN KEY constraint can reference a UNIQUE constraint

Which of the following is not a valid string constant or hexadecimal constant?

Which statement adds a row to a table?

Backup and restore history is stored in which database?