Database-Management-System

Question 545

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.

Database-Management-SystemSQLUGC NET CS 2011 Dec-Paper-2

Question 545 Explanation:

Since the query is co-related that is same table is being used two times for comparison so compare each entry of table T with every entry of table S. Then the outcome for above query will be

So the output contains all branches that have greater asset than any branch located in DELHI.

Correct Answer: A

Question 545 Explanation:

Since the query is co-related that is same table is being used two times for comparison so compare each entry of table T with every entry of table S. Then the outcome for above query will be

So the output contains all branches that have greater asset than any branch located in DELHI.