Pre-Summer Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Note! Following 1z0-144 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

Verified By IT Certified Experts

CertsTopics.com Certified Safe Files

Up-To-Date Exam Study Material

99.5% High Success Pass Rate

100% Accurate Answers

Instant Downloads

Exam Questions And Answers PDF

Try Demo Before You Buy

Certification Exams with Helpful Questions And Answers

Oracle Database 11g: Program with PL/SQL Questions and Answers

Question 1

View Exhibit1 and examine the structure of the employees table.

User SCOTT needs to generate a text report that contains the names of all employees and their salaries.

Examine the following commands issued by the DBA:

SQL_CREATE DICTORY my_dir AS '/temp/my_files* ;

SQL_GRANT WRITE ON DIRECTORY my_dir TO SCOTT;

View Exhibit2 and examine the procedure code. You issue the following command:

You issue the following command:

SQL_EXEC sal_5tatus ('MY_DIR', ‘EMPREPORT.TXT')

What is the outcome?

Options:

A.

It executes successfully and creates the report.

B.

It gives an error because the text file should be opened in append mode.

C.

It gives an error because the "no data found" condition is not handled to come out of the loop.

D.

It gives an error because user SCOTT should be granted both read and write privileges to the directory alias.

E.

It executes but no data is written to the text file because the FFLUSH subprogram is not used to write all the data buffered in memory to a file.

Buy Now
Question 2

Examine the following DECLARE section of PL/SQL block:

Which line in the above declaration would generate an error?

Options:

A.

Line 2

B.

Line 3

C.

Line 4

D.

Line 5

E.

Line 6

Question 3

Examine the following PL/SQL code:

Which statement is true about the execution of the code if the query in the PL/SQL block returns no rows?

Options:

A.

The program abruptly terminates and an exception is raised.

B.

The program executes successfully and the output is No ROWS_FOUND.

C.

The program executes successfully and the query fetches a null value in the V_LNAME variable.

D.

Program executes successfully, fetches a NULL value in the V_LNAME variable and an exception is raised.