Concepts and Architecture Question:

Download Job Interview Questions and Answers PDF

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

Oracle Architecture and Concepts Interview Question
Oracle Architecture and Concepts Interview Question

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?