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 5970

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.

2422

What is RECOVERY and SPEED parameters in DEFINE CLUSTER command?

1 14334

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

1 17740

What does the KEYRANGES parameter in Define Cluster commend do?

1 7462

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

IBM,

1 6187

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

4 18999

How to delete a member using JCL.?

5 15427

What is the Difference between LDS & ESDS ?

3 15335

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

3 10376

What is an alternate index and path ?

Infosys, TCS,

2 26756

How many buffers are allotted to VSAM KSDS and ESDS?

1 8242

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

Anjana, CTS, DSRC, IBM,

8 20440

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

1 5768

How many times secondary space allocated?

5 10883

Post New VSAM Questions

Un-Answered Questions { VSAM }

how can you load a vsam data set with records ?

1162

what is the syntax of ams modal commands?

1264

difference between vsam and database tables

1136

differentiate between sequential files and esds files in vsam?

1171

Why is it required to have a keyed directed retrieval?

1025

Explain the catalog?

990

Explain the function of entry-sequenced data set?

1034

write a program to read from a VSAM file , there will be a 5 records to create name. empno. resignation and address to update in a db2 table and call another program using dynamic call to find the matching fields in program 1 to update in db2 table. anybody pls send de program for dis ? thanks in advance...

2744

Define gdg?

990

explain in brief how are different versions of gdg named?

1002

If fspc(100 100) is specified does it mean that both the control interval and control area will be left empty because 100 % of both ci and ca are specified to be empty?

1098

Differentiate between ci split and ca split?

1012

What is recovery parameters in define cluster command?

1057

can you specify some the distinctive features of a ksds, key sequenced dataset?

1027

what do you mean by idcams? Explain its purpose?

967

For More Un-Answered { VSAM } Questions Click Here