Oracle Triggers MCQs with answers Page - 3

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. How can mutating table error be resolved?

  • (A) Drop table
  • (B) Use statement-level trigger or compound trigger
  • (C) Restart database
  • (D) Use view

A

Arogya • 3.49K Points
Extraordinary

Q. You want to store old salary and new salary whenever employee salary changes. What should you use?

  • (A) Function
  • (B) Audit trigger
  • (C) Cursor
  • (D) Index

A

Arogya • 3.49K Points
Extraordinary

Q. Which trigger type is best for maintaining audit history table?

  • (A) AFTER INSERT OR UPDATE OR DELETE FOR EACH ROW
  • (B) BEFORE SELECT
  • (C) Statement trigger
  • (D) System trigger

A

Arogya • 3.49K Points
Extraordinary

Q. A trigger keeps inserting records into same table repeatedly causing infinite loop. Why?

  • (A) Recursive trigger firing
  • (B) Index corruption
  • (C) Deadlock
  • (D) Network delay

A

Arogya • 3.49K Points
Extraordinary

Q. How to stop recursive trigger execution?

  • (A) Disable trigger temporarily
  • (B) Use WHEN clause condition
  • (C) Drop database
  • (D) Restart session

A

Arogya • 3.49K Points
Extraordinary

Q. You need to prevent salary from being less than 10,000 during insert. Which trigger?

  • (A) AFTER INSERT
  • (B) BEFORE INSERT
  • (C) AFTER UPDATE
  • (D) INSTEAD OF

A

Arogya • 3.49K Points
Extraordinary

Q. Which trigger fires when a user logs into database?

  • (A) DDL trigger
  • (B) LOGON trigger
  • (C) DML trigger
  • (D) Row trigger

A

Arogya • 3.49K Points
Extraordinary

Q. You want to stop users from deleting records on Sunday. What should be used?

  • (A) Constraint
  • (B) BEFORE DELETE trigger
  • (C) Index
  • (D) View

A

Arogya • 3.49K Points
Extraordinary

Q. Which pseudo record gives previous value in UPDATE trigger?

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

A

Arogya • 3.49K Points
Extraordinary

Q. A trigger updates another table when row inserted. What is this called?

  • (A) Cascading trigger
  • (B) Recursive trigger
  • (C) Mutating trigger
  • (D) Invalid 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.