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: Nov 13, 2024

Add To Cart

Question 1

Consider a function totalEmp () which takes a number as an input parameter and returns the total number of employees who have a salary higher than that parameter.

Examine this PL/SQL package AS –

Which two definitions of totalEmp () result in an implicit conversion by Oracle Database on executing this PL/SQL block?

A :

B :

C :

D :

Answer: B,C

Question 2

When modifying procedure code, the procedure must be re-executed to validate and store it in the database. True or False?

A : ue

B : lse

Answer: A

Question 3

Which of the following is not true about the Constructors?

A : ese are functions that return a new object as its value.

B : ery object has a system defined constructor method.

C : name of the constructor is same as the object type.

D : ne of the above.

Answer: D

Question 4

PL/SQL is a completely portable, ??? transaction processing language.

A : w-performance

B : gh-performance

C : th 1 & 2

D : ne of the above

Answer: B

Question 5

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

Page: 1 / 78

Total 389 Questions | Updated On: Nov 13, 2024

Add To Cart