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

DB2 Interview Questions

Questions Answers Views Company eMail

What is rct?

1164

What is check constraint in db2?

1012

How can you count the number of rows from a table tab?

1040

Which components manage deadlocks in db2?

1016

What is the physical storage length of time data type?

1064

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

994

What is the picture clause of null indicator variable?

1081

Where can you declare a cursor in a cobol-db2 program?

995

What is concurrency in db2?

1 2104

Which component is responsible for db2 startup and shutdown?

981

What is data manager?

994

What is the physical storage length of date data type?

1189

Which isolation level provides highest data integrity?

1040

What is the reason behind not using select * in embedded sql programs?

1044

What is the maximum size of varchar data type in db2?

1066

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is db2?

1124

How to compare data between two tables in db2?

1032

What is innodb buffer pool?

978

What is the role of union all and union

1069

What is the connection string to connect to the DB2 Database ?

1059

How can you classify the locks in db2?

1032

What is cursor stability in db2?

1277

Where do you specify them?

1166

What is the use of value function?

1074

How do I optimize a query in db2?

1038

What does sqlcabc has?

994

Explain about rct in db2?

1044

How is deadlock resolved?

1081

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11615

How and when does the db2 enforces the unique key?

1029

For More Un-Answered { DB2 } Questions Click Here