IBM MainFrame Interview Questions
Questions Answers Views Company eMail

How are write I/Os from the buffer pool executed?

1 3362

What is the syntax of SELECT statement when embedded in a COBOL program?

2 8836

What is ACQUIRE/RELEASE in BIND?

Cognizant,

3 24276

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 3341

What are foreign keys?

1 4074

What is JOIN and different types of JOIN.

IBM,

2 11396

What does DSNDB07 database do?

2 11144

What is a DB2 access path?

1 6348

What is a recovery log?

1 4027

What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

3 18893

How does DB2 store NULL physically?

2 9921

Explain the use of the WHERE clause?

1 3191

How can you quickly find out the number of rows updated after an update statement?

CSI, CTS,

1 8526

How could one combine a set of incremental image copies into a single copy?

1 3479

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 7122


Un-Answered Questions { IBM MainFrame }

What is the use of trt instruction?

564


what is JCL?

668


What is db2 purescale?

522


Why do we code s9 (4) comp. Inspite of knowing comp-3 will occupy less space?

680


Which component is responsible for processing sql statements and selecting access paths?

624






Define an aey9 abend?

645


Add a field to screen when what's the flow of impact?

2386


Explain the difference between pseudo-conversational and conversational?

537


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

2786


In real storage usage. By monitor through rmf iii the usage of real storage keep in increasing everyday. Why this happen?

516


What are the different parameters that are used in vsam?

700


what is the differences between getting the system time with eibtime and asktime command?

561


What db2 400?

655


What is dpf in db2?

633


What is an OOK-Rec?

1204