IBM MainFrame Interview Questions
Questions Answers Views Company eMail

What is a DB2 plan?

8 42930

How to define the data items to receive the fetch items for the SQL?

2 4698

What is a page?

2 4204

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

CTS,

1 9171

What is a collection?

3 5530

What does the CHECK Utility do ?

1 4818

Where could you look if you had a question about whether a column has been defined as an index?

2 4995

What are the various locking levels available?

3 5510

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

3 5659

What are the 4 environments which can access DB2 ?

2 6082

What is the picture clause of the null indicator variable?

6 17296

What will the FREE command do to a plan?

2 4826

What is a DB2 bind?

Logica CMG,

1 6409

What information can you find in SYSIBM.SYSLINKS table?

TCS,

1 8325

What is the difference between IN subselects and EXISTS subselect?

HCL, PreVator, TCS,

1 9879


Un-Answered Questions { IBM MainFrame }

What is sysplex?

502


A dd statement consists of 4 fields. Name them?

912


Tell me what type of files we can process thru file-aid?

528


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

6699


What are the functions available in rexx?

523






How you can read the file from bottom?

652


Explain about LMFREE�free data set from its association with data ID

992


Explain the biggest disadvantage of using a vsam dataset?

578


What is the difference between lds and esds?

547


What is amode(24)?

677


Explain how do you control cursor positioning?

555


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

2156


How you can characterize tables in cobol?

707


What is psb?

622


What is the use of dclgen in db2?

584