ORACLE DATABASE INTERVIEW QUESTIONS

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

Why are surrogate keys used in database design?

How do you define a surrogate key in an Oracle table?

What are the advantages and disadvantages of using surrogate keys?

How do surrogate keys differ from natural keys?

How do you generate surrogate keys using sequences in Oracle?

How do surrogate keys impact database normalization?

What are the considerations for choosing between surrogate keys and natural keys in a data warehouse?

How can you handle surrogate key generation in a distributed database environment?

Explain the role of surrogate keys in a star schema with an example?