VSAM Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

VSAM Interview Questions

Questions Answers Views Company eMail

Is it slower if you access a record through ALT INDEX as compared to Primary INDEX? Why?

1 5886

Yes. Because the alternate key would first locate the primary key, which in turn locates the actual record. Needs twice the number of I/Os.

2364

What is RECOVERY and SPEED parameters in DEFINE CLUSTER command?

1 14258

Describe SHAREOPTIONS parameter (SHR) in Define Cluster command.?

1 17670

What does the KEYRANGES parameter in Define Cluster commend do?

1 7406

What are the optional parameters to the input dataset While loading the empty cluster with the data records?

IBM,

1 6110

What is IDCAMS? and what is the purpose of it?

4 18846

How to delete a member using JCL.?

5 15221

What is the Difference between LDS & ESDS ?

3 15195

Is a delete operation possible in an ESDS?B. Is rewrite operation possible in ESDS ?

3 10274

What is an alternate index and path ?

Infosys, TCS,

2 26634

How many buffers are allotted to VSAM KSDS and ESDS?

1 8180

what's the biggest disadvantage of using a VSAM dataset?

Anjana, CTS, DSRC, IBM,

8 20141

what's the device independent method to indicate where a Record is Stored?

1 5698

How many times secondary space allocated?

5 10735

Post New VSAM Questions

Un-Answered Questions { VSAM }

what is meant by dirty read in vsam?

1318

What is the main purpose of having user catalog in vsam?

1010

what are the codes returned by the ams (access method services) command during the execution in vsam?

1249

Using alternate indexes in cics program?

985

What is a ci split? What is a ca split?

1133

what do you mean by a upgrade set in vsam?

1028

how do you define an altindx ? How do you use altindxs in batch, cics programs?

1037

Explain the biggest disadvantage of using a vsam dataset?

1002

What is the main function of key sequenced data set in vsam?

927

name a few common vsam status codes?

1016

what do you mean by a shareoptions parameter (shr) in define cluster command?

1221

differentiate between sequential files and esds files in vsam?

1127

What is the function of entry sequenced data set?

1037

how many buffers are allocated to vsam ksds and esds?

1126

What are the advantages of vsam over isam?

1099

For More Un-Answered { VSAM } Questions Click Here