SQL Server Mock Test 2

10%

Question 1 of 10

1. Reasons to use native XML features in SQL Server instead of managing your XML data in the file system would be:

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

All of the mentioned

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

Question 1 of 10

Question 2 of 10

2. Point out the wrong statement.

The first PowerShell cmdlet every administrator should learn is Get-Command

Get-Event is used to find events in the PowerShell event queue

None of the mentioned

Limit-EventLog is used to limit the size of the event log

Question 2 of 10

Question 3 of 10

3. Which of the function is not a ranking window function?

None of the mentioned

ROW_NUMBER

RANK

NTILE

Question 3 of 10

Question 4 of 10

4. Which is the duplication of computer operations and routine backups to combat any unforeseen problems?

Backup

Concurrency

Deadlock

Recovery

Question 4 of 10

Question 5 of 10

5. Which of the following function will be used in the following code for moving nodes?

DECLARE @newParent HierarchyId = (SELECT Node FROM H WHERE name = 'Johnny')
UPDATE H SET Node = Node.__________(Node.GetAncestor(1),@newParent)
WHERE Name = 'S1'

GetReparentedValue

GetValue

GetReparentedVal

None of the mentioned

Question 5 of 10

Question 6 of 10

6. What is purpose of GetDescendant method in the following code?

DECLARE @parent HierarchyId = HierarchyId::GetRoot()
INSERT INTO H (Node,ID,Name) VALUES (@parent.GetDescendant(NULL,NULL),2,'Johnny')

Takes 2 arguments

Takes 3 arguments

All of the mentioned

Takes 4 arguments

Question 6 of 10

Question 7 of 10

7. Point out the correct statement.

HierarchyID data type maps the data as a hashmap, so when traversing the binary tree structure

None of the mentioned

In HierarchyID, we create indexes in order to make the traversal efficient

In real scenarios, you always need to create indexes using Hierarchy ID data type

Question 7 of 10

Question 8 of 10

8. Which of the following functions are similar?

None of the mentioned

RANK and DENSE_RANK

RANK and NTILE

DENSE_RANK and NTILE

Question 8 of 10

Question 9 of 10

9. Point out the correct statement.

UNIQUE constraints enforce the uniqueness of the values in a set of columns

CHECK constraints enforce domain integrity

All of the mentioned

In a UNIQUE constraint, no two rows in the table can have the same value for the columns

Question 9 of 10

Question 10 of 10

10. Which of the following command is used to get child items in powershell?

Get-Child

Get-Command

Set-Alias

Get-ChildItem

Question 10 of 10