Question Detail

Fragmentation of a file system

Can always be prevented
occurs only is file is not used properly
Can be temporarily removed by compaction
None of above

Answer: Option C

Similar Questions :

1. Secondary index can be related with

Function dependency
B tree
Domain calculus
Relational algebric operators

Answer: Option B

2. Transaction processing was made possible by the development of

direct access storage
magnetic tape
cash register input
minicomputers

Answer: Option A

3. Two basic types of record access methods are

sequential and random
direct and immediate
sequential and indexed
online and real time

Answer: Option A

4. File record length

should always be fixed
should always be variable
should be chosen to match the data character
depends upon the size of file

Answer: Option D

5. Network structure

is a physical representation of data
is conceptually simple
allows many to many relationships
none of above

Answer: Option C

Read more from - Database Question Answers - Chapter 1