ORACLE DATABASE INTERVIEW QUESTIONS

What is a business key in the context of a database?

What is a natural key in a database?

What is a candidate key in a database?

How do you choose between a natural key and a surrogate key when designing a database schema?

Can a table have multiple candidate keys? If so, how are they managed?

What are the advantages and disadvantages of using natural keys?

How do you enforce candidate keys in Oracle?

How do business keys impact database normalization?

Explain with an example how to implement and use a candidate key, business key, and natural key in Oracle.

How can you handle the changes in natural keys in a relational database?