ORACLE DATABASE INTERVIEW QUESTIONS

What is a subquery in SQL?

Can a subquery return multiple rows? Provide an example.

What is the difference between a correlated and a non-correlated subquery?

How do you use subqueries in the SELECT clause in Oracle?

How do you use subqueries with the EXISTS operator in Oracle?

How do you use subqueries in the FROM clause in Oracle?

How do you use correlated subqueries in Oracle?

How do you optimize queries that use subqueries in Oracle?

How do you handle subqueries that return multiple columns in Oracle?

Explain a scenario where you need to use complex subqueries in a real-world application and how you would implement it in Oracle.