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 a DB2 plan?

8 45366

How to define the data items to receive the fetch items for the SQL?

2 5928

What is a page?

2 5098

What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?

CTS,

1 10175

What is a collection?

3 6910

What does the CHECK Utility do ?

1 5641

Where could you look if you had a question about whether a column has been defined as an index?

2 5948

What are the various locking levels available?

3 6766

If I have a view which is a join of two or more tables, can this view be updatable?

3 7432

What are the 4 environments which can access DB2 ?

2 7062

What is the picture clause of the null indicator variable?

6 19226

What will the FREE command do to a plan?

2 5834

What is a DB2 bind?

Logica CMG,

1 7296

What information can you find in SYSIBM.SYSLINKS table?

TCS,

1 9284

What is the difference between IN subselects and EXISTS subselect?

HCL, PreVator, TCS,

1 11079

Un-Answered Questions { MainFrame }

Explain dbdgen process?

1089

what is the use of sflend keyword?

1849

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1100

Explain the maps in cics?

1170

What is the difference between oracle and db2?

1098

Explain cemt transaction commands?

1154

What is the use of qsam?

816

Kindly specify the pic clause for the data type of length option field type of data fields?

1144

What is jcl in mainframe, and how many types of jcl statements are there for a job?

1189

Differentiate between control interval (ci) and control area (ca)?

1005

explain sflclr, sflend, sfldlt, and sflcsrrrn?

1349

How do you find whether any generations exist under a gdg base?

1040

Explain cedf transaction commands?

1140

how to pick up the changed records every time in a subfile after the first change made ?

1809

What is check constraint in db2?

1078

For More Un-Answered { MainFrame } Questions Click Here