Interview Questions.

Question 1. What Is A Hierarchy Path?

Answer :

Hierarchy course is a line that starts offevolved at the foundation, passes thru the intermediate tiers inside the hierarchy, and ends at a phase at the lowest of the hierarchy.

Question 2. What Is A Root Segment?

Answer :

A section that lies at the pinnacle of the hierarchy is referred to as the basis section. It is the simplest segment via which all structured segments are accessed.

IBM Cognos Interview Questions
Question 3. What Are Twin Segments?

Answer :

Two or more phase occurrences of a specific segment type below a single parent phase occurrence are known as dual segments.

Question four. Define Segment Occurrence?

Answer :

A phase incidence is an character section of a specific kind containing person facts.

IBM Cognos Tutorial
Question five. What Is A Database Record?

Answer :

Each prevalence of the basis phase plus all its subordinate phase occurrences make up for one database file.

IBM DB2 Interview Questions
Question 6. What Is The Limitation On The Number Of Levels In A Dl/i Database?

Answer :

We will have 15 levels in a DL/I database.

Question 7. How Many Segment Types Can You Have In A Dl/i Database?

Answer :

A DL/I database will have 255 section types.

IBM DB2 Tutorial Database Interview Questions
Question 8. What Are The Control Blocks In Ims?

Answer :

There are two manipulate blocks: the Database Descriptor (DBD) and Program Specification Block (PSB).

Question 9. What Are Common Dli Functions?

Answer :

The commonplace features are GU, GN, GNP, GHU, GHN, REPL, ISRT, and DLET.

System Administration Interview Questions
Question 10. What Are The Command Codes And Their Purposes?

Answer :

Command codes make bigger the feature of an SSA call. They simplify programming and improve overall performance.

System Analysis and Design Tutorial
Question 11. What Is The Use Of Procopt?

Answer :

Procopt parameter specifies PROCESSING OPTIONS that define the sort of processing finished on a phase.

System Analysis and Design Interview Questions
Question 12. What Is Multi-positioning?

Answer :

Multi-positioning is an option whereby the IMS maintains a separate role on every hierarchical course. When a couple of PCBs talk to the equal DBD, it's far referred to as multi-positioning.

IBM Cognos Interview Questions
Question thirteen. Define A Search Field?

Answer :

The field that is used to retrieve the data is called a seek area.

IBM Mainframe Tutorial
Question 14. What Is A Goback Statement?

Answer :

A Goback declaration is used to skip the manage lower back to the IMS control program.

Question 15. Define A Call Statement?

Answer :

A Call declaration is used to request for DL/I services which include acting certain operations at the IMS database.

IBM Mainframe Interview Questions
Question sixteen. What Is The Function Of A Gu Call?

Answer :

'GU' or Get Unique works similar to the random read announcement in COBOL. It is used to fetch a selected section prevalence primarily based on the sphere values which may be provided using Segment Search Arguments.

Question 17. What Is The Function Of A Ghu Call?

Answer :

'GHU' or Get Hold Unique specifies that we are going to update a phase after retrieval. GHU corresponds to the GU name.

IBM WAS Administration Interview Questions
Question 18. What Is The Function Of Ssa?

Answer :

SSA is referred to as Segment Search Arguments. SSA is an optionally available parameter. It is used to perceive the segment prevalence being accessed. We can encompass any variety of SSAs depending on the requirement.

IBM DB2 Interview Questions
Question 19. Explain Index Pointer Segment?

Answer :

DL/I shops the pointer to segments of the indexed database in a separate database. Index pointer segment is the only form of secondary index.

Question 20. Which Is The First Statement In Cobol-ims Programs?

Answer :

Entry announcement is the first declaration after the technique division.

IBM WebSphere Administration Interview Questions
Question 21. What Is The Return Code You Get After A Successful Ims Call?

Answer :

We acquire areas after a successful name.

Question 22. What Is The Use Of Sparse Sequencing?

Answer :

We can get rid of some of the index source segments from the index the use of sparse sequencing with secondary index database. Sparse sequencing is used to improve the performance. When some occurrences of the index supply section are not used, we are able to get rid of that. Sparse sequencing is likewise called Sparse Indexing.

Question 23. Explain Logical Relationship?

Answer :

A logical dating is a course among  segments associated logically and now not bodily. Usually a logical courting is set up among separate databases. But it's miles possible to have a relationship between the segments of 1 specific database.

IBM AIX 7 Administration Interview Questions
Question 24. What Are Logical Twins?

Answer :

Logical twins are the occurrences of a logical baby segment kind which are subordinates to a single prevalence of the logical determine section. DL/I makes the logical child phase seem like an real physical baby section. This is likewise known as digital logical infant section.

Database Interview Questions
Question 25. What Is A Concatenated Segment?

Answer :

A logical baby phase always starts offevolved with the entire concatenated key of the destination discern. This is called Destination Parent Concatenated Key (DPCK). Always code the DPCK at the begin of your section I/O place for a logical child. In a logical database, the concatenated phase makes the connection among segments which might be described in exclusive physical databases.

Question 26. Explain Dl/i Log?

Answer :

