SQL Server MCQs - CSE MCQs Questions and Answers

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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

slower

optimal

faster

none of the mentioned

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

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

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Statement for dropping XML index is :

DROP INDEX

DELETE INDEX

REMOVE INDEX

None of the Mentioned

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Different xml modes available for xml clauses are :

RAW

AUTO

PATH

All of the mentioned

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

What is every identifier in an XQuery called ?

Name

QName

Qidt

Qnam