UGC NET CSE | December 2011 | Part 2 | Question: 25

Question

The $SQL$ Expression Select distinct $T$. branch name from branch $T$, branch $S$ where $T$. assets $> S$. assets and $S$. branch-city = DELHI, finds the name of

• A. All branches that have greater asset than any branch located in DELHI.
• B. All branches that have greater assets than allocated in DELHI.
• C. The branch that has the greatest asset in DELHI.
• D. Any branch that has greater asset than any branch located in DELHI.

Comments

D option ans .?

Because  if more than same branch name if exist in relation T than option a and b not possible because query says distinct and in options a as well as in b it says All branches which is not true !

C option also seems false because there is possibility that city may not delhi and has greatest assests!

Answer 1

SELECT distinct TT. branch name

From branch TT, branch SS 

Where TT. assets >SS.assets and SS.branch-city = DELHI

Return : Any branch that has greater asset than any(any one )  branch located in DELHI.

Answer 2

Here S is located in delhi, and S could me many ,,for say 3 branched in delhi  asset =30,40,50  and T has 40,60now according to query t.asset>s.asset and here 40>30 and 60>all s

any T that is larger than any S will be printed

 

D is the correct answer