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

View the Exhibit to examine the PLSQL block.

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

Options :

A : It executes and the Output is emprec.deptname: .

B : It executes and the Output is emprec.deptname: Sales.

C : It produces an error because NULL is assigned to the emprec.empid field in the record

D : It produces an error because the CHECK constraint is violated while assigning a value to the emprec.deptid field in the record.

Answer: A

Question 3

View the Exhibit to examine the PL/SQL code.

Identify the correct output for the code.

Options :

A : King 17-JUN-87 1500

B : King 17-JUN-87 24000

C : King current sysdate 1500

D : King current sysdate 24000

Answer: C

Question 4

The collection method COUNT

Options :

A : Returns the last (largest) index numbers in a collection that uses integer subscripts.

B : Returns the number of elements that a collection currently contains.

C : Checks the Maximum Size of a Collection

D : None of the above.

Answer: B

Question 5

Which system events can be used to create triggers that fire both at database and schema
levels? (Choose all that apply)

Options :

A : AFTER LOGON

B : AFTER STARTUP

C : BEFORE SHUTDOWN

D : AFTER SERVERERROR

Answer: A,D

Fill Preparation Gaps with Free Online 1Z0-149 Exam Practice