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 keyword does an SQL SELECT statement use for a string search?

2 8258

Which catalog table stores referential constraints?

1 5986

Give the COBOL definition of a VARCHAR field.

2 16912

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 11196

How to see the structure of db2 table??

IBM,

4 33097

what is the maximum number of tables that can be joined ?

IBM, TCS,

8 20734

What is normalization and what are the five normal forms?

1 5162

What are simple, segmented and partitioned table spaces ?

TCS,

1 13757

What is dynamic SQL?

ADP,

1 6895

What does CURRENTDATA option in bind indicate

IBM,

1 8925

What is the format (internal layout) of ?TIMESTAMP??

1 5754

What is the difference between group by and order by?

IBM, TCS,

2 14649

How many buffer pools are there in DB2?

2 7444

What are the three lock types?

2 6583

When is the access path determined for dynamic SQL?

2 9156

Un-Answered Questions { MainFrame }

What is db2 stogroup?

1178

What is the purpose of record level identifier?

1137

all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?

2889

what is use of dcb parameter in dd statement?

1318

Tandem COBOL Interview questions (on TACL,SCOBOL,ENSCRIBE,PATHWAY0

23655

List out all the tables that are a part of cics ?

974

what is use of dsn parameter in dd statement?

1174

What is the function of job statement in jcl?

1107

What is iseries database?

1062

how do we prepare test data using file-aid tool?

2562

Why are you looking for a change?

987

When output dataset space is required, what quantity categories are used?

1376

what would I use uni-rexx for?

979

have in 100 records in a file i want to read first 3 records and skip next 3 records and agan i want to read 3 records and again i want to skip 3 records... run a loop from record one to 10 evaluate i/3 if comes even then skip else write to output file

1525

what are the reserved words for cics?

1119

For More Un-Answered { MainFrame } Questions Click Here