B you cant insert data into a view however you can

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: y non-updatable. Incorrect Answers 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 Answer: E Explanation: Side effects are defined as changes to the database tables or the public packaged variables. Incorrect Answers 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 IS g_id NUMBER:=7839 discount_rate NUMBER:=0.00; PROCEDURE display_price(p_price NUMBER); END discount; / CREATE OR REPLACE PACKAGE BODY discounts IS PROCEDURE display_price (p_price NUMBERI) IS BEGIN DBMS_OUTPUT.PUT LINE ( 'Discounted '|| TO_CHAR(p_price*NVL(discount_rate,1))); END discount; BEGIN Discount_rate=0.10; Actualtests.com - The Power of Knowing 1Z0-147 END discounts; / The SOL*Plus SERVEROUTPUT setting is turned on in your session. You execute the procedure DISPLAY_PRICE from SOL*Plus with the command EXECUTE discount.display_price(100); What is the result? A. Discounted 10 B. Discounted 100 C. Discounted 0.00 D. Discounted NULL E. Discounted 0.10 Answer: A Explanation: The discounts package contains...
View Full Document

Ask a homework question - tutors are online