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 catalog?

2 7288

Why might full image copies be faster to implement than an incremental image copy?

4 7079

What is the purpose of the WHENEVER statement?

1 5190

Is there any advantage to denormalizing DB2 tables?

1 6756

What are some SQL aggregates and other built-in functions?

2 5510

What is sqlcode -922 ?

2 26590

What is lock escalation?

2 14534

What is the difference between primary key & unique index ?

Patni, Temenos,

6 27327

What is a DB2 bind?

3 7232

How does DB2 determine what lock-size to use?

2 8986

What are some characteristics of columns that benefit from indexes?

1 4693

How will you delete duplicate records from a table?

Google,

7 25387

When is the skeleton cursor table created?

1 5189

What is cursor stability?

1 5582

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

IBM,

2 8611

Un-Answered Questions { MainFrame }

can any body give me any website for getting help on mainframe projectts in banking domain.

2157

PLEASE SEND ME THE DOCUMENTS IF ANY ONE HAVE REGARDING THE IMPACT ANALYSYS,REVIEWS

2464

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1797

any one have give AS400 study material? pls pass it to gopalsai789@gmail.com

1781

What is the latest version of ibm db2?

1352

List the type of locks and explain each of them.

984

Are you comfortable in cobol or jcl?

1098

Is it rquired any server for Ibm framework? Give me list of Ibm framework & recent version IBm framework?

2309

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

2103

i need a small 3d program using inline and outline.

2279

pls send the docs of any telecommunication mainframe project

2208

If I want to execute Sftp commands(LS & GET) stored in Physical file from CL program automatically...Can u Plz tell me how can I do this?...How the script will look?? THANX FOR NY HELP...

2836

how can you specify no duplicate key?

1220

How to convert a spool file to PDF file in AS400?

1301

what u mean by csrloc and rtncsrloc in rpgIV in as/400.Give an eg? to do...give some coding...what is row no and column no ???..if possible...give a no of lines coding....please

4533

For More Un-Answered { MainFrame } Questions Click Here