All India Exams
  • Sign In / Register Sign In
Home AptitudeBankEngineeringEnglishGKInterviewOnline TestPlacement PapersReasoning
  • Home
  • Aptitude
  • Bank
  • Engineering
  • English
  • GK
  • Interview
  • Online Test
  • Placement Papers
  • Reasoning

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.

Home InterviewTechnical Interview Questions and AnswersSoftware ToolsIBM ToolsMainFrame

IBM MainFrame Interview Questions and Answers


  • What is DRDA ?
  • Explain the use of the WHERE?
  • How can a LIKE table be created?
  • What is the need of running runstats in the test environment?
  • What is the need of a secondary index in IMS?
  • Explain foreign keys?
  • Write about the self-referencing constraint?
  • What does a deadlock mean in DB2?
  • What is the function of DBCTL?
  • How are TYPE 1 and TYPE 2 indexes different?
  • «
  • 1
  • 2
  • 3
  • 4
  • 5
  • »

Mock Tests & Online Quizzes

  • Aptitude Online Test

  • Reasoning Online Test

  • GK Online Test

  • English Online Test

  • RRB Mock Test

  • RBI Mock Test

  • Free SBI Mock Test

  • IBPS Mock Test FREE

  • SSC Mock Test

  • CAT Exam Mock Test

  • GATE Mock Test

  • LIC Mock Test Series

  • MAT Mock Test

  • SEBI Mock Test

  • ESIC Mock Test

  • IT Courses Quiz

Newsletter

Contact Us

Questions and Answers

  • Aptitude Questions
  • Verbal Reasoning Questions
  • Non Verbal Reasoning Questions
  • Logical Reasoning Questions
  • Data Sufficiency Questions
  • Data Interpretation Questions
  • C Programming
  • C++ Programming
  • PHP Programming
  • Java Programming
  • eLitmus Sample Papers
  • ECE Questions and Answers
  • EEE Questions and Answers
  • Verbal Ability Questions
  • GK Questions
  • AMCAT Mock Online Test
  • LIC Mock Test
  • IBPS Mock Test

Interview Questions

  • Java Interview Questions
  • .Net Interview Questions
  • Networking Interview Questions
  • C Language Interview Questions
  • C++ Interview Questions
  • Testing Interview Questions
  • Android Interview Questions
  • HR Interview Questions
  • Group Discussion Topics
  • iOS Interview Questions
  • Web Technologies
  • Database Interview Questions
  • MS Office Interview Questions
  • Software Tools
  • Data Interpretation
  • PHP Interview Questions
  • CAT Mock Test
  • SSC Mock Test
© by AllIndiaExams.in. All Rights Reserved | Copyright | Terms of Use & Privacy Policy