Integrity Constraints MCQs & Quiz Online PDF Book Download

Integrity constraints MCQs, integrity constraints quiz answers to learn data analytics courses online. Sql concepts and queries multiple choice questions (MCQs), integrity constraints quiz questions and answers for online undergraduate computer science degree. Database views, integrity constraints test prep for data analytics certification.

Learn sql concepts and queries test MCQs: 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 undergraduate computer science degree. Practice assessment test for scholarships, online learning integrity constraints quiz questions for competitive assessment in computer science major for big data certification.

MCQ on Integrity Constraints Quiz Book 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