How many CREATE TRIGGER statements are there?

Oracle - Quiz(MCQ)

Correct Answer : 6

Explanation : There are six CREATE TRIGGER statements according to their firing points : BEFORE INSERT TRIGGER, BEFORE UPDATE TRIGGER, BEFORE DELETE TRIGGER, AFTER INSERT TRIGGER, AFTER UPDATE TRIGGER and AFTER DELETE TRIGGER.

Recently Updated in Oracle Questions

Which of the following is/are the default index(es) provided by Oracle Database 12c?

Domain index

Bitmap index

Global and local

B - tree index

Correct Answer : B - tree index

In oracle Database 12c, when a server process is started, Oracle Database creates a non-shareMemory that contains data and control information. Which of the following options represents this memory?

System Global Area (SGA)

Program Global Area (PGA)

Both (A) and (B)

None of the above

Correct Answer : Program Global Area (PGA)

For which of the following platforms in Oracle Database 12c, remote operating system authentication over a secure connection is supported?

Mac OS platform

Windows platform

Unix platform

Linux platform

Correct Answer : Windows platform