Tag: databases

define the name of the package

provide an alias for the package

define the schema of the package

define the database of the package

FOR HOLD

FOR UPDATE

FOR FETCH

WITH HOLD

Removes all the statements in source code

Replaces all the SQL statements into corresponding host language CALL statements

Replaces SQL statements into corresponding host language statements

None of the above

BIND

REBIND

Both A & B

None of the above

-803

-811

-805

-855

A single, bound DBRM

A Multi bound DBRM with optimised access paths

A Single bound DBRM with optimised access paths

A Multi bound DBRM

Edited form of the SQL statements with some additional information

Complied version of SQL statements

Complied version of source code

None of the above

LOCK Manager

Resource Manager

IRLM

None of the above

Is an executable module containing access path logic provided by the DB2 optimiser

In an non executable module containing access path logic provide by the DB2 optimiser

Is just a module containing access path to DB2 optimiser

Is a module containing access path

It will drop the existing plan

It will delete the existing plan

Both a & b

None of the above