gs gs116 SQL Server Beyond Relational - Hierarchies - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic SQL Server Beyond Relational. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which of the following code snippet insert the top level manager ‘Jeff Brown’ as hierarchy root?
INSERT INTO Employees VALUES (1, 'Jeff Brown', NULL, hierarchyid::Root()); INSERT INTO Employees VALUES (1, 'Jeff Brown', NULL, hierarchyid::Get()); INSERT INTO Employees VALUES (1, 'Jeff Brown', NULL, hierarchyid::GetRoot()); INSERT INTO Employees VALUES (1, 'Jeff Brown', NULL, hierarchy::GetRoot());
Question 2: 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 Hierarchy ID data type
In HierarchyID, we create indexes in order to make the traversal efficient
None of the mentioned
Question 3: Which of the following is invalid code associated with hierarchical data type?
CREATE TABLE H ( Node HierarchyID PRIMARY KEY CLUSTERED, NodeLevel AS Node.GetLevel(), ID INT UNIQUE NOT NULL, Name VARCHAR(50) NOT NULL ) CREATE TABLE H ( Node HierarchyID PRIMARY KEY NON CLUSTERED, NodeLevel AS Node.GetLevel(), ID INT UNIQUE NOT NULL, Name VARCHAR(50) NOT NULL ) CREATE TABLE H ( Node HierarchyID FOREIGN KEY CLUSTERED, NodeLevel AS Node.GetLevel(), ID INT UNIQUE NOT NULL, Name VARCHAR(50) NOT NULL )
All of the mentioned
Question 4: Which of the following code is used to have a Breadth First index?
CREATE UNIQUE bfs_index ON H (NodeLevel,Node) CREATE UNIQUE INDEX bfs_index ON H (NodeLevel,Node) CREATE INDEX bfs_index ON H (NodeLevel,Node) CREATE UNIQUE INDEX bfs_index ON H (NodeLevel)
Question 5: Point out the wrong statement.
The Depth column comes in handy for performing the indent by using the Space() function
Stored procedures are the easiest way to extract hierarchical data
Inside SQL Server 2008, Microsoft introduces a new data type Index on HierarchyID to handle such type of data and reduce the complexity
None of the mentioned
Question 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
Takes 4 arguments
All of the mentioned
Question 7: Which of the following function returns true in the following code?
DECLARE @parent HierarchyId = (SELECT Node FROM H WHERE Name = 'Thuru') DECLARE @parentNodeLevel int = (select NodeLevel from h where name = 'Thuru') SELECT Node.ToString() AS NodeText, * FROM H WHERE Node.IsDescendantOf(@parent) = 'TRUE' AND Node != @parent AND NodeLevel = @parentNodeLevel + 1
IsDescendantOf
DescendantOf
IsDescendant
None of the mentioned
Question 8: Which of the code deletes node H using hierarchical data type?
DELETE FROM H WHERE Name = ‘Steve’
DROP FROM H WHERE Name = ‘Steve’
DELETE H WHERE Name = ‘Steve’
All of the mentioned
Question 9: 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'
GetReparentedVal
GetReparentedValue
GetValue
None of the mentioned
Question 10: Which of the following code will not throw an error?
DECLARE @child HierarchyId = (SELECT Node FROM H WHERE Name = 'S1') SELECT * FROM H WHERE Node = @child.GetAnces(2) DECLARE @child HierarchyId = (SELECT Node FROM H WHERE Name = 'S1') SELECT * FROM H WHERE Node = @child.GetAncestor(2) DECLARE @child HierarchyId = (SELECT Node FROM H WHERE Name = 'S1') SELECT * FROM H WHERE Node = @child.Ancestor(2)
None of the mentioned
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
