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 • 3.49K Points
Extraordinary

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 • 3.49K Points
Extraordinary

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 • 3.49K Points
Extraordinary

Q. Which trigger executes after the DML operation?

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

A

Arogya • 3.49K Points
Extraordinary

Q. Which event can fire a trigger?

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

A

Arogya • 3.49K Points
Extraordinary

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

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

A

Arogya • 3.49K Points
Extraordinary

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

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

A

Arogya • 3.49K Points
Extraordinary

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 • 3.49K Points
Extraordinary

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 • 3.49K Points
Extraordinary

Q. Which command removes a trigger?

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

A

Arogya • 3.49K Points
Extraordinary

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.