Database Question Answers - Chapter 1

• 1. If a relation scheme is in BSNF then it is also in

  1. First normal form
  2. Second normal form
  3. Third normal form
  4. Not in any normal form

  Answer And Explanation

  Answer: Option C

  Explanation:

  • View Answer
  • Comment on this question

• 2. Attribute of one table matching to the primary key of other table, is called as

  1. foreign key
  2. secondary key
  3. candidate key
  4. composite key

  Answer And Explanation

  Answer: Option A

  Explanation:

  • View Answer
  • Comment on this question

• 3. Allocation map

  1. Used to store program data
  2. specifies which blocks are used by which file
  3. is updated by application programs
  4. allow programs to erase files

  Answer And Explanation

  Answer: Option B

  Explanation:

  • View Answer
  • Comment on this question

• 4. The master list of an indexed file

  1. is sorted in ascending order
  2. contains only a list of keys and record numbers
  3. has a number assigned to each record
  4. none of above

  Answer And Explanation

  Answer: Option C

  Explanation:

  • View Answer
  • Comment on this question

• 5. 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 And Explanation

  Answer: Option A

  Explanation:

  • View Answer
  • Comment on this question

• 6. Ascending order of data hierarchy is

  1. bit->byte->record->field->file->database
  2. bit->byte->field->record->file->database
  3. byte->bit->field->record->file->database
  4. byte->bit->field->file->record->database

  Answer And Explanation

  Answer: Option B

  Explanation:

  • View Answer
  • Comment on this question

• 7. Which is not a logical database structure

  1. Chain
  2. Tree
  3. Relational
  4. Network

  Answer And Explanation

  Answer: Option A

  Explanation:

  • View Answer
  • Comment on this question