WorksheetsFile Organization
Total questions: 20
Worksheet time: 10mins
What is a file in the context of databases?
A type of hardware
A program for data processing
A collection of records
A table of numbers
Which of the following affects the response time of a database system?
Disk color
File organization
Screen resolution
Font size
Which file organization method is best for fast sequential access?
Hashing
Indexed
Sequential
Random
In a moving head disk drive, what does seek time refer to?
Time taken to search in RAM
Time to open a file
Time to move the head to the correct track
Time to boot the system
What is an example of a magnetic tape?
Pen drive
Video cassette
DVD
Blu-ray disc
Which file type stores a batch of updates?
Transaction file
Sequential file
Audio file
Archive file
What is the purpose of an index file?
To delete data
To store images
To speed up data retrieval
To organize videos
Which of the following is a disadvantage of hashing?
Very slow access
Requires a lot of memory
Not suitable for range queries
Needs a transaction log
What helps manage large data and updates in indexed files?
Free list
Multi-level indexing
Slotted page
Sequential access
In hashing, what is a collision?
When two files crash
When two records get same hash value
When disk space is full
When search takes too long
Which structure is best when frequent insertions and deletions are required?
Sequential
Index
Hash
Slotted page
What is an advantage of using indexing?
Slow access
Large memory consumption
Supports range and random queries
Supports only fixed length records
What does an overflow area in indexing help with?
Printing
Network speed
Managing record insertions
Deleting records
What is a header used for in file organization?
Formatting the disk
Managing free space
Increasing RAM
Storing video data
Which type of file organization skips index and accesses directly?
Sequential
Hashing
Index-sequential
Linked
Which of the following is NOT a type of file organization?
Sequential
Indexed
Hashed
Compressed
What is the main advantage of extendable hashing?
Reduces indexing time
Helps with growing data
Compresses data
Sorts data
What is the main drawback of sequential files?
Slow deletion and insertion
Too complex
Difficult to read
Requires special hardware
Which file organization combines sorting and indexing?
Hashed
Index Sequential
Variable length
Compressed
What is used to manage variable-length records?
Indexes
Slotted page
Header blocks
Cylinder gaps
