save up to 40%

What are the different states of a constraint?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What are the different states of a constraint?

Rating:

A constraint can have the following four states:

  • ENABLE VALIDATE: This state specifies that the constraint is enabled, and the existing data in the table protected by the constraint conforms to the constraint. It also ensures that new data being entered into the table also conforms to the constraint.


  • ENABLE NOVALIDATE: This state specifies that the constraint is enabled, but the existing data in the table protected by the constraint may violate the constraint. However, it ensures that new data being entered into the table conforms to the constraint.


  • DISABLE VALIDATE: This state specifies that the constraint is disabled but still remains valid. In this state, no Data Manipulation Language (DML) operation is allowed on the table protected by the constraint.


  • DISABLE NOVALIDATE: This state specifies that the constraint is disabled and invalidated.


    • Rating:



    Other articles

    Click here to Article home

     
    uCertify.com | Our Company | Articles | Privacy | Security | Contact Us | News and Press Release | uCertify India
    MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD Cisco Certification: CCNA, CCENT, A+, Network+, Security+
    Oracle Certification: OCP 9i, OCP 10g, OCA 9i, OCA 10g CIW foundation    EC-212-32    CISSP    Photoshop ACE    Adobe Flash ACE
    © 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.