IDMS Interview Preparation Guide Download PDF
IDMS Interview Questions and Answers will guide us now that IDMS (Integrated Database Management System) is a (network) CODASYL database management system first developed at B.F. Goodrich and later marketed by Cullinane Database Systems, So start preparation for the job of IDMS by the help of this IDMS Interview Questions with Answers guide
34 IDMS Questions and Answers:
1 :: Why would you use find and get rather than an obtain?
Find tells you whether the record is actually in the database. If it is not found you save the overhead of an obtain.
2 :: If the stored record is not defined as automatic of a set, how can it be stored as a member of the set?
Store the record then connect it to each set where it is a manual member.
3 :: Distinguish among erase, erase permanent, erase selective and erase all?
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.
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.
4 :: So manual and automatic are the connect options for a set. What are the disconnect options?
Mandatory and optional.
5 :: What is currency in IDMS?
Currency is the location within the database during run-unit execution.
There are four levels of currency:
current of run-unit is the record occurrence of the last successful find or obtain;
current of record type is for the most recent of each record type;
current of record set is the most recent within each set and current of area is within each area.
There are four levels of currency:
current of run-unit is the record occurrence of the last successful find or obtain;
current of record type is for the most recent of each record type;
current of record set is the most recent within each set and current of area is within each area.
6 :: What sets will the stored record connect to?
It will connect to all sets where it is defined as an automatic member. The store requires that currency be established for all these set occurrences.
7 :: How does IDMS insure data integrity?
IDMS uses record locks to prevent another run-unit from updating the same record.
8 :: What is an area sweep and when is it used in IDMS?
An area sweep accesses records on the basis of the physical location in a database area. It can be total, meaning a record by record search of the area, or it can be of occurrences of records of a specific type.
9 :: When you are obtaining next within a set and get a end of set return code, on what record are you now current in IDMS?
You are current on the owner.
10 :: What is a bind in IDMS?
A bind associates record types with the program work area; for run unit and records it is the first command issued in the program.