View the Exhibit and examine the description of the ORDERS table. Evaluate the following
SQL statement: SELECT order_id, customer_id FROM orders WHERE order_date > ‘June
30 2001′; Which statement is true regarding the execution of this SQL statement?
A.
It would execute and would return ORDER_ID and CUSTOMER_ID for all records having
ORDER_DATE greater than ‘June 30 2001’.
B.
It would not execute because ‘June 30 2001’ in the WHERE condition cannot be
converted implicitly and needs the use of the TO_DATE conversion function for proper
execution.
C.
It would not execute because ‘June 30 2001’ in the WHERE condition is not enclosed
within double quotation marks.
D.
It would not execute because ‘June 30 2001’ in the WHERE condition cannot be
converted implicitly and needs the use of the TO_CHAR conversion function for proper
execution.