0
What is difference between fixed length record and variable length record?
Wiki User
∙ 13y ago
A file where all the records are of the same length is said to have fixed length records.
Advantage : Access is fast because the computer knows where each record starts.
Eg If each record is 120 bytes long then
- the 1st record starts at [Start of File] + 0 bytes
- the 2nd record starts at [Start of File] + 120 bytes
- the 3rd record starts at [Start of File] + 240 bytes etc.....
Disadvantage : Using Fixed length records, the records are usually larger and therefore need more storage space and are slower to transfer (load or save).
One or more of the fields can be of differing lengths in each record, called variable length records
Advantages:
- the records will be smaller and will need less storage space
- the records will load faster
Disadvantages:
The computer will be unable to determine where each record starts so processing the records will be slower.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
What is fixed length record?
A fixed length record is a data structure that contains a standard amount fields, within the actual record.
What is the difference between single-valued attributes and simple attributes?
single valued attribute are one character in a record
What is the differences between reasoning and remembering?
Reasoning is actively analyzing. Remembering is simply making a mental record.
What is the difference between scripts and frames?
sript is frame like structure used to represent commonly occuring experiences eg:- shopping in a supermarket , going to the library etc. whereas frames are general record like structure which consists of collection of slots and slot values . The slotncan be of any size and type . Slots typically have names and values called facets
To add a record to a table?
add new
Fixed length record and variable length record?
fixed length database
Difference between timer and counter?
The difference between a timer and a counter is that a timer can be set to record different time intervals. As were a counter only records an overall length of time.
Difference between inverted lists and multi lists?
In a Multi-list organisation an index entry points to the first data record in the list, whereas in inverted index file an index entry has address pointers to all the data records related to it. • A multi-list index has fixed length records, whereas an inverted index contains variable length records
Why it is difficult to support direct access to files with variable-length records?
For direct access with variable-length records, it's virtually impossible to access a record directly because the address of the desired record can't be easily computed. In order to access a record, the File Manager must do a sequential search through the records. The File Manager could search forward from the CBA-if the address of the desired record was between the CBA and the end of the file. Otherwise, the search would start from the beginning of the file. It could be said that this semi-sequential search is only semi-adequate
What is a difference between a ticket and a warning?
There is definitely a difference between a ticket and a warning. A warning does not go on record a ticket does
What is the difference between Oracle data types char and varchar2?
Character string values storage:1. CHAR:§ Stores strings of fixed length.§ The length parameter s specifies the length of the strings.§ If the string has smaller length it padded with space at the end§ It will waste of a lot of disk space.§ If the string has bigger length it truncated to the scale number of the string.2. VARCHAR:§ Stores strings of variable length.§ The length parameter specifies the maximum length of the strings§ It stores up to 2000 bytes of characters§ It will occupy space for NULL values§ The total length for strings is defined when database was created.3. VARCHAR(2):§ Stores strings of variable length.§ The length parameter specifies the maximum length of the strings§ It stores up to 4000 bytes of characters§ It will not occupy space for NULL values§ The total length of strings is defined when strings are given
What Difference between data record and information?
data record is about the Recording of data .. while information is the data which we are about to record
What is the difference between dependent asnd independent variables?
The independent variable is the one that the person doing the experiment changes themself. The dependant variable is the one that is recorded as results. For example, if investigating the effect of water on the rate of photosynthesis, you would change the amount of water and record how the rate of photosynthesis changes. Therefore, the amount of water is the independent variable and the rate of photosynthesis is the dependant variable.
What are the Difference between farm account and farm record?
Different between farm record and farm accaunt
What is the difference between convicted and acquitted?
One gives you a criminal record.
What is the difference between record and database?
A database is composed of one or more records.
Difference between physical file and physical record?
Type your answer here... contains the data and have only one record format
