Question 1

Which of the following is true about PL/SQL index-by tables?

Options :

A : It is a set of key-value pairs.

B : Each key is unique and is used to locate the corresponding value.

C : The key can be either an integer or a string.

D : All of the above.

Answer: 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

SERVEROUTPUT is enabled.

Which is the correct method to use a PACKAGED CONSTANT in SELECT statements?

Options :

A :

B :

C :

D :

Answer: D

Question 4

Which system events can be used to create triggers that fire both at database and schema
levels? (Choose all that apply)

Options :

A : AFTER LOGON

B : AFTER STARTUP

C : BEFORE SHUTDOWN

D : AFTER SERVERERROR

Answer: A,D

Question 5

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

Free 1Z0-149 Mock Exam – Practice Online Confidently

Buying Options: