logo

CuriousTab

CuriousTab

Discussion


Home Database Physical Database Design Comments

  • Question
  • Which of the following is an advantage of partitioning?


  • Options
  • A. Complexity
  • B. Inconsistent access speed
  • C. Extra space
  • D. Security

  • Correct Answer
  • Security 


  • Physical Database Design problems


    Search Results


    • 1. 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
    • 2. 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
    • 3. 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
    • 4. 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
    • 5. 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
    • 6. 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
    • 7. 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
    • 8. 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
    • 9. 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
    • 10. Client/server security includes which of the following?

    • Options
    • A. Physical security
    • B. Change control security
    • C. Measures taken to secure all systems
    • D. All of the above.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment