Back to Exams
Oracle1Z0-144
Oracle Database Program with PL/SQL
This certification validates practical skills in enterprise business systems, with emphasis on configuring processes, managing information, and supporting business outcomes. It is intended for professionals who implement or operate enterprise business systems.
Rate this exam
Exam Details
Total Questions
101Last Updated
Aug. 2026Rating
4.7
Question Types
Multi choices
101 Get Full Access
Unlimited access to all questions
Detailed explanations for every question
Page progress: 1 / 215%
#1Multiple Choice
View the Exhibit to examine the PL/SQL code:
DECLARE -
x NUMBER := 5;
y NUMBER := NULL;
BEGIN -
IF x != y THEN yields NULL, not TRUE
DBMS_OUTPUT.PUT_LINE(x != y); not run
ELSIF x = y THEN also yields NULL
DBMS_OUTPUT.PUT_LINE(x = y);
ELSE -
DBMS_OUTPUT.PUT_LINE -
(Cant tell if x and y are equal or not.);
END IF;
END;
/
SREVROUPUT is on for the session. Which statement is true about the output of the PL/SQL block?
#2Multiple Choice
Examine the following command:
SQL>ALTER SESSION -
SET plsql_warnings *
'enable: severe',
'enable: performance',
'ERROR: 05003';
What is the implication of the above command?
#3Multiple Choice
Which two tasks should be created as functions instead of as procedures? (Choose two.)
#4Multiple Choice
View Exhibit 1 and examine the structure of the employees table.
View Exhibit 2 and examine the code.
What would be the outcome when the code is executed?
#5Multiple Choice
What is the correct definition of the persistent state of a packaged variable?