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 command used by TSO users to invoke DB2?

IBM,

2 9436

What is the FREE command?

1 5196

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2870

What is DB2 (IBM Database 2)?

3 5688

What is QUIESCE?

2 13220

what is the name of the default db2 catalog database?

IBM,

3 8572

What are the three DB2 date and time data types and their associated functions?

1 5414

What is the significance of DB2 free space and what parameters control it?

1 5498

Explain the EXPLAIN statement?

1 4997

What is a DBRM, PLAN ?

3 18636

What's the maximum number of characters that a tablename can have?

3 8909

What technique is used to retrieve data from more than one table in a single SQL statement?

CTS, IBM, TCS,

9 15813

can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 4942

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2072

Why use RUNSTAT Utility?

Merrill Lynch,

3 23961

Un-Answered Questions { MainFrame }

What is the interactive job?

1033

What is data structure in as400? What is the use of data structure?

1092

when does a dataset go uncataloged?

1330

what does vldcmdkey means?

1379

what keyword must be used with protect keyword ?

1783

What are various search techniques in cobol? Explain.

1081

We have an output dataset in job with disp parameter as shr.

956

Can I redefine an x(200) field with a field of x(100) ?

1230

Define perform?

1015

at what level s,o are defined and what they will do?

1820

define the rcvf command?

1744

What is the cics command level?

1067

Define redefine and its syntax?

990

List the type of locks?

946

Discuss about changing dataset name in proc.

1246

For More Un-Answered { MainFrame } Questions Click Here