Tag: databases

a) DELCARE and BEGIN

b) DECALRE and EXCEPTION

c) EXCEPTION and END

d) BEGIN and END

True

False

a) A stored procedure on the server.

b) A block of code in a PL/SQL library.

c) A standalone procedure on the client machine.

d) A block of code in the body of the program unit ORDERTOTAL.

e) A local subprogram defined within the program unit ORDERTOTAL.

a) Raise Application procedure

b) Raise Application Error procedure

c) Application Error procedure

d) None of the Above

SELECT *

FROM emp

WHERE comm = NULL

There is no error in this statement.

a) A comma has been left after the STATS_EXIST_EXCEPTION exception.

b) The STATS_EXIST_EXCEPTION has not been declared as a number.

c) The STATS_EXIST_EXCEPTION has not been declared as an exception.

d) none of the above

+

*

/

–

a) Only local or packaged sub programs can be overloaded.

b) Overloading allows different functions with the same name that differ only in their return types.

c) Overloading allows different subprograms with the same number, type and order of the parameter.

d) Overloading allows different subprograms with the same name and same number or type of the parameters.

e) Overloading allows different subprograms with the same name but different in either number or type or order of parameter.

a) Packages can be nested.

b) You can pass parameters to packages.

c) A package is loaded into memory each time it is invoked.

d) The contents of packages can be shared by many applications.

e) You can achieve information hiding by making package constructs private.

a) The package itself cannot be called, parameterized, or nested.

b) The format of a package is similar to that of a subprogram.

c) The contents can be shared by many applications once written.

d) None of the above.