Client Server Database Symmetric multiprocessing (SMP) architectures are useful for situations where data must remain in memory during processing to achieve the desired performance level. True False True False ANSWER DOWNLOAD EXAMIANS APP
Client Server Database Which of the following items are not necessary for client/server? Determine network bandwidth capabilities. Understand the requirements. Include the use of a file server. Assure that tools will connect with middleware. Determine network bandwidth capabilities. Understand the requirements. Include the use of a file server. Assure that tools will connect with middleware. 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 Middleware that does not provide access to a database. The same thing as ODB Middleware that provides access to a database. The same thing as JDB Middleware that does not provide access to a database. The same thing as ODB ANSWER DOWNLOAD EXAMIANS APP
Client Server Database A server cannot serve on which of the following levels? Business Layer Client Layer Database Layer All of these Business Layer Client Layer Database Layer All of these ANSWER DOWNLOAD EXAMIANS APP
Client Server Database Which of the following statements is true about symmetric multiprocessing? A single copy of the operating system resides in each processor. The problems of memory contention are unlikely. Bottlenecks increase with uniprocessor systems because tasks are not shared. Useful for situations where data must remain in memory to process. A single copy of the operating system resides in each processor. The problems of memory contention are unlikely. Bottlenecks increase with uniprocessor systems because tasks are not shared. Useful for situations where data must remain in memory to process. ANSWER DOWNLOAD EXAMIANS APP
Client Server Database 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. Result in thicker client and thinner database server. Data integrity improves as multiple applications access the same stored procedure. It takes a longer time to write them as compared to writing Visual Basic. Network traffic increases. Result in thicker client and thinner database server. Data integrity improves as multiple applications access the same stored procedure. ANSWER DOWNLOAD EXAMIANS APP