Microsoft
70-433 · Question #18
70-433 Question #18: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #18. The question stem and answer options stay visible for context.
Question
You have a table named Stores that has an XML column named OpenHours. This column contains the opening and closing times. <hours dayofWeek= "Monday" open ="8:00 AM" closed="8:00 PM" <hours dayofWeek= "Tuesday" open ="8:00 AM" closed="8:00 PM" ... <hours dayofWeek= "Saturday" open ="8:00 AM" closed="8:00 PM" You need to write a query that returns a list of stores and their opening time for a specified day. Which code segment should you use?
Options
- ADECLARE @Day VARCHAR(10) = 'Tuesday'
- BDECLARE @Day VARCHAR(10) = 'Tuesday'
- CDECLARE @Day VARCHAR(10) = 'Tuesday'
- DDECLARE @Day VARCHAR(10) = 'Tuesday'
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.