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

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 3

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 4

Subprograms and anonymous blocks can be called by other applications. True or False?

Options :

A : True

B : False

Answer: B

Question 5

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

Free 1Z0-149 Mock Exam – Practice Online Confidently