Free Oracle 1Z0-147 Practice Test & Real Exam Questions

Exam Code/Number: 1Z0-147
Exam Name/Title: Oracle9i program with pl/sql
Certification Provider: Oracle
Corresponding Certification: 9i Internet Application Developer

Exam Questions: 111
Updated On: Jun 02, 2026

Question #1

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

A. The specification and body of the package are stored together in the database.

B. The package specification is optional, but the package body is required.

C. The package specification is required, but the package body is optional.

D. The specification and body of the package are stored separately in the database.

E. Both the specification and body are required components of a package.

Discussion 0

Correct Answer: C,D Vote an answer

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

Question #2

Which three statements are true regarding database triggers? (Choose three)

A. A database trigger fires whenever a data event (such as DML) or system event (such as logon, shutdown) occurs on a schema or database.

B. A database trigger is a PL/SQL block, C, or Java procedure associated with a table, view, schema, or the database.

C. A database trigger executes implicitly whenever a particular event takes place.

D. A database trigger needs to be executed explicitly whenever a particular event takes place.

E. With a schema, triggers fire for each event for all users; with a database, triggers fire for each event for that specific user.

Discussion 0

Correct Answer: A,B,C Vote an answer

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

Question #3

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

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

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

C. CREATE OR REPLACE PROCEDURE tax_amt
(p_id NUMBER, p_amount OUT NUMBER)

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

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

Discussion 0

Correct Answer: C,E Vote an answer

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

Question #4

Consider this scenario
A procedure X references a view Y that is based on a table Z .
Which two statements are true? (Choose two.)

A. Z is an indirect dependent of Y

B. Y is a referenced object

C. Z is a direct dependent of X

D. Y is a direct dependent of X

E. Y is an indirect dependent of Z

F. Y is an indirect dependent of X

Discussion 0

Correct Answer: B,D Vote an answer

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

Question #5

There is a CUSTOMER table in a schema that has a public synonym CUSTOMER and you are granted all object privileges on it. You have a procedure PROCESS_CUSTOMER that processes customer information that is in the public synonym CUSTOMER table. You have just created a new table called CUSTOMER within your schema. Which statement is true?

A. If the structure of your CUSTOMER table is the same as the public synonym CUSTOMER table then the procedure PROCESS_CUSTOMER is invalidated and gives compilation errors.

B. If the structure of your CUSTOMER table is the same as the public synonym CUSTOMER table then the procedure PROCESS_CUSTOMER successfully recompiles when invoked and accesses your CUSTOMER table.

C. If the structure of your CUSTOMER table is entirely different from the public synonym CUSTOMER table then the procedure PROCESS_CUSTOMER successfully recompiles and accesses your CUSTOMER table.

D. Creating the table has no effect and procedure PROCESS_CUSTOMER still accesses data from public synonym CUSTOMER table.

Discussion 0

Correct Answer: B Vote an answer

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

Question #6

Examine the code examples. Which one is correct?

A. CREATE OR REPLACE TRIGGER authorize_action CALL log_execution BEFORE INSERT ON EMPLOYEES; /

B. CREATE OR REPLACE TRIGGER authorize_action BEFORE EMPLOYEES INSERT CALL log_execution;

C. CREATE OR REPLACE TRIGGER authorize_action BEFORE INSERT ON EMPLOYEES CALL log_execution; /

D. CREATE OR REPLACE TRIGGER authorize_action BEFORE EMPLOYEES INSERT CALL log_execution;

Discussion 0

Correct Answer: C Vote an answer

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

Question #7

Procedure PROCESS_EMP references the table EMP.
Procedure UPDATE_EMP updates rows if table EMP through procedure PROCESS_EMP.
There is a remote procedure QUERY_EMP that queries the EMP table through the local
procedure PROCESS_EMP.
The dependency mode is set to TIMESTAMP in this session.
Which two statements are true? (Choose two)

A. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for the first time.

B. If the signature of procedure PROCESS_EMP is modified and successfully recompiles, the EMP table is invalidated.

C. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP gets invalidated and will recompile when invoked for the first time.

D. If internal logic of procedure PROCESS_EMP is modified and successfully recompiles, QUERY_EMP gets invalidated and will recompile when invoked for the second time.

E. If the signature of procedure PROCESS_EMP is modified and successfully recompiles, UPDATE_EMP gets invalidated and will recompile when invoked for the first time.

Discussion 0

Correct Answer: A,D Vote an answer

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

Question #8

When creating a function, in which section will you typically find the RETURN keyword?

A. DECLARATIVE

B. HEADER only

C. EXECUTABLE and HEADER

D. DECLARATIVE,EXECUTABLE and EXCEPTION HANDLING

Discussion 0

Correct Answer: C Vote an answer

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

Question #9

Which two dictionary views track dependencies? (Choose two)

A. DEPTREE_TEMPTAB

B. USER_DEPENDENCIES

C. DBA_DEPENDENT_OBJECTS

D. USER_SOURCE

E. UTL_DEPTREE

F. USER_OBJECTS

Discussion 0

Correct Answer: A,B Vote an answer

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

Question #10

Which statement is valid when removing procedures?

A. Use a drop procedure statement to drop a procedure that is part of a package.
Then recompile the package specification.

B. Use a drop procedure statement to drop a procedure that is part of a package.
Then recompile the package body.

C. For faster removal and re-creation, do not use a drop procedure statement.
Instead, recompile the procedure using the alter procedure statement with the REUSE SETTINGS
clause.

D. Use a drop procedure statement to drop a standalone procedure.

Discussion 0

Correct Answer: D Vote an answer

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

Download Free Oracle 1Z0-147 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1Z0-147 exam.