Concepts Chapter 8 Database Quiz – Flashcards
Unlock all answers in this set
Unlock answersquestion
Primary keys ensure that ____.
answer
duplicate records are not stored in the database
question
A primary key is always made up of only one field.
answer
False
question
____ is a concern for some organizations and individuals when data is collected in databases without their permission.
answer
Privacy
question
In a database, a collection of related fields that describes some object or activity is referred to as a ____.
answer
record
question
In a database, a collection of related records is referred to as a table or a
answer
file
question
A ____ is a collection of data that has been organized and made available to a user.
answer
database
question
In a database, first name would be an example of a ____.
answer
field
question
Big data is a term used to refer to data sets that are too large to process through traditional means.
answer
True
question
Increased data redundancy is one of the primary advantages of using a database.
answer
False
question
One of the first steps in creating a database is to build queries and reports that can pull information from the data that is stored.
answer
True
question
When a database problem occurs, its tables may be split up during the ____ process to correct a data problem.
answer
normalization
question
A data definition language is used to define the ____ of a database.
answer
data and relationships
question
A popular database software program called ____ offers a wizard and QBE tool to help build and generate SQL queries.
answer
MS Access
question
A database ____ is a graphical representation of the structure of a database.
answer
schema
question
The ____ data manipulation language is used to build databases in both mainframe and personal computers.
answer
SQL
question
Inaccurate input entered into a database resulting in incorrect output is also known as ____.
answer
data redundancy
question
On Amazon.com, when the customer is ready to make a purchase, the database ____ manages the entire process.
answer
management system
question
A data center is used by large organizations to store older archived data that is no longer needed on a day-to-day basis.
answer
False
question
Installation and the ongoing maintenance of software in a database system are the job of the database ____.
answer
administrator
question
Data mining is used to generate business intelligence.
answer
True
question
As data centers continue to grow in size to multi-acre facilities, the number of employees required to run them also grows proportionally.
answer
False
question
Industrial databases are large databases that function as the cornerstone of information systems in businesses and enterprises.
answer
True
question
Which of the following tasks is the typically a primary responsibility of a database administrator?
answer
developing the data dictionary
question
A data center that is run and managed in an automated fashion while being monitored remotely is referred to as a ____ environment.
answer
lights out
question
The iTunes library is based on database technology.
answer
True
question
Microsoft Outlook and Quicken are examples of ____ DBMSs that are used to store and manipulate personal data.
answer
special-purpose
question
The most popular format for flat file databases is comma-separated values (CSV).
answer
True
question
A common type of flat file database format known as ____ stores records as a line of text separated by commas
answer
CSV
question
Database structure refers to the manner in which data is organized and stored.
answer
True
question
Relationships between tables can be illustrated through a(n) ____ relationship diagram.
answer
entity
question
Data integrity refers to the quality of data: the degree to which it is accurate and up to date.
answer
True
question
A database schema can stand alone as a single file or be part of a database.
answer
True
question
A data dictionary provides a detailed description of each field and table in a database.
answer
True
question
A schema illustrates the ____ and ____ in a database and the relationships among them.
answer
tables and fields
question
One of the first steps in creating a database is to build queries and reports that can pull information from the data that is stored.
answer
False
question
A data mine is a climate-controlled building or set of buildings that house servers that store and deliver mission-critical information and services.
answer
False
question
Distributed databases connect data at different locations using ____ networks.
answer
telecommunications
question
With ____, users are able to store data on Internet servers housed in data centers.
answer
cloud computing
question
A distributed database is also known as a ____ database.
answer
virtualized
question
A replicated database is a database that holds a duplicate set of frequently used data.
answer
True
question
A very large database that holds important data from a variety of sources is called a ____.
answer
data warehouse
question
A data mine is a large database that holds information to analyze pricing trends.
answer
False
question
Data ____ refers to the quality and accuracy of the data.
answer
integrity
question
In a relational database, a ____ would ensure that two customers with the same name don't get confused with each other.
answer
primary key
question
A(n) ____ database organizes data into multiple tables that are related by common fields.
answer
relational
question
In 1986, the American National Standards Institute (ANSI) adopted ____ as the standard query language for relational databases.
answer
SQL
question
Inaccurate input entered into a database resulting in incorrect output is also known as ____.
answer
GIGO
question
The process of extracting information from a data warehouse or data mart is called ____.
answer
data mining
question
A ____ is a skilled and trained computer professional who directs all activities related to an organization's database.
answer
Database Administrator (DBA)
question
To avoid data ____, a database stores data in one place.
answer
redundancy
question
Online services such as Google and Amazon rely on data organized by databases.
answer
True
question
A primary key is a ____ within a database table that uniquely identifies each record.
answer
field
question
The data manipulation language ____ is a popular tool when querying a relational database.
answer
SQL
question
SQL is one example of a data manipulation language.
answer
True
question
Database tools include software and techniques for analyzing, maintaining, and manipulating data in a database.
answer
True
question
The output of data mining in a business setting is sometimes called ____.
answer
business intelligence
