It is a private variable defined in a procedure or function within a package body whose value is consistent within a user session.

It is a public variable in a package specification whose value is consistent within a user session.

It is a private variable in a package body whose value is consistent across all current active sessions.

It is a public variable in a package specification whose value is always consistent across all current active sessions.

It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table

It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.

It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.

It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section.

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.