Seq

Check

BenchMark Reason

Ins

Upd

Del

1

Mandatory foreign keys

Y

Y

2

Deferred constraints

(corrective, non-transitional)

SELECT_FOR_UPDATE

NEWVALUES

Y

Y

Y

3

Lock parent records,

and subtype records of parent records.

LOCK_RECORD

Y

Y

Y

4

Foreign key checks

FOREIGN_KEY

Y

Y

5

Deferred subtype definitions

(totality and exclusivity)

Y

Y

6

Relationship checks:

Child Must Exist, Min/Max No of Children.

CARDINALITY

Y

7

Restrictive, non-transitional, multi-record constraints

CONSTRAINT_TEST

Y

Y

Y

8

Cardinality checks for relationships in which the current record is a child.

CARDINALITY

Y

Y

Y