Which Of The Following Code Snippet Insert The Top Level #181
Which of the following code snippet insert the top level manager ‘Jeff Brown’ as hierarchy root?
This multiple choice question (MCQ) is related to the book/course
gs gs116 Microsoft SQL Server.
It can also be found in
gs gs116 SQL Server Beyond Relational - Hierarchies - Quiz No.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());
Similar question(s) are as followings:
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