When an application application abnormally ends, it's miles important to revert the modifications completed by way of the application application, correct the mistakes, and re-execute it. To do that method, it's far required to have the DL/I log.

Database Administration Interview Questions
Question 27. What Is A Checkpoint?

Answer :

A checkpoint is a degree where the modifications achieved to a database by means of an application program are taken into consideration entire and correct.

System Administration Interview Questions
Question 28. Which Database Processing Is Very Fast?

Answer :

IMS DB processing may be very fast compared to DB2.

Question 29. Which Database Is Difficult To Manage?

Answer :

IMS predefined tree structure reduces flexibility and it's far tough to control.

IBM Cognos TM1 Interview Questions
Question 30. Through Which Segment All Dependent Segments Are Accessed?

Answer :

A phase that lies at the pinnacle of the hierarchy is called the foundation phase. It is the most effective segment through which all established segments are accessed.

Question 31. How Can We Access The Data In Ims Db?

Answer :

Data may be processed in both the methods: Sequential & Random.

Question 32. What Is The Predefined Pattern For Sequential Processing?

Answer :

Predefined sample for accessing information in DL/I is first down the hierarchy, then left to right.

IBM DataPower Interview Questions
Question 33. For Field Macro Statement In Dbdgen, What Does Type=p Parameter Specifies?

Answer :

TYPE=P specifies Packed decimal records type for the sphere which we've declared.

System Analysis and Design Interview Questions
Question 34. For Field Macro Statement In Dbdgen, What Does Type=x Parameter Specifies?

Answer :

TYPE=X specifies Hexadecimal facts kind for the sector which we have declared.

Question 35. What Does Senseg Stands For?

Answer :

SENSEG is known as Segment Level Sensitivity. It defines this system's get right of entry to to components of the database and it's miles recognized at the phase stage.

Question 36. Which Parameter Specifies The Language In Which The Application Program Is Written In Psbgen?

Answer :

The LANG parameter specifies the language in which the application software is written, e.G., COBOL.

IBM Mainframe Interview Questions
Question 37. Which Is Used To Pass The Control Back To The Ims Control Program?

Answer :

GOBACK is used to skip the manipulate back to the IMS manipulate application.

Question 38. Which Function Is Used To Get A Unique Record For Update Purpose?

Answer :

'GHU' code is used for Get Hold Unique. Hold function specifies that we're going to update the section after retrieval. The Get Hold Unique function corresponds to the Get Unique name.

Question 39. Which Function Is Used To Retrieve Segment Occurrences In Sequence Subordinate To An Established Parent Segment?

Answer :

'GNP' code is used for Get Next inside Parent. This function is used to retrieve phase occurrences in series subordinate to a longtime discern section.

Question 40. Which Function Is Used For Recovering The Database?

Answer :

'CHKP' code is used for the Checkpoint feature. It is used in the recovery features of IMS.

IBM WAS Administration Interview Questions
Question 41. In Pcb Which Field Is Used To Store The Level Of The Segment That Was Processed?

Answer :

Segment degree is called Segment Hierarchy Level Indicator. It incorporates individual facts and is  bytes lengthy. A segment stage field shops the level of the segment that turned into processed. When a segment is retrieved efficiently, the level variety of the retrieved segment is saved here.

Question forty two. In Pcb Which Field Stores The Area For Its Own Internal Linkage Related To An Application Program?

Answer :

Reserved DL/I is called the reserved location of the IMS. It shops four bytes binary facts. IMS makes use of this region for its personal inner linkage related to an application application.

IBM WebSphere Administration Interview Questions
Question forty three. Which Ssa Provides The Name Of The Segment Being Used Inside The Call?

Answer :

An unqualified SSA offers the name of the segment being used inside the name.

Question forty four. What Is The Length Of An Unqualified Ssa?

Answer :

A simple unqualified SSA is nine bytes long. The first 8 bytes preserve the phase call that is getting used for processing. The ultimate byte always consists of area.

Question forty five. Where Do We Code Command Code In A Qualified Ssa?

Answer :

Command code is coded on the tenth position.

Question forty six. If A Call Is Successful What Value You Will Get In Status-code Field?

Answer :

If a name is a hit you'll get spaces in STATUS-CODE area.

Question forty seven. Multiple Pcbs Can Not Be Defined For A Single Database. State Whether True Or False?

Answer :

This assertion is incorrect as Multiple PCBs can be described for a unmarried database.

Question forty eight. It Is Not Possible For A Program To Maintain Multiple Positions In A Database Using A Single Pcb. State Whether True Or False?

Answer :

This declaration is inaccurate as a application can preserve more than one positions in a database using a unmarried PCB.

Question forty nine. For Bidirectional Virtual Relationship The Logical Connection Goes From The Logical Child To The Logical Parent And It Cannot Go The Other Way Around. State Whether True Or False?

Answer :

This declaration is inaccurate as Bidirectional Virtual dating lets in get admission to in both the guidelines. The logical infant in its bodily shape and the corresponding virtual logical infant can be visible as paired segments.

Question 50. What Does Mpp Stands For?

Answer :

MPP stands for Message Processing Program.