Below, frequently asked Top IDMS interview questions and answers for freshers and experienced. All the best for your interview Preparation.
The following are the storage attributes of records: Storage attributes of records Length: Records can either be stored as fixed length or variable length Fixed length: The whole record instance is persisted in a contiguous block of memory on the line Variable length: The root part of the record is persisted on the current line. The remaining part of the record is persisted on some other part of the memory. Erase cancels the membership of a record in specific set occurrences and removes only the named record. Erase permanent removes the specific record and all mandatory occurrences it owns. It disconnects all optional members. Erase selective removes the record, all mandatory members and all optional members not connected to other sets. It disconnects those that are connected. Erase all removes the specified record and all the mandatory and optional records it owns. Autostatus is a protocol mode which causes the expansion of each DML statement to include a ‘perform IDMS-Status’ statement. Fixed length records access is faster Variable length records maintain better utilization of space Currency is the location within the database during run-unit execution. There are four levels of currency: Record Currency – Most recent record occurrence of each record type is identified by db-key. IDMS/R maintains unique record currency for each record. Set Currency – This is the most recent record occurrence of every set that is accessed by the program. Separate currency key for each set is maintained by IDMS/R. Area Currency – Area currency is the most recent record occurrence of every area that is accessed by the program. Separate currency for each area is maintained by IDMS/R. Run Unit Currency – RUC is the database key of the most recent record occurrence that is accessed by the program. The READY prepares a database area for access by DML functions. COMMIT: FINISH: A bind associates record types with the program work area; for run unit and records it is the first command issued in the program. FIND: OBTAIN: A junction record is a member record type that allows for many-to-many relationship between its two owner records. An OOK-Rec is a one of a kind record set, used to get to another record set. Database is a collection of organized information. Database models are of four types: Flat files: The whole data is persisted in a series of files without controls and redundancy. Hierarchical Database: The database architecture resembles a tree structure. Network Database: The network database architecture resembles that of hierarchical database with some variations. The main difference is that a relationship between two nodes at the same level, say F and G (siblings) can be established; Relational Database: In relational database, the data is represented in the form of tables. Local mode: Central Version: calc: via: direct: There are four methods are available for persisting records in an IDMS database. Direct: Sequential: Calc: Via: What are storage attributes of records?
Distinguish among erase, erase permanent, erase selective and erase all?
What is Auto status in IDMS?
What is the Difference between Fixed length and Variable length records?
What is currency in IDMS?
What is the purpose of a READY?
What are the uses of COMMIT and FINISH?
What is a bind in IDMS?
Explain about FIND and OBTAIN commands.
What is a junction record in IDMS?
What is an OOK-Rec in IDMS?
What is a database?
What is the difference between local and central version operating modes?
Name and explain the location modes?
Explain about logical data model of IDMS
What methods are available for persisting records in an IDMS database?