Database Application Transaction Processing_Chapter_4

FIFO stands for _____. 1. faster in, faster out 2. for information, for observation 3. for input, for output 4. first in, first out

first in, first out

Approximately how many potential web application users are there on the planet as of 2020? 500 Million 2 Billion 4.6 Billion 1 Billion

4.6 Billion

The .NET framework consists mostly of what? 1. Code 2. Techniques 3. Classes (objects) 4. Programs

Classes (objects)

While a transaction was processing, an update to the servers caused a reset. However, the transaction was still committed. What best describes the component of ACID in this scenario? 1. Atomic 2. Isolated 3. Durable 4. Consistent

Durable

When considering the ACID principles, which of the following best support each other directly? 1. Durable, atomic 2. Durable, rollback 3. Atomic, write 4. Isolated, durable

Durable, atomic

In a batch processing model, the executing jobs that are being processed by the computer are often said to be running... ... with elevated priority. ... in a multi-threaded environment. ... in the background. ... quickly.

... in the background.

The property that determines if a batch job is executed faster or slower than others is referred to as its ... ... popularity. ... polarity. ... affinity. ... priority.

... priority.

Which of the following are characteristics of web applications? Displays Information in a Web Browser Runs Remotely Stored Remotely All of the answers are correct.

All of the answers are correct.

Which of the following is a characteristic of .NET? 1. All of these answers are correct 2. It provides developers with tools 3. It is cross-platform 4. It is consistent

All of these answers are correct

You are planning a vacation to Europe next summer after saving money over several years. You go online and select an airline flight to take you there on your desired travel date and time. You select your preferred seat and complete the transaction. The airline later sends you a confirmation message but the booking includes a different flight and time. What problem most likely occurred during transaction processing?

An error was made during the data collection phase booking you on a different flight.

Which of the following is NOT a feature of .NET? 1. A robust development environment 2. A layered approach 3. Multiple programming language support 4. An inconsistent look and approach

An inconsistent look and approach

As a transaction is being performed, only part of it can be processed. Instead of saving only part of the data, the transaction is rolled back. What best describes the nature of the transaction? 1. Consistent 2. Isolated 3. Atomic 4. Durable

Atomic

Which of the following is NOT a typical activity of a Transaction Processing System? Data editing Data collection Data storage Data analysis

Data analysis

Consider a database application that updates stock prices. It has been written so that the stock price of a given stock is updated only if an unrelated stock is also changed. What component of ACID does this violate? 1. Consistency 2. Atomic 3. Durability 4. Isolation

Isolation.

What is the main distinguishing feature of a batch processing system?

It accumulates one or more transactions over a period of time before processing them at a later scheduled time.

Which of the following is NOT usually done with a web application? Shopping Mathematics Travel Navigation

Mathematics

Which of the following is NOT an environment supported by .NET? 1. Linux 2. Mac 3. iOS 4. Pascal

Pascal

Which of the following is NOT a specific type of transaction processing system? Purchasing system Performance evaluation Accounting system Order processing

Performance evaluation

Which of the following is a good example of batch processing? Word processing a document Purchasing goods online Listening to an online music service Printing out paychecks

Printing out paychecks

These are the most common operations in a database application transaction. 1. Read, delete 2. Rollback, write 3. Read, write 4. Write, commit

Read, write

Which of the following is NOT one of the uses of a database application? 1. Listing sales data 2. Storing customer data 3. Organizing payroll data 4. Selling products

Selling products.

Which is NOT a typical example of the types of data that can be stored into a database? 1. Product inventory 2. Social media posts 3. Sales numbers 4. Contact information

Social media posts.

What is the main difference between a database and a database application? 1. The database application contains the collection of information and data, while the database is the software used to organize this data. 2. The database is the search tool used to find the data, while the database application is the spreadsheet used. 3. The database application is used as a chart with rows and columns of data, while the database is the software that may be called a database management system. 4. The database contains the collection of information and data, while the database application is the software used to organize this data.

The database contains the collection of information and data, while the database application is the software used to organize this data.

What is the reason why web applications have a significant effect on BIS? None of the answers are correct. The amount of equipment involved. The way businesses interact with customers. The large number of people worldwide with Internet access.

The large number of people worldwide with Internet access.

.NET is meant to save a developer _____ on the mundane things. 1. Time and testing 2. Time and money 3. Time and energy 4. Energy and testing

Time and energy

For many years, all commercial transactions were handled with paper invoices and handwritten inventory logs. With the advent of computers and the internet, businesses had many new options available to them. What is the value of a transaction processing system to an organization?

Transaction processing enables businesses to monitor inventory carefully and reorder new shipments quickly.

MapQuest is an example of what category of web application? Travel None of the answers are correct. Shopping Navigation

Travel

Jobs that run in a batch processing environment... ... waste valuable resources that would otherwise be used by end users. ... only run in the evenings and weekends. ... can be executed at any point, and may use different priority settings to manage their impact on other jobs and users. ... need to be executed with a user to control and manage their outputs.

can be executed at any point, and may use different priority settings to manage their impact on other jobs and users.

All of the following can refer to a type of software that is used to store data, except _____. 1. database management system 2. database application 3. database software 4. database

database.

The type of database that stores journals and magazine articles is called a _____. research database library database corporate database news database

library database