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 6189

What is subquery ?

6 12689

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

1 5883

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

1 7474

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

IBM,

1 6326

What are the various locks available?

CTS,

5 12361

What will the DB2 optimizer do?

2 6348

What are the contents of a DCLGEN?

MetLife,

4 13323

What is deadlock?

2 7161

What is Declaration Generator(DCLGEN)?

1 7213

What is the difference between static and dynamic SQL?

1 25825

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

IBM,

1 7702

What is RUNSTATS?

3 7826

How many sub queries can you combine together ?

IBM,

4 10433

What is a cursor and what is its function?

2 5682

Un-Answered Questions { MainFrame }

State the differences between vsam and non-vsam files?

1063

Write a logic program for knowing the repeated number of a vowels in a given program?

3753

How do I create a view in db2?

1031

How to create backup table in db2?

1098

Using %check we are checking monika in mona what is output? What is %SCAN?

1687

What is the advantage of defragmentation?

975

How do I optimize a query in db2?

1107

how to get the last record in vsam file in cluster? And how can u get the ksds file records into ur cobol program?

983

what are various techniques to pass parameters from one program to another?

1873

How jcl is used for testing batch programs?

1294

How does coalesce work?

1035

how do you specify page overflow indicator for printer files in rpg?

2293

How to update data area in cobol 400 program?

1057

how can I automatically refresh a web page?

1070

what is maximum number of arrays allowed in rpg?

1924

For More Un-Answered { MainFrame } Questions Click Here