logo

CuriousTab

CuriousTab

Discussion


Home Database The Client-Server Database Comments

  • Question
  • 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.

  • Correct Answer
  • Complete applications can be written using QBE. 


  • The Client-Server Database problems


    Search Results


    • 1. 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
    • 2. 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
    • Discuss
    • 3. 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
    • 4. 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
    • 5. 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
    • 6. 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
    • 7. 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
    • 8. A snowflake schema is which of the following types of tables?

    • Options
    • A. Fact
    • B. Dimension
    • C. Helper
    • D. All of the above
    • Discuss
    • 9. Fact tables are which of the following?

    • Options
    • A. Completely denoralized
    • B. Partially denoralized
    • C. Completely normalized
    • D. Partially normalized
    • Discuss
    • 10. An operational system is which of the following?

    • Options
    • A. A system that is used to run the business in real time and is based on historical data.
    • B. A system that is used to run the business in real time and is based on current data.
    • C. A system that is used to support decision making and is based on current data.
    • D. A system that is used to support decision making and is based on historical data.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment