Question 1

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.
A) database application
B) database design
C) data field
D) data model

Accepted Answer

A database application is a software program that provides a user interface for interacting with a database. It includes forms for data entry, reports for data analysis, queries for retrieving data, and programs for automating tasks. The database application serves as an intermediary between the user and the database, allowing the user to easily access and manipulate data without needing to know the underlying database structure or programming languages.

Question 2

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 pre-installed on the users' computers.

Accepted Answer

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

Question 3

Which of the following is True of MySQL?
A) It is a Microsoft product.
B) It is license-free for most applications.
C) It is a paid and proprietary database product.
D) It uses Static Query Language (SQL) to manage database.

Accepted Answer

MySQL is an open-source relational database management system and is available for free under the GNU General Public License. It is not a Microsoft product and not a paid and proprietary database product. It uses SQL, but not specifically the Static Query Language (SQL).

Question 4

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 only one user at a time, and usually consist of a single application that includes both the DBMS and the database. All of the processing and data storage is done on the user's computer, without the need for Internet access or server-side processing. Therefore, choice D is the correct answer.

Question 5

Identify the type of task performed by a database administrator when validating the data model to be used in a database management system.
A) development
B) adaptation
C) backup and recovery
D) operation

Accepted Answer

Validating the data model is part of the development process of creating a database management system. Therefore, the task performed by a database administrator in this scenario falls under the development category.

Question 6

Which of the following is an example of a database management system?
A) MS Excel
B) BigData
C) NoSQL
D) Access

Accepted Answer

Access is a database management system (DBMS) that allows users to create, store, and manage data. MS Excel is a spreadsheet software, BigData is a term used to refer to large and complex data sets, and NoSQL is a type of database that uses a non-relational approach to store and manage data.

Question 7

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

Brenda should use a query to retrieve specific information from the database. A query is a way of requesting specific data from a database, and allows the user to specify parameters and filters to obtain exactly the information they need. A report is a presentation of data in a specific format, and a data model is a graphical representation of the structure of the database. A database administrative function relates to managing the technical aspects of the database, such as backup and security.

Question 8

Metadata are ________.
A) codes used for server-side processing
B) error logs of databases
C) data that describe data
D) data that are encrypted

Accepted Answer

Metadata are data that provide information about other data, such as the content, format, and structure of a file, database, or dataset. They do not refer to codes used for server-side processing or error logs, nor are they necessarily encrypted, although some metadata may contain sensitive information and may need to be protected accordingly.

Question 9

Which of the following is a developmental task of database administration?
A) evaluating an application design
B) monitoring backup procedures
C) conducting training for users
D) managing configuration changes in systems

Accepted Answer

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

Question 10

________ allow users to read, insert, modify, and delete data in a database.
A) Reports
B) Forms
C) Queries
D) Operations

Accepted Answer

Forms are used in databases to allow users to read, insert, modify, and delete data.

Question 11

Which of the following database administration tasks is related to adaptation?
A) monitoring backup procedures
B) conducting training for users
C) monitoring database performance
D) managing configuration changes in systems

Accepted Answer

Managing configuration changes in systems is related to adaptation. It involves making necessary changes to the database system to keep it up-to-date with the evolving business requirements. The other tasks listed are important database administration tasks, but are not directly related to adaptation.

Question 12

Which of the following is an international standard language for processing a database?
A) Cassandra
B) DB2
C) SQL
D) MS Access

Accepted Answer

SQL (Structured Query Language) is the international standard language for processing a database. Cassandra, DB2, and MS Access are all database management systems that utilize SQL as a language for querying and manipulating data. However, SQL can also be used independently of any specific database system.

Question 13

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________.
A) primary key
B) key attribute
C) foreign key
D) functionally dependent record

Accepted Answer

A primary key is a column or set of columns in a relational database table that uniquely identifies each row in the table, and in this case, "Employee Number" is used to assign unique numbers to each employee, making it the primary key. choice B) key attribute, and choice D) functionally dependent record are not appropriate in this context, while choice C) foreign key is not mentioned in the given information.

Question 14

Columns that are keys to different tables than the ones in which they reside are called ________.
A) attributes
B) foreign keys
C) primary keys
D) internal records

Accepted Answer

Columns that are keys to different tables than the ones in which they reside are called foreign keys. Primary keys are the columns that uniquely identify the records in a table, attributes are the columns that contain the data in a table, and internal records are not a commonly used term in database management.

Question 15

Relational databases represent relationships using ________.
A) foreign keys
B) file systems
C) metadata
D) primary keys

Accepted Answer

Relational databases use foreign keys to represent relationships between tables. Foreign keys are used to link one table to another and create connections between them. File systems and metadata are used for different purposes and are not directly related to representing relationships in a database. Primary keys are used to identify unique records within a table, but they do not represent relationships between tables.

Question 16

Identify an open source DBMS product.
A) MySQL
B) DB2
C) Access
D) Oracle Database

Accepted Answer

MySQL is the only open source DBMS product listed, making it the best choice for this question.

Question 17

The data in a database are modified and deleted. These operations of DBMS are known as ________.
A) statistical operations
B) analytical operations
C) administrative operations
D) processing operations

Accepted Answer

Processing operations in a DBMS include modifying and deleting data, as they involve handling and managing the data stored in the database.

Question 18

A database administrator of an organization constantly manages the processing rights and responsibilities of employees. This is an example of a(n) ________ task.
A) development
B) recovery
C) adaptation
D) operational

Accepted Answer

Operational tasks involve the day-to-day management of systems and processes within an organization, including managing access and permissions for employees, which is the task described in the scenario. Development involves creating new systems or features, recovery involves restoring data or systems after an incident or outage, and adaptation involves modifying existing systems to meet changing needs.

Question 19

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

Accepted Answer

A query is specifically designed to request data from a database. Forms and reports may display data, but they are not a request specifically designed for retrieving data. An application is a broader term that can refer to a program or software, but it does not necessarily refer to a request for data from a database.

Question 20

A(n) ________ is a program used to create, process, and administer a database.
A) operating system
B) database management system
C) information system
D) database system

Accepted Answer

A database management system (DBMS) is specifically designed for creating, processing, and administering databases. An operating system (A) manages computer hardware and software resources, while an information system (C) is a broader term that can refer to any system used to process and manage data. A database system (D) is a general term that can refer to any system used for managing databases, but a DBMS is the specific type of software used for this purpose.

Quiz 5: Database Processing

A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.

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

Which of the following is True of MySQL?

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

Identify the type of task performed by a database administrator when validating the data model to be used in a database management system.

Which of the following is an example of a database management system?

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.

Metadata are ________.

Which of the following is a developmental task of database administration?

________ allow users to read, insert, modify, and delete data in a database.

Which of the following database administration tasks is related to adaptation?

Which of the following is an international standard language for processing a database?

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________.

Columns that are keys to different tables than the ones in which they reside are called ________.

Relational databases represent relationships using ________.

Identify an open source DBMS product.

The data in a database are modified and deleted. These operations of DBMS are known as ________.

A database administrator of an organization constantly manages the processing rights and responsibilities of employees. This is an example of a(n) ________ task.

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

A(n) ________ is a program used to create, process, and administer a database.