MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
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 | |