Integrity constraint state benefits - Oracle Schema

Q.  Efficient Use of Integrity Constraints: A Procedure Using integrity constraint states in which of the following order can ensure the best benefits?

1. Disable state.
2. Perform the operation (load, export, import).
3. Enable novalidate state.
4. Enable state.

- Published on 12 Aug 15

a. 1, 2, 3, 4
b. 2, 1, 3, 4
c. 4, 2, 1, 3
d. 1, 3, 2, 4

ANSWER: 1, 2, 3, 4
 

    Discussion

  • Nirja Shah   -Posted on 25 Sep 15
    - Using integrity constraint states in the following order can ensure the best benefits:
    1. Disable state.

    2. Perform the operation (load, export, import).

    3. Enable novalidate state.

    4. Enable state.

    - Some benefits of using constraints in this order are:
    1. No locks are held.

    2. All constraints can go to enable state concurrently.

    3. Constraint enabling is done in parallel.

    4. Concurrent activity on table is permitted.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)