VALIDATE to NOVALIDATE simply forgets that the data was ever checked Moving a

Validate to novalidate simply forgets that the data

This preview shows page 5 - 9 out of 17 pages.

VALIDATE to NOVALIDATE simply forgets that the data was ever checked. Moving a single constraint from the ENABLE NOVALIDATE state to the ENABLE VALIDATE state does not block reads, writes, or other DDL statements.
Image of page 5
03)Briefly describe what is constraint checking? (10 Points)
Image of page 6
04)Briefly describe what are guidelines for defining Constraints? (10 Points)
Image of page 7
Image of page 8
Image of page 9

You've reached the end of your free preview.

Want to read all 17 pages?

  • Spring '16
  • administrator, Foreign key, Constraint, resource limits

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture