⟩ Explain can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint?
Yes.Use Enable Novalidate to enforce the constraints. Existing data will not be checked, only new/update will be validated.
Question and Answer:
Home Oracle Architecture and Concepts
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
Explain Transaction?
Explain What does COMMIT do?
Explain What is the function of Optimizer?
Explain What are the different approaches used by Optimizer in choosing an execution plan ?
Explain There is a field of type character in the table, but we are storing numeric values like (Roll number) in this field, so if we want to sort the field (in java) according to numbers. How?
Explain When does a Transaction end?
Explain What does ROLLBACK do?
What is COST-based approach to optimization?
Explain What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command?
Explain What are the factors that affect OPTIMIZER in choosing an Optimization approach?
