Multiple choice technology databases

A call statement inside the trigger body enables you to call:

  1. Package

  2. Function

  3. Procedure

  4. Another DB trigger
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To answer this question, the user needs to know the purpose of a trigger and what it can do.

A trigger is a set of instructions that are automatically executed in response to certain events in the database. A call statement inside the trigger body enables you to call other procedures or functions.

Now, let's go through each option and explain why it is right or wrong:

A. Package: A package is a collection of related functions, procedures, and other program objects. While a trigger can call a procedure or a function inside a package, it cannot directly call a package.

B. Function: A function is a named PL/SQL block that returns a value. A trigger can call a function to retrieve a value and use it in the execution of the trigger.

C. Procedure: A procedure is a named PL/SQL block that performs one or more specific tasks. A trigger can call a procedure to perform a specific task as part of the execution of the trigger.

D. Another DB trigger: A trigger can call another trigger inside the same schema, but it cannot call a trigger in another schema.

Therefore, the correct answer is:

The Answer is: C. Procedure

Keep practicing — related questions