logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Physical Database Design Comments
  • Question

  • Distributing the columns of a table into several separate physical records is known as horizontal partitioning.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 

    • Physical Database Design problems

    Search Results

    • 1. Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. Some advantages of partitioning include: efficiency, security, and load balancing.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. Hashing algorithm converts a primary key value into a record address.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. A bitmap index is an index on columns from two or more tables that come from the same domain of values.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. Denormalization and clustering can work well to minimize data access time for small records.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. An extent is a contiguous section of disk storage space.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. A pointer is a detailed coding scheme recognized by system software for representing organizational data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.

    • Options
    • A. True
    • B. False
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.