SQL Server Practice Test 3

1. Which of the following Statement ends one side of an existing conversation?

GET CONVERSATION GROUP

END CONVERSATION TIMER

END CONVERSATION

BEGIN CONVERSATION TIMER

2. Point out the correct statement.

Control-of-flow statements cannot span multiple batches, user-defined functions, or stored procedures

Control-of-flow words are useful when you need to direct Transact-SQL to take some kind of action

Control-of-flow language permits statements to be connected, related to each other, and made interdependent using programming-like constructs

All of the mentioned

3. Point out the wrong statement.

None of the mentioned

GOTO statements can be nested

GOTO can exist within conditional control-of-flow statements, statement blocks, or procedures

GOTO permissions need not be granted to any user

4. Which of the following statement decrypts a symmetric key?

OPEN SYMMETRIC KEY

None of the mentioned

DECRYPT SYMMETRIC KEY

CLOSE SYMMETRIC KEY

5. Point out the correct statement.

The full-text index includes more than one character-based columns in the table

The full-text index includes one or more character-based columns in the table

None of the mentioned

The full-text index includes only one character-based column in the table

6. What are Catalog Views for XML?

None of the Mentioned

View Collections

Unstructured data

Schema collections

7. Which of the following database cannot be dropped?

MSDB

Master

TEMPDB

All of the mentioned

8. Which of the following statement drops the synonym?

None of the mentioned

REMOVE SYNONYM

DROP SYNONYM

DELETE SYNONYM

9. Which of the following predicates is used for full text search?

FREETEXT()

TEXT()

All of the mentioned

10. The DROP DATABASE statement must run in ________ mode.

None of the mentioned

Readcommit

Autocommit

Commit