Concepts and Architecture Question:
Download Questions PDF

Explain can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint?

Answer:

Yes.Use Enable Novalidate to enforce the constraints. Existing data will not be checked, only new/update will be validated.

Download Oracle Architecture and Concepts Interview Questions And Answers PDF

Previous QuestionNext Question
Do you know how are Indexes Update?Explain what is meant by snapshot error?