Here you can find MainFrame Interview Questions and Answers.
In this MainFrame Interview Questions and Answers section you can learn and practice MainFrame Interview Questions and Answers to improve your skills in order to face technical inerview by IT companies. By Practicing these interview questions, you can easily crack any MainFrame interview.
AllIndiaExams provides you lots MainFrame Interview Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download MainFrame Interview Questions and Answers as PDF files and eBooks.
You no need to worry, we have given lots of MainFrame Interview Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the MainFrame technical interview.
What is DRDA ?
DRDA stands for Distributed Relational Database Architecture. DRDA is a connection protocol for relational database processing which IBM and vendor databases use. It consists of rules for communication between a remote relational DBMS and the application.
Explain the use of the WHERE?
The “WHERE” clause isolates an element or row whenever it is used with a relational statement.
How can a LIKE table be created?
It can be made by the use of the LIKE parameter in the statement CREATE. These tables are generally required for testing the production environment.
What is the need of running runstats in the test environment?
It is for clearing the default values from the catalog columns. Because if the columns have default values; then the result might not be an expected one.
What is the need of a secondary index in IMS?
It is a substitute path into any IMS database. It can be used as a file to acquire required data.
Explain foreign keys?
Foreign keys are properties of a particular table having matching entries to a primary key in some another table. This results in the formation of a relation between the two tables.
Write about the self-referencing constraint?
It limits the changes that can be made to the primary key from a foreign key. For this purpose, the foreign key has to define a DELETE CASCADE rule.
What does a deadlock mean in DB2?
When two independent processes contend for the same resource or the resources reserved by one another, it is called a deadlock. -911 and -913 are the SQLcode for a deadlock.
What is the function of DBCTL?
It is used to access IMS files for CICS Transactions and it is an address space. PSBs, DBDs, IMS files and ACBs are fixed into DBCTL for file access. Now if an IMS call is generated by a CICS program the processing gets transferred to DBCTL to be carried, and the result is sent as reply.
How are TYPE 1 and TYPE 2 indexes different?
TYPE 2 index is available for DB2V4. In this type, the data pages get locked, but the index pages are not locked. Therefore, TYPE 2 index are faster.