98-361 · Question #320
You are developing an application that stores data in SQL Server 2005 database. You need to write a query that retrieves all orders in the orders table that were placed on January 1, 2011. You write…
Sign in or unlock 98-361 to reveal the answer and full explanation for question #320. The question stem and answer options stay visible for context.
Question
You are developing an application that stores data in SQL Server 2005 database. You need to write a query that retrieves all orders in the orders table that were placed on January 1, 2011. You write the following query:
- SELECT * FROM Orders
- WHERE OrderDate = 01/01/2011
The statement executes without any error but does not return any data. You are certain that the database contains order from this date. How should you correct the SQL statement?
Options
- ASELECT * FROM Orders
- BSELECT * FROM Orders
- CSELECT * FROM Orders
- DSELECT * FROM Orders
Unlock 98-361 to see the answer
You've previewed enough free 98-361 questions. Unlock 98-361 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.