PrepAway - Latest Free Exam Questions & Answers

Which of the following is the line of code that would suitably complete the query?

You are employed as a developer at ABC.com. ABC.com makes use of SQL Server 2005
databases in their environment.
You want to make sure that all ABC.com’s orders processed on the 8th May 2012 are returned by
a query to the ABCOrders database table.
You start by writing the line of code shown below:
SELECT * FROM Orders
Which of the following is the line of code that would suitably complete the query?

PrepAway - Latest Free Exam Questions & Answers

A.
WHERE OrderDate = ’08/05/2012′

B.
WHERE OrderDate = ‘8th May 2012’

C.
IF OrderDate = ’01/01/2011′

D.
IF OrderDate = ”8th May 2012′

One Comment on “Which of the following is the line of code that would suitably complete the query?


Leave a Reply