GATE CSE
First time here? Checkout the FAQ!
x
+1 vote
17 views asked in Databases by (51 points)  
edited by | 17 views

1 Answer

+1 vote
C is the correct option.

For the part a.) There is no join symbol after part.

Fort part b:) after finding Red products say R1,R2,R3 we are just doing a cross prodcut with other tables.So there is no condition which says pick only supplier matching with R1,R2,R3

C:) First we filter Red product Id. R1,R2,R3,then we get the Sid supplying those Parts and then we get names of those IDs.

So c is corect option here
answered by Boss (9.7k points)  


Top Users Aug 2017
  1. Bikram

    5272 Points

  2. ABKUNDAN

    4730 Points

  3. akash.dinkar12

    3514 Points

  4. manu00x

    3492 Points

  5. rahul sharma 5

    3188 Points

  6. makhdoom ghaya

    2700 Points

  7. just_bhavana

    2432 Points

  8. stblue

    2244 Points

  9. Tesla!

    2090 Points

  10. pawan kumarln

    1876 Points


25,071 questions
32,226 answers
75,102 comments
30,232 users