MainFrame Interview Questions
Questions Answers Views Company eMail

What is a result table?

1 4415

What is the SQL Communications Area and what are some of its key fields?

1 4020

Usually, which is more important for DB2 system performance - CPU processing or I/O access?

1 3588

How would one remove old reorg information from the DB2 catalog?

2 5309

The only place of VSAM KSDS in DB2 is?

IBM,

2 6492

What is DCLGEN?

2 14410

Where is the output of EXPLAIN stored?

2 5685

What is the function of buffer manager?

1 4905

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

2 5466

What is a lock?

1 4234

What should be specified along with a cursor in order to continue updating process after commit?

IBM,

1 4293

How does DB2 use multiple table indexes?

1 4990

What is meant by repeatable read?

4 8799

Compare a subselect to a join?

1 4112

Describe the elements of the SELECT query syntax?

3 5173


Un-Answered Questions { MainFrame }

How can we find that module can be called – whether DYNAMICALLY or STATICALLY?

695


I have a pf, it contains 5 members, how to access particular member data from logical file?

522


what is a composite key?

990


Code the related portions of cics/cobol-i programs to gain addressability to twa area assigned to a particular task. Assme that the size of twa area is 300bytes. What are the advantages if cobol-ii is used in the place of cobol?

668


what is s000 u4087 error? please give the all error codes in cobol,jcl.

17009






Have you caused any huge mistakes for the bank?

499


What is the function of the dd mgmtclas keyword in sms datasets?

726


I have 60 steps in the JCL and want to Execute Only First from PROC by overriding in JCL ?

1336


What is meant by drda?

518


what does dfu program you to do on a record?

721


I have a File that has duplicate records. I need only those records that occur more than thrice.?

8587


What is copy pending status in db2?

624


How do I optimize a query in db2?

601


how to develop some simple graphs (bar charts) using just html?

658


what is “Cond= even” and “Cond=only”?

728