The Client-Server Database Questions

• A benefit of the three-tier architecture is which of the following?
• Which of the following statements is true concerning JDBC?
• The three different application logic components are which of the following?
• A server cannot serve on which of the following levels?
• Client/server security includes which of the following?
• A characteristic of a file server is which of the following?
• Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
• An application program interface (API) is which of the following?
• Stored procedures have which of the following advantages?
• A database server is responsible for which of the following?
• Three-tier architecture includes which of the following?
• Which of the following is true concerning the mainframe?
• Which of the following is true concerning QBE?
• Which of the following statements is true about symmetric multiprocessing?
• Which of the following items are not necessary for client/server?
• Query-by-Example (QBE) is the most widely available direct-manipulation database query language.
• Massively parallel processing (MPP) systems require a complete copy of the operating system to be resident in each dedicated memory.
• Client/server environments use a local area network (LAN) to support a network of personal computers, each with its own storage, that are also able to share common devices and software attached to the LAN.
• The database server is responsible for database storage, access, and processing.
• A fat client is a PC configured for handling user interfaces and some application processing, usually with no or limited local data storage.