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 9412

What is the FREE command?

1 5179

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

2852

What is DB2 (IBM Database 2)?

3 5665

What is QUIESCE?

2 13199

what is the name of the default db2 catalog database?

IBM,

3 8543

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

1 5393

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

1 5473

Explain the EXPLAIN statement?

1 4980

What is a DBRM, PLAN ?

3 18602

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

3 8886

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

CTS, IBM, TCS,

9 15752

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 4932

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?

2062

Why use RUNSTAT Utility?

Merrill Lynch,

3 23927

Un-Answered Questions { MainFrame }

Define cobol?

1403

what is *place and *auto keyword in prtf ?plz explain

3161

Suppose I have a pf,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in pf?

1054

how can we apply for HSBC exam(Mainframe) in India??? i went to their site and was told to submit my CV ,. etc..( totally confusing...)

2394

how to initialize a register to 0000?

1152

What is program status data structure(psds) in as400?

1085

explain how many ways you can load data in a vsam cluster?

1044

What is an area sweep and when is it used?

1545

what do you mean by define model parameter?

1150

What does EIB mean in CICS?

1173

what is utility for parm lib

2375

I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.

2743

What is the function of //cntl statement?

1336

What are foreign keys in db2?

1103

how to toggle between single line and multi - line display of a particular record in a subfile?

1794

For More Un-Answered { MainFrame } Questions Click Here