what is difference between random and sequence file access



what is difference between random and sequence file access..

Answer / naidu sekhar naidu

SEQUENTIAL FILE: 1)IF DATA IS ENTRY IN SEQUENTIAL ORDER
2)ACCESS IN SEQUENTIAL ORDER
3)MAIN ADVANTAGE REPORT GENERATION
RANDOM FILE: 1)IF DATA ENTRY IN SEQUENTIAL AS WELL AS RANDOM
2) SEARCHING IS MORE FASTER COMPARE TO THE SEQUENTIAL FILE


CORRECT ME IS AM WRONG U R FRIEND

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More DB2 Interview Questions

What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,


What is runstats db2?

0 Answers  


What is the logical entity between plan and Package?

5 Answers  


what are the max. & min. no. of partitions allowed in a partition tablespace?

2 Answers   IBM,


Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  






I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  


What is the result of open cursor statement?

0 Answers  


when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations

3 Answers   IBM,


What happens in bind step in a db2 program?

0 Answers  


can i code union in cobol-db2 pgm ?

4 Answers   Patni,


How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,


What is the error code -803 ?

3 Answers  


Categories