Question 1

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 2

Examine this code (all compiled into schema HR):Execute this code: SET SERVEROUTPUT ON EXEC test_pkg.do_stuff –What is the correct output?

Options :

A :

B :

C :

D :

E :

Answer: C

Question 3

Which statement is true about the DBMS_PARALLEL_EXECUTE package?

Options :

A : DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.

B : To execute chunks in parallel, users must have CREATE JOB system privilege

C : No specific system privileges are required to create or run parallel execution tasks

D : Only DBAs can create or run parallel execution tasks.

E : Users with CREATE TASK privilege can create or run parallel execution tasks.

Answer: B

Question 4

Subprograms are named PL/SQL blocks that can be called with a set of parameters.

Options :

A : True

B : False

C : Depends upon

D : None of the above

Answer: A

Question 5

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