Given the following query: SELECT title, gift FROM books CROSS JOIN promotion; Which of the following queries

Question:

Given the following query:

SELECT title, gift

FROM books CROSS JOIN promotion;

Which of the following queries is equivalent?

a. SELECT title, gift

FROM books NATURAL JOIN promotion;

b. SELECT title

FROM books INTERSECT

SELECT gift

FROM promotion;

c. SELECT title

FROM books UNION ALL

SELECT gift

FROM promotion;

d. All of the above

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: