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. False True TRUE ANSWER : ? YOUR ANSWER : ?
A benefit of the three-tier architecture is which of the following? Performance improves for compiled SQL statements Results in a thinner client and database server New modules can be built to support specific business needs All of these TRUE ANSWER : ? YOUR ANSWER : ?
Stored procedures have which of the following advantages? 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. TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is true concerning QBE? QBE does not give the programmer a visual programming environment. An official standard has been defined for QB QBE cannot be used for client/server systems. Complete applications can be written using QB TRUE ANSWER : ? YOUR ANSWER : ?
The database server is responsible for database storage, access, and processing. False True TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following statements is true about symmetric multiprocessing? 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. TRUE ANSWER : ? YOUR ANSWER : ?
Three-tier architecture includes which of the following? Two client layers and one server layer Three server layers Three client layers A client layer and two server layers 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 : ?
An application program interface (API) is which of the following? The same thing as JDB Middleware that provides access to a database. The same thing as ODB Middleware that does not provide access to a database. TRUE ANSWER : ? YOUR ANSWER : ?