Oracle Database 11g: Program with PL/SQL (1Z1-144) Free Practice Test

Question 1

Examine the following block of code:

Which line in the above code would result in errors upon execution?

A. line 8

B. line 2

C. line 5

D. line 7

Correct Answer: A

Question 2

Which statement is true about transactions in PL/SQL?

A. A block can contain only a single transaction.

B. SERVERPOINTS cannot be created in a PL/SQL block.

C. The END keyword signals the end of a PL/SQL block and automatically commits the transaction in the block.

D. A transaction can span multiple blocks.

Correct Answer: D

Question 3

Examine the following partial declare section from a block of PL/SQL code

Which line(s) in the above code are NOT valid? (Choose all that apply.)

A. line 2

B. line 5

C. line 3

D. line 4

Correct Answer: B,C

Question 4

View the Exhibit and examine the code and its outcome on execution:

What would be the effect on the two procedures if the value of debug is set to false? (Choose two.)

A. MY_PROC2 is not recompiled.

B. MY_PROC1 is recompiled without the debugging code.

C. MY_PROC1 is recompiled but remains unchanged.

D. MY_PROC2 is recompiled but remains unchanged.

Correct Answer: A,B

Question 5

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?

A. The program abruptly terminates and an exception is raised.

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

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

D. The program executes successfully and the output is No ROWS_FOUND.

Correct Answer: A

Question 6

Examine the following partial code:

Which statement is correct about the unnamed block of code at the end of a package body?

A. It generates an error because V_TAXRATE is a public variable that is already initialized in the package specification.

B. It acts as a package initialization block that executes each time a package subprogram is invoked within the user session and refreshes the initialized variable value.

C. It acts as a package initialization block that executes once, when the package is first invoked within the user session.

D. It generates an error because all the blocks of code in a package body must be named.

Correct Answer: C

Question 7

Which two guidelines are recommended by Oracle to reduce invalidation of dependent objects? (Choose two.)

A. When adding new items to a package, add them to the end of the package.

B. Reference tables indirectly by using views.

C. When adding new items to a package, add them to the beginning of the package.

D. Reference tables directly avoid using views.

Correct Answer: A,B

Question 8

Which statements are true about the WHEN OTHERS exception handler? (Choose all that apply)

A. It can be the only exception handler for the code.

B. It traps all the exceptions that are not already trapped.

C. It can be the first exception handler.

D. You can have multiple OTHERS clauses to trap all the multiple unhandled exceptions.

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 9

Which two statements are true about the PL/SQL initialization parameters? (Choose two.)

A. Changing the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units that have already been compiled

B. Setting PLSQL_CODE_TYPE to native provides the greatest performance gains only for computation-intensive procedural operations.

C. To use native code compilation, PLSQL_OPTIMIZE_I.EVEL should be set to a value less than or equal to l.

D. The default value of 2 for PLSQL_OPTIMI2E_LEVEL allows the compiler to rearrange code for better performance.

Correct Answer: B,D

Question 10

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?

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

B. 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.

C. It executes successfully and creates the report.

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

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

Correct Answer: C

Welcome to TestSimulate

Oracle Database 11g: Program with PL/SQL (1Z1-144) Free Practice Test