database triggers

mcqspedia.com has 5 Question/Answers about Topic database triggers

A collection of triggers can be created on each relation to record changes in relations called

A collection of triggers can be created on each relation to record changes in relations called
  • A. Temporary relations
  • B. Permanent relations
  • C. Delta relations
  • D. Filter relations
  • Correct Answer: Option C

For triggers in SQL, statement that specifies a condition is said to be

For triggers in SQL, statement that specifies a condition is said to be
  • A. While statement
  • B. From statement
  • C. Where statement
  • D. When statement
  • Correct Answer: Option D

System executes rest of trigger body that is satisfying condition only for the

System executes rest of trigger body that is satisfying condition only for the
  • A. Tuples
  • B. Attributes
  • C. Instances
  • D. Relation
  • Correct Answer: Option A

To maintain materialized views, we can use

To maintain materialized views, we can use
  • A. Triggers
  • B. Pointers
  • C. Clone objects
  • D. Cascading
  • Correct Answer: Option A

A trigger can be dropped by using command

A trigger can be dropped by using command
  • A. drop trigger
  • B. alter trigger drop
  • C. define drop trigger
  • D. declare drop trigger
  • Correct Answer: Option A