Free Test Limiting with LIMIT &... – SQL

Q1: Which keyword is used in MySQL to restrict the number of rows returned?

A. ROWNUM B. TOP C. LIMIT D. FETCH FIRST

Q2: Which clause is used in MySQL to limit the number of rows returned?

A. TOP B. ROWNUM C. LIMIT D. FIRST

Q3: What is the correct way to return only the first 5 rows in MySQL?

A. SELECT TOP 5 * FROM table; B. SELECT * FROM table WHERE ROWNUM <= 5; C. SELECT * FROM table LIMIT 5; D. SELECT FIRST 5 * FROM table;

Q4: Which clause is used in Oracle to limit the number of rows returned?

A. TOP B. LIMIT C. ROWNUM D. OFFSET

Q5: In SQL Server, how do you return only the top 10 records?

A. LIMIT 10 B. ROWNUM <= 10 C. TOP 10 D. SELECT FIRST 10

Q6: Which keyword is used with LIMIT to skip rows in MySQL?

A. OFFSET B. SKIP C. TOP D. ROWNUM

Q7: How do you select rows 11 to 20 in MySQL?

A. LIMIT 11, 20 B. LIMIT 10 OFFSET 10 C. TOP 10 OFFSET 10 D. ROWNUM 11 TO 20

Q8: Which is the default row limiting behavior if LIMIT is not specified?

A. All rows B. First 10 rows C. First 100 rows D. No rows

Q9: In PostgreSQL, which keyword is used to limit rows?

A. TOP B. ROWNUM C. LIMIT D. MAX

Q10: What does the LIMIT 0 clause return?

A. First row B. No rows C. All rows D. Last row

Q11: How can you select only 3 rows skipping the first 2 in MySQL?

A. LIMIT 2,3 B. LIMIT 3 OFFSET 2 C. TOP 3 SKIP 2 D. ROWNUM > 2 AND <= 5

Q12: Which database supports SELECT TOP N syntax?

A. MySQL B. Oracle C. SQL Server D. PostgreSQL

Q13: In Oracle, which is valid syntax to return the first row?

A. SELECT * FROM table LIMIT 1; B. SELECT * FROM table WHERE ROWNUM = 1; C. SELECT TOP 1 * FROM table; D. SELECT FIRST 1 * FROM table;

Q14: Which function is used in SQL Server to assign row numbers?

A. ROWNUM() B. ROW_NUMBER() C. RANK() D. LIMIT()

Q15: How do you fetch the top 50% rows in SQL Server?

A. SELECT TOP 50% * FROM table; B. LIMIT 50% C. ROWNUM < 50% D. SELECT * FROM table OFFSET 50%

Q16: What does LIMIT 5 OFFSET 10 return?

A. First 5 rows B. Rows 6-10 C. Rows 11-15 D. All rows after 10th

Q17: Which is NOT a valid SQL keyword for limiting rows?

A. TOP B. LIMIT C. ROWNUM D. COUNT

Q18: Can you use LIMIT without ORDER BY?

A. Yes B. No C. Only in MySQL D. Only in Oracle

Q19: What is the purpose of OFFSET in SQL?

A. Sort results B. Skip rows C. Count rows D. Group rows

Q20: Which of the following is true about LIMIT?

A. It reduces data transfer B. It reduces query time C. It limits displayed rows D. All of the above

Q21: Which database uses FETCH FIRST N ROWS ONLY?

A. SQL Server B. PostgreSQL C. Oracle 12c+ D. All of the above

Quiz for Limiting with LIMIT & TOP & ROWNUM