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

2 5047

Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 5123

When do you specify the isolation level? How?

1 5232

What do the initials DDL and DML stand for and what is their meaning?

2 5469

What is the error code -803 ?

3 11822

What can the SET option of the Repair Utility accomplish?

1 5584

What are the levels of isolation available with DB2V4

IBM,

2 4621

Where are plans stored?

2 7145

What is a clustering index?

2 5566

What is a Resource Control Table(RCT)? Describe its characteristics.

3 13562

How is the SUBSTR keyword used in sql?

1 9350

What is an inner join, and an outer join ?

CTA,

1 12944

Where is the access path logic created by the DB2 Optimizer stored?

1 8373

What is a root page?

1 4356

What happens to the PLAN if index used by it is dropped?

1 5772

Un-Answered Questions { MainFrame }

define the purpose of the leave operation?

1614

Name a few IBM utility programs, and explain its function.

4981

Can we see the copy book length using file-aid?

912

Explain how many exceptional condition can be given in a handle condition?

1021

what is message file?

1067

How do I import a csv file into db2?

995

What is check constraint in db2?

1095

What do the compilers provide?

1442

How can the attributes of one sms dataset be copied to another dataset?

1427

What are some jcl statements that are not allowed in procedures?

1237

what u mean by csrloc and rtncsrloc in rpgIV in as/400.Give an eg? to do...give some coding...what is row no and column no ???..if possible...give a no of lines coding....please

4453

What is dynamic transaction backout?

1143

Is it slower if you access a record through alt index as compared to primary index?

1024

is there any way to execute more than one proc in the same exec statement at the same time..?

2641

Write a program to enter and display the names of students in a class using the occurs clause.

1215

For More Un-Answered { MainFrame } Questions Click Here