Question 1

Software building blocks that are used to assure that common system capabilities like user interfaces and printing are standardized as well as modules for facilitating the data exchange between clients and servers best describes:
A)firmware
B)a software patch
C)a database management system
D)an application program interface

Accepted Answer

An application program interface (API) is a set of software building blocks used to standardize common system capabilities and facilitate data exchange between clients (e.g., user interfaces) and servers (e.g., databases). Firmware refers to software that is embedded in hardware devices, while a software patch is a corrective update to fix bugs or security vulnerabilities in software. A database management system is software used to manage and organize databases.

Question 2

A computing server where data analysis functions primarily reside best defines:
A)file server
B)analytical server
C)dedicated server
D)application server

Accepted Answer

The answer of A computing server where data analysis functions...

Question 3

Which of the following client/server architectures freshens up the delivery of existing server-based applications to distributed clients?
A)distributed function
B)remote presentation
C)remote data management
D)distributed presentation

Accepted Answer

Distributed presentation architecture allows existing server-based applications to be delivered to distributed clients with a fresh user interface and improved performance. This architecture focuses on distributing the presentation layer across multiple client machines while keeping the business logic and data management on the server. It provides a better user experience, reduced network traffic, and improved scalability.

Question 4

Which of the following functions transforms inputs into outputs,including simple summarization to complex mathematical modeling like regression analysis?
A)data analysis
B)data presentation
C)data management
D)transport management

Accepted Answer

Data analysis involves transforming inputs into outputs, including summarization and mathematical modeling like regression analysis. Data presentation is focused on visualizing data results. Data management includes activities like data storage, integration, and retrieval. Transport management is unrelated to data analysis.

Question 5

A LAN-based computing environment in which a central database server or engine performs all database commands sent to it from client workstations,and in which application programs on each client concentrate on user interface functions,describes a:
A)file server environment
B)client/server architecture
C)bus architecture
D)metropolitan area network

Accepted Answer

The description is referring to a client/server architecture, where the central database server performs all the database commands and client workstations access the database through this server. The client workstations focus on user interface functions, while the server handles the processing and storage of data. This type of architecture is common in corporate environments where multiple users need to access the same database. A file server environment typically refers to a central file server that allows users to access files, but not necessarily a database. Bus architecture and metropolitan area network refer to different types of network topologies and are not relevant to the description given.

Question 6

Which of the following is a combination of hardware,software,and communication technologies that bring together data management,presentation,and analysis into a three-tiered client/server environment?
A)middleware
B)transparency software
C)presentation software
D)partitioning software

Accepted Answer

Middleware is a combination of hardware, software, and communication technologies that bring together data management, presentation, and analysis into a three-tiered client/server environment. It acts as a bridge between different applications and databases, enabling them to exchange data seamlessly. Transparency software, presentation software, and partitioning software are not necessarily components of middleware.

Question 7

Which of the following is a file server limitation?
A)decentralized data control
B)need for powerful client workstations
C)excessive data movement
D)all of the above

Accepted Answer

All of the given options are file server limitations.

- Decentralized data control: A file server requires a centralized approach to data management, which means that all data is stored and controlled in one central location. This can be a limitation for organizations that need to have more distributed data control.
- Need for powerful client workstations: A file server can require powerful client workstations to effectively access and manipulate data on the server. This can be a limitation for organizations with a limited budget or older technology.
- Excessive data movement: A file server can require excessive data movement, as clients access and transfer data to and from the server. This can be a limitation for organizations with limited bandwidth or slow network connections.

Question 8

Which of the following functions manages just the interface between system users and the software,including the display and printing of forms and reports and possibly validating system inputs?
A)data analysis
B)data presentation
C)data management
D)transport management

Accepted Answer

The function described in the question is data presentation, which is concerned with managing the interface between system users and the software, including the display and printing of forms and reports and validating system inputs. Data analysis involves manipulating and analyzing data to derive insights and inform decision-making. Data management involves activities like storing, retrieving, and maintaining data. Transport management refers to the management of transportation operations, such as shipping and logistics.

