Question: Suppose: table A has columns X and Y. table B has columns Y and Z What is true of the query: SELECT A.X, B.Z FROM

Suppose:

table A has columns X and Y.

table B has columns Y and Z

What is true of the query: SELECT A.X, B.Z FROM A, B?

a. The result is empty if there is no overlap in the values of column Y of table A and column Y of table B

b. The size of the result is the smaller of the sizes (number of rows) of the tables

c. There are 4 columns in the result

d. The size of the result is the product of the sizes (number of rows) of the tables

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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

Students Have Also Explored These Related Databases Questions!