File Organization

Question 1
Marks : +2 | -2
Pass Ratio : 50%
The slotted page structure is used for _________
Organizing records in a block
Organizing blocks in a database
Deleting records from a block
None of the mentioned
Explanation:
The slotted page structure is used for organizing records in a block. The slotted page structure contains a header at the beginning of each block.
Question 2
Marks : +2 | -2
Pass Ratio : 50%
How can variable length records arise in a file
Storage of multiple record types in a file
Record types that allow variable lengths for one or more fields
Record types that allow repeating fields, such as arrays or multisets
All of the mentioned
Explanation:
Variable length records arise in a system in several ways like, Storage of multiple record types in a file. Record types that allow variable lengths for one or more fields. Record types that allow repeating fields, such as arrays or multisets.
Question 3
Marks : +2 | -2
Pass Ratio : 50%
What does a null bitmap indicate?
The database does not exist
The record does not exist
The attributes of a record do not have a value
The attributes are missing from record
Explanation:
A null-bitmap indicates that the attributes of a particular record have null values.
Question 4
Marks : +2 | -2
Pass Ratio : 50%
The header in the slotted page structure does not contain which of the following data?
The number of record entries in the header
The end of free space in a block
The size of all the records put together in the header
An array containing location and size of each record
Explanation:
The header in the slotted page structure does not contain the size of all the records put together in the header but it contains the number of record entries, the end of free space and an array containing location and size of each record.
Question 5
Marks : +2 | -2
Pass Ratio : 50%
Which of the following is true about file header?
It is allocated at the beginning of the file
It has information about the file
It generally contains the address of the first record in it
All of the mentioned
Explanation:
A file header is a certain number of bytes allocated at the beginning of the file. It contains a variety of information about the file and it can be used to point the first record by storing the address of the first record in it.
Question 6
Marks : +2 | -2
Pass Ratio : 50%
State true or false: It is easier to delete a record from the fixed length records
True
False
Explanation:
It is tough to delete a record from the fixed length records but it is easier to delete a record from the variable length record. Thus, implementation of variable records is preferred.
Question 7
Marks : +2 | -2
Pass Ratio : 50%
What is the approximate storage capacity of CDs in MB
300
700
1100
1500
Explanation:
Question 8
Marks : +2 | -2
Pass Ratio : 50%
The linked list formed by the deleted records is called as ______
Delete list
Free list
Null list
Non-existent list
Explanation:
As the addresses can be thought of as pointers, the deleted records thus form a linked list. The linked list formed by the deleted records is called as a free list.
Question 9
Marks : +2 | -2
Pass Ratio : 50%
State true or False: Variable length records cannot be implemented
True
False
Explanation:
Variable length records can be implemented in databases. There are different techniques to implement variable length records.
Question 10
Marks : +2 | -2
Pass Ratio : 50%
The devices that store a lot of optical disks are called as
Optical reservoirs
Jukeboxes
Karaoke machines
Sequential access machines
Explanation:
Jukeboxes are the devices that store a lot of optical disks and load them automatically on demand.