You are a database developer. You plan to design a database solution by using SQL Server
2008. You create a table that contains information about Web pages that are added to a
Web site. The Web site has a home page and contains 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 must support the following design considerations: ·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. ·Changing the links to
the upper-level pages is a rare requirement. You need to ensure that the table is designed
appropriately. What should you use?
A.
Use the XML data type.
B.
Use the hierarchyid data type.
C.
Use a Parent/Child mechanism that references the same table.
D.
Use a Parent/Child mechanism that references one or more additional tables.