Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started