The Client-Server Database problems
- 1. A benefit of the three-tier architecture is which of the following?
Options- A. New modules can be built to support specific business needs
- B. Performance improves for compiled SQL statements
- C. Results in a thinner client and database server
- D. All of the above. Discuss
Correct Answer: New modules can be built to support specific business needs
- 2. Which of the following statements is true concerning JDBC?
Options- A. It is language independent.
- B. It is similar in concept to ODBC.
- C. It is useful for all object-oriented languages.
- D. It consists of three main layers. Discuss
Correct Answer: It is similar in concept to ODBC.
- 3. The three different application logic components are which of the following?
Options- A. Presentation, Client, and Storage
- B. Presentation, Client, and Processing
- C. Presentation, Processing, and Storage
- D. Presentation, Processing, and Network Discuss
Correct Answer: Presentation, Processing, and Storage
- 4. A server cannot serve on which of the following levels?
Options- A. Client Layer
- B. Business Layer
- C. Database Layer
- D. All of the above. Discuss
Correct Answer: Client Layer
- 5. Client/server security includes which of the following?
Options- A. Physical security
- B. Change control security
- C. Measures taken to secure all systems
- D. All of the above. Discuss
Correct Answer: All of the above.
- 6. 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
Correct Answer: Manages file operations and is shared on a network.
- 7. 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
Correct Answer: All of the above.
- 8. 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
Correct Answer: Middleware that provides access to a database.
- 9. 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
Correct Answer: Data integrity improves as multiple applications access the same stored procedure.
- 10. 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
Correct Answer: Database storage
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.