Database Question Answers - Chapter 1

  • 22. RAID configurations of a disk are used to provide

    1. fault tolerance
    2. high speed
    3. high data density
    4. none of above
    5. It will be successful now that the DNA-based map has been developed.
    6. It has been mostly unsuccessful in reducing the trade of illegal ivory.
    7. It will continue to be ineffective unless the problems of political corruption are solved.
    8. Western monetary support was a major factor in its success.
    Answer :

    Option

  • 23. Which normal form is considered adequate for normal relational database design

    1. 2NF
    2. 5NF
    3. 3NF
    4. 4NF
    5. I
    6. II
    7. IV
    8. All required
    Answer :

    Option

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

    1. K
    2. I
    3. F
    4. None of these
    5. First normal form
    6. Second normal form
    7. Third normal form
    8. Not in any normal form
    Answer :

    Option

  • 25. Non procedural query language can be related with

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

    Option C

  • 26. Two basic types of record access methods are

    1. sequential and random
    2. direct and immediate
    3. sequential and indexed
    4. online and real time
    Answer :

    Option C

  • 27. Physical location of a record in database is determined with the help of

    1. B tree file
    2. Indexed file
    3. Hashed file
    4. sequential file
    5. data in statement I alone are sufficient to answer the question.
    6. data in statement II alone are sufficient to answer the question.
    7. data either in statement I alone or in statement II alone are sufficient to answer the question.
    8. data given in both statements I and II together are not sufficient to answer the question.
    9. data in both statements I and II together are necessary to answer the question.
    Answer :

    Option F

  • 28. 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 :

    Option A

Please Like Us

disawar satta king