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 12, 2025

Add To Cart

Question 1

SERVEROUTPUT is enabled.

Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

A :

B :

C :

D :

Answer: D

Question 2

View the Exhibit to examine the PL/SQL code.

Identify the correct output for the code.

A : ng 17-JUN-87 1500

B : ng 17-JUN-87 24000

C : ng current sysdate 1500

D : ng current sysdate 24000

Answer: C

Question 3

View the Exhibit to examine the PLSQL block.

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

A : executes and the Output is emprec.deptname: .

B : executes and the Output is emprec.deptname: Sales.

C : produces an error because NULL is assigned to the emprec.empid field in the record

D : produces an error because the CHECK constraint is violated while assigning a value to the emprec.deptid field in the record.

Answer: A

Question 4

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

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

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

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

D : l of the above.

Answer: D

Question 5

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

Page: 1 / 78

Total 389 Questions | Updated On: Mar 12, 2025

Add To Cart