XML datatype was introduced in which of the following versions of SQL Server?
SQL Server 2005
Well Done. Your Answer is Correct Keep it Up!
SQL Server 2000
SQL Server 2008
SQL Server 2014
Category: Databases MCQs
SQL Server provides how many Xquery methods?
SQL Server provides how many Xquery methods?
5
Well Done. Your Answer is Correct Keep it Up!
6
4
3
What is the hybrid model in SQL Server?
What is the hybrid model in SQL Server?
Combination of relational and XML data type columns
Well Done. Your Answer is Correct Keep it Up!
Combination of relational and non relational data type columns
Using XML with views
Using XML with triggers
Which of the reasons will force you to use XML data model in SQL Server?
Which of the reasons will force you to use XML data model in SQL Server?
All options are correct
Well Done. Your Answer is Correct Keep it Up!
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
Which SQL keyword is used to retrieve a maximum value?
Which SQL keyword is used to retrieve a maximum value?
MAX
Well Done. Your Answer is Correct Keep it Up!
UPPER
TOP
MOST
Which of the following command is used to get child items in powershell?
Which of the following command is used to get child items in powershell?
Get-Child
Well Done. Your Answer is Correct Keep it Up!
Set-Alias
Get-Command
Get-ChildItem
DecryptByKeyAutoCert is ________________ type function.
DecryptByKeyAutoCert is ________________ type function.
Symmetric decryption with Automatic key handling
Well Done. Your Answer is Correct Keep it Up!
Asymmetric Encryption and decryption
Encryption Hashing
Symmetric Encryption and decryption
Text and Image Functions are ___________
Text and Image Functions are ___________
nondeterministic
Well Done. Your Answer is Correct Keep it Up!
deterministic
table valued
All options are correct
__________ are used for supporting encryption, decryption, digital signing and their validation.
__________ are used for supporting encryption, decryption, digital signing and their validation.
Cryptographic functions
Well Done. Your Answer is Correct Keep it Up!
Cursor functions
Configuration functions
None of the options are correct
Data types in SQL Server are organized into how many categories?
Data types in SQL Server are organized into how many categories?
6
Well Done. Your Answer is Correct Keep it Up!
8
9
10