Confidently Practice Online with Free 1Z0-149 Exam Cram

Practice your Oracle Database 19c: Program with PL/SQL certification test with free 1Z0-149 exam cram and take control of your certification preparation. At FreeExamCram, you can practice online for free using real 1Z0-149 exam dumps, verified questions, and expert-designed free online practice tests. Moreover our Oracle 1Z0-149 exam cram backed by our confidence-boosting refund guarantee.

Question 1

Options :

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

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

C :

Rewrite the block as:

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

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

Answer: C,D

Question 2

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?

Options :

A :

B :

C :

D :

Answer: B,C

Question 3

For which three SYSTEM EVENTS can triggers be created? (Choose three.)

Options :

A : DDL

B : AFTER AUDIT

C : BEFORE ANALYZE

D : SHUTDOWN

E : SERVERERROR

F : STARTUP

G : BEFORE GRANT

Answer: A,D

Question 4

Which is true about counter variables in a FOR loop?

Options :

A : It must explicitly be declared.

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

C : It cannot be NULL.

D : It is accessible outside the body of the loop.

Answer: C

Question 5

View the Exhibit to examine the PL/SQL block.

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

Options :

A : It executes successfully and gives the desired output.

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

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

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

Answer: C