Integrity Constraints MCQ (Multiple Choice Questions) PDF Download

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

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

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

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

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