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

Exam Code/Number: 1Z0-144
Exam Name/Title: Oracle Database 11g: Program with PL/SQL
Certification Provider: Oracle
Corresponding Certification: Other Oracle Certification

Exam Questions: 103
Updated On: Jun 03, 2026

Question #1

Which two statements are true about anonymous blocks and named subprograms?
(Choose two)

A. Both anonymous blocks and subprograms execute by default with invoker's rights.

B. The declare section is optional for both anonymous blocks and subprograms.

C. Subprograms are by default executed with definer's rights.

D. The declare section is mandatory for anonymous blocks and optional for subprograms.

Discussion 0

Correct Answer: B,C Vote an answer

Question #2

View Exhibit1 and examine the structure of the employees table.

User SCOTT needs to generate a text report that contains the names of all employees and their salaries.
Examine the following commands issued by the DBA: SQL_CREATE DICTORY my_dir AS '/temp/my_files* ; SQL_GRANT WRITE ON DIRECTORY my_dir TO SCOTT;
View Exhibit2 and examine the procedure code. You issue the following command: You issue the following command:

SQL_EXEC sal_5tatus ('MY_DIR', 'EMPREPORT.TXT')
What is the outcome?

A. It gives an error because the text file should be opened in append mode.

B. It gives an error because the "no data found" condition is not handled to come out of the loop.

C. It executes but no data is written to the text file because the FFLUSH subprogram is not used to write all the data buffered in memory to a file.

D. It gives an error because user SCOTT should be granted both read and write privileges to the directory alias.

E. It executes successfully and creates the report.

Discussion 0

Correct Answer: E Vote an answer

Question #3

Examine the following block of code:

Which line in the above code would result in errors upon execution?

A. line 8

B. line 5

C. line 7

D. line 2

Discussion 0

Correct Answer: A Vote an answer

Question #4

Which statement is true about transactions in PL/SQL?

A. A block can contain only a single transaction.

B. The END keyword signals the end of a PL/SQL block and automatically commits the transaction in the block.

C. SERVERPOINTS cannot be created in a PL/SQL block.

D. A transaction can span multiple blocks.

Discussion 0

Correct Answer: D Vote an answer

Question #5

Which two statements are true about the PL/SQL initialization parameters? (Choose two.)

A. To use native code compilation, PLSQL_OPTIMIZE_I.EVEL should be set to a value less than or equal to l.

B. Changing the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units that have already been compiled

C. Setting PLSQL_CODE_TYPE to native provides the greatest performance gains only for computation-intensive procedural operations.

D. The default value of 2 for PLSQL_OPTIMI2E_LEVEL allows the compiler to rearrange code for better performance.

Discussion 0

Correct Answer: C,D Vote an answer

Question #6

Examine the following code that you plan to execute:

What correction should be performed in the above code?

A. The PROC2 procedure code should be defined in the package body.

B. The PROC3 procedure should be declared in the package specification.

C. The variable x must be declared in the package body and removed from the specification,

D. The PROC3 procedure header should be declared at the beginning of the package body.

Discussion 0

Correct Answer: A,B Vote an answer

Question #7

Which statements correctly describe the features of functions and procedures? (Choose all that apply.)

A. A procedure can contain a return statement without a value.

B. A procedure can be executed as part of a SQL expression or as a PL/SQL statement,

C. A function can return multiple values using a single return clause,

D. A function can contain zero or more parameters that are transferred from the calling environment.

Discussion 0

Correct Answer: A Vote an answer

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

Download Free Oracle 1Z0-144 Demo

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