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: Jan 07, 2025

Add To Cart

Question 1

What is the statement to remove a procedure from a database?

A : TER PROCEDURE

B : OP PROCEDURE

C : LETE PROCEDURE

D : UNCATE procedure.

Answer: B

Question 2

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 3

Which data dictionary view contains the list of procedures and functions defined within package specification that you can execute?

A : L_SOURCE

B : L_DEPENDENCIES

C : L_OBJECTS

D : L_PROCEDURES

E : L_PLSQL_OBJECT_SETTINGS

Answer: D

Question 4

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 5

Which is true about counter variables in a FOR loop?

A : must explicitly be declared.

B : can be modified in the body of the loop.

C : cannot be NULL.

D : is accessible outside the body of the loop.

Answer: C

Page: 1 / 78

Total 389 Questions | Updated On: Jan 07, 2025

Add To Cart