database constraints and relational schemas

mcqspedia.com has 5 Question/Answers about Topic database constraints and relational schemas

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

Multi-valued dependencies and functional dependencies are classified as category of
  • A. relation dependencies
  • B. data dependencies
  • C. entity dependencies
  • D. attribute dependencies
  • Correct Answer: Option B

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

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

Constraint violated when given value of attribute is not included in corresponding domain is
  • A. domain constraint
  • B. attribute constraint
  • C. key constraint
  • D. lock constraint
  • Correct Answer: Option A

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

Key which specifies that two different tuples cannot have same value is classified as
  • A. super key
  • B. simple key
  • C. parallel key
  • D. conceptual key
  • Correct Answer: Option A

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

When primary key is null of new tuple then constraint violated is
  • A. null integrity constraint
  • B. primary integrity constraint
  • C. secondary integrity constraint
  • D. entity integrity constraint
  • Correct Answer: Option D