Tag: technology

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

YES

NO

Cant say

Depends on the query

Only Package

Only application plan

Both A & B

None of the above

in the SQLDA data structure

in the SQLCA data structure

in the DB configuration file

in the event monitor log

Query Manager Facility

Query Management Factor

Query Management Facility

None of the above

SQL Communications Area

SQL Control Area

SQL Connection Area

SQL Control Access

Declaration General

Data Control Language Generator

DB2 Control Region

Declaration Generator

DB2 Interchange

DB2 Information

DB2 Intercative

DB2 Init