DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?

2 4919

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 5172

Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.

5 8109

Can SQL statements/queries be included in a copybook?

2 7995

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

RBS,

1 14040

If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 12464

What is Call attach facility? How does it work?

Syntel,

1 12987

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 9396

Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?

1 5158

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 8886

What is the difference between Primary key and unique index?

6 10434

why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 9131

What is package versioning? Please give an example.

1 4877

Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)

2 6469

In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?

Syntel,

8 19250

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the physical storage length of date data type?

1304

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2219

What language is db2 written in?

1101

How to create backup table in db2?

1146

What is bind package and plan in db2?

1103

What is schema in db2?

1079

Explain about mirror activator disk mirroring?

1060

How can deadlocks be resolved?

990

What is runstats and reorg in db2?

1356

What is the meaning concurrency in the db2 database?

1160

List down the data types in the db2 database.

1178

What is drop table?

1064

Explain package in db2 and its advantages?

1269

What db2 400?

1250

What does db2 mean?

1082

For More Un-Answered { DB2 } Questions Click Here