Online Access Free 1Z0-147 Practice Test

Which view displays indirect dependencies, indenting each dependency?

• A.I_DEPT_TREE
• B.DEPTREE
• C.IDEPTREE
• D.INDENT_TREE

Examine the code examples. Which one is correct?

• A.CREATE OR REPLACE TRIGGER authorize_action BEFORE INSERT ON EMPLOYEES CALL log_execution; /
• B.CREATE OR REPLACE TRIGGER authorize_action BEFORE EMPLOYEES INSERT CALL log_execution;
• C.CREATE OR REPLACE TRIGGER authorize_action CALL log_execution BEFORE INSERT ON EMPLOYEES; /
• D.CREATE OR REPLACE TRIGGER authorize_action BEFORE EMPLOYEES INSERT CALL log_execution;

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;
/
What is the name of the private procedure in this package?

• A.UPDATE_SAL
• B.MANAGE_EMPS
• C.UPDATE_EMP
• D.DELETE_EMP
• E.INSERT_EMP
• F.CALC_TAX

Which three are true regarding error propagation? (Choose three)

• A.An exception raised inside an exception handler immediately propagates to the enclosing block.
• B.An exception raised inside a declaration immediately propagates to the current block.
• C.An exception cannot propagate across remote procedure calls.
• D.The use of the RAISE; statement in an exception handler reraises the current exception.

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

• A.Use the DBMS_MANAGE_LOB.MIGRATE procedure.
• B.You cannot migrate from a LONG to a LOB date type for a column.
• C.Use the ALTER TABLE command.
• D.Use the DBMS_LOB.MIGRATE procedure.
• E.Use the UTL_MANAGE_LOMIGRATE procedure.