SQL Server Mock Test 3

10%

Question 1 of 10

1. Which of the following index options are added by the CREATE INDEX statement?

PARTITION SCHEME

XML INDEX

INCLUDED (column)

ONLINE

Question 1 of 10

Question 2 of 10

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

FREETEXT()

TEXT()

All of the mentioned

Question 2 of 10

Question 3 of 10

3. Point out the correct statement.

Dropping a database snapshot does not delete the database snapshot from an instance of SQL Server

You can drop a database currently being used

When a database is dropped, the master database should be backed up

None of the mentioned

Question 3 of 10

Question 4 of 10

4. Which is a new DDL statement?

DROP ROLES

None of the mentioned

CREATE APPLICATION ROLE

CREATE USERS

Question 4 of 10

Question 5 of 10

5. Statement for dropping XML index is __________

DROP INDEX

REMOVE INDEX

None of the Mentioned

DELETE INDEX

Question 5 of 10

Question 6 of 10

6. The space use of XML indexes can be found in the table-valued function named?

sys.dm_db_index_plan_stats

sys.dm_db_index_phy_stats

sys.dm_db_index_physical_stats

sys.dm_db_index_table_stats

Question 6 of 10

Question 7 of 10

7. Point out the correct statement.

CREATE USER transfers a securable between schemas

T-SQL is SQL language for SYBASE

CREATE LOGIN modifies the login details

GET_TRANSMISSION_STATUS does provide information for messages that do not have a conversation endpoint in the current instance

Question 7 of 10

Question 8 of 10

8. Point out the wrong statement.

Full-text queries perform linguistic searches against text data

To define full-text searches, SQL Server full-text queries use the full-text predicates

Before you can run full-text queries on a table, the database administrator must create a full-text index on the table

Full-text search is applicable to a shorter range of business scenarios

Question 8 of 10

Question 9 of 10

9. Point out the wrong statement.

SQL Server provides only three global variables

All the global variables represent information specific to the server or a current user session

None of the mentioned

Global variables represent a special type of variable

Question 9 of 10

Question 10 of 10

10. SQL Server provides how many Xquery methods?

Question 10 of 10