MainFrame Interview Questions and Answers
Here you can find MainFrame Interview Questions and Answers.
Why MainFrame Interview Questions and Answers Required?
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.
Where can I get MainFrame Interview Questions and Answers?
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.
How to solve these MainFrame Interview Questions and Answers?
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.
MainFrame Interview Questions and Answers
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.
MainFrame Interview Questions and Answers
Explain the use of the WHERE?
The “WHERE” clause isolates an element or row whenever it is used with a relational statement.
MainFrame Interview Questions and Answers
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.
MainFrame Interview Questions and Answers
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.
MainFrame Interview Questions and Answers
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.
MainFrame Interview Questions and Answers
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.
MainFrame Interview Questions and Answers
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.
MainFrame Interview Questions and Answers
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.
MainFrame Interview Questions and Answers
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.
MainFrame Interview Questions and Answers
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.
