Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-144

Oracle 1z0-144 Exam Practice Questions (P. 1)

  • Full Access (112 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #1
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?
  1. A
    The output is x = y.
  2. B
    It produces an error.
  3. C
    The output is x != y.
  4. D
    The output is Can't tell if x and y are equal or not.

Correct Answer:
D

Question #2
Examine the following command:

SQL>ALTER SESSION -
SET plsql_warnings *
'enable: severe',
'enable: performance',
'ERROR: 05003';
What is the implication of the above command?
  1. A
    It issues a warning whenever ERROR: 05003 occur during compilation.
  2. B
    It causes the compilation to fail whenever the warning ERROR.05003 occurs.
  3. C
    It issues warnings whenever the code causes an unexpected action or wrong results performance problems.
  4. D
    It causes the compilation to fail whenever the code gives wrong results or contains statements that are never executed.

Correct Answer:
B
References:

Question #3
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?
  1. A
    It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table
  2. B
    It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.
  3. C
    It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.
  4. D
    It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section.

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

Question #4
Which two tasks should be created as functions instead of as procedures? (Choose two.)
  1. A
    Reference host or bind variables in a PL/SQL block of code
  2. B
    Tasks that compute and return multiple values to the calling environment
  3. C
    Tasks that compute a value that must be returned to the calling environment
  4. D
    Tasks performed in SQL that increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into

Correct Answer:
CD

Question #5
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?
  1. A
    It executes successfully.
  2. B
    It gives an error because the SAL variable is not visible in the increase function.
  3. C
    It gives an error because the increase function cannot be called from the RAISE_SALARY procedure.
  4. D
    It gives an error because the increase function and the RAISE_SALARY procedure should be declared at the beginning of the declare section before all the

Correct Answer:
A

Next Questions

All Pages