Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 2948

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 3112

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 5000

Can SQL statements/queries be included in a copybook?

2 5840

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 10550

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 9020

What is Call attach facility? How does it work?

Syntel,

1 11068

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

2 6980

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 3517

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 5063

What is the difference between Primary key and unique index?

6 6825

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

3 6480

What is package versioning? Please give an example.

1 3435

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

2 4227

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 14100


Post New DB2 Questions






Un-Answered Questions { DB2 }

How do I change the column size in db2?

198


What is reorg and runstats in db2?

204


Can one database have multiple instances?

195


What is the purpose of rollback and commit?

214


What are foreign keys in db2?

233






If I have a view which is a join of two or more tables, can this view be updateable?

228


What is isolation level in db2?

197


What is explain in db2?

205


Who uses db2?

218


What is temporal table in db2?

182


What is buffer pool and list some of them?

241


Discuss about db2 bind?

264


What is load replace in db2?

191


What is dbrm? What it contains?

254


How many databases are there?

200