COBOL,DB2 Interview Questions

deepthimadhu · Posted: Mon Dec 07, 2009 10:16 am

1. What will happen if you give GO BACK in a main program
a. Nothing wrong will happen. The program would give the expected
results. You can either use STOP RUN or GO BACK in the main pgm.

2. What is -806 abend?
a. Load module not found.

3. SELECT dept_name
INTO :ws-dept-name
FROM department
WHERE dept_no > 0;
Will the above query work fine?
a. The query would work fine if a single row is retrieved but would go
wrong if multiple rows are retrieved. A CURSOR should be declared for
retrieving multiple rows.

4. What is EXPLAIN?
a. EXPLAIN command gives explanation about the access paths in DB2
and provides explanation on how data will be accessed and how to
improve the performance of a command.

5. What is BIND in DB2?
a. BIND is used to create executable codes and access paths for the SQL
statements in the DBRM.

6. JUSTIFIED clause in COBOL.
a. JUSTIFIED RIGHT is used to allign data to the rightmost positon of the
receiving field. Default will be left justified.

deepthimadhu · Posted: Mon Dec 07, 2009 10:41 am

I missed out one question

What is the difference between SPUFI and QMF?

SPUFI
a. Return codes for the queries are obtained.
b. The result is directly stored in a data set.
c. Multiple queries can be executed at the same time.
d. Result appears in a less organised manner.

QMF
a. Return codes for the queries are not obtained.
b. The result is not stored in a data set.
c. Only a single query can be executed at a time.
d. Result appears in an organised manner.

Anuj Dhawan · Posted: Mon Dec 07, 2009 2:51 pm

So should we learn from these answers or you've some question(s)?

deepthimadhu · Posted: Mon Dec 07, 2009 4:58 pm

I just posted the questions that I came across in an interview.

Correct me if any of the answers are incorrect or if anything else needs to be added.

Anuj Dhawan · Posted: Mon Dec 07, 2009 5:02 pm