Quiz 1Z0-147

Quiz 1Z0-147, Program with PL/SQL

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

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

which is valid with a DML trigger?

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

A CALL statement inside the trigger body enables you to call ______.

You need to remove the database triggerBUSINESS_HOUR.Which command do you use to remove the trigger in the SQL *Plus environment?

How can you migrate from a LONG to a LOB data type for a column?

Which two statements will successfully invoke this procedure in SQL *Plus?

Which two describe a stored procedure?

Which four are valid invocations?