POSTGRESQL DATABASE INTERVIEW QUESTIONS

What does the LIMIT clause do in PostgreSQL?

Can you use the LIMIT clause without the OFFSET clause in PostgreSQL?

Is the LIMIT clause specific to PostgreSQL, or is it available in other SQL databases like ORACLE?

How does the LIMIT clause improve query performance in PostgreSQL?

Can the LIMIT clause be used with the ORDER BY clause? Explain with a use case.

What will happen if the number specified in the LIMIT clause is greater than the number of rows available in the result set?

Explain the difference between the LIMIT clause in PostgreSQL and the equivalent row limiting feature in ORACLE.

Describe a scenario where using LIMIT in a subquery could optimize query performance in PostgreSQL.

How would you handle pagination in a PostgreSQL query using LIMIT and OFFSET? Explain with an example.

What are the potential drawbacks of using LIMIT and OFFSET for pagination in PostgreSQL, and how can they be mitigated?