Triggers MCQ

Test your knowledge with important Triggers MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Triggers MCQs at Bissoy

• Which prefixes are available to Oracle triggers?
  ক

  : new only

  খ

  : old only

  গ

  Both :new and : old

  ঘ

  Neither :new nor : old
• Triggers ________ enabled or disabled
  ক

  Can be

  খ

  Cannot be

  গ

  Ought to be

  ঘ

  Always
• What are the different in triggers?
  ক

  Define, Create

  খ

  Drop, Comment

  গ

  Insert, Update, Delete

  ঘ

  All of the mentioned
• Which of the following is NOT an Oracle-supported trigger?
  ক

  BEFORE

  খ

  DURING

  গ

  AFTER

  ঘ

  INSTEAD OF
• The default extension for an Oracle SQL*Plus file is:
  ক

  .txt

  খ

  .pls

  গ

  .ora

  ঘ

  .sql
• The variables in the triggers are declared using
  ক

  –

  খ

  @

  গ

  /

  ঘ

  /@
• What are the after triggers?
  ক

  Triggers generated after a particular operation

  খ

  These triggers run after an insert, update or delete on a table

  গ

  These triggers run after an insert, views, update or delete on a table

  ঘ

  All of the mentioned
• The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.
  ক

  for insert, on

  খ

  On, for insert

  গ

  For, insert

  ঘ

  None of the mentioned
• Triggers are supported in
  ক

  Delete

  খ

  Update

  গ

  Views

  ঘ

  All of the mentioned
• A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
  ক

  Procedures

  খ

  Triggers

  গ

  Functions

  ঘ

  None of the mentioned
• The TRIGGER privilege is used for the table to be able to create and drop triggers for it.
  ক

  True

  খ

  False
• Before MySQL 5.1.6 which privilege was required to create and drop triggers?
  ক

  PRIVILEGE

  খ

  TRIGGER

  গ

  SUPER

  ঘ

  MACRO
• Which statement is used to remove a trigger?
  ক

  REMOVE

  খ

  DELETE

  গ

  DROP

  ঘ

  CLEAR
• For which of the following are triggers not supported?
  ক

  delete

  খ

  update

  গ

  insert

  ঘ

  views
• Which statement is used to create a trigger?
  ক

  CREATE TRIGGER

  খ

  CREATE TRIGGERS

  গ

  PRODUCE TRIGGER

  ঘ

  PRODUCE TRIGGERS
• Triggers enable to enforce data integrity constraints.
  ক

  True

  খ

  False