Oracle 1Z0-147 Actual Free Exam Questions & Community Discussion

Examine this package:
CREATE OR REPLACE PACKAGE manage_emps
IS
tax_rate CONSTANT NUMBER(5,2) := .28;
v_id NUMBER;
PROCEDURE insert_emp (p_deptno NUMBER, p_sal NUMBER);
PROCEDURE delete_emp;
PROCEDURE update_emp;
FUNCTION calc_tax (p_sal NUMBER)
RETURN NUMBER;
END manage_emps;
/
CREATE OR REPLACE PACKAGE BODY manage_emps
IS
PROCEDURE update_sal
(p_raise_amt NUMBER)
IS
BEGIN UPDATE emp SET sal = (sal * p_raise_emt) + sal WHERE empno = v_id; END; PROCEDURE insert_emp (p_deptno NUMBER, p_sal NUMBER) IS BEGIN INSERT INTO emp(empno, deptno, sal) VALYES(v_id, p_depntno, p_sal); END insert_emp; PROCEDURE delete_emp IS BEGIN DELETE FROM emp WHERE empno = v_id; END delete_emp; PROCEDURE update_emp IS v_sal NUMBER(10, 2); v_raise NUMBER(10, 2); BEGIN SELECT sal INTO v_sal FROM emp WHERE empno = v_id; IF v_sal < 500 THEN v_raise := .05; ELSIP v_sal < 1000 THEN v_raise := .07; ELSE v_raise := .04; END IF; update_sal(v_raise); END update_emp; FUNCTION calc_tax (p_sal NUMBER) RETURN NUMBER IS BEGIN RETURN p_sal * tax_rate;
END calc_tax;
END manage_emps;
/
How many public procedures are in the MANAGE_EMPS package?

You need to create a DML trigger. Which five pieces need to be identified? (Choose five)

You need to create a trigger to ensure that information in the EMP table is only modified during business hours, Monday to Friday from 9:00am to 500pm Which types of trigger do you create? (Choose two.)

Which two programming constructs can be grouped within a package? (Choose two)

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 discounts;
/
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(dlscount_rate, 1)));
END display_price;
BEGIN
Discount_rate = 0.10;
END discounts;
/
The SQL*Plus SERVEROUTPUT setting is turned on in your session. You execute the procedure
DISPLAY_PRICE from SQL*Plus with the command EXECUTE discounts. display_price (100);
What is the result?

Which two statements about packages are true? (Choose two)

Examine this code:
CREATE OR REPLACE PACKAGE comm_package
IS
g_comm NUMBER := 10;
PROCEDURE reset_comm(p_comm IN NUMBER);
END comm_package;
/
User Jones executes the following code at 9:01am: EXECUTE comm_package.g_comm := 15
User Smith executes the following code at 9:05am: EXECUTE comm_paclage.g_comm := 20
Which statement is true?