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 28, 2021

Add To Cart

Question 1

A : ne 5 should be replaced with: DBMS_LOB.CREATETEMPORARY (pdatabuf (1), TRUE, DBMS_LOB.CALL);

B : ne 5 should be replaced with: DBMS_LOB.CREATETEMPORARY (pdatabuf (1), FALSE, DBMS_LOB.SESSION);

C : Rewrite the block as:

D : atabuf (1) := NULL; should be added after line 4.

E : ne 5 should be replaced with:DBMS_LOB.CREATETEMPORARY (pdatabuf, TRUE, DBMS_LOB.SESSION);

Answer: C,D

Question 2

Examine the following DECLARE section of PL/SQL block:

Which line in the above declaration would generate an error?

A : ne 2

B : ne 3

C : ne 4

D : ne 5

E : ne 6

Answer: A

Question 3

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 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

View the Exhibit to examine the PL/SQL block.

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

A : executes successfully and gives the desired output.

B : does not execute because the definition of type population is indexed by VARCHAR2.

C : executes, and the string keys of an associative array are not stored in creation order, but in sorted order.

D : does not execute because the value that is once assigned to the element of the associative array cannot be changed.

Answer: C

Page: 1 / 78

Total 389 Questions | Updated On: Mar 28, 2021

Add To Cart