Free Practice Oracle 1Z0-149 Exam Questions 2025

Stay ahead with 100% Free Oracle Database 19c: Program with PL/SQL 1Z0-149 Dumps Practice Questions

Page: 1 / 78

Total 389 Questions | Updated On: Mar 28, 2021

Add To Cart

Question 1

When modifying procedure code, the procedure must be re-executed to validate and store it in the database. True or False?

A : True

B : False

Answer: A

Question 2

Select incorrect variable declarations

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 3

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

Question 4

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 5

Which of the following is not true about labeling PL/SQL loops?

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

Page: 1 / 78

Total 389 Questions | Updated On: Mar 28, 2021

Add To Cart