Multiple choice technology databases

If the TOP option specifies a number greater than the number of rows in the query result set, then

  1. The query returns the rows in the query result set without producing an error.

  2. Return no rows

  3. Produces an error

  4. The query returns rows
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When TOP specifies a number greater than available rows, the query returns all rows without error. Database systems handle this gracefully by returning whatever rows exist in the result set, up to the TOP limit.

Keep practicing — related questions