Integrity Constraints MCQs & Quiz Online PDF eBook Download

Integrity constraints multiple choice questions (MCQs), integrity constraints quiz answers for online computer science degree. Sql concepts and queries MCQs, integrity constraints quiz questions and answers for online college courses. Learn database views, integrity constraints test prep for top computer science schools.

Learn sql concepts and queries MCQ: if there is a chain of foreign-key dependencies across multiple relations, a deletion or update at one end of chain may propagate, with choices no dependent, entire chain, 1 dependent only, and few dependents only for online college courses. Practice merit scholarships assessment test, online learning integrity constraints quiz questions for competitive exams in computer science major for computer science associate degree.

MCQs on Integrity Constraints PDF eBook Download

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

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

B

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

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

D

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

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

C

MCQ: 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 primary-key attributes of the

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

B