Database Question Answers - Chapter 1

  • 22. Which is a type of DBMS software

    1. utilities
    2. query language
    3. report writer
    4. All of above
    Answer And Explanation

    Answer: Option D

  • 23. Large collection of files are called

    1. fields
    2. Records
    3. Database
    4. Sectors
    Answer And Explanation

    Answer: Option C

  • 24. In order to use a DBMS, it is important to understand

    1. the physical schema
    2. all subschemas
    3. one sub schema
    4. none of above
    Answer And Explanation

    Answer: Option C

  • 25. Data dictionary is a special file that contains

    1. the names of all fields in all files
    2. the data types of all fields of all files
    3. Both of above
    4. None of above
    Answer And Explanation

    Answer: Option B

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

    Answer: Option A

  • 27. Secondary index can be related with

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

    Answer: Option B

  • 28. Natural join can be related with

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

    Answer: Option D