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

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 5045

What does the sqlcode of -818 pertain to?

3 7611

How many clustering indexes can be defined for a table?

2 7119

What is tablespace?

3 6685

What is the function of the Data Manager?

2 5229

What is a SELECT statement?

1 4423

How do you define a correlated name?

1 4007

What is the self-referencing constraint?

2 6378

What is a buffer pool?

2 6495

What is the cascade rule and how does it relate to deletions made with a subselect?

1 5585

When is the results table for the query in a DECLARE CURSOR statement created?

5 9294

What does it mean if the null indicator has -1, 0, -2?

1 13620

What is meant by isolation level?

3 6826

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 6887

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 5177

Un-Answered Questions { MainFrame }

What is the term “where” for?

1021

how to define a directory and what is the structure and definition for the same?

1080

How are the next sentence and continue different from each other?

1312

what is sflpag and sflsiz ?

3469

How to find schema of a table in db2?

1029

What do we mean by 'Virtual storage' for a dataset and for a JOBSTEP ? What is the significance of the following statement for a programmer 'Virtual storage results in program addresses being independent of the addresses that actually exist in a computer' ?

2041

what is the difference between seton lr and retrn?

2062

what is the purpose of putovr (put with explicit override) keyword?

1666

how can I control from my cgis the cache of a remote browser?

1182

how can you detect and handle a record lock situation?

2004

What is the difference between Structured COBOL Programming and Object Oriented COBOL programming?

1142

Differentiate between addressing mode and run mode.

1091

What is the purpose of the chain and setll and setgt?

1053

What is the syntax of redefine?

964

Is length = 0 sufficient to ascertain that the field has been modified?

1093

For More Un-Answered { MainFrame } Questions Click Here