-
What is a region?
Region is used synonymously with area. It is a group of logically contiguous pages.
-
Name and explain the three location modes?
Calc is based on a symbolic value which is used to determine the target page. Via mode is for members only. Via records are stored near to their owners. In direct mode the target is specified by the user and is stored as close as possible to that page.
-
What is the IDD?
IDD is the Integrated Data Dictionary. It contains information about the elements, record types, sets, maps and dialogues within the database.
-
What is a set? What pointers are required, what are possible? How may sets be ordered?
A set is an owner record and, optionally, its member records. There are three types of pointers: next, prior and owner, but only next is required. There are five possible orders for arrangements of sets; they are: first - insert at beginning, last - insert at end of set, next - insert after current of set, prior - insert prior to current of set and sorted - insert according to sort value.
-
How does IDMS insure data integrity?
IDMS uses record locks to prevent another run-unit from updating the same record.
-
-
What does a COMMIT statement do?
It writes a checkpoint to the Journal File and releases any record locks.
-
-
IDMS set of occurances
In IDMS which of following is true for any set of occurances?1. It may have zero owner instances.2. It must have one and only one owner instance.3. It must have atleast one member instance.4. None
-
When you are obtaining next within a set and get a end of set return code, on what record are you now current?
You are current on the owner.
-
What is the difference between local and central version operating modes?
In local there is no IDMS System running above the DBMS. It is the more efficient mode but lacks the recovery and integrity facilities of the central version (CV) control program. In CV many application programs access the database through a single copy of the DBMS.
-
What is an area sweep and when is it used?
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.
-
What is the purpose of a READY?
The READY prepares a database area for access by DML functions.
-
Explain the difference between record occurrence and record type?
A record occurrence is the instances of a record; it is the smallest addressable unit of data. A type is the description of a record; there need not be any occurrences.
-
What is an OOK-Rec?
An OOK-Rec is a one of a kind record set, used to get to another record set
-
-
-
-
-
Advantages of IDMS
What is the advantages of using IDMS compared to other database systems?
IDMS Interview Questions
Ans