Question Detail

The master list of an indexed file

  • is sorted in ascending order
  • contains only a list of keys and record numbers
  • has a number assigned to each record
  • none of above
Similar Questions :

1. 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

2. Which is not a logical database structure

  • Chain
  • Tree
  • Relational
  • Network

3. 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

4. The master list of an indexed file

  • is sorted in ascending order
  • contains only a list of keys and record numbers
  • has a number assigned to each record
  • none of above

5. If a relation scheme is in BSNF then it is also in

  • First normal form
  • Second normal form
  • Third normal form
  • Not in any normal form
Read more from - Database Question Answers - Chapter 1