Question 1

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

Accepted Answer

A query is a request for specific data from a database. Forms are used for data input, reports display data in a formatted way, and applications are software programs that can perform a variety of functions.

Question 2

Heidi, an accountant, completed three mandatory training sessions in the last quarter. She needs to update her training record in the company's database. Which of the following elements will help Heidi modify her data?
A)reports
B)forms
C)queries
D)operations

Accepted Answer

Forms are user interfaces that allow Heidi to view and modify data in the company database. It is the best choice for her to update her training record as it provides a more user-friendly and structured layout compared to other database elements. Reports and queries may not be suitable as they are more focused on retrieving data and analyzing trends rather than inputting new data. Operations may refer to various actions that can be performed on the database, but it does not provide a direct way for Heidi to modify her training record.

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

This is a correct definition of reports.

Question 5

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

Accepted Answer

Browser applications are web-based applications that can be accessed through a web browser without the need for pre-installation on users' computers.

Question 6

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.

Accepted Answer

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

Question 7

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

Accepted Answer

Traditional database application programs are thick applications that need to be installed on users' computers. They are not browser-based and do not display dynamic content. They are also not typically written in languages such as html5 and JavaScript. While they do use the database server for data storage and retrieval, they usually have their own embedded application logic.

Question 8

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

Accepted Answer

A query is a request for specific information from a database. By using a query, Brenda can extract relevant data from the database, such as sales figures from the second and third quarter of the year, and create a report that meets her specific needs. A report is an output of a query, and a data model is a visual representation of how data is organized in a database. Database administrative functions refer to tasks related to managing and maintaining a database, such as creating backups or optimizing performance.

Question 9

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

Accepted Answer

This scenario is an example of the lost-update problem, which occurs when two or more users attempt to update the same data simultaneously, and their changes conflict resulting in the loss of data.

Question 10

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 11

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

Accepted Answer

Browser-based applications support graphical queries, which means that users can interact with the application by clicking and dragging elements on the screen. They are typically thin-client applications, meaning that most of the processing is done on the server rather than on the client's computer. They can also display dynamic content, meaning that the content can change and update in real-time based on user input or data from external sources. They are typically programmed using web technologies such as HTML, JavaScript, and CSS.

Question 12

Explain the functioning of browser applications.

Accepted Answer

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

Question 13

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.

Accepted Answer

Single-user databases are designed to be used by one user at a time, and typically the application, the database management system, and the database itself all reside on the user's computer. It does not require the use of the Internet and does not use html5, css3, or JavaScript for user-side processing.

Question 14

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

Accepted Answer

The lost-update problem is a concurrency issue that occurs in multi-user database processing environments. Single-user processing does not solve this problem as it may still occur if multiple applications access the database simultaneously. The lost-update problem can be resolved by using techniques such as locking, transactions, and isolation levels to ensure data consistency and prevent multiple users from overwriting each other's updates.

Question 15

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

Accepted Answer

Locking is a mechanism to prevent multiple users from accessing and modifying the same data at the same time. It helps to coordinate the activities of users and prevent conflicts such as the lost-update problem, where changes made by one user may be overwritten by another, leading to data inconsistency. Therefore, locking is necessary to ensure data integrity and consistency in multi-user environments.

Question 16

What is a database application?

Accepted Answer

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

Question 17

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

Accepted Answer

Browser applications are accessed through web browsers and do not need to be preinstalled on the users' computers. They are typically written in HTML, CSS, and JavaScript, and can be used across different operating systems and devices. COBOL and VisualBasic/C++ are not commonly used for browser application development. Browser applications also rely on the Internet to transmit data, rather than internal networks.

Question 18

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

Accepted Answer

HTML (Hypertext Markup Language) is commonly used to create web pages and handle browser-based database application forms, reports, and queries. It can be used to structure and display content, as well as interact with server-side programming languages to process and manipulate data. C++, COBOL, and Visual Basic are programming languages that can be used to build software applications, but they are not typically used for web development or browser-based database applications.

Question 19

What are traditional database applications?

Accepted Answer

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

Question 20

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

Accepted Answer

Browser-based applications are accessed over the internet and are more exposed to security threats compared to traditional applications that may run in more controlled environments.

Quiz 5: Database Processing

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

Heidi, an accountant, completed three mandatory training sessions in the last quarter. She needs to update her training record in the company's database. Which of the following elements will help Heidi modify her data?

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

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

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

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

Traditional database application programs are ________.

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.

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

Browser-based applications ________.

Explain the functioning of browser applications.

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

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

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

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?

Browser-based applications ________.