Question 9

The primary difference between an application built using the client/server architecture and a centralized database system on a mainframe is that:
A)in a mainframe environment,all interactions with the user and local devices are handled by local intelligent terminals
B)in a client/server environment,each client is an intelligent part of the application processing system
C)in a client/server environment,all parts of the information system are managed and executed by the central computer
D)none of the above

Accepted Answer

In a client/server environment, each client acts as an intelligent part of the application processing system, and is responsible for interacting with the user and local devices. In contrast, a centralized database system on a mainframe typically relies on local intelligent terminals to handle interactions with the user and devices, and all parts of the information system are managed and executed by the central computer. Therefore, option B is the most appropriate choice, as it correctly identifies the primary difference between these two architectures.

Question 10

Which of the following statements regarding the differences between file server and client/server architectures is true?
A)While the file server architecture involves efficient data transfers,the client/server architecture has large file and data transfers.
B)Servers and clients perform processing in a file server architecture.Only servers perform processing in a client/server architecture.
C)While database security and integrity on a file server architecture is high,it is low on the client/server architecture.
D)While software maintenance on the file server architecture is considered low,software maintenance on the client/server architecture is mixed since some new parts must be delivered to each client.

Accepted Answer

In file server architecture, software maintenance is considered low because updates only need to be made to the one central file server. In client/server architecture, software maintenance can be mixed because updates need to be delivered to each individual client. The other statements are not true regarding the differences between file server and client/server architectures.

Question 11

In the typical client/server architecture:
A)all database recovery,security,and concurrent access management are centralized at the server
B)all database recovery,security,and concurrent access management are moved to the client
C)only database recovery and concurrent access management are centralized at the server
D)database security and recovery are provided by the client

Accepted Answer

In the typical client/server architecture, all database recovery, security, and concurrent access management are centralized at the server. This allows for better control and management of the database, as well as ensuring that security measures are consistent across all clients accessing the server. Moving these functions to the client could result in inconsistent implementation and potential security issues.

Question 12

The front-end portion of the client/server database system that provides the user interface and data manipulation functions describes a(n):
A)client
B)server
C)database engine
D)application program interface

Accepted Answer

The front-end portion of the client/server database system refers to the user interface and data manipulation functions which are typically provided by a client application. Therefore, the best choice is A) client. B) server refers to the back-end portion that stores and manages the data. C) database engine is the software that manages access to the database. D) application program interface (API) refers to a set of standards and protocols for accessing a software application, and is not specific to the front-end of a client/server database system.

Question 13

When using a DBMS in a file server environment:
A)data security checks and file and record locking are done at the file server
B)data security checks and file and record locking are done on the mainframe
C)data security checks and file and record locking are done at the client PCs
D)data security checks are performed at the file server,and file and record locking are done at the client PCs

Accepted Answer

In a file server environment, the client PCs are responsible for handling data security checks and file and record locking, as the file server primarily acts as a storage provider without processing these tasks.

Question 14

Which of the following combines three logical and distinct applications (data management,presentation,and analysis)into a single information system application?
A)analytical server
B)application server
C)three-tiered client/server
D)trinity server

Accepted Answer

A three-tiered client/server architecture separates the system into three distinct layers: data management, presentation, and analysis, allowing for a more organized and efficient information system application.

Question 15

Which of the following functions manages all interaction between software and files and databases,including data retrieval/querying,updating,security,concurrency control,and recovery?
A)data analysis
B)data presentation
C)data management
D)transport management

Accepted Answer

Data management encompasses all of the mentioned functions, including data retrieval, querying, updating, security, concurrency control, and recovery. The other options are not as comprehensive and do not cover all of these aspects of managing data.

Question 16

Which of the following is not a benefit of adopting a client/server architecture?
A)Companies can leverage the benefits of microcomputer technology.
B)Numerous tools for systems design and performance monitoring are available in a client/server environment.
C)It facilitates the use of graphical user interfaces.
D)It allows for and encourages the acceptance of open systems.

