Oracle 1Z0-144 Actual Free Exam Questions & Community Discussion

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: Jul 07, 2026

Question #36

Identify two situations where the DBMS_SQL package should be used. (Choose two.)

A. You do not know how many columns a select statement will return, or what their data types will.

B. The SELECT list is not known until run time.

C. The dynamic SQL statement retrieves rows into records.

D. You must use the %found SQL cursor attribute after issuing a dynamic SQL statement that is an insert or update statement.

Discussion 0

Correct Answer: A,B Vote an answer

Question #37

View the Exhibit and examine the structure of the customer table.

You create the following trigger to ensure that customers belonging to category "A" or "B" in the customer table can have a credit limit of more than 8000.

What is the outcome?

A. The trigger is fired, a message is displayed, and the update is successful

B. The trigger is not fired because the when clause should be used to specify the condition, however, the update is successful.

C. The trigger is not fired because column names must be specified with the update event to identify which columns must be changed to cause the trigger to fire, however, the update is successful.

D. The trigger is fired and a message is displayed, but the update is rolled back.

Discussion 0

Correct Answer: C Vote an answer

Question #38

Examine the following block of code:

Which two statements are correct about the code above? (Choose two.)

A. The function goes through the parse, bind, execute, and fetch phases.

B. The function goes through the parse, bind, and execute phases.

C. All the processing phases for the function are performed only at run time.

D. Only the EXECUTE IMMEDIATE statement inside the function is parsed at run time.

E. The function goes through only the parse and executes phases.

Discussion 0

Correct Answer: C,D Vote an answer

Question #39

ORDER_TOTAL is a column in the orders table with the data type and size as number (8, 2) Examine the following code:

Which statement is correct about the above code?

A. It gives an error in line 3

B. It gives an error in line 6

C. It gives an error in line 4

D. It executes successfully and displays the output.

Discussion 0

Correct Answer: D Vote an answer

Question #40

Examine the following PL/SQL code;

The execution of the code produces errors. Identify the error in the code.

A. The EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR statement.

B. The fetch clause is missing

C. The open cursor is missing

D. The exit when condition is missing

Discussion 0

Correct Answer: B Vote an answer

Question #41

Which system events can be used to create triggers that fire both at database and schema levels? (Choose all that apply)

A. AFTER STARTUP

B. AFTER LOGON

C. BEFORE SHUTDOWN

D. AFTER SERVERERROR

Discussion 0

Correct Answer: B,D Vote an answer

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

Question #42

Examine the following command:
SQL>ALTER SESSION
SET plsql_warnings *
'enable: severe',
'enable: performance',
'ERROR: 05003';
What is the implication of the above command?

A. It causes the compilation to fail whenever the code gives wrong results or contains statements that are never executed.

B. It issues warnings whenever the code causes an unexpected action or wrong results performance problems.

C. It causes the compilation to fail whenever the warning ERROR.05003 occurs.

D. It issues a warning whenever ERROR: 05003 occur during compilation.

Discussion 0

Correct Answer: B Vote an answer

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.