Database Constraints and Relational Schemas MCQs Test Online pdf Download

Practice MCQs on database constraints and relational schemas with DBMS tests for online test prep and learning. Free study guide has multiple choice questions (MCQ) with database constraints and relational schemas quiz as when primary key is null of new tuple then constraint violated is, answering options null integrity constraint, primary integrity constraint, secondary integrity constraint and entity integrity constraint for exam prep. Study to learn database constraints and relational schemas quiz online with MCQs to practice test questions with answers.

MCQs on Database Constraints and Relational Schemas

MCQ. When primary key is null of new tuple then constraint violated is

  1. null integrity constraint.
  2. primary integrity constraint.
  3. secondary integrity constraint.
  4. entity integrity constraint.

D

MCQ. Key which specifies that two different tuples cannot have same value is classified as

  1. super key.
  2. simple key.
  3. parallel key.
  4. conceptual key.

A

MCQ. Constraint violated when given value of attribute is not included in corresponding domain is

  1. domain constraint.
  2. attribute constraint.
  3. key constraint.
  4. lock constraint.

A

MCQ. If two or more constraints are violated by using insert operation then by default the

  1. insert is accepted.
  2. insert is rejected.
  3. insertion permanently blocked.
  4. none of above.

B

MCQ. Multi-valued dependencies and functional dependencies are classified as category of

  1. relation dependencies.
  2. data dependencies.
  3. entity dependencies.
  4. attribute dependencies.

B

DMCA.com Protection Status