ORACLE DATABASE INTERVIEW QUESTIONS

What is the purpose of the WHERE clause in SQL?

How do you use the WHERE clause to filter rows in a SELECT statement?

How do you use comparison operators in the WHERE clause?

How do you use the WHERE clause with multiple conditions?

How do you use the LIKE operator in the WHERE clause?

How do you use the IN operator in the WHERE clause?

How do you use subqueries in the WHERE clause?

How do you use the EXISTS operator in the WHERE clause?

How do you handle NULL values in the WHERE clause?

Explain how you would optimize a query using the WHERE clause to improve performance?