Question 1

Examine this PL/SQL function:What happens when the function is created with PLSQL_WARNINGS set to ENABLE: ALL?

Options :

A : There are no compilation warnings or errors.

B : It fails compilation.

C : An information compilation warning is generated.

D : A performance compilation warning is generated.

E : A severe compilation warning is generated.

Answer: C

Question 2

Examine this PL/SQL function:

What happens when the function is created with PLSQL_WARNINGS set to ENABLE: ALL?

Options :

A : There are no compilation warnings or errors.

B : It fails compilation.

C : An information compilation warning is generated.

D : A performance compilation warning is generated.

E : A severe compilation warning is generated.

Answer: C

Question 3

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

Options :

A : ALTER PROCEDURE

B : DROP PROCEDURE

C : DELETE PROCEDURE

D : TRUNCATE procedure.

Answer: B

Question 4

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 5

Which two blocks of code execute successfully?

Options :

A : DECLARE SUBTYPE new_one IS BINARY_INTERGER RANGE 0..9;
my_val new_one;
BEGIN my_val :=0;
END;

B : DECLARE SUBTYPE new_string IS VARCHAR2 (5) NOT NULL; my_str_new_string;
BEGIN my_str := abc;
END;

C :

    DECLARE SUBTYPE new_one IS NUMBER (2, 1);
    my_val new_one;
    BEGIN my_val :=12.5;
    END;

D : DECLARE SUBTYPE new_one IS INTEGER RANGE 1..10 NOT NULL;
my_val new_one;
BEGIN my_val :=2;
END;

E : DECLARE SUBTYPE new_one IS NUMBER (1, 0);
my_val new_one;
BEGIN my_val := -1

Answer: A

Free 1Z0-149 Mock Exam – Practice Online Confidently