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

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

Step by Step Solution

3.44 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a SELECT ti... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c12127c4b_716480.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12127c4b_716480.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!