> > >

Oracle 12c Admin MCQs

Which of the given SQL statements is equivalent to the following SQL statement?

SELECT c.customer_id, d.order_id, c.customer_name, d.order_price FROM customer c, orders (IWHERE c.order_id = d.order_id;

SELECT customer_id. order_id. customer_name. order_price FROM customer WHERE order_id IN (SELECT order_id FROM orders);

SELECT customer_id, order_id, customer_name. order_price FROM customer NATURAL JOIN orders;

SELECT c.customer_id. d.order_id, c.customer_name, d.order_price FROM customer c JOIN orders d ON c.order_id = d.order_id;

SELECT c.customer_id, d.order_id, c.customer_name, d.order_price FROM customer JOIN orders USING (c.order_id = d.order_id;);

Answer

Correct Answer: SELECT c.customer_id. d.order_id, c.customer_name, d.order_price FROM customer c JOIN orders d ON c.order_id = d.order_id;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Oracle 12c Admin Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it