Which of the following items are not necessary for client/server? Include the use of a file server. Understand the requirements. Assure that tools will connect with middleware. Determine network bandwidth capabilities. TRUE ANSWER : ? YOUR ANSWER : ?
Activities of a DBMS occur in the processing component logic. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is true concerning the mainframe? Mission-critical systems have tended to remain there. All of these Requires someone to decide which code should be on the workstation or the server. It is the same thing as client/server. TRUE ANSWER : ? YOUR ANSWER : ?
A benefit of the three-tier architecture is which of the following? All of these Results in a thinner client and database server New modules can be built to support specific business needs Performance improves for compiled SQL statements TRUE ANSWER : ? YOUR ANSWER : ?
Centralized systems are more susceptible to security threats than client/server architectures. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)? Requires certain criteria to be met in order to establish an ODBC connection. All of these Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed. Each vendor desiring to be ODBC-complaint provides an ODBC driver. TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following statements is true about symmetric multiprocessing? Bottlenecks increase with uniprocessor systems because tasks are not shared. The problems of memory contention are unlikely. Useful for situations where data must remain in memory to process. A single copy of the operating system resides in each processor. TRUE ANSWER : ? YOUR ANSWER : ?
The database server is responsible for database storage, access, and processing. False True TRUE ANSWER : ? YOUR ANSWER : ?
An application program interface (API) is which of the following? The same thing as JDB Middleware that provides access to a database. Middleware that does not provide access to a database. The same thing as ODB TRUE ANSWER : ? YOUR ANSWER : ?