ORACLE DATABASE INTERVIEW QUESTIONS

What is a primary key in Oracle?

How do you define a primary key when creating a table in Oracle?

Can a primary key consist of multiple columns in Oracle?

How do you add a primary key to an existing table in Oracle?

What are the restrictions associated with primary keys in Oracle?

How does a primary key differ from a unique key in Oracle?

How do you handle primary key violations in Oracle?

Can a primary key be modified in Oracle? If so, how?

How does Oracle handle primary key indexing?

Explain the importance of primary keys in relational database design with an example?