Examine the following code:

What is the outcome?

The procedure is created successfully and displays the values 20 and 30 when it is called.
The procedure gives errors because the parameters should be in out mode.
The procedure gives errors because the host variables cannot be referenced anywhere in the definition of a PL/SQL stored procedure.
The procedure is created successfully but does not display any values when it is called because the host variables cannot be displayed inside the procedure.

Answer(s): C

View the Exhibit and examine the structure of the customer table.

What is the outcome?

The trigger is fired, a message is displayed, and the update is successful
The trigger is fired and a message is displayed, but the update is rolled back.
The trigger is not fired because the when clause should be used to specify the condition, however, the update is successful.
The trigger is not fired because column names must be specified with the update event to identify which columns must be changed to cause the trigger to fire, however, the update is successful.

Answer(s): D

Which two statements are correct about PL/SQL package components? (Choose two)

A package must have both specification and body.
A package body can exist without the package specification.
A package specification can exist without the package body.
When a packaged public variable is called for the first time in a session, the entire package is loaded into memory.

Answer(s): C,D

Which system events can be used to create triggers that fire both at database and schema levels? (Choose all that apply)

Answer(s): A,D

http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/create_trigger.htm#LNPLS2064

Free Oracle 1Z0-144 Exam Questions (page: 4)