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

A) 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;

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

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

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

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;

Top Trending Technologies MCQ's

Machine Learning

Artificial Intelligence

Natural Language Processing

Top Trending Technologies Interview Questions