logo

CuriousTab

CuriousTab

Physical Database Design problems

  • 1. A rule of thumb for choosing indexes for a relational database includes which of the following?

  • Options
  • A. Indexes are more useful on smaller tables.
  • B. Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.
  • C. Do not specify a unique index for the primary key of each table.
  • D. Be careful indexing attributes that have null values.
    • Discuss
  • 2. What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?

  • Options
  • A. VARCHAR2
  • B. CHAR
  • C. LONG
  • D. NUMBER
    • Discuss
  • 3. Sequential retrieval on a primary key for sequential file storage has which of the following features?

  • Options
  • A. Very fast
  • B. Moderately fast
  • C. Slow
  • D. Impractical
    • Discuss
  • 4. A multidimensional database model is used most often in which of the following models?

  • Options
  • A. Data warehouse
  • B. Relational
  • C. Hierarchical
  • D. Network
    • Discuss
  • 5. Which of the following is an advantage of partitioning?

  • Options
  • A. Complexity
  • B. Inconsistent access speed
  • C. Extra space
  • D. Security
    • Discuss
  • 6. 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
    • Discuss
  • 7. The three newest database architectures in use today are relational, multidimensional and hierarchical.

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

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

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

First 2

Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.