ORACLE DATABASE INTERVIEW QUESTIONS

What is cardinality in the context of a database?

How does cardinality affect database performance?

What is the difference between high cardinality and low cardinality?

How do you determine the cardinality of a column in Oracle?

What is the significance of cardinality in query optimization?

How can you improve query performance by considering cardinality?

How does the concept of cardinality apply to database joins?

How do you gather statistics for cardinality estimation in Oracle?

Explain the role of cardinality in the execution plan of a complex query with an example?

What are histograms, and how do they relate to cardinality?