Question 1

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

Accepted Answer

Relational databases use foreign keys to establish relationships between tables. These keys serve as a link between two tables, allowing data to be shared between them. File systems, metadata, and unique identifiers are all important components of database systems, but they are not specific to establishing relationships between tables.

Question 2

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

Accepted Answer

Metadata are data that describe other data, such as information about the content, structure, and formatting of a document or database. They are not code, error logs, or encrypted data transmissions.

Question 3

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

Accepted Answer

MySQL is the only open source DBMS product in the given options. The other options (DB2, Access, and Oracle Database) are all proprietary software.

Question 4

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) identifier
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. In this case, the "Employee Number" column is acting as the primary key as it assigns a unique number to each employee and allows them to be identified individually.

Question 5

Which of the following is a developmental task of database administration?
A) creating and staffing the DBA function
B) monitoring backup procedures
C) conducting training for users
D) managing configuration changes in systems

Accepted Answer

Creating and staffing the DBA function is a developmental task of database administration because it involves planning and organizing the resources necessary to support the database environment.

Question 6

When you modify or delete data present in a database, you are ________.
A) creating a new database
B) forming a data model
C) simplifying the data structure
D) processing the database

Accepted Answer

When you modify or delete data present in a database, you are processing the database. This means that you are making changes to the existing data in the database, rather than creating a new database, forming a data model or simplifying the data structure.

Question 7

________ are used by users to read, insert, modify, and delete data in a database.
A) Reports
B) Forms
C) Queries
D) DBMS

Accepted Answer

Forms are user interfaces designed to allow users to interact with a database and perform actions such as reading, inserting, modifying, and deleting data. Reports are used to display data from a database in a formatted manner, while queries are used to retrieve specific data from a database. DBMS (Database Management Systems) are software applications used to manage and maintain databases.

Question 8

The 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

Managing processing rights and responsibilities of employees is a routine operational task performed by a database administrator to ensure smooth functioning of the organization's database.

Question 9

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 developed by Microsoft. The other options listed are technologies or concepts related to databases, but not fully-fledged database management systems. MS Excel is a spreadsheet program, BigData refers to large data sets that require specialized software to manage and process, and NoSQL is a type of database that uses a non-relational model.

Question 10

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 an international standard language for processing a database. While the other options mentioned are database management systems, SQL is the language used to communicate with these systems and perform operations on the database.

Question 11

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.

Question 12

Which of the following is true of MySQL?
A) It is offered by Oracle.
B) It is license-free for most applications.
C) It is a closed-source database product.
D) It is yet to be widely adopted.

Accepted Answer

MySQL is available under the GNU General Public License and is thus license-free for most applications. However, Oracle acquired MySQL in 2010, so option A is also partially correct. Option C is false because MySQL is an open-source database product. Option D is also false because MySQL is one of the most widely used relational database management systems.

Question 13

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 are also types of output from databases, but they are not used for requesting data. Applications can interact with databases, but they are not a specific type of request for data.

Question 14

Which of the following is true of traditional database application programs?
A) Application forms, reports, and queries are displayed and processed using a browser.
B) All of the application logic is contained in a program on the database server.
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

Traditional database application programs are often written in languages like C++ and VisualBasic, which are not necessarily object-oriented but can be used in an object-oriented manner.

Question 15

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 collection of forms, reports, queries, and programs that serves as an intermediary between users and database data. It is a software program that interacts with a database to access data and perform various functions on that data. The other options are not relevant to the given description.

Question 16

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 filter and retrieve the specific sales analyses data from the database based on her requirements. The other options do not involve filtering and retrieving specific data from the database.

Question 17

Identify the type of task that a database administrator is performing 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 a task that falls under the development phase of the database management system lifecycle. It involves ensuring that the data model accurately represents the requirements of the system and that it follows normalization principles to avoid data redundancy and inconsistencies.

Question 18

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 involves adapting the database to new or changing requirements, such as adding new users or modifying security settings. The other tasks listed do not directly involve adaptation. Monitoring backup procedures and database performance are related to maintenance, while conducting training for users is related to user support.

Question 19

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

Accepted Answer

A database management system (DBMS) is a specialized software that allows users to create, manage, and manipulate databases. It acts as an interface between the end-users and the database, providing them with tools and features to interact with the data stored in it. Therefore, a DBMS is the correct answer for this question.

Question 20

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 a single user on their computer, meaning that the application, the DBMS, and the database itself all reside on that individual's computer. They do not require access to the Internet and are not displayed or processed using html5, css3, or JavaScript. While JavaScript may be used for user-side processing in other contexts, it is not a key component of single-user databases.

Quiz 5: Database Processing

Relational databases represent relationships using ________.

Metadata are ________.

Identify the open source DBMS product among the following.

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) ________.

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

When you modify or delete data present in a database, you are ________.

________ are used by users to read, insert, modify, and delete data in a database.

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

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

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

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

Which of the following is true of MySQL?

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

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

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

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.

Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system.

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

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

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