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: Feb 19, 2025

Add To Cart

Question 1

Which of the following is not true about the Constructors?

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 2

Which data dictionary view contains the list of procedures and functions defined within package specification that you can execute?

A : ALL_SOURCE

B : ALL_DEPENDENCIES

C : ALL_OBJECTS

D : ALL_PROCEDURES

E : ALL_PLSQL_OBJECT_SETTINGS

Answer: D

Question 3

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 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

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

A : IN

B : OUT

C : IN OUT

D : None of the above

Answer: C

Page: 1 / 78

Total 389 Questions | Updated On: Feb 19, 2025

Add To Cart