File Organization

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