Database Question Answers - Chapter 1

• 29. Large collection of files are called

  1. fields
  2. Records
  3. Database
  4. Sectors

  Answer :

  Option C

• 30. Secondary index can be related with

  1. Function dependency
  2. B tree
  3. Domain calculus
  4. Relational algebric operators

  Answer :

  Option B

• 31. Data dictionary tell DBMS

  1. what files are in the database
  2. what attributes are processed by data
  3. what these files contain
  4. all of above

  Answer :

  Option D

• 32. The logical structure with one to many relationships is a

  1. network
  2. tree
  3. chain
  4. relational

  Answer :

  Option B

• 33. The distinguishable parts of a record are called

  1. files
  2. data
  3. fields
  4. formats

  Answer :

  Option C

• 34. Database management systems are used to

  1. eliminate data redundancy
  2. establish relationships among records in different files
  3. manage file access
  4. none of above

  Answer :

  Option A

• 35. Fragmentation of a file system

  1. Can always be prevented
  2. occurs only is file is not used properly
  3. Can be temporarily removed by compaction
  4. None of above

  Answer :

  Option C