READ Free Dumps For Oracle- 1z0-144

Question ID 2642	/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 pubiic: 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?
Option A	A.    It goes into an infinite loop.
Option B	B.    It executes successfully and displays only the list of faculty names.
Option C	C.    It does not execute and displays an error message because the end-of-file condition is not taken care of.
Option D	D.    It executes successfully and displays the list of faculty names followed by a "no data found” error message.
Correct Answer	B

Explanation

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

Explanation

Previous-Page 1 2. . . 5 6 7 8 9 10 11. . . 62 63 Next-Page

Send email to admin@getfreedumps for new dumps request!!!