ORACLE DATABASE INTERVIEW QUESTIONS

What is a database index in Oracle?

How do you create an index in Oracle?

What are the benefits of using indexes in a database?

What are the different types of indexes available in Oracle?

How do you drop an index in Oracle?

What is the difference between a unique index and a non-unique index?

How does the optimizer use indexes to improve query performance in Oracle?

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

How do you monitor and maintain indexes in Oracle?

Explain the concept of index clustering factor and its impact on query performance with an example.