Oracle - Triggers MCQ

Oracle – Triggers

1 / 25

1. In Oracle, what is the primary purpose of DML triggers?

To enforce data constraints

To create tables

To perform calculations

To define variables

2 / 25

2. What does DML stand for in the context of Oracle triggers?

Data Manipulation Language

Database Management Language

Data Modeling Language

Dynamic Markup Language

3 / 25

3. What happens when you create multiple triggers of the same type on a table in Oracle?

Triggers must have unique names

Triggers execute in alphabetical order

Triggers execute in a random order

Only one trigger can be created

4 / 25

4. What is the main purpose of using compound triggers in Oracle?

To prevent mutating table errors

To create nested triggers

To combine DDL and DML triggers

To enforce data constraints

5 / 25

5. In Oracle, what is a mutating table error in the context of triggers?

An error that occurs when a trigger references the table being modified

An error that occurs when a trigger is created

An error that occurs when a trigger references a variable

An error that occurs when a trigger is disabled

6 / 25

6. What is the primary advantage of using INSTEAD OF triggers in Oracle?

They execute automatically

They enforce data constraints

They provide a workaround for DDL triggers

They allow custom handling of DML operations

7 / 25

7. Which type of trigger in Oracle can be used to handle events such as database startup and shutdown?

Database event triggers

INSTEAD OF triggers

AFTER SUSPEND triggers

DDL triggers

8 / 25

8. What is the primary purpose of the LOGON trigger in Oracle?

To enforce data constraints

To create tables

To track database changes

To prevent unauthorized access

9 / 25

9. In Oracle, what type of trigger can be used to replace DML operations with custom logic?

Database event trigger

AFTER SUSPEND trigger

INSTEAD OF trigger

DDL trigger

10 / 25

10. What is the primary role of the DBMS_RESUMABLE package in Oracle triggers?

To create triggers

To enforce data constraints

To track database changes

To handle resumable space errors

11 / 25

11. In Oracle, how can you check the validity of triggers?

By using the TRIGGER_STATUS function

By querying the DBA_TRIGGERS view

By executing a DDL statement

By disabling and re-enabling triggers

12 / 25

12. What is the primary purpose of disabling a trigger in Oracle?

To improve trigger performance

To prevent trigger execution

To create tables

To enforce data constraints

13 / 25

13. In Oracle, what is the primary role of an INSTEAD OF DELETE trigger?

To prevent DELETE operations

To execute a DELETE statement

To replace DELETE operations with custom logic

To enforce data constraints

14 / 25

14. What does DDL stand for in the context of Oracle triggers?

Database Management Language

Data Definition Language

Dynamic Markup Language

Data Manipulation Language

15 / 25

15. In Oracle, what type of trigger is fired when a tablespace runs out of space?

AFTER SUSPEND trigger

LOGON trigger

INSTEAD OF trigger

ORA_SPACE_ERROR_INFO trigger

16 / 25

16. What is the primary purpose of the INSTEAD OF INSERT trigger in Oracle?

To replace INSERT operations with custom logic

To enforce data constraints

To execute an INSERT statement

To prevent INSERT operations

17 / 25

17. In Oracle, what is the primary role of the STARTUP trigger?

To execute when a user logs in

To execute when the database starts

To enforce data constraints

To prevent logon attempts

18 / 25

18. What is the primary advantage of using AFTER SUSPEND triggers in Oracle?

They handle resumable space errors

They execute before DML triggers

They execute before DDL triggers

They enforce data constraints

19 / 25

19. In Oracle, what is the purpose of the ORA_SPACE_ERROR_INFO function?

To create triggers

To enforce data constraints

To track database changes

To handle resumable space errors

20 / 25

20. What is the primary purpose of the SHUTDOWN trigger in Oracle?

To enforce data constraints

To execute when the database starts

To execute when a user logs in

To execute when the database shuts down

21 / 25

21. How can you view the triggers in an Oracle database?

By using the DBA_TRIGGERS view

By disabling triggers

By querying the TRIGGERS table

By executing a SELECT statement

22 / 25

22. What is the primary purpose of creating a disabled trigger in Oracle?

To create tables

To improve trigger performance

To enforce data constraints

To prevent trigger execution

23 / 25

23. In Oracle, what type of trigger is fired when a session is suspended due to a space error?

AFTER SUSPEND trigger

INSTEAD OF trigger

ORA_SPACE_ERROR_INFO trigger

LOGON trigger

24 / 25

24. What is the main advantage of using INSTEAD OF UPDATE triggers in Oracle?

They allow custom handling of UPDATE operations

They execute automatically

They provide a workaround for DDL triggers

They enforce data constraints

25 / 25

25. In Oracle, what type of trigger can be used to execute custom logic after an error occurs?

LOGON trigger

Database event trigger

DDL trigger

SERVERERROR trigger

Your score is

0%

Oracle – Triggers MCQ