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?

1046

What are the contents of dclgen?

1053

Why select is not preferred in embedded sql programs?

1232

How do you select a row using indexes in db2?

1075

When reorg is used?

1072

What are the various isolation levels possible?

1050

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

1017

Can you use max on a char column?

1031

List some fields from sqlca?

1004

Explain what are the various isolation levels possible?

991

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

1042

What is the use of value function?

1076

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

1086

What is the result of open cursor statement?

1030

How would the varchar column remarks defined?

1038

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is alias in db2?

982

What is role in db2?

1042

How do I change the column size in db2?

1084

How is deadlock resolved?

1082

What is a db2 package?

991

How can you quickly find out the # of rows updated after an update statement?

987

What is an instance database?

1007

What is dclgen in db2?

1083

Can one database have multiple instances?

1007

How to get the ddl of a table in db2?

1074

What is the purpose of rollback and commit?

1089

How to check last update on table in db2?

1004

How to run db2 command in windows?

1141

What type of database is db2?

913

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4215

For More Un-Answered { DB2 } Questions Click Here