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

Which kind of parameters cannot have a DEFAULT value?

Options :

A : OUT

B : IN

C : CONSTANT

D : R(ead)

E : W(rite)

Answer: A

Question 3

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 4

View the Exhibit and examine the structure of the EMP table.

Examine the code of the packages that you have created.

You issue the following command:
SQL> DROP PACKAGE manage_emp;
What is the outcome?

Options :

A : It drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effect.

B : It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package.

C : It returns an error and does not drop the MAMAGE_EMP package because of the cascading effect.

D : It drops the MANAGE_EMP package and invalidates both the specification and body for the EMP_DET package.

Answer: B

Question 5

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

Options :

A : True

B : False

Answer: B

Higher Test Marks with Free Online 1Z0-149 Exam Practice