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 8912

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

1 5744

What is the difference between group by and order by?

IBM, TCS,

2 14634

How many buffer pools are there in DB2?

2 7424

What are the three lock types?

2 6565

When is the access path determined for dynamic SQL?

2 9138

What is a Database Request Module(DBRM)?

4 20230

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

Tech Mahindra,

3 14336

What is cursor stability?

1 8448

What are data types?

2 5414

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

2 9654

What are leaf pages?

3 8854

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

IBM,

3 10536

What are the disadvantages of PAGE level lock?

3 8375

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

1 5332

Post New DB2 Questions

Un-Answered Questions { DB2 }

define clustering index.

1034

How do you eliminate duplicate values in db2?

1198

What are concurrency issues?

1102

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

1012

Explain about dbrm.

1051

Why cursor is used in db2?

1038

What is bind in db2?

1054

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

What is cursor with hold option in db2?

1076

What is isolation level in db2?

1011

List down the types of triggers in the db2 database?

1035

What is data manager?

1056

What is the use of predicate?

1043

What is a db2 tablespace?

1069

Why select is not preferred in embedded sql programs?

1307

For More Un-Answered { DB2 } Questions Click Here