constraints in sql

mcqspedia.com has 5 Question/Answers about Topic constraints in sql

Referential triggered action clause in Standard Query Language is attached to constraint called

Referential triggered action clause in Standard Query Language is attached to constraint called
  • A. primary key constraint
  • B. stamped key constraint
  • C. interval notation constraint
  • D. foreign key constraint
  • Correct Answer: Option D

Clause used in SQL for ensuring referential integrity is classified as

Clause used in SQL for ensuring referential integrity is classified as
  • A. PRIMARY KEY clause
  • B. SECONDARY KEY clause
  • C. FOREIGN KEY clause
  • D. INTERVAL KEY clause
  • Correct Answer: Option C

If explicit value of attributes is not provided in SQL then value included in new tuple in such situation is called

If explicit value of attributes is not provided in SQL then value included in new tuple in such situation is called
  • A. sampled statement
  • B. decimal value
  • C. notation statement
  • D. default value
  • Correct Answer: Option D

If referential integrity constraint is violated then specific action clause attached by database designers other than by default action is classified as

If referential integrity constraint is violated then specific action clause attached by database designers other than by default action is classified as
  • A. referential triggered action
  • B. foreign key triggered action
  • C. primary key triggered action
  • D. decimal triggered action
  • Correct Answer: Option A

Constraints that are applied on individual tuples and are verified whenever any tuple is modified or new tuple is inserted are called

Constraints that are applied on individual tuples and are verified whenever any tuple is modified or new tuple is inserted are called
  • A. language based constraints
  • B. tuple based constraints
  • C. scale based constraints
  • D. precision based constraints
  • Correct Answer: Option B