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 a DB2 catalog?

2 7148

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

4 6912

What is the purpose of the WHENEVER statement?

1 5061

Is there any advantage to denormalizing DB2 tables?

1 6646

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

2 5383

What is sqlcode -922 ?

2 26401

What is lock escalation?

2 14370

What is the difference between primary key & unique index ?

Patni, Temenos,

6 27019

What is a DB2 bind?

3 7064

How does DB2 determine what lock-size to use?

2 8830

What are some characteristics of columns that benefit from indexes?

1 4598

How will you delete duplicate records from a table?

Google,

7 25052

When is the skeleton cursor table created?

1 5073

What is cursor stability?

1 5482

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

IBM,

2 8442

Un-Answered Questions { MainFrame }

Can you define mdt?

1083

what happens in execution stage in job processing?

1138

What is ims (db/dc)?

1044

what is the maximum number of fields under a record format of physical file?

1843

What is iseries database?

1046

How to index LF by relative record no (RRN)

3288

What are all the divisions of a COBOL program?

1212

Mention the downsides of page level lock.

1159

What does the sample library of uni-rexx consist of?

1059

name the utility program closely associated with vsam?

1030

How do you code cobol to access a parameter that has been defined in jcl? And do you code the parm parameter on the exec line in jcl?

1195

Can min or max be used with alphanumeric data?

976

State all the file open modes?

1062

Are view updateable?

1040

Is it possible to obtain a record from IDMS database without mentioning the record-name itself?

1329

For More Un-Answered { MainFrame } Questions Click Here