Question 1

In a relational database model, the columns are called _____.

Accepted Answer

Columns in a relational database model are referred to as attributes. Attributes represent the data categories within a table.

Question 2

In the context of the operators used in a query by example (QBE)form, the _____ is used when only one of the conditions in the QBE form must be met.

Accepted Answer

The OR operator is used in a Query by Example (QBE) form when any one of the specified conditions must be met for a record to be included in the query results. This allows for more flexible queries that can match multiple criteria.

Question 3

A data _____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

Accepted Answer

A data warehouse is a centralized repository that stores data from multiple sources, designed to support decision making, business intelligence, reporting, and data analysis.

Question 4

In a(n)_____, each record can have multiple parent and child records.

Accepted Answer

In a network model, each record is allowed to have multiple parent and child records, which enables the creation of more complex relationships among data. This contrasts with the hierarchical model, where each record can only have a single parent.

Question 5

The data _____ component of a database management system (DBMS)is used for tasks such as backup and recovery, security, and change management.

Accepted Answer

The data administration component of a DBMS is responsible for tasks like backup and recovery, ensuring security, and managing changes, which are crucial for maintaining the integrity and availability of the database.

Question 6

When using query by example (QBE)in the data manipulation component of a database management system (DBMS), the _____ is used when all the conditions in the QBE form must be met.

Accepted Answer

The AND operator is used in Query by Example (QBE) when all the conditions specified in the QBE form must be met for a record to be included in the query results. This ensures that only records matching all criteria are selected.

Question 7

In a relational database model, the rows are called _____.

Accepted Answer

Rows in a relational database model are referred to as tuples, which represent a single data item or record.

Question 8

To begin designing a relational database, you must define the _____ by defining each table and the fields in it.

Accepted Answer

The logical structure of a database involves defining each table and the fields within it, which is a crucial step in the initial design phase of a relational database. This process does not directly involve setting up physical storage details (physical structure) or specifying keys (primary or foreign), although those are subsequent steps in database design.

Question 9

The _____ stores data types for fields, default values for fields, and validation rules for data in each field.

Accepted Answer

The data dictionary stores metadata, which includes data types for fields, default values for fields, and validation rules for data in each field, making it essential for understanding and managing the structure of a database.

Question 10

A _____ acts as an interface to a database, retrieving data for users and allowing users to enter data in the database.

Accepted Answer

A data-driven website interacts with a database, allowing for the retrieval and input of data, unlike static or flat pages which do not interact with databases.

Question 11

Which component of a database management system (DBMS)is used to design elements of an application using a database, such as data entry screens, interactive menus, and interfaces with other programming languages?

Accepted Answer

Application generation subsystems of a DBMS are used to design and generate the elements of an application, such as data entry screens, interactive menus, and interfaces with other programming languages, facilitating the creation of user-friendly interfaces for database interaction.

Question 12

In a relational database model, a _____ is a field in a relational table that matches the primary key column of another table.

Accepted Answer

A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table. It is used to establish and enforce a link between the data in two tables.

Question 13

In the context of the data administration component of a database management system (DBMS), the acronym CRUD stands for _____.

Accepted Answer

CRUD stands for Create, Read, Update, and Delete, which are the four basic functions of persistent storage in database management systems.

Question 14

Which type of databases is not limited by the data's physical location?

Accepted Answer

Distributed databases are designed to store data across multiple physical locations, meaning they are not limited by the data's physical location. This allows for data to be stored in various places while still being accessible as if it were in a single location.

Question 15

In a relational database model, which operation searches data in a table and retrieves records based on certain criteria?

Accepted Answer

The select operation in a relational database model is used to search data in a table and retrieve records based on certain criteria.

Question 16

The data _____ component of a database management system (DBMS)is used to add, delete, modify, and retrieve records from a database.

Accepted Answer

The data manipulation component of a DBMS is specifically designed for adding, deleting, modifying, and retrieving records from a database, aligning with the operations described.

Question 17

In a relational database model, which operation pares down a table by eliminating columns according to certain criteria?

Accepted Answer

The project operation in a relational database model is used to reduce a table by selecting certain columns, effectively eliminating the others that do not meet the specified criteria. This operation helps in creating a new table that contains only the specified attributes of the original table.

Question 18

Which approach to set up a distributed database management system (DDBMS)combines the fragmentation approach and the replication approach?

Accepted Answer

Allocation is the approach in a distributed database management system that combines both fragmentation and replication. It involves deciding where to place the fragments and how many copies (replicas) of each fragment to create and distribute across different sites to optimize performance and ensure data availability and reliability.

Question 19

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

Accepted Answer

Normalization is the process that improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table. This helps in maintaining data integrity and reducing data anomalies.

Question 20

The data _____ component of a database management system (DBMS)is used to create and maintain the data dictionary.

Accepted Answer

The data definition component of a DBMS is responsible for defining the database structure and schema, and it includes the creation and maintenance of the data dictionary, which holds metadata about the database.

Quiz 3: Data and Business Intelligence

In a relational database model, the columns are called _____.

In the context of the operators used in a query by example (QBE) form, the _____ is used when only one of the conditions in the QBE form must be met.

A data _____ is a collection of data from a variety of sources used to support decision-making applications and generate business intelligence.

In a(n) _____, each record can have multiple parent and child records.

The data _____ component of a database management system (DBMS) is used for tasks such as backup and recovery, security, and change management.

When using query by example (QBE) in the data manipulation component of a database management system (DBMS) , the _____ is used when all the conditions in the QBE form must be met.

In a relational database model, the rows are called _____.

To begin designing a relational database, you must define the _____ by defining each table and the fields in it.

The _____ stores data types for fields, default values for fields, and validation rules for data in each field.

A _____ acts as an interface to a database, retrieving data for users and allowing users to enter data in the database.

Which component of a database management system (DBMS) is used to design elements of an application using a database, such as data entry screens, interactive menus, and interfaces with other programming languages?

In a relational database model, a _____ is a field in a relational table that matches the primary key column of another table.

In the context of the data administration component of a database management system (DBMS) , the acronym CRUD stands for _____.

Which type of databases is not limited by the data's physical location?

In a relational database model, which operation searches data in a table and retrieves records based on certain criteria?

The data _____ component of a database management system (DBMS) is used to add, delete, modify, and retrieve records from a database.

In a relational database model, which operation pares down a table by eliminating columns according to certain criteria?

Which approach to set up a distributed database management system (DDBMS) combines the fragmentation approach and the replication approach?

_____ improves database efficiency by eliminating redundant data and ensuring that only related data is stored in a table.

The data _____ component of a database management system (DBMS) is used to create and maintain the data dictionary.