Home / CSE / Database System 2 - CS :: Client Server Database

CSE :: Database System 2 - CS

  1. Three-tier architecture includes which of the following?

  2. A.

     Three server layers

    B.

     A client layer and two server layers

    C.

     Two client layers and one server layer

    D.

     Three client layers


  3. Which of the following is true concerning the mainframe?

  4. 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.


  5. A server cannot serve on which of the following levels?

  6. A.

     Client Layer

    B.

     Business Layer

    C.

     Database Layer

    D.

     All of the above


  7. The three different application logic components are which of the following?

  8. A.

     Presentation, Client, and Storage

    B.

     Presentation, Client, and Processing

    C.

     Presentation, Processing, and Storage

    D.

     Presentation, Processing, and Network


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

  10. A.

     Database storage

    B.

     Data processing logic

    C.

     Data presentation logic

    D.

     All of the above


  11. Activities of a DBMS occur in the processing component logic.

  12. A.

     True

    B.

     False


  13. The presentation logic component is responsible for formatting and presenting data on the user's screen or other output device, and for managing user input from a keyboard or other input device.

  14. A.

     True

    B.

     False


  15. Symmetric multiprocessing (SMP) architectures are useful for situations where data must remain in memory during processing to achieve the desired performance level.

  16. A.

     True

    B.

     False


  17. Massively parallel processing (MPP) systems require a complete copy of the operating system to be resident in each dedicated memory.

  18. A.

     True

    B.

     False


  19. The Windows operating system and Windows applications are event driven.

  20. A.

     True

    B.

     False