Oracle 1Z0-149 Exam Real Questions

Prepare and pass your Oracle Database 19c: Program with PL/SQL with free 1Z0-149 exam questions.

Page: 1 / 78

Total 389 Questions | Updated On: Oct 09, 2024

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

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

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

In which of the following scenarios would you recommend using associative arrays?

A : en you want to retrieve an entire row from a table and perform calculations

B : en you know the number of elements in advance and the elements are usually accessed sequentially

C : en you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries

D : en you want to create a relatively small lookup table, where the collection can be constructed on memory each time a subprogram is invoked

Answer: D

Question 5

Which PRAGMA statement may enable associated PL/SQL functions to run more efficiently when called from SQL?

A : AGMA SERIALLY_REUSABLE;

B : AGMA UDF;

C : AGMA INLINE (‘< function_name >’, ‘YES’);

D : AGMA AUTONOMOUS_TRANSACTION;

Answer: B

Page: 1 / 78

Total 389 Questions | Updated On: Oct 09, 2024

Add To Cart