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: Feb 19, 2025

Add To Cart

Question 1

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 2

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 3

Which system events can be used to create triggers that fire both at database and schema
levels? (Choose all that apply)

A : TER LOGON

B : TER STARTUP

C : FORE SHUTDOWN

D : TER SERVERERROR

Answer: A,D

Question 4

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 5

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

A : OP

B : LOOP

C : -THEN

D : IT

Answer: B

Page: 1 / 78

Total 389 Questions | Updated On: Feb 19, 2025

Add To Cart