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: Mar 25, 2025

Add To Cart

Question 1

What can the value of the INTO clause be while fetching data in an explicit cursor?

A : /SQL scalar variables only

B : /SQL variables or records

C : llections or records only

D : cords only

Answer: B

Question 2

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

A : L

B : TER AUDIT

C : FORE ANALYZE

D : UTDOWN

E : RVERERROR

F : ARTUP

G : FORE GRANT

Answer: A,D

Question 3

In which of the following scenarios would you recommend using associative arrays?

A : en you want to retrieve an entire row from a table and perform calculations

B : en you know the number of elements in advance and the elements are usually accessed sequentially

C : en you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries

D : en you want to create a relatively small lookup table, where the collection can be constructed on memory each time a subprogram is invoked

Answer: D

Question 4

The collection method COUNT

A : turns the last (largest) index numbers in a collection that uses integer subscripts.

B : turns the number of elements that a collection currently contains.

C : ecks the Maximum Size of a Collection

D : ne of the above.

Answer: B

Question 5

Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with

%ROWTYPE? (Choose three.)

A : EATE

B : OP

C : DATE

D : LECT

E : LETE

F : TER

G : ERT

Answer: A,C,D

Page: 1 / 78

Total 389 Questions | Updated On: Mar 25, 2025

Add To Cart