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

IBM MainFrame (5234)
IBM AS400 (1355)
IBM PL/1 (31)

MainFrame Interview Questions

Questions Answers Views Company eMail

What is meant by concurrency?

1 6294

What is subquery ?

6 12934

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 5964

How does the processing of a correlated subquery differ from a non correlated subquery?

1 7566

Can you define an Index if the table size less than 10 PAGES?

IBM,

1 6401

What are the various locks available?

CTS,

5 12550

What will the DB2 optimizer do?

2 6462

What are the contents of a DCLGEN?

MetLife,

4 13508

What is deadlock?

2 7324

What is Declaration Generator(DCLGEN)?

1 7304

What is the difference between static and dynamic SQL?

1 25902

How many Buffer pools are there in DB2 and what are they?

IBM,

1 7775

What is RUNSTATS?

3 7943

How many sub queries can you combine together ?

IBM,

4 10634

What is a cursor and what is its function?

2 5802

Un-Answered Questions { MainFrame }

Where is the vsam ksds placed?

1047

What is a db2 schema?

1304

Is it possible to left uncode disp?

1265

In sms datasets, what is the function of the dd mgmtclas keyword?

1438

How to read a pf in reverse(from last record to first) using cl?

1219

what is cab?

1230

how many buffers are allocated to vsam ksds and esds?

1218

What is the difference between iter and do? We know both are used to execute set of statements repeatedly, but what is the main difference?

1068

how will you find a particular line in debugging if its a infinite loop

1828

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2795

Why block size is multiple of lrecl in jcl?

1480

Mention the content that is present inside a PPT ?

1047

what is sflrolval?

1148

What is plan in cobol db2?

1220

Can min or max be used with alphanumeric data?

1038

For More Un-Answered { MainFrame } Questions Click Here