Oracle9i program with pl/sql - 1Z0-147 Free Exam Questions [2026]

QUESTION NO: 1
Which two statements about object dependencies are accurate? (Choose two.)

A. When referencing a package procedure or function from a stand-alone procedure or function, If the package specification changes, the stand-alone procedure referencing a package construct as well as the package body become invalid

B. When referencing a package procedure or function from a stand-alone procedure or function, if the package body changes and the package specification does not change, the stand-alone procedure referencing a package construct remains valid.

C. When referencing a package procedure or function from a stand-alone procedure or function, if the package specification changes, the package body remains valid but the stand-alone procedure becomes invalid

D. When referencing a package procedure or function from a stand-alone procedure or function, if the package body changes and the package specification does not change, the stand-alone procedure referencing a package construct becomes invalid

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).

QUESTION NO: 2
You have the following table:
CREATE TABLE Emp_log ( Emp_id NUMBER Log_date DATE, New_salary NUMBER, Action VARCHAR(20));
You have the following data in the EMPLOYEES table:
EMPLOYEE_ID LAST_NAME SALARY DEPARTMENT_ID
100 King 24000 90 101 Kochhar 17000 90 102 De Haan 17000 90 103 Hunold 9000 60 104 Ernst 6000 60 105 Austin 4800 60 106 Pataballa 4800 60 107 Lorentz 4200 60 108 Greenberg 12000 100 201 Hartstein 13000 20 202 Fay 6000 20
You create this trigger:
CREATE OR REPLACE TRIGGER Log_salary_increase AFTER UPDATE ON employees FOR EACH ROW WHEN (:new.Salary > 1000) BEGIN INSERT INTO Emp_log (Emp_id, Log_date, New_Salary, Action) VALUES (new.Employee_id, SYSDATE, :new.SALary, 'NEW SAL'); END /
Then, you enter the following SQL statement:
UPDATE Employee SET Salary = Salary + 1000.0 Where Department_id = 20M
What are the result in the EMP_LOG table?
A EMP_ID LOG_DATE NEW_SALARY ACTION
201 24-SEP-02 13000 NEW SAL 202 24-SEP-02 600 NEW SAL

A. No rows are inserted.

B. EMP_ID LOG_DATE NEW_SALARY ACTION
201 24-SEP-02 14000 NEW SAL 202 24-SEP-02 7000 NEW SAL

C. EMP_ID LOG_DATE NEW_SALARY ACTION
201 24-SEP-02 NEW SAL 202 24-SEP-02 NEW SAL

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).

QUESTION NO: 3
Why do you use an INSTEAD OF trigger?

A. To perform clean up actions when ending a user session.

B. To insert data into a view that normally does not accept inserts.

C. To insert into an audit table when data is updated in a sensitive column.

D. To modify data in which the DML statement has been issued against an inherently nonupdateable view.

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).

QUESTION NO: 4
Examine this code
CREATE OR REPLACE PROCEDURE load bfile (p_flle_loc IN VARCHAR2)
IS
V_file BFILE;
V_filename VARCHAR2 (16);
CURSOR emp_cursor IS
SELECT employee_id
FROM employees
WHERE Job_id = 'IT_PROG'
FOR UPDATE;
BEGIN
FOR emp_record IN emp_cursor LOOP
V_filename:= emp_record.employee_id || '.GIF';
V_file := BFILENAME(p_flle_loc, v_filename);
END LOOP;
END;
/
What does the BFILENAME function do?

A. It returns a BFILE locator that is associated with a physical LOB binary file on the server's file system

B. It creates a directory object for use with the external BFILEs

C. It checks for the existence of an external BFILE

D. It reads data from an external BFILE

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).

QUESTION NO: 5
Which two does the INSTEAD OF clause in a trigger identify? (Choose two)

A. The event associated with the trigger.

B. The table associated with the trigger.

C. The statement level or for each row association to the trigger.

D. The package associated with the trigger.

E. The view associated with the trigger.

Discussion 0

Correct Answer: A,E Vote an answer

Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).

QUESTION NO: 6
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)

B. CREATE OR REPLACE PROCEDURE tax_amt
(p_id NUMBER)
RETURN NUMBER

C. CREATE OR REPLACE FUNCTION tax_amt
(p_id NUMBER)
RETURN NUMBER(10,2)

D. CREATE OR REPLACE FUNCTION tax_amt
(p_id NUMBER)
RETURN NUMBER

E. CREATE OR REPLACE PROCEDURE tax_amt
(p_id NUMBER, p_amount OUT NUMBER(10, 2))

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).

QUESTION NO: 7
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 = 'PLAYER';

B. SELECT * FROM USER DEPENDENCIES WHERE REFERENCED_NAME = 'ADD_PLAYER';

C. SELECT * FROM USER_DEPENDENCIES WHERE TYPE = 'DIR';

D. SELECT * FROM USER DEPENDENCIES WHERE REFERENCED_NAME = 'TABLE';

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).

QUALITY AND VALUE

Tested and Approved

Easy to Pass

Try Before Buy

RECENT DISCUSSIONS

Useful Links

Contact Us