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 #22

View Exhibit1 and examine the structure of the product table.

View Exhiblt2 and examine the procedure you created. The procedure uses the prod id to determine whether the list price is within a given range.

You then create the following trigger on the product table.
CREATE OR REPLACE TRIGGER check_price__trg BEF0RE INSERT OR UPDATE OF prod_id, prod_list_price ON product FOR EACH ROW WHEN (nev.prod_id <> NVX(old.prod_id,0) OR New.prod__list_price <> NVL(old.prod_list_price, 0) ) BEGIN check_price (: new.prod_id) ; END /
Examine the following update command for an existing row in the product table.
SQL> UPDATE produce SET prod_list_price = 10 WHERE prod_id=115;
Why does it generate an error?

A. Because both the procedure and trigger access the same table

B. Because the WHEN clause cannot be used with a row-level trigger

C. Because the procedure call in the trigger is not valid

D. Because the column list specified with UPDATE in the trigger is not valid

E. Because the condition specified in the when clause is not valid

Discussion 0

Correct Answer: E Vote an answer

Question #23

View Exhibit1 and examine the structure of the DO table. View Exhibit2 and examine the code.

The anonymous block gives an error on execution. What is the reason?

A. A null value cannot be applied to the bind arguments In the using clause in line 10

B. The names of bind variables must be the same as the using clause bind arguments in line 10

C. The SQL does not support the Boolean data type.

D. The assignment in line 7 is not valid.

Discussion 0

Correct Answer: D Vote an answer

Question #24

The STRING_TAB table has the following structure:

View the Exhibit and examine the code.

What is the outcome on execution?

A. It displays only
This is my test string. - Because EXCEPTION should have been defined in the anonymous
block to get the error message.

B. It displays only
Output buffer not long enough, and exits the anonymous block.

C. It does not display any of the MEMS_PUTPUT messages and gives an error because a
transaction control statement cannot be used in the exception section of a procedure.

D. It displays
Output buffer not long enough.
This is my test string.-.

Discussion 0

Correct Answer: D Vote an answer

Question #25

Which two statements are true about the usage of the cursor for loops? (Choose two.)

A. The record type must be explicitly declared to control the loop.

B. The cursor needs to be closed after the iteration is complete.

C. The implicit open, fetch, exit, and close of the cursor happen.

D. The PL/SQL creates a record variable with the fields corresponding to the columns of the cursor result set.

Discussion 0

Correct Answer: C,D Vote an answer

Question #26

Examine the following PL/SQL code:

The server output is on for the session. Which statement is true about the execution of the code?

A. The code generates an error because the cursor is not opened before the FOR loop.

B. The code generates an error because the loop does not have the exit when clause.

C. The code executes successfully and gives the desired output.

D. The code generates an error because the EMP_RECORD variable is not declared.

Discussion 0

Correct Answer: C Vote an answer

Question #27

Which three statements are true about wrapping? (Choose three.)

A. The PL/SQL wrapper detects and reports only syntax errors.

B. To change a wrapped object, the wrapped code can be unwrapped, modified In a text file, and then wrapped again.

C. When wrapping a package or object type, only the body should be wrapped, not the specification.

D. When wrapping a package or object type, both the body and specification should be wrapped.

E. To change a wrapped object, the original source code needs to be modified and then wrapped again

F. The PL/SQL wrapper detects and reports both syntax and semantic errors.

Discussion 0

Correct Answer: B,C,E Vote an answer

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

Question #28

Identify situations in which the DBMS_SQL package is the only applicable method of processing dynamic SQL. (Choose all that apply.)

A. When a query returns multiple rows

B. When a column name in a where clause is unknown at compile time.

C. When the number of columns selected in a query is not known until run time

D. When privileges need to be granted to a new user to access an existing schema at run time

E. When a table needs to be created based on an existing table structure at run time

Discussion 0

Correct Answer: B,C 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.