logo

CuriousTab

CuriousTab

Discussion


Home Database Physical Database Design Comments

  • Question
  • A multidimensional database model is used most often in which of the following models?


  • Options
  • A. Data warehouse
  • B. Relational
  • C. Hierarchical
  • D. Network

  • Correct Answer
  • Data warehouse 


  • Physical Database Design problems


    Search Results


    • 1. 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
    • 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. 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
    • 4. The fastest read/write time and most efficient data storage of any disk array type is:

    • Options
    • A. RAID-0.
    • B. RAID-1.
    • C. RAID-2.
    • D. RAID-3.
    • Discuss
    • 5. Which of the following are integrity controls that a DBMS may support?

    • Options
    • A. Assume a default value in a field unless a user enters a value for that field.
    • B. Limit the set of permissible values that a field may assume.
    • C. Limit the use of null values in some fields.
    • D. All of the above.
    • Discuss
    • 6. Which of the following is an advantage of partitioning?

    • Options
    • A. Complexity
    • B. Inconsistent access speed
    • C. Extra space
    • D. Security
    • Discuss
    • 7. A benefit of the three-tier architecture is which of the following?

    • Options
    • A. New modules can be built to support specific business needs
    • B. Performance improves for compiled SQL statements
    • C. Results in a thinner client and database server
    • D. All of the above.
    • Discuss
    • 8. Which of the following statements is true concerning JDBC?

    • Options
    • A. It is language independent.
    • B. It is similar in concept to ODBC.
    • C. It is useful for all object-oriented languages.
    • D. It consists of three main layers.
    • Discuss
    • 9. The three different application logic components are which of the following?

    • Options
    • A. Presentation, Client, and Storage
    • B. Presentation, Client, and Processing
    • C. Presentation, Processing, and Storage
    • D. Presentation, Processing, and Network
    • Discuss
    • 10. A server cannot serve on which of the following levels?

    • Options
    • A. Client Layer
    • B. Business Layer
    • C. Database Layer
    • D. All of the above.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment