You work in an International company named TAKEEEN. And you’re in charge of the database of your company. You intend to use SQL Server 2008 to create a database solution. A table which contains information about Web pages is created by you.
And the Web pages are added to the Web site which contains a home page and various other Web pages.
The home page is the root page of the site.
All pages except the root page have a link to an upper-level page.
The table you design must meet the following requirements:
• Changing the links to the upper-level pages is a rare requirement;
• Records of the Web pages that are linked to a particular page can be quickly retrieved.
• The position of a Web page in a collection of linked pages can be quickly retrieved.
You have to make sure that the table is well designed.
So what should you use?
A. The XML data type should be used.
B. The hierarchyid data type should be used.
C. A Parent/Child mechanism that references the same table should be used.
D. A Parent/Child mechanism that references one or more additional tables should be used.
