1Z0-071 practice - PrepKeys

Q5 Single choice

View the Exhibit and examine the structure of the ORDERS table.

You must select ORDER_ID and ORDER_DATE for all orders that were placed after the last order placed by CUSTOMER_ID 101.

Which query would give you the desired result?

A
SELECT order_id, order_date FROM orders WHERE order_date >
ANY
(SELECT order_date FROM orders WHERE customer_id = 101);
B
SELECT order_id, order_date FROM orders WHERE order_date > ALL
(SELECT MAX(order_date) FROM orders ) AND customer_id = 101;
C
SELECT order_id, order_date FROM orders WHERE order_date > ALL
(SELECT order_date FROM orders WHERE customer_id = 101);
D
SELECT order_id, order_date FROM orders WHERE order_date > IN
(SELECT order_date FROM orders WHERE customer_id = 101);