logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Physical Database Design Comments
  • Question

  • In general, larger block sizes are used for online transaction processing applications and smaller block sizes are used for databases with a decision support or data warehousing system.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 

    • Physical Database Design problems

    Search Results

    • 1. An entity cluster is a set of one or more entity types and associated relationships.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. Generalization is the process of defining more general entity types from a set of more specialized entity types.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. An entity instance of a subtype represents the same entity instance of a supertype.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. An action assertion is a statement that expresses some aspect of the static structure of the organization.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. An ERD that has had the entities clustered will display more entities.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. The three newest database architectures in use today are relational, multidimensional and hierarchical.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. 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
    • 8. Hashing algorithm converts a primary key value into a record address.

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

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. 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

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.