Quiz 1Z0-147

Quiz 1Z0-147, Program with PL/SQL

A CALL statement inside the trigger body enables you to call…

Which command do you use to remove the trigger in the SQL *Plus environment?

Which dictionary view can you query to determine the names of the procedures and functions that invoke the CALC_TEAM_AVG function?

For the timing information, which is valid with a DML trigger?

Which type of argument passes a value from a procedure to the calling environment?

What is the most appropriate location to store the code that calculates the discounts?

Which statement about triggers is true?

Which statement, when added to the above procedure will successfully invoke the UPD_BAT_STAT procedure?

Which four triggering events can cause a trigger to fire? (Choose four)

" Which command can you issue to see the actual error message?