Exam 1z0-071 Topic 14 Question 35 Discussion

Actual exam question for Oracle's 1z0-071 exam
Question #: 35
Topic #: 14

View the Exhibit and examine the structure of the ORDERS table. (Choose the best answer.)

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 ordersWHERE order_date > IN(SELECT
order_date FROM orders WHERE customer_id = 101); B. SELECT order_id, order_date FROM ordersWHERE order_date > ALL(SELECT MAX(order_date) FROM orders ) AND customer_id = 101; C. SELECT order_id, order_date FROM ordersWHERE order_date > ANY(SELECT order_date FROM orders WHERE customer_id = 101); D. SELECT order_id, order_date FROM ordersWHERE order_date > ALL(SELECT order_date FROM orders WHERE customer_id = 101);

Comments

0 Happy Clients

0 Shares

0 Demo Downloads

10 Years in Business