How many cluster index can have in a table?

Answers were Sorted based on User's Feedback



How many cluster index can have in a table?..

Answer / karthik

only one clustered index is allowed

Is This Answer Correct ?    5 Yes 0 No

How many cluster index can have in a table?..

Answer / satish

each cluster have only one index. and multiple clusters may have in table.

Is This Answer Correct ?    0 Yes 0 No

How many cluster index can have in a table?..

Answer / deep

one OR more than one index

Is This Answer Correct ?    1 Yes 6 No

Post New Answer

More VSAM Interview Questions

If FSPC(100 10 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   DSRC,


What is RECOVERY and SPEED parameters in DEFINE CLUSTER command?

1 Answers  


name the utility program closely associated with vsam?

0 Answers   IBM,


is it slower if you access a record through alternative index as compared to primary index?

1 Answers   IBM,


In a KSDS file, key is missing for one record. How to insert the key for that particular record from back up file. Is there any sorting needed for the back up file before the key insertion?

0 Answers   RBS,


What is control area?

0 Answers  


Explain about the file objects in vsam?

0 Answers  


name a few common vsam status codes?

0 Answers   IBM,


What is a vsam dataset?

0 Answers  


explain the information contained in ci

0 Answers   IBM,


What is the difference between PS file and VSAM file?

7 Answers   IBM, Infosys, Verizon,


how to view clusters that has more than 10000 records

2 Answers  


Categories