Questions and answers for exam Preparation

MCQs

Total Questions : 10

Question 1. Point out the correct statement :

The full-text index includes only one character-based column in the table
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

Discuss Question

Answer: Option C. -> The full-text index includes one or more character-based columns in the table

Each full-text index indexes one or more columns from the table, and each column can use a specific language.

Question 2. Which of the following is not a XML storage option ?

Native storage as XML data type
Mapping between XML and relational storage
Small object storage
None of the Mentioned

Discuss Question

Answer: Option C. -> Small object storage

XML uses large object storage which uses varchar(max) and varbinary(max).

Question 3. Full-text search is an ________ component of the SQL Server Database Engine

slower
optimal
faster
none of the mentioned

Discuss Question

Answer: Option B. -> optimal

Full-text queries perform linguistic searches against text data in full-text indexes.

Question 4. The choice of XML technology, native XML versus XML view, generally depends upon the following factors:

Storage options
Query capabilities
Indexing
All of the Mentioned

Discuss Question

Answer: Option D. -> All of the Mentioned

Different XML choices may also have different performance characteristics.

Question 5. Point out the correct statement :

HierarchyID data type maps the data as a hashmap, so when traversing the binary tree structure
In real scenarios, you always need to create indexes using HierarchyID data type
In HierarchyID, we create indexes in order to make the traversal efficient
None of the mentioned

Discuss Question

Answer: Option C. -> In HierarchyID, we create indexes in order to make the traversal efficient

In order to make the query execution efficient, we create indexes.

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

sys.dm_db_index_physical_stats
sys.dm_db_index_phy_stats
sys.dm_db_index_plan_stats
sys.dm_db_index_table_stats

Discuss Question

Answer: Option A. -> sys.dm_db_index_physical_stats

sys.dm_db_index_physical_stats provides information, such as the number of disk pages occupied, average row size in bytes, and number of records, for all index types.

Question 7. Statement for dropping XML index is :

DROP INDEX
DELETE INDEX
REMOVE INDEX
None of the Mentioned

Discuss Question

Answer: Option A. -> DROP INDEX

The DROP INDEX (Transact-SQL) Transact-SQL statement can be used to drop existing primary or secondary XML and non-XML indexes.

Question 8. Different xml modes available for xml clauses are :

RAW
AUTO
PATH
All of the mentioned

Discuss Question

Answer: Option D. -> All of the mentioned

Within the FOR XML clause,we specify an XML mode: RAW, AUTO, EXPLICIT or PATH.

Question 9. SQL Server lets you define how many types of secondary XML indexes?

Discuss Question

Answer: Option A. -> 3

Secondary indexes are PATH, VALUE, and PROPERTY.

Question 10. What is every identifier in an XQuery called ?

Name
QName
Qidt
Qnam

Discuss Question

Answer: Option B. -> QName

A QName is made up of a namespace prefix and a local name. In this implementation, the variable names in XQuery are QNames and they cannot have prefixes.