Oracle 1z0-144 Exam Actual Questions

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?

Correct Answer: D 🗳️

Examine the following command:

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

Correct Answer: B 🗳️
References:

View the exhibit and examine the structure of the products table.

Examine the following code:

Which statement is true when the procedure DELETE_DETAILS is invoked?

Correct Answer: A 🗳️
In this case, the debug output will only occur if there is an exception.

Which two tasks should be created as functions instead of as procedures? (Choose two.)

Correct Answer: CD 🗳️