View the Exhibit to examine the PL/SQL block.

Which two statements are true about the execution of the PL/SQL block? (Choose two.)

A. It executes successfully and gives the desired output.

B. It does not execute because the definition of type POPULATION is indexed by VARCHAR2.

C. It executes, and the string keys of an associative array are not stored in creation order, but in sorted order.

D. It does not execute because the value that is once assigned to the element of the associative array cannot be changed.

View Exhibit 1 and examine the structure of the DO table.

View Exhibit 2 and examine the code.

The anonymous block gives an error on execution. What is the reason?

A. The assignment in line 7 is not valid.

B. The SQL does not support the Boolean data type.

C. A null value cannot be applied to the bind arguments in the using clause in line 10.

D. The names of bind variables must be the same as the using clause bind arguments in line 10.

Which two statements correctly differentiate functions and procedures? (Choose two.)

A. A function can be called only as part of a SQL statement, whereas a procedure can be called only as a PL/SQL statement.

B. A function must return a value to the calling environment, whereas a procedure can return zero or more values to its calling environment.

C. A function can be called as part of a SQL statement or PL/SQL expression, whereas a procedure can be called only as a PL/SQL statement.

D. A function may return one or more values to the calling environment, whereas a procedure must return a single value to its calling environment.

Examine the following PL/SQL code: Which statement is true about the fetch statements in the PL/SQL code?

A. Each fetch retrieves the first row and assigns values to the target variables.

B. Each fetch retrieves the next consecutive row and assigns values to the target variables.

C. They produce an error because you must close and reopen the cursor before each fetch -statement.

D. Only the first fetch retrieves the first row and assigns values to the target variables- the second produces an error.

Which two guidelines are recommended by Oracle to reduce invalidation of dependent objects? (Choose two.)

A. Reference tables indirectly by using views.

B. Reference tables directly and avoid using views.

C. When adding new items to a package, add them to the end of the package.

D. When adding new items to a package, add them to the beginning of the package.