Consider the following three SQL queries (Assume the data in the people…

PYQ UGC NET 2015

Consider the following three SQL queries (Assume the data in the people table):

(a) Select Name from people where Age>21;

(b) Select Name from people where Height>180;

(c) Select Name from people where (Age>21) or (Height>180);

If the SQL queries 𝑎 and 𝑏 above, return 10 rows and 7 rows in the result set respectively, then what is one possible number of rows returned by the SQL query 𝑐 ?

  1. A.

    3

  2. B.

    7

  3. C.

    10

  4. D.

    21

Attempted by 1034 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…