VSAM Questions for Beginners and Intermediate Level.
- Can you describe the process how are records stored in an ESDS, entry sequenced data-set in VSAM?
- Explain what do you mean by CI, control interval?
- Explain what is free space in VSAM?
- Is it necessary that primary key values have to be unique? Do alternate key values have to be unique in VSAM?
- In the COBOL SELECT statement, what is the ORGANIZATION for a KSDS?
- What is a path in VSAM?
- What is the upgrade set?
- In the COBOL SELECT statement for a KSDS what are the three possibilities for ACCESS in VSAM?
- Explain what is the purpose of the FILE STATUS clause in the SELECT statement in VSAM?
- If there is a need to use the REWRITE command haw must the VSAM file be opened?
- Explain the meaning and syntax for the START command.
- What is the utility program closely associated with VSAM?
- Can you explain in detail the seven IDCAMS commands?
- What do you mean by a catalog in VSAM?
- What is RECOVERY and SPEED parameters in DEFINE CLUSTER command ?
- Can you describe the SHAREOPTIONS parameter (SHR) in Define Cluster command in VSAM.
- Explain what is an alternate index? Provide Examples.
- What is a LDS (Linear Data Set ) and what is it used for in VSAM?
- Explain what do you mean by a cluster?
- What are the three levels of definition for the VSAM DEFINE?
- Explain what is the significance of the SHAREOPTIONS parameter in VSAM?
- What is the meaning of the DEFINE MODEL parameter?
- What is File Status in VSAM ?
- Under IDCAMS, multiple functions can be executed, each of which returns a condition code. What will be the condition code returned to the operating system ?
- Explain what is Control Interval, Control Area in VSAM?
- What is FREESPACE ?
- Describe the process of defining an ALTINDX ? How do you use ALTINDXs in batch, CICS program's ?
- What happens when you open an empty VSAM file in a COBOL program for input ?
- How do you initialize a VSAM file before any operation?
- Explain what is the meaning of each of the values in SHAREOPTS (2 3) in VSAM?
- Can you describe the process of calculating record size of an alternate cluster ? Please also provide values for both unique and non-unique.
- Explain what is the difference between sequential files and ESDS files in VSAM?
- Explain in brief how can you load a VSAM data set with records ?
- Describe the process of defining a GDG in VSAM?
- What is the device independent method to indicate where a Record is Stored ?
- How many times secondary space allocated in VSAM?
- How can you define a kSDS in VSAM?
- What does a file status of 02 on a VSAM indicate ?
- During processing of a VSAM file, some system error occurs and it is subsequently madeunusable. What do you do in VSAM?
- How do you fix the problem associated with VSAM out of space condition ?
- What is the meaning of VSAM RETURN-CODE 28 ?
- On which dataset You can have ALT INDEX ?
- What is IDCAMS ? and what is the purpose of it ?
- Explain how do you delete a member using JCL.
- Explain what is the difference between LDS and ESDS in VSAM?
- Is a delete operation possible in an ESDS? Also, is rewrite operation possible in ESDS in VSAM?
- What is the RRN for the first record in RRDS ?
- How many Alternate Indexes you can have on a data-set in VSAM?
- Explain what are the optional parameters to the input data-set while loading the empty cluster with the data records ?
- Explain what is a Base Cluster in VSAM?
Related Posts
No comments :