Question 1

Horizontal partitioning is when different rows in a database are assigned to different database servers.

Accepted Answer

Horizontal partitioning involves dividing a database table into smaller, more manageable pieces, where each partition contains a subset of the rows, and these partitions can be distributed across different database servers.

Question 2

Vertical partitioning is when different columns in a database are assigned to different database servers.

Accepted Answer

Vertical partitioning involves distributing different columns of a database table across multiple database servers to improve performance and manageability.

Question 3

Data replication duplicates some or all tables (rows and columns) on more than one database server.

Accepted Answer

Data replication involves copying data from one database server to another, which can include duplicating entire tables or specific rows and columns to ensure data availability and redundancy.

Question 4

Vertical replication is when different columns in a database are replicated to different database servers.

Accepted Answer

Vertical replication refers to the replication of different rows, not columns, across different database servers.

Question 5

In batch processing, transactions are accumulated into batches for periodic processing. The batch inputs are processed to update databases and produce appropriate reports.

Accepted Answer

Batch processing involves collecting transactions over a period and processing them together, updating databases and generating reports as needed.

Question 6

In online processing, a group of transactions are placed in a line for periodic updates to the database at a later point in time.

Accepted Answer

The statement describes batch processing, not online processing. Online processing involves immediate processing and updating of transactions.

Question 7

Batch input technologies are obsolete.

Accepted Answer

Batch input technologies are still used in various industries for processing large volumes of data efficiently, especially in legacy systems and environments where real-time processing is not required.

Question 8

Contrary to popular belief, batch input technologies are not quite obsolete.

Accepted Answer

Batch input technologies are still used in certain industries and applications where they are efficient and cost-effective, despite the rise of real-time processing technologies.

Question 9

The majority of systems have slowly evolved from on-line processing to batch processing.

Accepted Answer

Batch processing was the earlier method used in computing, and systems have evolved from batch processing to online processing, not the other way around.

Question 10

Typically, many businesses must commit to a data format to make EDI feasible.

Accepted Answer

Businesses often need to standardize their data format to ensure compatibility and efficiency in Electronic Data Interchange (EDI) systems.

Question 11

Electronic data interchange (EDI) is the standardized electronic flow of business transactions or data between businesses.

Accepted Answer

EDI is a system that allows businesses to exchange documents and data in a standardized electronic format, facilitating efficient and accurate communication between different organizations.

Question 12

Electronic data interchange (EDI) is the latest technique for sharing data between businesses in a flexible, non-standard format to facilitate data sharing and transaction update in a natural language format.

Accepted Answer

EDI is a standardized method for exchanging business documents between organizations in a structured, machine-readable format, not in a flexible or natural language format.

Question 13

Image and document interchange is similar to EDI except that the actual images of forms and data are transmitted and received.

Accepted Answer

Image and document interchange involves the transmission of actual images of forms and data, whereas EDI (Electronic Data Interchange) typically involves the exchange of structured data without images.

Question 14

Image and document interchange is particularly useful in applications in which the form images or graphics are required.

Accepted Answer

Image and document interchange is useful in applications where form images or graphics are needed, as it allows for the seamless exchange and integration of visual content across different platforms and formats.

Question 15

Middleware products allow the programmers to ignore underlying communication protocols.

Accepted Answer

Middleware products abstract the complexity of communication protocols, enabling developers to focus on application logic rather than the intricacies of network communication.

Question 16

Presentation middleware allows a programmer to build user interface components that can talk to web browsers or desktop GUI.

Accepted Answer

Presentation middleware facilitates communication between user interface components and web browsers or desktop GUIs, enabling the development of interactive applications.

Question 17

Application middleware enables two programmer-written processes on different processors to communicate with one another in whatever way is best suited to the overall application. It is essential to multi-tier application development.

Accepted Answer

Application middleware facilitates communication between processes on different systems, supporting multi-tier architectures by providing necessary services and abstractions.

Question 18

Database middleware allows a programmer to pass SQL commands to a database engine for processing though a standard application program interface (API).

Accepted Answer

Database middleware provides an API that enables applications to communicate with a database engine, allowing SQL commands to be passed and processed.

Question 19

Remote procedure calls (RPCs), message queues and object request brokers are examples of presentation middleware.

Accepted Answer

RPCs, message queues, and object request brokers are examples of communication middleware, not presentation middleware. Presentation middleware deals with the user interface and presentation logic.

Question 20

Object database connectivity (ODBC) automatically translates SQL commands for one database server for use on a different database server.

Accepted Answer

ODBC is a standard interface that allows applications to access data from a variety of database systems using a common set of function calls. ODBC automatically translates SQL commands for one database server for use on a different database server, making it easy to develop applications that can access data from multiple sources.

Quiz 13: Application Architecture and Modeling