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. 4)

  • 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 #16
Which two statements are correct about the usage of parameters in functions? (Choose two.)
  1. A
    Functions can have only in mode parameters.
  2. B
    Functions called in SQL statements cannot have out or in out mode parameters.
  3. C
    Functions having in, out, or in out parameters can be called only in named PL/SQL subprograms
  4. D
    Functions having in, out, or in out parameters can be called in PL/SQL procedures and anonymous blocks.

Correct Answer:
BD

Question #17
View the Exhibit and examine the structure of the employees table.

Examine the following block of code:

What is the outcome when the above code is executed?
  1. A
    It executes successfully.
  2. B
    It gives an error because decode cannot be used in a PL/SQL block.
  3. C
    It gives an error because the AVG function cannot be used in a PL/SQL block
  4. D
    It gives an error because the MONTHS_BETWEEN function cannot be used in a PL/SQL block.
  5. E
    It gives an error because both the AVG and decode functions cannot be used in a PL/SQL block.

Correct Answer:
A

Question #18
Examine the following code:

Which two statements are true about the above function? (Choose two.)
  1. A
    It can be used only in a parallelized query.
  2. B
    It can be used in both a parallelized query and a parallelized DML statement.
  3. C
    It can be used only in a parallelized data manipulation language (DML) statement.
  4. 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.
  5. E
    It requires a PRAGMA RESTRICT_REFERENCES declaration with RNDS, WNDS, RNPS, and WNPS specified in order to use parallel optimization.

Correct Answer:
BD
References:

Question #19
/temp/my_files is an existing folder in the server, facultylist.txt is an existing text file in this folder.
Examine the following commands that are executed by the DBA:
SQL>CREATE DIRECTION my_dir AS /temp/my_files:
SQL>GRANT READ ON DIRECTORY my_dir To public:
View the Exhibit and examine the procedure created by user SCOTT to read the list of faculty names from the text file.

SCOTT executes the procedure as follows:

SQL>SET SERVEROUTPUT ON -
SQL>EXEC read_file (MY_DIR, FACULTYLIST.TXT)
What is the outcome?
  1. A
    It goes into an infinite loop.
  2. B
    It executes successfully and displays only the list of faculty names.
  3. C
    It does not execute and displays an error message because the end-of-file condition is not taken care of.
  4. D
    It executes successfully and displays the list of faculty names followed by a "no data found" error message.

Correct Answer:
D
References:

Question #20
View the Exhibit to examine the PL/SQL block.

Which statement is true about the execution of the PL/SQL block?
  1. A
    It executes successfully and gives the desired output.
  2. B
    It does not execute because the definition of type population is indexed by VARCHAR2.
  3. C
    It executes, and the string keys of an associative array are not stored in creation order, but in sorted order.
  4. D
    It does not execute because the value that is once assigned to the element of the associative array cannot be changed.

Correct Answer:
C
References:

Previous Questions Next Questions

All Pages