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: Jun 23, 2025

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

For which three SYSTEM EVENTS can triggers be created? (Choose three.)

A : DDL

B : AFTER AUDIT

C : BEFORE ANALYZE

D : SHUTDOWN

E : SERVERERROR

F : STARTUP

G : BEFORE GRANT

Answer: A,D

Question 3

View the Exhibit to examine the PL/SQL code.

Identify the correct output for the code.

A : King 17-JUN-87 1500

B : King 17-JUN-87 24000

C : King current sysdate 1500

D : King current sysdate 24000

Answer: C

Question 4

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 5

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

Page: 1 / 78

Total 389 Questions | Updated On: Jun 23, 2025

Add To Cart