Oracle Database 11g Changed 1z0-144 Questions

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

Question 5

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?

It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table

It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.

It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.

It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section.

Question 6

Which statements correctly describe the features of functions and procedures? (Choose all that apply.)

A procedure can contain a return statement without a value.

A function can return multiple values using a single return clause.

A procedure can be executed as part of a SQL expression or as a PL/SQL statement,

A function can contain zero or more parameters that are transferred from the calling environment.

Question 7

Which two statements are true about the exit statement encountered in loop? (Choose two)

The PL/SQL block execution terminates immediately after the exit statement.

The loop completes immediately and control passes to the statement after end loop

The statements after the exit statement in the Iteration are not executed before terminating the LOOP.

The current iteration of the loop completes immediately and control passes to the next iteration of the loop.

Question 8

You execute the following block of code:

Which statement is true about the outcome?

Both Output statements show different values.

Both output statements show exactly the same values.

It gives an error because the nested blocks are not labeled.

It gives an error because the V_CUSTOMER variable have different types in the nested blocks