0
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.
What else can I help you with?
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
What is different between a key and superkey?
A key is a minimal set of attributes that uniquely identifies a record in a database table, meaning no two records can have the same value for that set of attributes. A superkey, on the other hand, is any set of attributes that can uniquely identify a record, but it may contain additional attributes that are not necessary for uniqueness. In essence, all keys are superkeys, but not all superkeys are keys, as keys must be minimal.
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.
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.
Difference between physical file and physical record?
Type your answer here... contains the data and have only one record format
If you have been free for 10 years how do you clear a felony from your record?
The length of time you have been released makes no difference - you must petition the court to have your record "expunged" and give good reason as to why the record should disappear.
What is the difference between an information system and record keeping?
The difference between record keeping and information system is that traditional record keeping is a manual process of controlling and governing important records of a business. While an information system is the same procedure via computer system making the process easier.
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 a CD and a vinyl record?
size colour sound range cost durability
