VSAM Interview questions
VSAM Interview questions 1-10
-
Q1: VSAM full form?
- Answer : Full form of VSAM is Virtual Storage Access Method
- Answer : Entry Sequenced Datasets (ESDS), Key Sequenced Datasets (KSDS) and Relative Record Dataset (RRDS).
- Answer : A control interval is the unit of information that VSAM transfers between virtual and auxiliary storage.
- Answer : A group of control intervals makes up a control area.
- Answer : A cluster is the combination of the index, sequence set and data portions of the dataset. The operating system gives program access to the cluster, ie. to all parts of the dataset simultaneously.
- Answer : The catalog contains the names of all datasets, VSAM and non-VSAM. It is used to access these datasets.
- Answer : If there isn't enough space in the control interval VSAM performs a control interval split by moving some records to the free control intervals. If there isn't a free control interval VSAM performs a control area split by allocating a new control area and moving half of the control intervals to it.
- Answer : The base cluster consists of the data component and the index component for the primary index of a KSDS.
- Answer : The ORGANIZATION is INDEXED.
- Answer : The RECORD KEY in the SELECT clause identifies the files primary key as it will be known to the program.