GATE CSE
First time here? Checkout the FAQ!
x
+1 vote
30 views asked in Databases by (121 points) 1 2 6
edited by | 30 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 Veteran (15k points) 13 111 317


Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
Top Users Oct 2017
  1. Arjun

    23678 Points

  2. Bikram

    17278 Points

  3. Habibkhan

    8960 Points

  4. srestha

    6450 Points

  5. Debashish Deka

    5478 Points

  6. jothee

    5128 Points

  7. Sachin Mittal 1

    4882 Points

  8. joshi_nitish

    4486 Points

  9. sushmita

    4032 Points

  10. Rishi yadav

    3974 Points


Recent Badges

Notable Question Sedhu Raman
Notable Question cse23
Notable Question vishwa ratna
Notable Question learner_geek
Popular Question Devshree Dubey
Popular Question nish kim
Popular Question Simar sandhu
Popular Question Rashi Gupta
Notable Question Akriti sood
Popular Question Samujjal Das
27,407 questions
35,256 answers
84,506 comments
33,480 users