Explore topic-wise MCQs in SQL Server.

This section includes 1 Mcqs, each offering curated multiple-choice questions to sharpen your SQL Server knowledge and support exam preparation. Choose a topic below to get started.

1.

Which of the following is invalid code associated with hierarchical data type ?

A. CREATE TABLE H ( Node HierarchyID PRIMARY KEY CLUSTERED, NodeLevel AS Node.GetLevel(), ID INT UNIQUE NOT
B. CREATE TABLE H ( Node HierarchyID PRIMARY KEY NON CLUSTERED, NodeLevel AS Node.GetLevel(), ID INT UNIQUE NOT
C. CREATE TABLE H ( Node HierarchyID FOREIGN KEY CLUSTERED, NodeLevel AS Node.GetLevel(), ID INT UNIQUE NOT
D. All of the mentioned
Answer» D. All of the mentioned
Discussion