Integrity Constraints MCQs Quiz Online PDF Download

Learn integrity constraints MCQs, database management system online test for distance education, free online sql courses prep. Practice sql concepts and queries multiple choice questions (MCQs), integrity constraints quiz questions and answers. ETS GRE test prep on join expressions, database transactions, dbms transactions, integrity constraints tutorials for online SQL join courses distance learning.

Study bachelors and masters in data science degree MCQs: if there is a chain of foreign-key dependencies across multiple relations, a deletion or update at one end of chain may propagate, for online courses with choices no dependent , entire chain, 1 dependent only, few dependents only for science students and scholars to prepare for entry tests for admission in online universities and colleges. Free skills assessment test is for online learn integrity constraints quiz questions with MCQs, exam preparation questions and answers.

MCQs on Integrity Constraints Quiz PDF 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