Client Server Database A benefit of the three-tier architecture is which of the following? New modules can be built to support specific business needs Results in a thinner client and database server All of these Performance improves for compiled SQL statements New modules can be built to support specific business needs Results in a thinner client and database server All of these Performance improves for compiled SQL statements ANSWER DOWNLOAD EXAMIANS APP
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 statements is true about symmetric multiprocessing? A single copy of the operating system resides in each processor. The problems of memory contention are unlikely. Useful for situations where data must remain in memory to process. Bottlenecks increase with uniprocessor systems because tasks are not shared. A single copy of the operating system resides in each processor. The problems of memory contention are unlikely. Useful for situations where data must remain in memory to process. Bottlenecks increase with uniprocessor systems because tasks are not shared. ANSWER DOWNLOAD EXAMIANS APP
Client Server Database A characteristic of a file server is which of the following? Manages file operations and is shared on a network. 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 limited to one P Manages file operations and is shared on a network. 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 limited to one P ANSWER DOWNLOAD EXAMIANS APP
Client Server Database Activities of a DBMS occur in the processing component logic. False True False True ANSWER DOWNLOAD EXAMIANS APP
Client Server Database Massively parallel processing (MPP) systems require a complete copy of the operating system to be resident in each dedicated memory. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS