Oracle Triggers MCQs with answers Page - 1

Here, you will find a collection of MCQ questions on Oracle Triggers. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Arogya • 1.97K Points
Master

Q. What is a trigger in Oracle?

  • (A) A stored SQL query
  • (B) A PL/SQL block that automatically executes when a database event occurs
  • (C) A view
  • (D) An index

A

Arogya • 1.97K Points
Master

Q. When does a BEFORE trigger execute?

  • (A) After commit
  • (B) Before the DML operation occurs
  • (C) After database shutdown
  • (D) After select statement

A

Arogya • 1.97K Points
Master

Q. Which trigger executes after the DML operation?

  • (A) BEFORE trigger
  • (B) DURING trigger
  • (C) AFTER trigger
  • (D) END trigger

A

Arogya • 1.97K Points
Master

Q. Which event can fire a trigger?

  • (A) INSERT
  • (B) UPDATE
  • (C) DELETE
  • (D) All of the above

A

Arogya • 1.97K Points
Master

Q. Which keyword refers to new values in a row-level trigger?

  • (A) :OLD
  • (B) :NEW
  • (C) :VALUE
  • (D) :DATA

A

Arogya • 1.97K Points
Master

Q. Which keyword refers to old values in a row-level trigger?

  • (A) :OLD
  • (B) :NEW
  • (C) :PREV
  • (D) :PAST

A

Arogya • 1.97K Points
Master

Q. Which clause specifies trigger firing for each row?

  • (A) FOR EACH ROW
  • (B) FOR ALL ROWS
  • (C) ROW LEVEL
  • (D) PER ROW

A

Arogya • 1.97K Points
Master

Q. A trigger without 'FOR EACH ROW' is called:

  • (A) Row-level trigger
  • (B) Statement-level trigger
  • (C) Column trigger
  • (D) View trigger

A

Arogya • 1.97K Points
Master

Q. Which command removes a trigger?

  • (A) DELETE TRIGGER
  • (B) REMOVE TRIGGER
  • (C) DROP TRIGGER
  • (D) CLEAR TRIGGER

A

Arogya • 1.97K Points
Master

Q. Which trigger can prevent invalid data entry?

  • (A) BEFORE trigger
  • (B) AFTER trigger
  • (C) INSTEAD OF trigger
  • (D) SYSTEM trigger

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.