70-442 Microsoft Licensing Braindump
ExamSoon 70-442 Exams
Microsoft PRO:Design & Optimize Data Access by Using MS SQL Serv 2005
O rder : 70-442 Exam
Practice Exam: 70-442
Exam Number/Code: 70-442
Exam Name: PRO:Design & Optimize Data Access by Using MS SQL Serv 2005
Questions and Answers: 110 Q&As
Free 70-442 Braindumps
Exam : Microsoft 70-442
Title : PRO:Design & Optimize Data Access by Using MS SQL Serv 2005
1. You are a database developer for your company. An XML document is stored in the XML variable @Article. The
XML document in the variable can contain hundreds of article elements. The XML document is shown in the following
segment.
<articles>
<article>
<title>...</title>
<paragraph>...</paragraph>
<image filename="...">
<description>...</description>
</image>
<paragraph>...</paragraph>
<image filename="...">
<description>...</description>
</image>
<paragraph>...</paragraph>
<paragraph>...</paragraph>
</article>
...
</articles>
You need to design a query that will return the filename and description for all images from the XML document in the
following tabular format.
Which query should you use?
A. SELECT@Article.value('(/articles/article/image)[1]/@filename', 'NVARCHAR(50)') AS
Filename,@Article.value('(/articles/article/image/description)[1]', 'NVARCHAR(max)') AS Description
B. SELECT col.value('(articles/article/image)[1]/@filename', 'NVARCHAR(50)') AS
Filename ,col.value('articles/article/image/description[1]', 'NVARCHAR(max)') AS
DescriptionFROM @Article.nodes('/') AS x (col);
C. SELECT col.value('@filename', 'NVARCHAR(50)') AS Filename ,col.value('description[1]',
'NVARCHAR(max)') AS DescriptionFROM @Article.nodes('/articles/article/image') AS x (col) ;
D. SELECT col.query('<filename>{@filename}</filename>') AS
Filename ,col.query('description[1]') AS DescriptionFROM @Article.nodes('/articles/article/image') AS x (col) ;
Answer: C
2. BACKGROUND
Company Overview
Margie's Travel is a small regional travel agency that handles many different types of travel arrangements.
Planned