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 the syntax for creating a table in the db2 database?

1108

What are the benefits of using the db2 database?

1229

What is buffer pool in the db2 database?

1107

What is the meaning concurrency in the db2 database?

1110

What are the two types of logging in the db2 database? Explain them.

1074

List down the data types in the db2 database.

1124

List down the types of triggers in the db2 database?

1029

How can the duplicate values be eliminated from db2 select?

1106

What is the function of logging in the db2 database?

1123

What is the role of the data page in the db2 database?

1028

Explain the difference between null compression and default compression?

945

Why adabas is used?

932

Explain associator in adabas?

867

What is find and read operation in adabas file?

894

What is adabas and why it is used?

953

Un-Answered Questions { MainFrame }

What is the term conversational programs means?

1016

What is an in line perform? When would you use it? Anything else you wish to say about it.

1076

Before you give the explain statement, what are the prerogatives?

1040

How to compare data between two tables in db2?

1088

How do you concatenate the firstname and lastname from emp table to give a complete name?

1077

Name all the file-open modes

1080

What is the difference between pct and fct?

1221

i want to learn mainframe..any websites and material to learn from basic..? my mail id : rajeswaribe2010@gmail.com

2221

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2045

How does jcl act on code(if you take a cobol program)?

1287

Define psb?

1092

How long have you been working on mainframes?

971

What is the need of a secondary index in IMS?

1066

What is db2 optimizer?

1237

What is meant by a ‘Transid’ ?

1051

For More Un-Answered { MainFrame } Questions Click Here