As an Amazon Associate I earn from qualifying purchases.

Integrity Constraints MCQs Quiz Online PDF Download eBook

Solve Integrity Constraints Multiple Choice Questions (MCQ), integrity constraints quiz answers PDF database practice test for online degree programs. Learn sql concepts and queries Multiple Choice Questions and Answers (MCQs), "Integrity Constraints Quiz" questions and answers for online college courses. Learn integrity constraints, database views test prep for top computer science schools.

"If there is a chain of foreign-key dependencies across multiple relations, a deletion or update at one end of the chain may propagate" Multiple Choice Questions (MCQ) on integrity constraints with choices no dependent, entire chain, 1 dependent only, and few dependents only for online college courses. Practice integrity constraints quiz questions for merit scholarship test and certificate programs for computer science associate degree.

MCQs on Integrity Constraints PDF Download eBook

MCQ: 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

B

MCQ: 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

D

MCQ: 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

C

MCQ: 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

C

MCQ: 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

B