Consider the following Relational Schema and the SQL Query that follows: R(A,…

Consider the following Relational Schema and the SQL Query that follows:

R(A, B, C)

SELECT A, B, C From R ORDER BY C DESC, B ASC;

What conditions must a tuple t satisfy so that t necessarily precedes the tuple (7, 7, 7)? Identify one such tuple from the list below.

  1. A.

    (5, 9, 7)

  2. B.

    (5, 8, 5)

  3. C.

    (9, 4, 7)

  4. D.

    (3, 7, 7)

Attempted by 754 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…