DB2 QUIZ

1.

What is the input to the bind process?
- A.
  
  DBRM
- B.
  
  SQL
- C.
  
  Table Name
- D.
  
  None of these
Correct Answer
A. DBRM

Explanation
DBRM is the input to the bind process which is produced in the pre-compile step.

Rate this question:
2.

What happens in BIND step in a DB2 program?
- A.
  
  Bind step checks for data type matches
- B.
  
  Bind contains SQL statements
- C.
  
  Bind step converts all SQL statements to executables
- D.
  
  None of these
Correct Answer
C. Bind step converts all SQL statements to executables

Explanation
Bind step converts all the SQL statements into executable form in COBOL-DB2 program.

Rate this question:
3.

Which component is used to processes SQL statements and selects the access paths?
- A.
  
  Buffer Manager
- B.
  
  DB2 Optimizer
- C.
  
  Data Manager
- D.
  
  Data Definer
Correct Answer
B. DB2 Optimizer

Explanation
DB2 optimizer is used to select the access paths & to process the SQL queries.

Rate this question:
4.

The first Precompile utility which is required for the db2 part of the compilation?
- A.
  
  IKJEFT01
- B.
  
  IGYCTCRL
- C.
  
  DSNHPC
- D.
  
  IKJEFT02
Correct Answer
C. DSNHPC

Explanation
The first utility which is required for the db2 part of the compilation is DSNHPC.The DB2 Precompile performs three functions.First -checks the SQL in the program for errors.Second - adds working storage areas and source code compatible statements that are used to invoke DB2.One of the working storage areas contains a literal "timestamp" called a consistency token. Finally, all of the SQL statements are extracted from the program source and placed into a member called the DataBase Request Module, or DBRM, which also contains the consistency token.

Rate this question:
5.

Which utility is used to execute a COBOL-DB2 program?
- A.
  
  IGYCTCRL
- B.
  
  IKJEFT01
- C.
  
  RUN
- D.
  
  DSNHPC
Correct Answer
B. IKJEFT01

Explanation
IKJEFT01 is used to execute a COBOL-DB2 program. Program name is mentioned with PLAN name & Library where program resides

Rate this question:
6.

The utility which is used for converting a source code into an object code is?
- A.
  
  DSNHPC
- B.
  
  IEWL
- C.
  
  IKJET01
- D.
  
  None of these
Correct Answer
D. None of these

Explanation
The utility which is used for converting a souce code into an object module is IGYCRCTL.
During the conversion of SC to OC we need sysut, sysin and syslin
SYSIN is the Source program input for the COBOL compiler.
While SYSLIN is the Object module output.
And SYSUT is the additional inputs required for the compilation

Rate this question:
7.

The utility which is used for converting an object code into an executable load module is ?
- A.
  
  IGYCRCTL
- B.
  
  IEWL
- C.
  
  DSNHPC
- D.
  
  RUNJCL
Correct Answer
B. IEWL

Explanation
Once we get the OC, we need to process this OC into a code which is in a readilty executable format.
for converting OC into executable load module we need another utility called IEWL

Rate this question:
8.

Which of the Following Parm Parameter is used to get a sorted cross reference listing??
- A.
  
  LIST
- B.
  
  XREF
- C.
  
  XCTL
- D.
  
  MAP
Correct Answer
B. XREF

Explanation
The parm parameters are used to pass information to a program. Map ,list and xref form SOME parm parameters
XREF is used to get a sorted cross-reference listing. data-names and procedure-names will be listed in alphanumeric order. It also includes listing, where all the data-names that are referenced within your program and the line number where they are defined. This is useful for identifying the fields that are defined but not used anywhere after the development of new program.

Rate this question:
9.

What does application plan contains?
- A.
  
  DBRM
- B.
  
  Package
- C.
  
  Both A & B
- D.
  
  None of these
Correct Answer
C. Both A & B

Explanation
Application plan consists of one or more DBRM & application package which is kept in buffer pool during program execution

Rate this question:
10.

DBRM stands for?
- A.
  
  Data Base Resource Manager
- B.
  
  Data Base Resource Module
- C.
  
  Data Base Request Module
- D.
  
  Data Base Request Manager
Correct Answer
C. Data Base Request Module

Explanation
DBRM stands for Data Base Request Module.

Rate this question:

Db2 Quiz

What is the input to the bind process?

What happens in BIND step in a DB2 program?

Which component is used to processes SQL statements and selects the access paths?

The first Precompile utility which is required for the db2 part of the compilation?

Which utility is used to execute a COBOL-DB2 program?

The utility which is used for converting a source code into an object code is?

The utility which is used for converting an object code into an executable load module is ?

Which of the Following Parm Parameter is used to get a sorted cross reference listing??

What does application plan contains?

DBRM stands for?