ORACLE DATABASE INTERVIEW QUESTIONS

What is the purpose of the LIMIT clause in SQL?

How do you retrieve the first 10 rows from a table in Oracle?

How does ROWNUM work in Oracle?

How do you retrieve a specific range of rows, such as rows 11 to 20, in Oracle?

How can you combine the LIMIT equivalent with an ORDER BY clause in Oracle?

How do you use the FETCH FIRST clause to limit rows in Oracle 12c and later versions?

How do you implement pagination in Oracle using the OFFSET and FETCH clauses?

How can you dynamically limit the number of rows returned by a query using bind variables in Oracle?

How do you use the RANK() function with the FETCH FIRST clause to retrieve top N rows based on a condition?

Explain a scenario where you need to limit the number of rows returned by a query and how you would implement it in Oracle.