Oracle Triggers MCQs with answers Page - 5

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. A trigger created on database startup is called?

  • (A) Startup Trigger
  • (B) System Trigger
  • (C) DDL Trigger
  • (D) Login Trigger

A

Arogya • 3.49K Points
Extraordinary

Q. Which timing cannot be used in a trigger?

  • (A) BEFORE
  • (B) AFTER
  • (C) DURING
  • (D) INSTEAD OF

A

Arogya • 3.49K Points
Extraordinary

Q. INSTEAD OF triggers are mainly used on?

  • (A) Tables
  • (B) Views
  • (C) Indexes
  • (D) Sequences

A

Arogya • 3.49K Points
Extraordinary

Q. Which statement disables a trigger?

  • (A) DROP TRIGGER
  • (B) ALTER TRIGGER DISABLE
  • (C) DELETE TRIGGER
  • (D) STOP TRIGGER

A

Arogya • 3.49K Points
Extraordinary

Q. Which trigger fires only once per DML statement?

  • (A) Row Level Trigger
  • (B) Statement Level Trigger
  • (C) Instead Of Trigger
  • (D) DDL Trigger

A

Arogya • 3.49K Points
Extraordinary

Q. What is a mutating table error?

  • (A) Table dropped
  • (B) Accessing table being modified inside row trigger
  • (C) Invalid SQL
  • (D) Deadlock

A

Arogya • 3.49K Points
Extraordinary

Q. Which trigger solves mutating table error?

  • (A) Row Trigger
  • (B) Compound Trigger
  • (C) DDL Trigger
  • (D) Before Trigger

A

Arogya • 3.49K Points
Extraordinary

Q. Can a trigger call a stored procedure?

  • (A) No
  • (B) Yes
  • (C) Only functions
  • (D) Only packages

A

Arogya • 3.49K Points
Extraordinary

Q. Which keyword restricts trigger execution based on condition?

  • (A) WHERE
  • (B) WHEN
  • (C) IF
  • (D) CHECK

A

Arogya • 3.49K Points
Extraordinary

Q. Which trigger fires before inserting a row?

  • (A) BEFORE INSERT Trigger
  • (B) AFTER INSERT Trigger
  • (C) INSTEAD INSERT Trigger
  • (D) ROW INSERT 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.