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 4681

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 4894

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 7747

Can SQL statements/queries be included in a copybook?

2 7782

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 13860

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 12229

What is Call attach facility? How does it work?

Syntel,

1 12752

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

2 9139

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 4997

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 8442

What is the difference between Primary key and unique index?

6 10012

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

3 8878

What is package versioning? Please give an example.

1 4719

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

2 6213

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 18645

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is db2 instance?

1019

How do I add a column in db2?

1000

Which component is responsible for processing sql statements and selecting access paths?

1074

What is load utility in db2?

1132

List some fields from sqlca?

1004

What happens in bind step in a db2 program?

916

What is an instance in db2?

988

What is dclgen in db2?

1084

Which are the db2 tools to protect integrity of the database?

1073

How do we specify index to include or not during bind process.

2072

How is the value function used?

1082

Explain db2.

993

Which isolation level provides maximum concurrency?

1093

What is a page in db2?

983

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1034

For More Un-Answered { DB2 } Questions Click Here