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 |
What are foreign keys?
How do I delete a table in db2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
When would you prefer to use VARCHAR?
Explain in detail about buffer manager and its functionalities?
How will you return the number of records in table?
Why db2 is called db2?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
What is ibm db2 database?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?