100% Oracle 1Z0-147 Guaranteed Success With Testing Engine

Oracle 1Z0-147 Exam Overview:

Oracle 1Z0-147 Exam Syllabus Topics:

Oracle9i program with pl/sql Sample Questions:

1. The add_player procedure inserts rows into the PLAYER table. Which command will show this directory dependency?

A) SELECT * FROM USER DEPENDENCIES WHERE REFERENCED_NAME = 'ADD_PLAYER';
B) SELECT * FROM USER_DEPENDENCIES WHERE TYPE = 'DIR';
C) SELECT * FROM USER DEPENDENCIES WHERE REFERENCED_NAME = 'TABLE';
D) SELECT * FROM USER_DEPENDENCIES WHERE REFERENCED_NAME = 'PLAYER';

2. Which three are true statements about dependent objects? (Choose three)

A) The Oracle server automatically records dependencies among objects.
B) You can view whether an object is valid or invalid in the USER_OBJECTS data dictionary view.
C) You can view whether an object is valid or invalid in the USER_STATUS data dictionary view.
D) All schema objects have a status that is recorded in the data dictionary.
E) Invalid objects cannot be described.
F) An object with status of invalid cannot be a referenced object.

3. Which two program declarations are correct for a stored program unit? (Choose two)

A) CREATE OR REPLACE PROCEDURE tax_amt
(p_id NUMBER, p_amount OUT NUMBER(10, 2))
B) CREATE OR REPLACE PROCEDURE tax_amt
(p_id NUMBER, p_amount OUT NUMBER)
C) CREATE OR REPLACE FUNCTION tax_amt
(p_id NUMBER)
RETURN NUMBER
D) CREATE OR REPLACE PROCEDURE tax_amt
(p_id NUMBER)
RETURN NUMBER
E) CREATE OR REPLACE FUNCTION tax_amt
(p_id NUMBER)
RETURN NUMBER(10,2)

4. Examine this code:
CREATE OR REPLACE FUNCTION calc_sal(p_salary NUMBER)
RETURN NUMBER
IS
v_raise NUMBER(4,2) DEFAULT 1.08;
BEGIN
RETURN v_raise * p_salary;
END calc_sal;
/
Which statement accurately call the stored function CALC_SAL? (Choose two)

A) INSERT calc_sal(salary) INTO employees
WHERE department_id = 60;
B) SELECT last_name, salary, calc_sal(salary)
FROM employees ORDER BY
calc_sal(salary);
C) SELECT salary, calc_sal(salary)
FROM employees
WHERE department_id = 60;
D) DELETE FROM employees(calc_sal(salary))
WHERE calc_sal(salary) > 1000;
E) UPDATE employees (calc_sal(salary))
SET salary = salary * calc_sal(salary);

5. Examine this package:
CREATE OR REPLACE PACKAGE discounts
IS
g_id NUMBER := 7829;
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 NUMBER)
IS
BEGIN
DBMS_OUTPUT.PUT_LINE('Discounted '||
TO_CHAR(p_price*NVL(discount_rate, 1)));
END display_price;
BEGIN
discount_rate := 0.10;
END discounts;
/
Which statement is true?

A) The value of DISCOUNT_RATE is set to 0.10 when the package is invoked for the first time in a session.
B) The value of DISCOUNT_RATE is set to 1.00 each time the procedure DISPLAY_PRICE is invoked.
C) The value of DISCOUNT_RATE always remains 0.00 in a session.
D) The value of DISCOUNT_RATE is set to 0.10 each time the package is invoked in a session.

Solutions: