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

DB2 Interview Questions

Questions Answers Views Company eMail

Where besides the DB2 catalog is database object information stored by DB2?

1 4975

What is isolation level?

4 7281

What is a predicate?

1 4776

What is ALTER ?

3 6878

What do you need to do before you do EXPLAIN?

1 5248

How do you insert a record with a nullable column?

2 6274

What is a result table?

1 5639

What is the SQL Communications Area and what are some of its key fields?

1 5023

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 4284

How would one remove old reorg information from the DB2 catalog?

2 6448

The only place of VSAM KSDS in DB2 is?

IBM,

2 8012

What is DCLGEN?

2 15764

Where is the output of EXPLAIN stored?

2 6840

What is the function of buffer manager?

1 5759

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 6505

Post New DB2 Questions

Un-Answered Questions { DB2 }

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9200

What is db2 stogroup?

1160

What is db2 look?

1023

What is dbrm? What it contains? When it will be created?

1050

What is the maximum size of a char data type in db2?

1010

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1278

what are bind concepts in db2 cobol?

1092

What is lock escalation in db2?

1031

What does db2 stand for?

1025

What is the meaning concurrency in the db2 database?

1110

How to take backup of table in db2?

1074

What type of database is db2?

971

How does cobol compile db2 program?

1057

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1101

Discuss about db2 bind?

1097

For More Un-Answered { DB2 } Questions Click Here