Question 1

PL/SQL is a completely portable, ??? transaction processing language.

Options :

A : Low-performance

B : High-performance

C : Both 1 & 2

D : None of the above

Answer: B

Question 2

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

Options :

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

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

C : When 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 : When 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 3

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

Options :

A : PRAGMA SERIALLY_REUSABLE;

B : PRAGMA UDF;

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

D : PRAGMA AUTONOMOUS_TRANSACTION;

Answer: B

Question 4

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

Options :

A : LOOP

B : END LOOP

C : IF-THEN

D : EXIT

Answer: B

Question 5

User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database.
SCOTT creates the following trigger:

SCOTT does not grant the execute privilege on this trigger to any other users.
For which user(s) would this trigger fire by default when they drop an object in the hr schema?

Options :

A : Only HR

B : SCOTT and HR

C : Only SCOTT

D : SCOTT, HR, and SYS

Answer: A

Higher Test Marks with Free Online 1Z0-149 Exam Practice

Buying Options: