CIS1200 Unit 11 questions with complete
solutions graded A+
Two lists showing different values for the same data in different places of a database is an example of -
correct answer ✔✔data inconsistency.
When different versions of the same data appear in different places in a database, it is known as data
inconsistency.
Which of the following is a TRUE statement when considering using databases instead of lists? - correct
answer ✔✔Data can be easily shared among users.
Data-entry errors can be minimized with databases.
Data integrity can be ensured with a database.
Databases provide several main advantages: They manage large amounts of data efficiently, they enable
information sharing, and they promote data integrity.
Which type of relationship should be used to connect a Password table to a User Account table? - correct
answer ✔✔one-to-one relationship
A relationship in relational databases can take one of three forms. A one-to-many relationship is
characterized by a record appearing only once in one table while having the capability of appearing
many times in a related table. A one-to-one relationship indicates that for each record in a table there is
only one corresponding record in a related table. A many-to-many relationship is characterized by
records in one table being related to multiple records in a second table and vice versa.
Which type of database organizes data by measure and feature attributes? - correct answer
✔✔multidimensional database
There are three main types of databases. A relational database, such as Microsoft Access, operates by
organizing data into various tables based on logical groupings. An object-oriented database stores data in
objects rather than in tables. Objects contain not only data but also methods for processing or
, manipulating that data. A multidimensional database organizes data in a cube format so that data can be
analyzed from different perspectives, called dimensions.
The field that has a unique entry for each record in a database table is called the - correct answer
✔✔primary key.
To keep records distinct, each record must have one field that has a value unique to that record. This
field that provides a unique value for each record is called a primary key field.
Which best describes a data warehouse? - correct answer ✔✔a collection of all the data from an
organization's databases
A data warehouse is a large-scale collection of data that contains and organizes in one place all the data
from an organization's multiple databases. Individual databases contain a wealth of information, but
each database's information usually pertains to one area in the organization. Data warehouses,
therefore, consolidate information from various operational systems to present an enterprise-wide view
of business operations.
Extracting, transforming, and storing data are processes associated with which of the following? - correct
answer ✔✔data staging
Source data must go through data staging before entering the data warehouse. Data staging consists of
three steps: 1. Extraction of the data from source databases. 2. Transformation (reformatting) of the
data. 3. Storage of the data in the data warehouse.
The process by which great amounts of data are analyzed and investigated is known as - correct answer
✔✔data mining.
Data mining is the process by which great amounts of data are analyzed and investigated. The objective
is to spot significant patterns or trends within the data that would otherwise not be obvious.
A system that is designed to help keep track of everyday business activities is a(n) - correct answer
✔✔transaction-processing system.
solutions graded A+
Two lists showing different values for the same data in different places of a database is an example of -
correct answer ✔✔data inconsistency.
When different versions of the same data appear in different places in a database, it is known as data
inconsistency.
Which of the following is a TRUE statement when considering using databases instead of lists? - correct
answer ✔✔Data can be easily shared among users.
Data-entry errors can be minimized with databases.
Data integrity can be ensured with a database.
Databases provide several main advantages: They manage large amounts of data efficiently, they enable
information sharing, and they promote data integrity.
Which type of relationship should be used to connect a Password table to a User Account table? - correct
answer ✔✔one-to-one relationship
A relationship in relational databases can take one of three forms. A one-to-many relationship is
characterized by a record appearing only once in one table while having the capability of appearing
many times in a related table. A one-to-one relationship indicates that for each record in a table there is
only one corresponding record in a related table. A many-to-many relationship is characterized by
records in one table being related to multiple records in a second table and vice versa.
Which type of database organizes data by measure and feature attributes? - correct answer
✔✔multidimensional database
There are three main types of databases. A relational database, such as Microsoft Access, operates by
organizing data into various tables based on logical groupings. An object-oriented database stores data in
objects rather than in tables. Objects contain not only data but also methods for processing or
, manipulating that data. A multidimensional database organizes data in a cube format so that data can be
analyzed from different perspectives, called dimensions.
The field that has a unique entry for each record in a database table is called the - correct answer
✔✔primary key.
To keep records distinct, each record must have one field that has a value unique to that record. This
field that provides a unique value for each record is called a primary key field.
Which best describes a data warehouse? - correct answer ✔✔a collection of all the data from an
organization's databases
A data warehouse is a large-scale collection of data that contains and organizes in one place all the data
from an organization's multiple databases. Individual databases contain a wealth of information, but
each database's information usually pertains to one area in the organization. Data warehouses,
therefore, consolidate information from various operational systems to present an enterprise-wide view
of business operations.
Extracting, transforming, and storing data are processes associated with which of the following? - correct
answer ✔✔data staging
Source data must go through data staging before entering the data warehouse. Data staging consists of
three steps: 1. Extraction of the data from source databases. 2. Transformation (reformatting) of the
data. 3. Storage of the data in the data warehouse.
The process by which great amounts of data are analyzed and investigated is known as - correct answer
✔✔data mining.
Data mining is the process by which great amounts of data are analyzed and investigated. The objective
is to spot significant patterns or trends within the data that would otherwise not be obvious.
A system that is designed to help keep track of everyday business activities is a(n) - correct answer
✔✔transaction-processing system.
