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.



Yes. Because the alternate key would first locate the primary key, which in turn locates the actua..

Answer / Garima Agrawal

"Correct answer: Yes. The reason is that an alternate key needs to first search for and locate the primary key before it can find the actual record. This results in double the number of I/Os compared to direct access using the primary key."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More VSAM Interview Questions

How many times secondary space allocated?

5 Answers  


What are the advantages of vsam over isam?

1 Answers  


Using alternate indexes in batch program?

1 Answers  


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?

1 Answers  


we can define the ksds cluster by two ways by using the file-aid or by using the idcams utility. Explain them.

1 Answers   IBM,


What is File Status in VSAM?

1 Answers   IBM,


Can you delete vsam files with the delete option of the disposition parameter of jcl?

1 Answers   IBM,


How do you define an ALTINDX ? How do you use ALTINDXs in batch, CICS pgm?s ?

2 Answers   IBM,


Common VSAM Error conditions and codes

1 Answers  


Why is master catalog used in vsam?

1 Answers  


What is the Difference between LDS & ESDS ?

3 Answers  


Explain the function of entry-sequenced data set?

1 Answers  


Categories