Have an account?
Skip to Content
Build your own quiz
15 questions
Show Answers
See Preview
- 1. Multiple Choice
The traditional file environment does not typically have a problem with
data inconsistency
program-data independence.
lack of flexibility in creating ad-hoc reports.
lack of flexibility in creating ad-hoc reports.
data sharing.
- 2. Multiple Choice
A(n) ________ is a characteristic or quality that describes a database entity.
field
tuple
key field
attribute
relationship
- 3. Multiple Choice
________ creates confusion that hampers the creation of information systems that integrate data from different sources.
Batch processing
Data redundancy
Data independence
Online processing
Data quality
- 4. Multiple Choice
Which of the following features enables a DBMS to reduce data redundancy and inconsistency?
enforces referential integrity
couples program and data
data dictionary
two-dimensional tables
minimizes isolated files with repeated data
- 5. Multiple Choice
A DBMS makes the
physical database available for different logical views.
relational database available for different logical views.
physical database available for different analytic views.
relational database available for different analytic views.
logical database available for different analytic views.
- 6. Multiple Choice
The logical view of a database
displays the organization and structure of data on the physical storage media.
includes a digital dashboard.
allows the creation of supplementary reports.
enables users to manipulate the logical structure of the database.
presents data as they would be perceived by end users.
- 7. Multiple Choice
A field identified in a table as holding the unique identifier of the table's records is called the
primary key.
key field.
primary field.
unique ID.
primary entity.
- 8. Multiple Choice
The specialized language programmers use to add and change data in the database is called
a data access language.
a data manipulation language.
structured query language.
a data definition language.
a DBMS.
- 9. Multiple Choice
Big data does not refer to
datasets with fewer than a billion records.
datasets with unstructured data.
machine-generated data (i.e. from sensors).
data created by social media (i.e. tweets, Facebook Likes).
data from Web traffic.
- 10. Multiple Choice
Which of the following technologies would you use to analyze the social media data collected by a major online retailer?
OLAP
data warehouse
data mart
Hadoop
DBMS
- 11. Multiple Choice
A data warehouse is composed of
historical data from legacy systems.
current data.
internal and external data sources.
historic and current internal data.
historic external data.
- 12. Multiple Choice
All of the following are technologies used to analyze and manage big data except
cloud computing.
noSQL.
in-memory computing.
analytic platforms.
Hadoop.
- 13. Multiple Choice
The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)
information policy.
data definition file.
data quality audit.
data governance policy.
data policy.
- 14. Multiple Choice
The special organizational function whose responsibilities include physical database design and maintenance is called
data administration.
database administration.
information policy administration.
data auditing.
database management.
- 15. Multiple Choice
Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called
data auditing.
defragmentation.
data scrubbing.
data optimization.
data normalization.
- Answer choicesTagsAnswer choicesTags