Question 1

The collection method COUNT

Options :

A : Returns the last (largest) index numbers in a collection that uses integer subscripts.

B : Returns the number of elements that a collection currently contains.

C : Checks the Maximum Size of a Collection

D : None of the above.

Answer: B

Question 2

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 3

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

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

What can the value of the INTO clause be while fetching data in an explicit cursor?

Options :

A : PL/SQL scalar variables only

B : PL/SQL variables or records

C : Collections or records only

D : Records only

Answer: B

Smartly Prepare Exam with Free Online 1Z0-149 Practice Test

Buying Options: