Free Oracle 1Z0-149 Exam Questions

Become Oracle Certified with updated 1Z0-149 exam questions and correct answers

Page: 1 / 78

Total 389 Questions | Updated On: Aug 09, 2025

Add To Cart

Question 1

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

A : PL/SQL scalar variables only

B : PL/SQL variables or records

C : Collections or records only

D : Records only

Answer: B

Question 2

A : Line 5 should be replaced with: DBMS_LOB.CREATETEMPORARY (pdatabuf (1), TRUE, DBMS_LOB.CALL);

B : Line 5 should be replaced with: DBMS_LOB.CREATETEMPORARY (pdatabuf (1), FALSE, DBMS_LOB.SESSION);

C : Rewrite the block as:

D : pdatabuf (1) := NULL; should be added after line 4.

E : Line 5 should be replaced with:DBMS_LOB.CREATETEMPORARY (pdatabuf, TRUE, DBMS_LOB.SESSION);

Answer: C,D

Question 3

Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with

%ROWTYPE? (Choose three.)

A : CREATE

B : DROP

C : UPDATE

D : SELECT

E : DELETE

F : ALTER

G : INSERT

Answer: A,C,D

Question 4

Which is true about EXIT and CONTINUE statements?

A : They can be used in any type of loop.

B : They must have a WHEN condition.

C : They have the same effect on the execution of a loop.

D : They must use labels.

Answer: A

Question 5

Examine the following DECLARE section of PL/SQL block:

Which line in the above declaration would generate an error?

A : Line 2

B : Line 3

C : Line 4

D : Line 5

E : Line 6

Answer: A

Page: 1 / 78

Total 389 Questions | Updated On: Aug 09, 2025

Add To Cart