Database - The Client -Server Database
Database - The Client -Server Database
1. Which of the following statements is true about symmetric multiprocessing?
- A single copy of the operating system resides in each processor.
- Useful for situations where data must remain in memory to process.
- Bottlenecks increase with uniprocessor systems because tasks are not shared
- The problems of memory contention are unlikely.
2. Which of the following items are not necessary for client/server?
- Assure that tools will connect with middleware.
- Understand the requirements.
- Determine network bandwidth capabilities.
- Include the use of a file server.
3. A benefit of the three-tier architecture is which of the following?
- New modules can be built to support specific business needs
- Performance improves for compiled SQL statements
- Results in a thinner client and database server
- All of the above.
4. Which of the following statements is true concerning JDBC?
- It is language independent.
- It is similar in concept to ODBC.
- It is useful for all object-oriented languages.
- It consists of three main layers.
5. A characteristic of a file server is which of the following?
- Manages file operations and is shared on a network.
- Manages file operations and is limited to one PC.
- Acts as a fat client and is shared on a network.
- Acts as a fat client and is limited to one PC.
6. Stored procedures have which of the following advantages?
- It takes a longer time to write them as compared to writing Visual Basic.
- Network traffic increases
- Data integrity improves as multiple applications access the same stored procedure.
- Result in thicker client and thinner database server.
7. Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
- Each vendor desiring to be ODBC-complaint provides an ODBC driver.
- Requires certain criteria to be met in order to establish an ODBC connection.
- Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.
- All of the above.
8. Which of the following is true concerning QBE?
- An official standard has been defined for QBE.
- QBE cannot be used for client/server systems.
- QBE does not give the programmer a visual programming environment.
- Complete applications can be written using QBE.
9. Client/server security includes which of the following?
- Physical security
- Change control security
- Measures taken to secure all systems
- All of the above.
10. An application program interface (API) is which of the following?
- The same thing as ODBC.
- Middleware that does not provide access to a database.
- Middleware that provides access to a database.
- The same thing as JDBC.