ORACLE DATABASE INTERVIEW QUESTIONS

What are the different types of indexes available in Oracle?

What is a B-tree index, and when should you use it?

What is a bitmap index, and when should you use it?

What are unique indexes, and how do you create one in Oracle?

How do composite indexes work, and when should you use them?

What are function-based indexes, and how are they created in Oracle?

How do bitmap indexes differ from B-tree indexes in terms of performance and use cases?

What are reverse key indexes, and when should you use them?

How do you monitor and maintain different types of indexes in Oracle?

Explain the benefits and trade-offs of using different index types with an example?