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 not execute because ‘June 30 2001’ in the WHERE condition is not enclosed within
double quotation marks.
B.
It would execute and would return ORDER_ID and CUSTOMER_ID for all records having
ORDER_DATE greater than ‘June 30 2001’.
C.
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.
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.