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

Explain the use of the WHERE clause.

IBM,

2 5446

What is index cardinality?

3 11024

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

IBM, Tech Mahindra,

2 12119

What are the three types of page locks that can be held?

1 4614

What is the meaning of -805 SQL return code?

3 12810

What is a base table?

2 4867

what's the best lock size that you could use when you create a tablespace?

IBM,

2 5928

How would you print the output of an SQL statement from SPUFI?

2 8841

What is the STOSPACE Utility used for?

1 6532

Where besides the DB2 catalog is database object information stored by DB2?

1 4978

What is isolation level?

4 7282

What is a predicate?

1 4778

What is ALTER ?

3 6879

What do you need to do before you do EXPLAIN?

1 5248

How do you insert a record with a nullable column?

2 6280

Un-Answered Questions { MainFrame }

What is parallel sysplex?

816

Which isolation level provides maximum concurrency?

1152

What is the difference between Call and a Link?

1198

What is the need to code commits in batch programs?

1151

Explain the use of DCT ?

1078

when do you explicitly open files and close files in an rpg program?

2065

Hello, I have created a CMD type object. In one of the fields in Display file , I would like to see All the Source files present by pass the name of Library. Tried using CHoice(Keyword) and Choicepgm on PARM , but doesn't seems to be working. Any help please..

2288

Explain in detail about buffer manager and its functionalities?

1065

What is the maximum of key fields and search fields allowed in a segment?

999

Define gdg?

990

How to declare host variables?

992

Name the command used for terminating a browse operation?

1027

How do I import a csv file into db2?

991

Explain processing program table(ppt)?

1157

Explain the primary function of the processing program table (ppt)?

994

For More Un-Answered { MainFrame } Questions Click Here