Oracle Database 11g: Program with PL/SQL - 1Z0-144 Exam Questions [2026]

QUESTION NO: 1
In which of the following scenarios would you recommend using associative arrays?

A. When you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries B. When you want to create a relatively small lookup table, where the collection can be constructed on memory each time a subprogram is invoked. C. When you want to retrieve an entire row from a table and perform calculations D. When you know the number of elements in advance and the elements are usually accessed sequentially

Correct Answer: A,B

QUESTION NO: 2
View the Exhibit and examine the structure of the departments table in SCOTT's schema.

Examine the following block of code:
CREATE OR REPLACE PROCEDURE add_dept(
p_id NUMBER, p_name VARCHAR2) IS
BEGIN
INSERT INTO departments VALUES <p_id, p_name, NULL, NULL);
END;
/
The above procedure is created by user SCOTT. Another user JONES needs to use the
procedure.
Which two statements are true in the above scenario? (Choose two.)

A. JONES executes the procedure with definer's rights. B. JONES executes the procedure with invoker's rights. C. SCOTT should grant only the execute privilege for the procedure to JONES. D. SCOTT should grant both the BXKCOTE privilege for the procedure and insert privilege for the table to

Correct Answer: A,C

QUESTION NO: 3
Examine the following code:

Which two statements are true about the above function? (Choose two.)

A. It can be used only in a parallelized query. B. It requires a PRAGMA RESTRICT_REFERENCES declaration with RNDS, WNDS, RNPS, and WNPS specified in order to use parallel optimization. C. It can be used only in a parallelized data manipulation language (DML) statement. D. It can have a separate copy run in each of the multiple processes when called from a SQL statement that is run in parallel. E. It can be used in both a parallelized query and a parallelized DML statement.

Correct Answer: B,E

QUESTION NO: 4
Which two statements are true about the handling of internally defined or user-defined PL7SQL exceptions? (Choose two.)

A. Instead of adding exception handlers to your PL/SQL block, check for errors at every point where they may occur. B. An exception handler should commit the transaction. C. Add exception handlers whenever errors occur. D. Handle named exceptions whenever possible instead of using when others in exception handlers.

Correct Answer: A,D

QUESTION NO: 5
View the Exhibit and examine the code and its outcome on execution:

What would be the effect on the two procedures if the value of debug is set to false? (Choose two.)

A. MY_PROC1 is recompiled without the debugging code. B. MY_PROC1 is recompiled but remains unchanged. C. MY_PROC2 is recompiled but remains unchanged. D. MY_PROC2 is not recompiled.

Correct Answer: A,D

QUESTION NO: 6
Identify two features of obfuscation. (Choose two.)

A. Only the wrap utility can obfuscate multiple programs at a time. B. SQL' Plus cannot process the obfuscated source files. C. The Import and Export utilities accept wrapped files. D. The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View E. Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.

Correct Answer: A,C

QUESTION NO: 7
Which two statements are true about PL/SQL exception propagation? (Choose two.)

A. If you declare a local exception in a subblock and a global exception in the outer block, the global declaration overrides the local exception. B. The exception reproduces Itself In successive enclosing blocks until a handler is found. C. If you declare a local exception in a subblock and a global exception in the outer block, the local declaration overrides the global exception. D. Exception- can propagate across the remote subprograms that are called through database links.

Correct Answer: B,C

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

A. BEFORE SHUTDOWN B. AFTER SERVERERROR C. AFTER STARTUP D. AFTER LOGON

Correct Answer: B,D

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

QUESTION NO: 9
View the Exhibit and examine the blocks of code that you plan to execute. Which statement is true about the blocks of code?

A. The procedure creation gives an error because the function invocation in line 1 is not valid. B. The anonymous block gives an error because the function invocation in line 2 is not valid. C. All the blocks execute successfully and the anonymous block displays 1 2 3 cut: 0 45 cart: 1 D. All the blocks execute successfully and the anonymous block displays 1 2 3 cant: 45 45 cnt: 45

Correct Answer: D

QUESTION NO: 10
View the Exhibit and examine the structure of the AUDIR_CUST table.
Exhibit Missing
CUST_ID and CUST_LIMIT are existing columns in the CUSTOMER table.
Examine the following trigger code:

Which statement is true about the above trigger?

A. It gives an error on compilation because it should be a statement-level trigger. B. It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION statement should be introduced in the trigger. C. It gives an error on compilation because of the commit command in the trigger code D. It compiles and fires successfully when the credit limit is updated in the customer table.

Correct Answer: B