Question 2058 – Nielit Scientific Assistance CS 15-10-2017
November 9, 2023Database-Management-System
November 9, 2023Database-Management-System
|
Question 725
|
Given relations R(w,x) and S(y,z) the result of
SELECT DISTINCT w,x from R<S
SELECT DISTINCT w,x from R<S
|
R has no duplicates and S is non empty
|
|
|
R and S have no duplicates
|
|
|
S has no duplicates and R is non empty
|
|
|
R and S has the same number of tuples
|
Question 725 Explanation:
r has no duplicate, if r can have duplicates it can be remove in the final state. s in non-empty if s is empty then r*s becomes empty.
Correct Answer: A
Question 725 Explanation:
r has no duplicate, if r can have duplicates it can be remove in the final state. s in non-empty if s is empty then r*s becomes empty.