The SQL Expression Select distinct T. branch name from branch T, branch S…

PYQ UGC NET 2011Modified — slightly modified from the official paper; see the solution

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

  1. A.

    all branches that have greater asset than any branch located in DELHI.

  2. B.

    all branches that have greater assets than allocated in DELHI.

  3. C.

    the branch that has the greatest asset in DELHI.

  4. D.

    any branch that has greater asset than any branch located in DELHI.

Attempted by 40 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…