Unformatted text preview: y non-updatable.
A. This could be performed by a System Event Trigger (BEFORE LOGOFF) not by an
INSTEAD OF Trigger.
B. You can't insert data into a view, however, you can insert data into the underlying
table that the view is based on.
C. This would not require an INSTEAD of Trigger, rather you would specify BEFORE
UPDATE OF ColumnName ON TableName.
Actualtests.com - The Power of Knowing 1Z0-147 QUESTION 100: When using a PL/SQL stored package, how is a side effect defined?
A. changes only to database tables
B. changes only to packaged public variables defined in a package body
C. changes only to packaged public variables defined in a package specification
D. changes to database tables or packaged public variables defined in a package body
E. changes to database tables or packaged variables defined in a package specification
Side effects are defined as changes to the database tables or the public packaged
A. Side effects are not limited to changes to the database tables. They also include
changes to public packaged variables.
B. Variables defined in the package body are not public.
C. This option excludes changes to database tables.
D. Database Tables and Public variables are not defined in a package body.
QUESTION 101: Examine this package
CREATE OR REPLACE PACKAGE discounts
PROCEDURE display_price(p_price NUMBER);
CREATE OR REPLACE PACKAGE BODY discounts
PROCEDURE display_price (p_price NUMBERI)
DBMS_OUTPUT.PUT LINE ( 'Discounted '||
Actualtests.com - The Power of Knowing 1Z0-147
The SOL*Plus SERVEROUTPUT setting is turned on in your session. You execute
the procedure DISPLAY_PRICE from SOL*Plus with the command EXECUTE
What is the result?
A. Discounted 10
B. Discounted 100
C. Discounted 0.00
D. Discounted NULL
E. Discounted 0.10
The discounts package contains...
View Full Document
- Fall '09
- Stored procedure, Incorrect Answers