Learn with Anil · TGPSC HMWSSB Manager (Engineering) PYQsPractise online →Subscribe ₹149

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.

  1. Manager 2015 Paper 2 (CS & IT) · Q34 · Database Management Systems · SQL & Relational Algebra

    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.

    1. R has no duplicate and S is non-empty
    2. R and S have no duplicates
    3. S has no duplicates and R is non-empty
    4. 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.

Answer it in the practice appMake a topic-wise quiz