Oracle
1Z0-047 · Question #19
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…
The correct answer is C. It would not execute because 'June 30 2001' in the WHERE condition cannot be converted implicitly. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- AIt would not execute because 'June 30 2001' in the WHERE condition is not enclosed within double
- BIt would execute and would return ORDER_ID and CUSTOMER_ID for all records having ORDER_DATE
- CIt would not execute because 'June 30 2001' in the WHERE condition cannot be converted implicitly
- DIt would not execute because 'June 30 2001' in the WHERE condition cannot be converted implicitly
How the community answered
(32 responses)- A13% (4)
- B3% (1)
- C81% (26)
- D3% (1)
Community Discussion
No community discussion yet for this question.
