Question 1

Which of the following is not true about labeling PL/SQL loops?

Options :

A : PL/SQL loops can be labeled.

B : The label should be enclosed by angle brackets (< and >).

C : The label name appears at the beginning of the LOOP statement.

D : The label name can also appear at the end of the LOOP statement or with an EXIT statement.

Answer: B

Question 2

If left out, which of the following would cause an infinite loop to occur in a simple loop?

Options :

A : LOOP

B : END LOOP

C : IF-THEN

D : EXIT

Answer: B

Question 3

View the Exhibit to examine the PL/SQL block.

Which statement is true about the execution of the PL/SQL block?

Options :

A : It executes successfully and gives the desired output.

B : It does not execute because the definition of type population is indexed by VARCHAR2.

C : It executes, and the string keys of an associative array are not stored in creation order, but in sorted order.

D : It does not execute because the value that is once assigned to the element of the associative array cannot be changed.

Answer: C

Question 4

Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with

%ROWTYPE? (Choose three.)

Options :

A : CREATE

B : DROP

C : UPDATE

D : SELECT

E : DELETE

F : ALTER

G : INSERT

Answer: A,C,D

Question 5

Examine this code (all compiled into schema HR):

Execute this code:
SET SERVEROUTPUT ON
EXEC test_pkg.do_stuff –
What is the correct output?

Options :

A :

B :

C :

D :

E :

Answer: C

Free 1Z0-149 Mock Exam – Practice Online Confidently