You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. You have received instruction from the CIO to create an online catalog application that will display the product information on the Domain.com Web site. The product information is stored in a SQL Server 2005 database server named Certkiller -DB01. The CIO informs you that the data is stored as relational data. However, the data should be passed to the application as an XML document by using FOR XML.
A Domain.com employee named Clive Wilson works in the Research and Development department. You instruct him, to test the application. Clive Wilson detects that not all the items matching the query appear in the XML document. He determines that only the products that have values for all elements in the schema appear in the XML document. You instruct him to modify the Transact-SQL statement in order that all products matching the query appear in the XML document.
What should Clive Wilson do?
A.
Clive Wilson should modify the replace value of clause in the query.
B.
The HAVING clause needs to be added to the query.
C.
In order for all matching queries to appear in the XML document Clive Wilson needs to add an XML index to the table that contains the product information.
D.
It is important that Clive Wilson add the XSINIL argument to the ELEMENTS directive in the query.
Explanation:
If you add the XSINIL instruction to the ELEMENTS clause in the FOR XML construction, Certkiller -DB01 will generates an empty XML element for NULL values.