TGPSC HMWSSB Manager 2015 Paper 2 CSE · Question 34
Question 34 of the TSPSC Manager (Engineering), HMWSSB, 2015: Paper 2 (Computer Science & Information Technology) (1 November 2015). Try it first, then open the answer. The explanation is in the practice app with the All-in-One Pass.
Consider relations R(A,B) and S(C,D); and the following SQL query.
Select distinct A,B, from R,S
Under what conditions the result is guaranteed to be same as R.
- R has no duplicate and S is non-empty
- R and S have no duplicates
- S has no duplicates and R is non-empty
- R and S have the same number of tuples
Show answer
Answer: (1) R has no duplicate and S is non-empty
Explanation: open it in the practice app. It needs the ₹149 All-in-One Pass: one payment for every exam on the site.