Client Server Database Which of the following statements is true about symmetric multiprocessing? Bottlenecks increase with uniprocessor systems because tasks are not shared. Useful for situations where data must remain in memory to process. The problems of memory contention are unlikely. A single copy of the operating system resides in each processor. Bottlenecks increase with uniprocessor systems because tasks are not shared. Useful for situations where data must remain in memory to process. The problems of memory contention are unlikely. A single copy of the operating system resides in each processor. ANSWER DOWNLOAD EXAMIANS APP
Client Server Database 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. True False True False ANSWER DOWNLOAD EXAMIANS APP
Client Server Database A benefit of the three-tier architecture is which of the following? Performance improves for compiled SQL statements New modules can be built to support specific business needs All of these Results in a thinner client and database server Performance improves for compiled SQL statements New modules can be built to support specific business needs All of these Results in a thinner client and database server ANSWER DOWNLOAD EXAMIANS APP
Client Server Database Stored procedures have which of the following advantages? Network traffic increases. Data integrity improves as multiple applications access the same stored procedure. Result in thicker client and thinner database server. 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. It takes a longer time to write them as compared to writing Visual Basic. ANSWER DOWNLOAD EXAMIANS APP
Client Server Database An application program interface (API) is which of the following? Middleware that provides access to a database. The same thing as JDB The same thing as ODB Middleware that does not provide access to a database. Middleware that provides access to a database. The same thing as JDB The same thing as ODB Middleware that does not provide access to a database. ANSWER DOWNLOAD EXAMIANS APP
Client Server Database A characteristic of a file server is which of the following? Acts as a fat client and is shared on a network. Acts as a fat client and is limited to one P Manages file operations and is shared on a network. Manages file operations and is limited to one P Acts as a fat client and is shared on a network. Acts as a fat client and is limited to one P Manages file operations and is shared on a network. Manages file operations and is limited to one P ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS