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

DB2 Interview Questions

Questions Answers Views Company eMail

What does CURRENTDATA option in bind indicate

IBM,

1 8904

What is the format (internal layout) of ?TIMESTAMP??

1 5742

What is the difference between group by and order by?

IBM, TCS,

2 14629

How many buffer pools are there in DB2?

2 7421

What are the three lock types?

2 6553

When is the access path determined for dynamic SQL?

2 9126

What is a Database Request Module(DBRM)?

4 20219

What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?

Tech Mahindra,

3 14324

What is cursor stability?

1 8442

What are data types?

2 5403

What is a NULL value? What are the pros and cons of using NULLS?

2 9651

What are leaf pages?

3 8841

when does the SQL statement gets executed when you use cursor in the application programming ?

IBM,

3 10525

What are the disadvantages of PAGE level lock?

3 8367

In terms of DB2 indexing, what is the root page?

1 5328

Post New DB2 Questions

Un-Answered Questions { DB2 }

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1044

What is the syntax for creating a table in the db2 database?

1107

What are the benefits of using the db2 database?

1229

What does sqlcabc has?

1055

Give the name of some fields form sqlca.

1079

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1071

What is buffer pool and list some of them?

1028

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1737

Explain various types of locks in db2?

1151

What are the different types of base tables?

1094

What is the use of commit in db2?

1083

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3157

What is syscat in db2?

1010

How many types of page locks can be held in db2?

1042

What is dbrm? When it will be created?

1029

For More Un-Answered { DB2 } Questions Click Here