relational data model and database constraints

MCQsQuestion.com has 7 Question/Answers about Topic relational data model and database constraints

Format or data type must be specified for

Format or data type must be specified for
  • A. table ender
  • B. entity domain
  • C. range
  • D. domain
  • Correct Answer: Option D

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

If two or more constraints are violated by using insert operation then by default the
  • A. insert is accepted
  • B. insert is rejected
  • C. insertion permanently blocked
  • D. none of above
  • Correct Answer: Option B

Constraints which deals with changes in database are classified as

Constraints which deals with changes in database are classified as
  • A. assertion constraints
  • B. trigger constraints
  • C. specified constraints
  • D. transition constraints
  • Correct Answer: Option D

Constraint which is used to specify consistency in two or more relations among tuples is classified as

Constraint which is used to specify consistency in two or more relations among tuples is classified as
  • A. primary integrity constraint
  • B. entity integrity constraint
  • C. referential integrity constraint
  • D. null integrity constraint
  • Correct Answer: Option B

Distribution in which each row denote some related values collection is classified as

Distribution in which each row denote some related values collection is classified as
  • A. record
  • B. entity
  • C. concept
  • D. table
  • Correct Answer: Option D

State in which database does not follow integrity constraints is classified as

State in which database does not follow integrity constraints is classified as
  • A. parallel state
  • B. invalid state
  • C. valid state
  • D. candidate state
  • Correct Answer: Option B

Constraint violated when key value in tuple already exists in some other relation’s tuple is called

Constraint violated when key value in tuple already exists in some other relation’s tuple is called
  • A. domain constraint
  • B. attribute constraint
  • C. key constraint
  • D. lock constraint
  • Correct Answer: Option C