Integrity Constraints MCQs Test Online PDF Book Download

Integrity constraints multiple choice questions (MCQs), integrity constraints test prep for online learning with IT degree certificate eCourses. Learn sql concepts and queries multiple choice questions (MCQs), integrity constraints quiz questions and answers. Career test on join expressions, database transactions, dbms transactions, sql data types and schemas test for online SQL join courses distance learning.

Learn sql concepts and queries practice test MCQs: if any of foreign-key columns is null, tuple is defined automatically to satisfy the, for free online courses with options integrity, atomicity, isolation, constraint for online computer science degree. Free skills assessment test is for e-learning online integrity constraints quiz questions for competitive assessment in computer science major.

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