Chapter 11: CSC
In a database, a ________ stores data in rows and columns.
table
A datacenter is a facility designed to house a company's servers and other equipment in a secure and controlled environment.
true
A many-to-many relationship exists when a book has multiple authors and the authors have written many different books.
true
Durability, as related to transaction processing, means that once a transaction has been completed, it cannot be undone.
true
One way to display the data in a table is by creating a report.
true
The Integrated Automated Fingerprint Identification System database contains fingerprints of those who have served in the armed forces or work in the federal government and law enforcement.
true
The Integrated Automated Fingerprint Identification System is considered to be a biometric database.
true
The National Missing Person DNA database is part of the CODIS system.
true
The geographic information system combines layers of geographically referenced information about Earth's surface.
true
The primary key field uniquely identifies a record in a table.
true
When designing a database, you should have separate fields for a person's first and last names.
true
When information is duplicated in multiple places, it is known as data redundancy.
true
A data ________ rule would prevent a user from entering text in a date/time field.
validation
Which is NOT a CODIS index?
victims
Which of the following is NOT a SQL relational keyword?
QUIT
The test that a transaction processing system uses to make sure that transactions are fully completed or aren't undertaken at all is known as ________.
atomicity
________ is the application of information technology to the field of biology.
bioinformatics
A(n) ________ improves over time by learning from its interactions.
cognitive computing system
A GIS can be used by local municipalities to ________.
design emergency routes
A data ________ defines the fields in a database and the type of data that each field contains.
dictionary
A DBMS will define a data type for you by evaluating the data currently entered into the fields.
false
A data warehouse is used to discover relationships among data items.
false
A database controller (DBC) is a person who oversees database systems.
false
A decision support system is made up of a knowledge base and an inference engine.
false
Microsoft Excel is an example of a DBMS.
false
The test that a transaction processing system uses to make sure that each transaction is independent is known as durability.
false
Using a report to enter data into a database decreases the frequency of data entry errors.
false
In a database, title, author, publication date, and ISBN are examples of ________.
fields
An Excel spreadsheet is an example of a(n) ________ database.
flat
________ make data entry easier because they can be set up to match the layout of a paper document.
forms
What project was coordinated by the U.S. Department of Energy and the National Institutes of Health?
human genome project
Which is a type of data that can be stored in an object-oriented database?
images, audio, video
Which is NOT an advantage of data normalization?
increases database development time
A database is a collection of ________ that has been organized in a meaningful way.
information
A(n) ________ is a set of rules that are used to apply a knowledge base to each situation
interference engine
A GIS is made up of datasets, also called ________, of geographically referenced information about Earth's surface.
layers
To ensure that a person does not misspell Wednesday in a field, a(n) ________ list can be used.
lookup
An expert system is a computer programmed to ________.
make decisions in real life situations
Data in a ________ database are stored in data cubes.
multidimensional
The science and telecommunications industries would most likely use the ________ database type.
object-oriented
Microsoft Office is an example of a(n) ________.
office support system (OSS)
In a relational database for vehicles, a ________ relationship occurs when each vehicle record may link to several repair records, but each repair can link to only one vehicle.
one-to-many
________ allows the user to selectively extract data from different viewpoints.
online analytical processing (olap)
In a one-to-one relationship, both tables use the same ________ to link two records.
primary key
A ________ could be used to retrieve all the phone numbers from a student database.
query
A ________ contains the information for a single entity in the database.
record
The ________ database is the most popular type used by businesses.
relational
To print data or display it in an easy-to-read format, a ________ can be used.
report
Which would make the best primary key in a table?
student id
