Microsoft SQL Server MCQ

A sysadmin user is allowed to perform what actions?

Set user accounts

Edit databases

Any action in SQL server

Change security settings

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

Check Answer

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

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

Check Answer

Which of the following statements prevents users from performing actions?

REVOKE

REMOVE

UNGRANT

DENY

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

Check Answer

Which statement is allowed inside of a User Defined Function?

DECLARE

INSERT

TRY....CATCH

DELETE

EXECUTE

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

Check Answer

a FOREIGN KEY constraint can reference a UNIQUE constraint

True

False

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

Check Answer

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

'02143'

'New York"

"Somerville, MA 02143"

'Boston'

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

Check Answer

Which statement adds a row to a table?

ADD

UPDATE

RESERT

INSERT INTO

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

Check Answer

Backup and restore history is stored in which database?

backuphist

msdb

master

bckhist

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

Check Answer