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 4821

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 5036

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 7953

Can SQL statements/queries be included in a copybook?

2 7893

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 13958

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 12353

What is Call attach facility? How does it work?

Syntel,

1 12877

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

2 9269

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 5089

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 8690

What is the difference between Primary key and unique index?

6 10265

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

3 9029

What is package versioning? Please give an example.

1 4801

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

2 6349

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 18974

Post New DB2 Questions

Un-Answered Questions { DB2 }

Give a brief description of db2 isolation levels?

1068

Are view updateable?

1041

What are iseries servers?

1071

What is package in cobol db2?

1115

What is the use of db2 optimizer?

1110

What is copy pending status in db2?

1122

How do I import a csv file into db2?

989

What is reorg and runstats in db2?

1213

What is a db2 table?

1009

What is a db2 collection?

1035

Describe major components of db2?

1090

Define check constraint.

1076

Can we delete records from view?

966

What is the difference between bind and rebind in db2?

1449

What does db2 blu stand for?

1165

For More Un-Answered { DB2 } Questions Click Here