A.A procedure can contain a return statement without a value.

B.A function can return multiple values using a single return clause,

C.A procedure can be executed as part of a SQL expression or as a PL/SQL statement,

D.A function can contain zero or more parameters that are transferred from the calling environment.

A.MY_PROC1 is recompiled but remains unchanged.

B.MY_PROC2 is recompiled but remains unchanged.

C.MY_PROC1 is recompiled without the debugging code.

D.MY_PROC2 is not recompiled.

A.The PL/SQL wrapper detects and reports only syntaxerrors.

B.The PL/SQL wrapper detects and reports both syntaxand semantic errors.

C.When wrapping a package or object type, both the body and specification should be wrapped.

D.When wrapping a package or object type, only the body should be wrapped, not the specification.

E.To change a wrapped object, the original source code needs to be modified and then wrapped again

F.To change a wrapped object, the wrapped code can be unwrapped, modified In a text file, and then wrapped again.

A.King current sysdate 24000

B.King current sysdate 1500

C.King 17-JUN-87 1500

D.King 17-JUN-87 24000

A.It executes successfully and all the rows are updated.

B.It gives an error but saves the inserted rows and the update to the first row.

C.It gives an error but saves the inserted rows; however, no rows are updated.

D.It gives an error and all the data manipulation language (DML) statements are rolled back.