MainFrame Interview Questions
Questions Answers Views Company eMail

What is a DB2 catalog?

2 6176

Why might full image copies be faster to implement than an incremental image copy?

4 5563

What is the purpose of the WHENEVER statement?

1 4291

Is there any advantage to denormalizing DB2 tables?

1 5787

What are some SQL aggregates and other built-in functions?

2 4421

What is sqlcode -922 ?

2 25028

What is lock escalation?

2 13128

What is the difference between primary key & unique index ?

Patni, Temenos,

6 24796

What is a DB2 bind?

3 5934

How does DB2 determine what lock-size to use?

2 7851

What are some characteristics of columns that benefit from indexes?

1 3839

How will you delete duplicate records from a table?

Google,

7 22490

When is the skeleton cursor table created?

1 4363

What is cursor stability?

1 4706

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

IBM,

2 7073


Un-Answered Questions { MainFrame }

Explain the system transid cemt?

596


What are fset, frset?

598


can I redistribute oorexx freely with commercial software?

579


what is rpg fixed logic cycle?

662


How to find the UNIT and VOLUME of a (a) KEPT (b) UNCATALOGED and (c) CATALOGED dataset - using (i) JCL and using (ii) ISPF ?

2174






how can you load a vsam data set with records ?

661


Mention data types used in db2 ?

681


Explain the advantages of adabas?

587


Define where and its usage?

521


Is db2 free?

684


Explain what happens when you issue a escape routine in a program? Will there be any compilation /run time erro?

565


cics command level is?

646


Explain what are the optional parameters to the input dataset while loading the empty cluster with the data records?

612


) what is the difference between AID and HANDLE AID?

1637


How is a typical db2 batch pgm executed?

642