Multiple choice technology databases

An application developer needs to write a PL/SQL code, wherein salary raise to be processed for all the employees of grade "C2" and above. As per the Oracle recommended standards, Which PL/SQL objects should be part of his application code? Choose all that apply

  1. Package

  2. Stored Procedure

  3. Cursor

  4. Stored Function

  5. View

  6. Trigger

Reveal answer Fill a bubble to check yourself
A,B,C,E Correct answer
Explanation

For processing salary raises for employees meeting a grade criteria, a Stored Procedure encapsulates the business logic, a Package organizes related procedures/functions, a Cursor iterates through employee rows, and a View can filter employees by grade C2 and above. Stored Functions return values (not ideal for DML operations), Triggers fire automatically (not for scheduled processing). The correct answers are A, B, C, E.