ORACLE DATABASE INTERVIEW QUESTIONS

What is a foreign key in Oracle?

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

What is the purpose of a foreign key in a relational database?

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

What happens if you try to insert a value in the foreign key column that does not exist in the referenced primary key column?

How do you delete rows in the parent table that are referenced by a foreign key in the child table?

How do you handle circular references with foreign keys in Oracle?

Can you create a foreign key on a composite primary key in Oracle?

How do you disable and enable a foreign key constraint in Oracle?

Explain the concept of referential integrity with an example?