Where do IIMs conduct interviews?

IMS DB - INTERVIEW QUESTIONS



These interview questions are specifically designed to provide you with the types of questions that you will encounter during your interview for the IMS DB topic.

As per my experience, good interviewers hardly ever plan to ask you a specific question during your interview. In general, the questions start out with some basic concepts of the topic and later they will continue based on further discussion and what you have to answer.

Q: What is a hierarchy path?

A.: Hierarchy path is a line that starts at the root, passes through the intermediate levels in the hierarchy, and ends at a segment at the bottom of the hierarchy.

Q: What is a root segment?

A.: a segment that lies at the top of the hierarchy is called the root segment. It is the only segment through which all dependent segments are accessed.

Q: What are twin segments?

A.: Two or more segments of the occurrence of a particular segment type occurring under a single parent segment are called twin segments.

Q: Define segment occurrence?

A.: A segment occurrence is a single segment of certain type that contains user data.

Q: What is a database record?

A.: Each occurrence of the root segment plus all subordinate segment occurrence makeup for a database record.

Q: What is the limit on the number of levels in a DL / I database?

A.: We can have 15 levels in a DL / I database.

Q: How many segment types can you have in a DL / I database?

A.: A DL / I database can have 255 segment types.

Q: What are the control blocks in IMS?

A.: There are two control blocks: the database descriptor (DBD) and the program specification block (PSB).

Q: What are common DLI functions?

A.: The common functions are GU, GN, BSP, GHU, GHN, ERSETZT, ISRT and DLET.

Q: What are the command codes and what are their purposes?

A.: Command codes extend the functionality of an SSA call. They simplify programming and improve performance.

Q: What is the use of PROCOPT?

A.: Procopt parameter gives processing options that define the type of processing performed on a segment.

Q: What is multi-positioning?

A.: Multi-positioning is an option whereby the IMS maintains a separate position on each hierarchy path. If more than one PCB is on the same DBD, it is considered multipositioning.

Q: Define a search field.

A.: The field that is used to retrieve the data known as the search field.

Q: What is a GOBACK declaration?

A.: A GoBack instruction is used to pass control back to the IMS control program.

Q: Define a call explanation.

A.: A call statement is used to request for DL ​​/ I services such as the execution of certain operations in the IMS database.

Q: What is the function of a GU call?

A.: "GU" or Get Unique works similarly to the random read instruction in COBOL. It is used to fetch a specific segment occurrence based on the field values ​​that can be provided using segment search arguments.

Q: What is the function of a GHU call?

A.: 'GHU' or Get Hold Unique indicates that we are going to update a segment after getting it. GHU corresponds to the GU call.

Q: What is the function of the SSA?

A.: SSA is known as segment search arguments. SSA is an optional parameter. It is used to identify the segment occurrence that is being accessed. We can do any number of SSAs depending on the requirement.

Q: Explain index pointer segment.

A.: DL / I stores the pointer to parts of the indexed database in its own database. Index pointer segment is the only type of secondary index.

Q: What is the first statement in COBOL-IMS programs?

A.: Entry statement is the first statement after the procedure splitting.

Q: What is the return code you get after a successful IMS call?

A.: We get places after a successful call.

Q: What is the use of sparse sequencing?

A.: We can remove some of the index source segments from the index with sparse sequencing using secondary index database. Sparse sequencing is used to improve performance. If some occurrences of the index seed segment are not used, we can remove them. Sparse sequencing is also known as sparse indexing.

Q: Explain Logical Relationship.

A.: A logical relationship is a connection between two segments logically and physically not related. Usually a logical relationship is established between different databases. But it is possible to have a relationship between the segments of a given database. .

Q: What are logical twins?

A.: Logical twins are the occurrences of a logical child segment type that are subordinates to single occurrences of the logical parent segment. DL / I makes the logical child segment appear like an actual physical child segment. This is also logically known as the virtual child segment.

Q: What is a chained segment?

A.: A logical child segment always begins with the entire concatenated key of the target parent. This is known as the Target Parent Concatenated Key (DPCK). The DPCK always code at the beginning of your segment I / O area for a logical child. In a logical database, the chained segment makes the connection between segments that are defined in other physical databases.

Q: Explain that DL / I log.

A.: When an application program ends abnormally, it is necessary to revert the changes made by the application program, correct the errors, and then run it again. To do this it is necessary to have the DL / I log out again ..

Q: What is a checkpoint

A.: A checkpoint is a stage where the changes to the database made by an application program are viewed completely and accurately.

Prepare for the subject

Additionally, you can go through the examples that you have practiced on the subject and make sure that you are speaking confidently on them. If you're a fresher, then the interviewer doesn't expect you to answer very complex questions. Rather, expect you to know the basic concepts clearly.

Second, it really doesn't matter if you don't answer a few questions, but your confidence matters. So be sure and let your answers reflect confidence during the interview. We at Tutorialspoint wish you all the best.