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
- 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
The Client-Server Database problems
Search Results
Correct Answer: Database storage
Correct Answer: Data integrity improves as multiple applications access the same stored procedure.
Correct Answer: Middleware that provides access to a database.
Correct Answer: All of the above.
Correct Answer: Manages file operations and is shared on a network.
Correct Answer: Mission-critical systems have tended to remain there.
Correct Answer: Complete applications can be written using QBE.
Correct Answer: Useful for situations where data must remain in memory to process.
Correct Answer: Include the use of a file server.
Correct Answer: All of the above
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.