Database Triggers MCQs & Quiz Online PDF eBook Download

Database triggers multiple choice questions (MCQs), database triggers quiz answers for online computer science degree. Advanced sql MCQs, database triggers quiz questions and answers for applied computer science. Learn embedded sql, jdbc and sql syntax, java database connectivity (jdbc), database triggers test prep for online degrees.

Learn advanced sql MCQ: a trigger can be dropped by using command, with choices drop trigger, alter trigger drop, define drop trigger, and declare drop trigger for applied computer science. Practice merit scholarships assessment test, online learning database triggers quiz questions for competitive exams in computer science major for online computer engineering programs.

MCQs on Database Triggers PDF eBook Download

MCQ: A trigger can be dropped by using command

  1. drop trigger
  2. alter trigger drop
  3. define drop trigger
  4. declare drop trigger

A

MCQ: To maintain materialized views, we can use

  1. Triggers
  2. Pointers
  3. Clone objects
  4. Cascading

A

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

  1. Tuples
  2. Attributes
  3. Instances
  4. Relation

A

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

  1. While statement
  2. From statement
  3. Where statement
  4. When statement

D

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

  1. Temporary relations
  2. Permanent relations
  3. Delta relations
  4. Filter relations

C