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 8240

Which catalog table stores referential constraints?

1 5964

Give the COBOL definition of a VARCHAR field.

2 16885

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

2 11160

How to see the structure of db2 table??

IBM,

4 33064

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

IBM, TCS,

8 20677

What is normalization and what are the five normal forms?

1 5142

What are simple, segmented and partitioned table spaces ?

TCS,

1 13737

What is dynamic SQL?

ADP,

1 6874

What does CURRENTDATA option in bind indicate

IBM,

1 8901

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

1 5742

What is the difference between group by and order by?

IBM, TCS,

2 14629

How many buffer pools are there in DB2?

2 7419

What are the three lock types?

2 6548

When is the access path determined for dynamic SQL?

2 9125

Un-Answered Questions { MainFrame }

How can return codes be tested before execution of a job step?

1482

Can you define temporary storage?

1134

Explain the types of perform?

1018

what is “Cond= even” and “Cond=only”?

1313

how do you create an alternate index ?

1070

What is a plan and package in db2?

1102

State all the file open modes?

1074

Is therE anybody who knows about TICKLER FILE of RM.??thank you

2120

define clustering index.

1026

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1437

Which is faster delete or truncate?

1127

What is the place for VSAM KSDS?

1103

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2365

How can you quickly find out the # of rows updated after an update statement?

1046

What is the term bms in cics?

1219

For More Un-Answered { MainFrame } Questions Click Here