Integrity Constraints MCQs Quiz Online PDF Download

Learn integrity constraints MCQs, database management system test for online learning courses, test prep to practice test. Sql concepts and queries quiz has multiple choice questions (MCQ), integrity constraints quiz questions and answers, join expressions, database transactions, dbms transactions, integrity constraints tutorials for online SQL join courses distance learning.

Database management system practice test 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 science students and scholars to prepare for entry tests for admission in online universities and colleges. Free study guide is for online learning integrity constraints quiz with MCQs to practice test questions with 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