What is Alternate Index ? How is it different from regular
index ?
Answer Posted / nk
The purpose of any index is to provide the most efficient
access to the records in a file. Say you have a file of
employee names and numbers. Usually the primary index will
be the employee number. If you request a record by
providing the empl#, the access will be very fast. If you
have to very often request a record by the empl name, you
may want to create a second (a/k/a alternate) index based
on the name. So when you provide a name, the access to the
correct record also will be very fast.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
There are 5 fields and 1000 records in a file. Unload it into an array. Write the syntax for declaration and how will you unload it.
What is amode(31)
I have File 1 occurs 5 times with Employee-ID,Employee-Name,Employee-Dept (EEE and MECH). I have File 2 occurs 10 times with Employee-ID,Employee-Name,Employee-Dept (EEE,CIVIL,CHEMICAL and MECH). In FIle 1 and FIle 2 , for matching Employee-DEPT (Only MECH) , we need to move entire records from file1 to file 2. We should not use 2D array. Your help is needed here.
Which is the default, TEST BEFORE or TEST AFTER for a PERFORM statement?
Why is it necessary that file needs to be opened in I-O mode for REWRITE?
What is the difference between binary search and sequential search?
Name some of the examples of COBOl 11?
how do you reference the rrds file formats from cobol programs
What are the different rules for performing sort operation?
What is comp-1 and comp-2?
What is redefines clause in COBOL?
What is amode(24)?
Explain what you understand by passing by value.
How do define dynamic array in cobol. how do you define single dimensional array and multidimensional array in your cobol?
Explain sorting techniques in cobol program? Provide the sort file definition, the sort statement, its syntax and meaning