Online 1Z0-149 Practice Test

Question 1

Select incorrect variable declarations

Options :

A : foo_number varchar2(10);

B : foo_text number(10);

C : foo_char char(1) := 'Y';

D : foo_time date;

E : foo_text varchar2(10) := 'hello world';

Answer: A

Question 2

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 3

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 4

In which of the following scenarios would you recommend using associative arrays?

Options :

A : When you want to retrieve an entire row from a table and perform calculations

B : When you know the number of elements in advance and the elements are usually accessed sequentially

C : When you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries

D : When you want to create a relatively small lookup table, where the collection can be constructed on memory each time a subprogram is invoked

Answer: D

Question 5

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

EXPERTY DESIGNED 1Z0-149 PRACTICE TEST