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 alias in db2?

986

What is clone table?

1000

What is scrollable cursor in db2?

1005

What are types of indexes?

1002

What is bind and rebind in db2?

1077

What is cascading rollback?

1135

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1231

What is catalog database in db2?

1105

What is database reorganization?

1056

What is copy pending and check pending in db2?

955

Why cursor is used in db2?

986

What is an instance in db2?

989

What is the use of with ur in db2?

1005

Can we delete records from view?

921

How do I delete a table in database?

978

Un-Answered Questions { MainFrame }

Name and explain the location modes?

831

How to retrieve a physical file after deleting that?

1040

What is the connection string to connect to the DB2 Database ?

1062

State the maximum number of tables that can be joined?

941

Can you explain dfhmdf bms macro?

1011

How do you pull up a query which was previously saved in qmf?

1103

Define concatenating?

1056

what is swap-in and swap-out?

1047

Explain this error: "all record formats for externally-described file abcd ignored or dropped due to error; file ignored."?

1285

What is the difference between binary search and sequential search?

1048

Is automatic restart possible in jcl? If yes, how?

1065

we can define the ksds cluster by two ways by using the file-aid or by using the idcams utility. Explain them.

1256

What is a collection in db2?

988

How do I delete a column in db2?

1052

Explain mdt?

1072

For More Un-Answered { MainFrame } Questions Click Here