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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 7. Which is not a logical database structure

    1. Chain
    2. Tree
    3. Relational
    4. Network
    Answer And Explanation

    Answer: Option A