Integrity Constraints Multiple Choice Questions with Answers – PDF Download

MCQ 1: If there is a chain of foreign-key dependencies across multiple relations, a deletion or update at one end of the chain may propagate:

1. No dependent
2. Entire chain
3. 1 dependent only
4. Few dependents only

MCQ 2: If any of the foreign-key columns is null, the tuple is defined automatically to satisfy the:

1. Integrity
2. Atomicity
3. Isolation
4. Constraint

MCQ 3: When a referential-integrity constraint is violated, the normal procedure is to:

1. Continue with flow
2. Accept the action
3. Reject the action
4. Store it for evaluation

MCQ 4: The SQL standard allows a clause initially deferred to be added to a:

1. Uniqueness specification
2. Atomicity specification
3. Constraint specification
4. Isolation specification

MCQ 5: By default, in SQL a foreign key references the primary-key attributes of the:

1. Referencing table
2. Referenced table
3. Primary table
4. Both the tables