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

DB2 Interview Questions

Questions Answers Views Company eMail

Which isolation level provides maximum concurrency?

653

What are the contents of a dclmgen?

620

What is role in db2?

608

What action db2 takes when a program aborts in the middle of a transaction?

647

What is the physical storage length of timestamp data type?

638

What is dclgen (declaration generator)?

592

What is the maximum length of sqlca?

851

How can you classify the locks in db2?

624

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

647

What do you mean by storage group (stogroup)?

574

What is buffer pool?

604

What is the default page size of buffer pools?

639

What is the usage of open cursor command?

592

What is db2? Explain.

593

What is the use of predicate?

577

Post New DB2 Questions

Un-Answered Questions { DB2 }

what are bind concepts in db2 cobol?

641

What is clone table?

587

What are the contents of dclgen?

642

How to test SQL -911 error while developing COB-DB2 program

6696

Is the primary key a clustered index?

599

Highlight all the advantages that are attached to a package.

618

How can we read records for specific member in CL? AND rpg?

226

How to run db2 command in windows?

632

What does db2 stand for?

593

Why do we use cursor?

588

is it compulsory commitment control in journal?

2003

What is drop table?

575

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

593

How do I change the column size in db2?

583

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

3781

For More Un-Answered { DB2 } Questions Click Here