Question 1

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database.
A) report
B) data model
C) database administrative function
D) query
E) pull function

Accepted Answer

Query is a specific request for data in a database. Brenda can use a query to obtain the sales analysis data for the second and third quarter of the year.

Question 2

Browser-based applications ________.
A) are thick-client applications
B) can display only static content
C) support graphical queries
D) process queries using C++
E) process queries without using SQL

Accepted Answer

Browser-based applications support graphical queries, allowing users to interact with data and information through graphical interfaces. They are typically thin-client applications that run on the user's web browser, and while they can process queries, they typically do so using web-based technologies like JavaScript and SQL rather than C++. They can also display dynamic and interactive content, not just static content.

Question 3

Which of the following is True of traditional database application programs?
A) Application forms, reports, and queries are displayed and processed using a browser application.
B) The application logic is contained in a program on the client-side computer.
C) They are written in object-oriented languages such as C++ and VisualBasic.
D) They are thin-client applications that need not be preinstalled on the users' computers.
E) They are cloud-based applications that need not be preinstalled on the users' computers.

Accepted Answer

The answer of Which of the following is True of...

Question 4

Most traditional databases use the Internet to transmit traffic back and forth between the users' computers and the DBMS server.

Accepted Answer

Traditional databases can operate on local networks (LANs) and do not necessarily require the Internet to transmit data between users' computers and the DBMS server.

Question 5

A(n) ________ is a request for data from a database.
A) form
B) report
C) query
D) application
E) db pull

Accepted Answer

A query is a specific request for data from a database, whereas a form is typically used for data entry or updating records, a report is a pre-formatted display of data, an application refers to a software program, and "db pull" is not a recognized term in database terminology.

Question 6

Browser-based applications ________.
A) need to be preinstalled on the users' computers
B) run within a corporate network that is protected from the Internet
C) eliminate the need to check for data consistency
D) are more vulnerable to security threats than are traditional applications
E) do not need to be encrypted

Accepted Answer

Browser-based applications are more exposed to the broader internet, making them more susceptible to security threats compared to traditional applications that might operate within more controlled environments.

Question 7

Charles and Irene are editors at a content development firm. Both of them, unknowingly, are working on the same copy of the annual report. Irene finishes editing the report and saves her copy; Charles saves his report an hour after Irene. Charles's report overwrites Irene's, and her changes are lost. This scenario is an example of the ________.
A) lost-update problem
B) crow's-foot paradigm
C) bullwhip effect
D) update query problem
E) bait-and-switch problem

Accepted Answer

The situation described is known as the lost-update problem, which occurs when two or more users access the same data simultaneously, and the changes made by one user are overwritten by the changes made by another user.

Question 8

Browser applications are thin-client applications that need to be preinstalled on the users' computers.

Accepted Answer

Browser applications are not preinstalled on users' computers. They can be accessed through a web browser without the need for installation.

Question 9

Explain the functioning of browser applications.

Accepted Answer

The answer of Explain the functioning of browser applications....

Question 10

Which of the following is True of single-user databases?
A) They are displayed and processed using HTML5, CSS3, and JavaScript.
B) They use JavaScript for user-side processing.
C) The Internet is used to access the DBMS server computer.
D) The application, the DBMS, and the database all reside on the user's computer.
E) They run on clustered Linux or Unix systems

Accepted Answer

Single-user databases run on the user's computer, so the application, DBMS, and database are all located on the same device.  Options A, B, C, and E do not accurately describe single-user databases.

Question 11

Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations.

Accepted Answer

Reports commonly involve the organization and manipulation of data through techniques such as sorting, grouping, filtering, and summarizing.

Question 12

What is a database application?

Accepted Answer

The answer of What is a database application?...

Question 13

Browser applications are thin-client applications that ________.
A) use COBOL as the standard language for user-side processing
B) are processed using VisualBasic and C++
C) need not be preinstalled on the users' computers
D) depend on internal networks and not the Internet to transmit data
E) do not need to be encrypted

Accepted Answer

Browser applications are web-based applications that can be accessed using a web browser and do not require preinstallation on the users' computers.

Question 14

Which of the following is used to process and display browser database application forms, reports, and queries?
A) C++
B) HTML
C) COBOL
D) VisualBasic
E) DB2

Accepted Answer

HTML is the standard markup language used for creating web pages and is specifically designed for displaying content on browsers. It can be used to create database application forms, reports, and queries that can be processed and displayed on a webpage.

Question 15

What are traditional database applications?

Accepted Answer

The answer of What are traditional database applications?...

Question 16

The lost-update problem can be resolved by implementing single-user database processing.

Accepted Answer

The lost-update problem cannot be resolved by implementing single-user database processing as it only allows a single user to access the database at a time, and does not address the issue of multiple users accessing and potentially updating the same data simultaneously. Other methods such as locking, transactions, and concurrency control are typically used to address the lost-update problem in multi-user database environments.

Question 17

State the purposes of the four elements of a database application.

Accepted Answer

The answer of State the purposes of the four elements...

Question 18

Katrina is a sales representative for an online retailer. She needs to update her customer list with new contact information for five customers. Which of the following elements will help Katrina modify her data?
A) reports
B) forms
C) queries
D) operations
E) triggers

Accepted Answer

Forms are used to input and modify data in a user-friendly way. Katrina can use a form to update her customer list with the new contact information. Reports would be used to present data in a readable format, queries are used to filter and extract specific data, operations and triggers are not relevant to modifying customer information.

Question 19

Traditional database application programs are ________.
A) browser-based and display dynamic content
B) written in languages such as HTML5 and JavaScript
C) entirely dependent on the database server for application logic
D) thick applications that need to be installed on users' computers
E) cloud-based applications

Accepted Answer

Traditional database application programs are thick applications that need to be installed on users' computers, which means that they do not rely on the browser or the database server for application logic. They are written in languages such as Java, C++, or .NET, and they interact with the database server via SQL or other database drivers.

Question 20

Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.

Accepted Answer

Locking is a technique used to control and coordinate the access of multiple users or processes to shared resources, such as files or database records, to prevent them from interfering with each other and to ensure consistency and integrity of the data. One of the main problems that locking tries to solve is the lost-update problem, which occurs when two or more users try to update the same data concurrently, and one of the updates overwrites or cancels out the other, leading to inconsistent or incorrect results. By using locking, each user can acquire exclusive or shared access to the data, and release it only after completing their transaction or operation, thus preventing conflicts and preserving atomicity, consistency, isolation, and durability (ACID) properties of the database. Therefore, the statement is true.

Quiz 5: Database Processing

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database.

Browser-based applications ________.

Which of the following is True of traditional database application programs?

Most traditional databases use the Internet to transmit traffic back and forth between the users' computers and the DBMS server.

A(n) ________ is a request for data from a database.

Browser-based applications ________.

Browser applications are thin-client applications that need to be preinstalled on the users' computers.

Explain the functioning of browser applications.

Which of the following is True of single-user databases?

Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations.

What is a database application?

Browser applications are thin-client applications that ________.

Which of the following is used to process and display browser database application forms, reports, and queries?

What are traditional database applications?

The lost-update problem can be resolved by implementing single-user database processing.

State the purposes of the four elements of a database application.

Katrina is a sales representative for an online retailer. She needs to update her customer list with new contact information for five customers. Which of the following elements will help Katrina modify her data?

Traditional database application programs are ________.

Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.