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 01, 2026

Add To Cart

Question 1

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 2

View the Exhibit and examine the structure of the customer table.

2021-06-04-19-34-43-bbbe9e3ac276119b5b1b2648c6325d40

You create the following trigger to ensure that customers belonging to category "A" or "B"
in the customer table can have a credit limit of more than 8000.

What is the outcome?

A : The trigger is fired, a message is displayed, and the update is successful

B : The trigger is fired and a message is displayed, but the update is rolled back.

C : The trigger is not fired because the when clause should be used to specify the condition, however, the update is successful.

D : The trigger is not fired because column names must be specified with the update event to identify which columns must be changed to cause the trigger to fire, however, the update is successful.

Answer: A

Question 3

Subprograms are named PL/SQL blocks that can be called with a set of parameters.

A : True

B : False

C : Depends upon

D : None of the above

Answer: A

Question 4

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 5

View the Exhibit to examine the PL/SQL block.

Which statement is true about the execution of the PL/SQL block?

A : It executes successfully and gives the desired output.

B : It does not execute because the definition of type population is indexed by VARCHAR2.

C : It executes, and the string keys of an associative array are not stored in creation order, but in sorted order.

D : It does not execute because the value that is once assigned to the element of the associative array cannot be changed.

Answer: C

Page: 1 / 78

Total 389 Questions | Updated On: Aug 01, 2026

Add To Cart