logo

CuriousTab

CuriousTab

Discussion


Home Database The Client-Server Database Comments

  • Question
  • Three-tier architecture includes which of the following?


  • Options
  • A. Three server layers
  • B. A client layer and two server layers
  • C. Two client layers and one server layer
  • D. Three client layers

  • Correct Answer
  • A client layer and two server layers 


  • The Client-Server Database problems


    Search Results


    • 1. A database server is responsible for which of the following?

    • Options
    • A. Database storage
    • B. Data processing logic
    • C. Data presentation logic
    • D. All of the above.
    • Discuss
    • 2. Stored procedures have which of the following advantages?

    • Options
    • A. It takes a longer time to write them as compared to writing Visual Basic.
    • B. Network traffic increases
    • C. Data integrity improves as multiple applications access the same stored procedure.
    • D. Result in thicker client and thinner database server.
    • Discuss
    • 3. An application program interface (API) is which of the following?

    • Options
    • A. The same thing as ODBC.
    • B. Middleware that does not provide access to a database.
    • C. Middleware that provides access to a database.
    • D. The same thing as JDBC.
    • Discuss
    • 4. Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?

    • Options
    • A. Each vendor desiring to be ODBC-complaint provides an ODBC driver.
    • B. Requires certain criteria to be met in order to establish an ODBC connection.
    • C. Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.
    • D. All of the above.
    • Discuss
    • 5. A characteristic of a file server is which of the following?

    • Options
    • A. Manages file operations and is shared on a network.
    • B. Manages file operations and is limited to one PC.
    • C. Acts as a fat client and is shared on a network.
    • D. Acts as a fat client and is limited to one PC.
    • Discuss
    • 6. Which of the following is true concerning the mainframe?

    • Options
    • A. It is the same thing as client/server.
    • B. Requires someone to decide which code should be on the workstation or the server.
    • C. Mission-critical systems have tended to remain there.
    • D. All of the above.
    • Discuss
    • 7. Which of the following is true concerning QBE?

    • Options
    • A. An official standard has been defined for QBE.
    • B. QBE cannot be used for client/server systems.
    • C. QBE does not give the programmer a visual programming environment.
    • D. Complete applications can be written using QBE.
    • Discuss
    • 8. Which of the following statements is true about symmetric multiprocessing?

    • Options
    • A. A single copy of the operating system resides in each processor.
    • B. Useful for situations where data must remain in memory to process.
    • C. Bottlenecks increase with uniprocessor systems because tasks are not shared.
    • D. The problems of memory contention are unlikely.
    • Discuss
    • 9. Which of the following items are not necessary for client/server?

    • Options
    • A. Assure that tools will connect with middleware.
    • B. Understand the requirements.
    • C. Determine network bandwidth capabilities.
    • D. Include the use of a file server.
    • Discuss
    • 10. A snowflake schema is which of the following types of tables?

    • Options
    • A. Fact
    • B. Dimension
    • C. Helper
    • D. All of the above
    • Discuss


    Comments

    There are no comments.

Enter a new Comment