Records and File Organisation

Description

Flashcards on Records and File Organisation, created by 09064 on 07/01/2015.
09064
Flashcards by 09064, updated more than 1 year ago
09064
Created by 09064 over 9 years ago
16
1

Resource summary

Question Answer
What is an array? What is a disadvantage? An array is a way of storing multiple types of data. A disadvantage is that it can only store 1 data type.
What is the purpose of a record? A record is a way of storing multiple data types under individual items of data (fields).
What is the definition of serial files? A collection of records, stored one after another, in no particular sequence.
How are records added to serial files? Where is new data added to(appended)? Data is stored in the order that it arrives. New data is added to the end of the file.
How are files searched in serial files? Why is this a disadvantage? The whole file is searched from the beginning until the correct record is located. There are 2 disadvantages: if the file is large then search can take a long time, if the record is not present you will not know until the search is finished.
How are records deleted in serial and sequential files? Removing a record leaves a gap in the file. This means that when a file is deleted the entire file is copied to a new file without the records that will be deleted.
What is the definition of sequential files? A collection of records stored one after each other in key sequence.
How are records added to sequential files? A new record is inserted within the existing records. A new file is created and all the records are copied until the new one can be inserted into it's proper place.
How are records searched in sequential files? Files are searched from the beginning until the record is found. However if you reach a key field that is higher than the one you are searching for then the search ends as it knows the record is not present.
What are indexed sequential files ? Where records are stored using a key field, however an index is also stored which allows the records to be accessed directly
What is the other name for direct access files? Random access files
Show full summary Hide full summary

Similar

AS Philosophy Exam Questions
Summer Pearce
Computing Hardware - CPU and Memory
ollietablet123
Cell Structure
megan.radcliffe16
Exchange surfaces and breathing
megan.radcliffe16
Unit 1 flashcards
C R
A level Computing Quiz
Zacchaeus Snape
Biology B1.1 - Genes
raffia.khalid99
Biology B1.3
raffia.khalid99
A2 Organic Chemistry - Reactions
yannycollins
GCSE Biology B2 (OCR)
Usman Rauf
AS Chemistry - Enthalpy Changes
Sarah H-V