Online 1Z0-149 Practice Test

Question 1

Examine the following DECLARE section of PL/SQL block:

Which line in the above declaration would generate an error?

Options :

A : Line 2

B : Line 3

C : Line 4

D : Line 5

E : Line 6

Answer: A

Question 2

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 3

Which of the following is not true about the Constructors?

Options :

A : These are functions that return a new object as its value.

B : Every object has a system defined constructor method.

C : The name of the constructor is same as the object type.

D : None of the above.

Answer: D

Question 4

SERVEROUTPUT is enabled.

Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

Options :

A :

B :

C :

D :

Answer: D

Question 5

In which parameter mode Formal parameter acts like an initialized variable?

Options :

A : IN

B : OUT

C : IN OUT

D : None of the above

Answer: C

EXPERTY DESIGNED 1Z0-149 PRACTICE TEST