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 8829

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

1 5643

What is the difference between group by and order by?

IBM, TCS,

2 14460

How many buffer pools are there in DB2?

2 7303

What are the three lock types?

2 6433

When is the access path determined for dynamic SQL?

2 8988

What is a Database Request Module(DBRM)?

4 19993

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

Tech Mahindra,

3 14126

What is cursor stability?

1 8361

What are data types?

2 5281

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

2 9481

What are leaf pages?

3 8651

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

IBM,

3 10369

What are the disadvantages of PAGE level lock?

3 8178

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

1 5244

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the use of predicate?

985

Explain in detail about buffer manager and its functionalities?

997

How does coalesce work?

963

How connect db2 database to datastage?

1191

How do you stop a db2 database in linux?

960

What are bind parameters in db2?

983

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1027

What language is db2 written in?

983

Is the primary key a clustered index?

1080

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1221

What is bind package and plan in db2?

1006

What types of tables are there in the db2 database?

1008

Define declaration generator (dclgen).

1068

What do you mean by between and in? Is between inclusive of specified range values?

1041

How do I add a column in db2?

1000

For More Un-Answered { DB2 } Questions Click Here