A.setting the UTL_FILE_DIR initialization parameter

B.running the UTLMAIL.SQL and prvtmail.plb scripts

C.setting the SMTP_OUT_SERVER initialization parameter

D.using the CREATE DIRECTORY statement to associate an alias with an operating system directory

E.granting read and WRITE privileges to control the type of access to files in the operating system

A.The exception reproduces itself in successive enclosing blocks until a handler is found.

B.Exception- can propagate across the remote subprograms that are called through database links.

C.If you declare a local exception in a subblock and a global exception in the outer block, the local declaration overrides the global exception.

D.If you declare a local exception in a subblock and a global exception in the outer block, the global declaration overrides the local exception.

A.The execution fails because of the misplaced elseclause.

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

C.The execution fails and throws exceptions if no employee with EMPLOYEE_ID 115is found.

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

A.It executes successfully.

B.It gives an error because the SAL variable is not visible in the increase function.

C.It gives an error because the increase function cannot be called from the RAISE_SALARY procedure.

D.It gives an error because the increase function and the RAISE_SALARY procedure should be declared at the beginning of the declare section before all the other declarations.

A.It does not display any of the DBMS_OUTPUT messages and gives an error because a transaction control statement cannot be used in the exception section of a procedure.

B.It displays
Output buffer not long enough.
This is my test string.-.

C.It displays only
Output buffer not long enough, and exits the anonymous block.

D.It displays only
This is my test string.- Because EXCEPTION should have been defined in the anonymous block to get the error message.