Question 1

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 2

For which three SYSTEM EVENTS can triggers be created? (Choose three.)

Options :

A : DDL

B : AFTER AUDIT

C : BEFORE ANALYZE

D : SHUTDOWN

E : SERVERERROR

F : STARTUP

G : BEFORE GRANT

Answer: A,D

Question 3

Which of the following is true about PL/SQL nested tables?

Options :

A : Nested tables are like one-dimensional arrays with arbitrary number of elements.

B : Unlike arrays a nested table doesn’t have declared number of elements. The size of a nested table can increase dynamically.

C : Initially a nested array has consecutive subscripts or dense, but it can become sparse when elements are deleted from it.

D : All of the above.

Answer: D

Question 4

Which of the following is true about PL/SQL index-by tables?

Options :

A : It is a set of key-value pairs.

B : Each key is unique and is used to locate the corresponding value.

C : The key can be either an integer or a string.

D : All of the above.

Answer: D

Question 5

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

Higher Test Marks with Free Online 1Z0-149 Exam Practice