The Client-Server Database problems
- 1. 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
Correct Answer: A client layer and two server layers
- 2. 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
Correct Answer: Mission-critical systems have tended to remain there.
- 3. 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
Correct Answer: Complete applications can be written using QBE.
- 4. 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
Correct Answer: Useful for situations where data must remain in memory to process.
- 5. 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
Correct Answer: Include the use of a file server.
- 6. Query-by-Example (QBE) is the most widely available direct-manipulation database query language.
Options- A. True
- B. False Discuss
Correct Answer: True
- 7. Massively parallel processing (MPP) systems require a complete copy of the operating system to be resident in each dedicated memory.
Options- A. True
- B. False Discuss
Correct Answer: True
- 8. 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.
Options- A. True
- B. False Discuss
Correct Answer: True
- 9. The database server is responsible for database storage, access, and processing.
Options- A. True
- B. False Discuss
Correct Answer: True
- 10. A fat client is a PC configured for handling user interfaces and some application processing, usually with no or limited local data storage.
Options- A. True
- B. False Discuss
Correct Answer: False
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.