ORACLE DATABASE INTERVIEW QUESTIONS

What is SQL and what does it stand for?

What are the basic SQL commands?

How do you write a simple SELECT query in SQL?

What is the purpose of the WHERE clause in SQL?

Explain the difference between INNER JOIN and OUTER JOIN in SQL.?

How do you use the GROUP BY clause in SQL?

What are subqueries in SQL and how are they used?

Explain the concept of indexes in SQL and their types?

What is a stored procedure in SQL and how do you create one in Oracle?

Describe the concept of a cursor in Oracle SQL and its types?