Question 1
2 out of 2 points
A collection of data fields that are all related to one object, activity, or individual is called a file.
Selected Answer:
False
Correct Answer: False
Question 2
2 out of 2 points
Haley's employer has asked her to review tens of thousands of social media posts about their
company's products and compile this data into a database. In terms of the characteristics of big data,
Haley is dealing with .
Selected Answer: a.
variety
Correct Answer: a.
variety
Question 3
2 out of 2 points
Today, most organizations use the traditional approach to data management, where multiple
information systems share a pool of related data.
Selected Answer:
False
Correct Answer: False
Question 4
2 out of 2 points
Suppose you wish to find what tables are in a database, what fields they have, and how they are
related you would review the .
Selected Answer: b.
schema
Correct Answer: b.
schema
Question 5
2 out of 2 points
Which of the following statements is true of a database?
Selected Answer: b.
It helps companies analyze information to open new market
opportunities.
Correct Answer: b.
It helps companies analyze information to open new market
opportunities.
Question 6
2 out of 2 points
Each attribute in a relational database model can be constrained to a range of allowable values called
a .
Selected Answer: d.
domain
Correct Answer: d.
domain
Question 7
2 out of 2 points
A database administrator (DBA) is an important nontechnical position responsible for defining and
implementing consistent principles for a variety of data issues, including setting data standards and
data definitions that apply across all the databases in an organization.
Selected Answer:
False
Correct Answer: False
Question 8
2 out of 2 points
For the operation, it is required that the the two tables have a common attribute.
Selected Answer: d.
join
Correct Answer: d.
join
Question 9
2 out of 2 points
For each data item, a data dictionary usually contains information such as the name of the data item,
the range of values that can be used, and the amount of storage needed for the item.
Selected Answer:
True
Correct Answer: True
Question 10
2 out of 2 points
A is a collection of instructions and commands used to define and describe data and
relationships in a specific database.
Selected Answer: d.
data definition
language
Correct Answer: d.
data definition
language
Question 11
2 out of 2 points
is an approach that starts by investigating the general data and information needs of an
organization at the strategic level and then examines more specific data and information needs for the
functional areas and departments within the organization.
Selected Answer: b.
Enterprise data modeling
Correct Answer: b.
Enterprise data modeling
Question 12
2 out of 2 points
An enterprise data model is created only for documentation, but is otherwise inconsequential.
Selected Answer:
False
Correct Answer: False
Question 13
2 out of 2 points
One of the primary advantages of a relational database is that it allows tables to be linked to reduce
data redundancy and allow data to be organized more logically.
Selected Answer:
True
Correct Answer: True
Question 14
2 out of 2 points
The position of a is a non-technical position responsible for defining and implementing
consistent principles for setting data standards and data definitions that apply across all the databases
in an organization.
Selected Answer: a.
data administrator
Correct Answer: a.
data administrator
Question 15
2 out of 2 points
Carlos is working with an existing database, but he wants to eliminate some of the columns in the
table to create a new, more streamlined database. He will use projection to create his new database.
Selected Answer:
True
Correct Answer: True
