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 5126

What does the sqlcode of -818 pertain to?

3 7740

How many clustering indexes can be defined for a table?

2 7245

What is tablespace?

3 6808

What is the function of the Data Manager?

2 5333

What is a SELECT statement?

1 4496

How do you define a correlated name?

1 4082

What is the self-referencing constraint?

2 6481

What is a buffer pool?

2 6602

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

1 5675

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

5 9496

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

1 13692

What is meant by isolation level?

3 6946

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 7011

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 5286

Un-Answered Questions { MainFrame }

what is a logical file?

1935

What is the pic clause for the data type of length option field type of data fields?

994

What is the cobol picture clause of the db2 data types date, time, timestamp?

1138

what are dds required for subfile?

1106

What is the default access path of a file?

1182

What is the maximum length of a single line of jcl?

1412

Explain difference between escape(top or bottom) and escape immediate(top or bottom?

1275

how does the rpg element work?

1307

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9404

Can you define temporary storage?

1198

Define free space?

1117

Can you explain dfheiblk?

1156

How does the jcl specify the job to os?

1225

what is the use of the file status clause in the select statement in vsam?

1168

how to pass the parameters from jcl to assembler pgm?

1167

For More Un-Answered { MainFrame } Questions Click Here