Tag: technology

Packages can be nested.

You can pass parameters to packages.

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

The contents of packages can be shared by many applications.

You can achieve information hiding by making package constructs private.

True

False

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

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

The contents can be shared by many applications once written.

None of the above.

True

False

CREATE OR REPLACE FUNCTION tax_amt (p_id NUMBER) RETURN NUMBER

CREATE OR REPLACE PROCEDURE tax_amt (p_id NUMBER) RETURN NUMBER

CREATE OR REPLACE PROCEDURE tax_amt (p_id NUMBER, p_amount OUT NUMBER)

CREATE OR REPLACE FUNCTION tax_amt (p_id NUMBER) RETURN NUMBER(10,2)

CREATE OR REPLACE PROCEDURE tax_amt (p_id NUMBER, p_amount OUT NUMBER(10, 2))

A stored procedure uses the DELCLARE keyword in the procedure specification to declare formal parameters.

A stored procedure is named PL/SQL block with at least one parameter declaration in the procedure specification.

A stored procedure must have at least one executable statement in the procedure body.

A stored procedure uses the DECLARE keyword in the procedure body to declare formal parameters.

Querying with the SELECT * notification.

Declaring variables with the %TYPE attribute.

Specifying schema names when referencing objects.

Declaring records by using the %ROWTYPE attribute.

Specifying package.procedure notation while executing procedures.

A stored procedure is typically written in SQL.

A stored procedure is a named PL/SQL block that can accept parameters.

A stored procedure is a type of PL/SQL subprogram that performs an action.

A stored procedure has three parts: the specification, the body, and the exception handler part.

The executable section of a stored procedure contains statements that assigns values, control execution, and return values to the calling environment.

//

/*

/+

+/

getServletInfo()

getInitParameters()

getServletConfig()

None