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

DB2 Interview Questions

Questions Answers Views Company eMail

Can you tell me how can you find out the # of rows updated after an update statement?

1101

What are the contents of dclgen?

1112

Why select is not preferred in embedded sql programs?

1299

How do you select a row using indexes in db2?

1135

When reorg is used?

1129

What are the various isolation levels possible?

1122

How can you do the explain of a dynamic sql statement?

1069

Can you use max on a char column?

1097

List some fields from sqlca?

1058

Explain what are the various isolation levels possible?

1044

What is the physical storage length of the data types date, time, and timestamp?

1090

What is the use of value function?

1151

If I have a view which is a join of two or more tables, can this view be updateable?

1139

What is the result of open cursor statement?

1083

How would the varchar column remarks defined?

1088

Post New DB2 Questions

Un-Answered Questions { DB2 }

What are the 2 sqlcodes that are returned?

1189

What is the role of data manager in the db2 database?

1109

Which isolation level provides highest data integrity?

1118

what is the sqlcode -501

13152

Which component is responsible for processing sql statements and selecting access paths?

1127

B37 abend during spufi?

1455

Define db2.

1116

What kind of database is db2?

1036

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

2070

What is isolation level in db2?

1005

what is a corelated subquerry?

1122

What are union and union all?

983

What is clone table?

1042

How to fetch the last row from the table in SQL (db2)?

1655

What is consistency token in db2?

1143

For More Un-Answered { DB2 } Questions Click Here