Use the TO_DATE function in line 2.

Use the TO_DATE function in line 7.

Use the TO_NUMBER function in line 6.

Use both the TO_DATE function in line 2 and the TO_NUMBER function in line 6.

Subprograms are by default executed with definer's rights.

The declare section is optional for both anonymous blocks and subprograms.

Both anonymous blocks and subprograms execute by default with invoker's rights.

The declare section is mandatory for anonymous blocks and optional for subprograms.

It executes successfully and creates the report.

It gives an error because the text file should be opened in append mode.

It gives an error because the "no data found" condition is not handled to come out of the loop.

It gives an error because user SCOTT should be granted both read and write privileges to the directory alias.

It executes but no data is written to the text file because the FFLUSH subprogram is not used to write all the data buffered in memory to a file.

To use native code compilation, PLSQL_OPTIMIZE_I.EVEL should be set to a value less than or equal to l.

The default value of 2 for PLSQL_OPTIMI2E_LEVEL allows the compiler to rearrange code for better performance.

Setting PLSQL_CODE_TYPE to native provides the greatest performance gains only for computation-intensive procedural operations.

Changing the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units that have already been compiled

It executes successfully and gives the desired output.

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

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

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

A transaction can span multiple blocks.

A block can contain only a single transaction.

SERVERPOINTS cannot be created in a PL/SQL block.

The END keyword signals the end of a PL/SQL block and automatically commits the transaction in the block.

The execution fails because of the misplaced else clause.

The execution is successful even if there is no employee with EMPLOYEE_ID 115.

The execution falls and throws exceptions if no employee with EMPLOYEE_ID us is found.

The execution is successful, but it displays an incorrect output if no employee with EMPLOYEE_ID 115 is found.

Add exception handlers whenever errors occur.

An exception handler should commit the transaction.

Handle named exceptions whenever possible instead of using when others in exception handlers.

Instead of adding exception handlers to your PL/SQL block, check for errors at every point where they may occur.

Both Output statements show different values.

Both output statements show exactly the same values.

It gives an error because the nested blocks are not labeled.

It gives an error because the V_CUSTOMER variable have different types in the nested blocks

Reference host or bind variables in a PL7SQL block of code

Tasks that compute and return multiple values to the calling environment

Tasks that compute a value that must be returned to the calling environment

Tasks performed in SQL that increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into an application