Oracle Triggers MCQs with answers Page - 2

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. Which trigger is used on views?

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

A

Arogya • 3.49K Points
Extraordinary

Q. Which view shows trigger information?

  • (A) USER_TRIGGERS
  • (B) USER_TABLES
  • (C) USER_VIEWS
  • (D) USER_INDEXES

A

Arogya • 3.49K Points
Extraordinary

Q. Can a trigger call a procedure?

  • (A) No
  • (B) Yes
  • (C) Only in views
  • (D) Only in functions

A

Arogya • 3.49K Points
Extraordinary

Q. Which operation does NOT fire a DML trigger?

  • (A) INSERT
  • (B) UPDATE
  • (C) DELETE
  • (D) SELECT

A

Arogya • 3.49K Points
Extraordinary

Q. Which trigger fires once per statement?

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

A

Arogya • 3.49K Points
Extraordinary

Q. What happens if trigger raises an exception?

  • (A) Nothing happens
  • (B) DML operation is rolled back
  • (C) Table deleted
  • (D) Database restart

A

Arogya • 3.49K Points
Extraordinary

Q. Triggers are mainly used for:

  • (A) Data validation and auditing
  • (B) Creating tables
  • (C) Indexing
  • (D) Backup

A

Arogya • 3.49K Points
Extraordinary

Q. Which trigger tracks who updated a row?

  • (A) Audit trigger
  • (B) DDL trigger
  • (C) Log trigger
  • (D) Cursor trigger

A

Arogya • 3.49K Points
Extraordinary

Q. Which privilege is needed to create trigger?

  • (A) CREATE TABLE
  • (B) CREATE TRIGGER
  • (C) ALTER SESSION
  • (D) CREATE VIEW

A

Arogya • 3.49K Points
Extraordinary

Q. While updating a table, the trigger throws ORA-04091: table is mutating. Why?

  • (A) Trigger is too large
  • (B) Trigger is querying the same table on which it is fired
  • (C) Database memory full
  • (D) Invalid cursor

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.