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

DB2 Interview Questions

Questions Answers Views Company eMail

How can deadlocks be resolved?

937

What is commit in db2?

1055

What is access path in db2?

986

Can we insert update delete in view?

972

Can one database have multiple instances?

1054

What do you mean by commit and rollback?

1043

What is copy pending status in db2?

1127

What is collection in db2 bind?

1017

What do you mean by rollback?

991

What is alias in db2?

1061

What is clone table?

1042

What is scrollable cursor in db2?

1055

What are types of indexes?

1074

What is bind and rebind in db2?

1139

What is cascading rollback?

1214

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is db2 plan table?

1050

What is db2 command?

1037

Explain about dbrm.

1047

What is meant by dclgen?

1110

What is a trigger in the db2 database?

1080

What is an instance database?

1052

How to execute stored procedures?

1130

How do you concatenate the firstname and lastname from emp table to give a complete name?

1077

How does coalesce work?

1023

What is cursor in dbms?

1069

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 ?...

4315

What is bind in db2?

1044

List out the three types of page locks that can be held.

1149

What is image copy in db2?

1020

What are the bind parameters ibm db2?

1053

For More Un-Answered { DB2 } Questions Click Here