Oracle Triggers MCQs with answers Page - 4

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 type executes for CREATE TABLE statements?

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

A

Arogya • 3.49K Points
Extraordinary

Q. Trigger becomes INVALID. What should you do?

  • (A) Delete trigger
  • (B) ALTER TRIGGER trigger_name COMPILE
  • (C) Restart database
  • (D) Reinstall Oracle

A

Arogya • 3.49K Points
Extraordinary

Q. Which view shows trigger compilation errors?

  • (A) USER_ERRORS
  • (B) USER_TABLES
  • (C) USER_INDEXES
  • (D) USER_CONSTRAINTS

A

Arogya • 3.49K Points
Extraordinary

Q. Which trigger allows DML operations on complex view?

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

A

Arogya • 3.49K Points
Extraordinary

Q. Which trigger fires once for each row affected by a DML statement?

  • (A) Statement Level Trigger
  • (B) Row Level Trigger
  • (C) Database Trigger
  • (D) System Trigger

A

Arogya • 3.49K Points
Extraordinary

Q. Which clause is required to create a row-level trigger?

  • (A) FOR EACH ROW
  • (B) AFTER EACH ROW
  • (C) WHEN EACH ROW
  • (D) PER ROW

A

Arogya • 3.49K Points
Extraordinary

Q. Which pseudo record contains the old values in an UPDATE trigger?

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

A

Arogya • 3.49K Points
Extraordinary

Q. Which pseudo record contains the new values in an INSERT trigger?

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

A

Arogya • 3.49K Points
Extraordinary

Q. What will happen if a trigger raises an exception?

  • (A) Only trigger fails
  • (B) Entire transaction rolls back
  • (C) Table is dropped
  • (D) Nothing happens

A

Arogya • 3.49K Points
Extraordinary

Q. Which trigger type fires after a table is dropped?

  • (A) DDL Trigger
  • (B) DML Trigger
  • (C) Row Trigger
  • (D) Compound 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.