Free Oracle 1Z0-149 Practice Exam Questions and Answers 2026

Start Learning with the Newest and 100% Free 1Z0-149 Exam Dumps Questions

Page: 1 / 78

Total 389 Questions | Updated On: Apr 02, 2026

Add To Cart

Question 1

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 2

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

Question 3

If left out, which of the following would cause an infinite loop to occur in a simple loop?

A : LOOP

B : END LOOP

C : IF-THEN

D : EXIT

Answer: B

Question 4

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 5

Which of the following is true about PL/SQL nested tables?

A : Nested tables are like one-dimensional arrays with arbitrary number of elements.

B : Unlike arrays a nested table doesn’t have declared number of elements. The size of a nested table can increase dynamically.

C : Initially a nested array has consecutive subscripts or dense, but it can become sparse when elements are deleted from it.

D : All of the above.

Answer: D

Page: 1 / 78

Total 389 Questions | Updated On: Apr 02, 2026

Add To Cart