Online 1Z0-149 Practice Test

Question 1

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

Question 2

SERVEROUTPUT is enabled.

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

Options :

A :

B :

C :

D :

Answer: D

Question 3

Which of the following is true about database transactions?

Options :

A : The SQL statements that constitute a transaction can collectively be either committed, i.e., made permanent to the database or rolled back (undone) from the database

B : A transaction has a beginning and an end.

C : None of the above.

D : Both A and B.

Answer: D

Question 4

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 5

What can the value of the INTO clause be while fetching data in an explicit cursor?

Options :

A : PL/SQL scalar variables only

B : PL/SQL variables or records

C : Collections or records only

D : Records only

Answer: B

EXPERTY DESIGNED 1Z0-149 PRACTICE TEST