Accepted Answer

The answer of Which of the following is not a...

Question 17

Which of the following statements regarding the differences between file server and client/server architectures is true?
A)While database security and integrity are low on a file server architecture,they are high on a client/server architecture.
B)While network usage involves efficient data transfers on a file server architecture,it is not efficient on a client/server architecture.
C)In terms of hardware and system software flexibility,there is less need for coordination between the client and server on a client/server architecture than on a file server architecture.
D)In terms of concurrent data access,concurrent data access is managed by the client in a client/server architecture.

Accepted Answer

In a client/server architecture, the server manages database security and integrity, providing higher levels of both compared to a file server architecture where these responsibilities are often handled by the client, leading to lower security and integrity.

Question 18

Which of the following is a primary reason for creating three-tiered client/server architectures?
A)Applications can be partitioned in a way that best fits the organizational computing needs.
B)Making global changes or customizing processes for individual users is relatively easy.
C)Because data analysis is separate from the user interface,it is a lot easier to change one or both without affecting the other.
D)All of the above.

Accepted Answer

All of the reasons mentioned - partitioning applications to fit organizational needs, easy customizations, and separation of data analysis from user interface - are primary reasons for creating three-tiered client/server architectures.

Question 19

The back-end portion of the client/server database system running on the server and providing database processing and shared access functions describes a(n):
A)intelligent agent
B)server
C)database engine
D)client

Accepted Answer

The back-end portion of a client/server database system, which runs on the server and provides database processing and shared access functions is called the database engine. Option A, intelligent agent, is incorrect as it refers to a software program that uses artificial intelligence to perform tasks on behalf of a user. Option B, server is partially correct, but not specific enough as there can be many types of servers like web server, application server, etc. Option D, client, is incorrect as the client is the front-end portion of the database system that is used by the end-users to interact with the database.

Question 20

Client-based deliveries of applications to users of PCs and workstations are called:
A)client-delivery applications
B)local applications
C)front-end applications
D)back-end applications

Accepted Answer

Front-end applications refer to client-based deliveries of applications to users, as they are the interface through which users interact with the software.

Quiz 12: Designing Distributed and Internet Systems

Software building blocks that are used to assure that common system capabilities like user interfaces and printing are standardized as well as modules for facilitating the data exchange between clients and servers best describes:

A computing server where data analysis functions primarily reside best defines:

Which of the following client/server architectures freshens up the delivery of existing server-based applications to distributed clients?

Which of the following functions transforms inputs into outputs,including simple summarization to complex mathematical modeling like regression analysis?

A LAN-based computing environment in which a central database server or engine performs all database commands sent to it from client workstations,and in which application programs on each client concentrate on user interface functions,describes a:

Which of the following is a combination of hardware,software,and communication technologies that bring together data management,presentation,and analysis into a three-tiered client/server environment?

Which of the following is a file server limitation?

Which of the following functions manages just the interface between system users and the software,including the display and printing of forms and reports and possibly validating system inputs?

The primary difference between an application built using the client/server architecture and a centralized database system on a mainframe is that:

Which of the following statements regarding the differences between file server and client/server architectures is true?

In the typical client/server architecture:

The front-end portion of the client/server database system that provides the user interface and data manipulation functions describes a(n) :

When using a DBMS in a file server environment:

Which of the following combines three logical and distinct applications (data management,presentation,and analysis) into a single information system application?

Which of the following functions manages all interaction between software and files and databases,including data retrieval/querying,updating,security,concurrency control,and recovery?

Which of the following is not a benefit of adopting a client/server architecture?

Which of the following statements regarding the differences between file server and client/server architectures is true?

Which of the following is a primary reason for creating three-tiered client/server architectures?

The back-end portion of the client/server database system running on the server and providing database processing and shared access functions describes a(n) :

Client-based deliveries of applications to users of PCs and workstations are called: