Category: SQL Server MCQs

All options are correct

You need language support for query and data modification for cross-domain applications

You want the server to guarantee that the data is well formed and also optionally validate your data according to XML schema

You want indexing of XML data for efficient query processing and good scalability, and the use of a first-rate query optimizer

SQL Server 2005

SQL Server 2000

SQL Server 2008

SQL Server 2014

5

6

4

3

Combination of relational and XML data type columns

Combination of relational and non relational data type columns

Using XML with views

Using XML with triggers

All options are correct

Your data is sparse or you do not know the structure of the data

Your data represents containment hierarchy

Order is inherent in your data

MAX

UPPER

TOP

MOST

Get-Child

Set-Alias

Get-Command

Get-ChildItem

Symmetric decryption with Automatic key handling

Asymmetric Encryption and decryption

Encryption Hashing

Symmetric Encryption and decryption

nondeterministic

deterministic

table valued

All options are correct

Cryptographic functions

Cursor functions

Configuration functions

None of the options are correct