Info Tech Chapter 5 – Flashcards
50 test answers
Unlock all answers in this set
Unlock answers 50question
The type of logical database model that treats data as if they were stored in two-dimensional tables is the:
answer
relational DBMS.
Unlock the answer
question
What are the relationships that the relational database is named for?
answer
Relationships between entities
Unlock the answer
question
A characteristic or quality describing an entity is called a(n):
answer
attribute.
Unlock the answer
question
The most basic business database is comprised of:
answer
five tables: for customers, employees, suppliers, products, and sales.
Unlock the answer
question
In a table for customers, the information about a single customer would reside in a single:
answer
row.
Unlock the answer
question
In a relational database, a record is also called a(n):
answer
tuple.
Unlock the answer
question
A field identified in a table as holding the unique identifier of the table's records is called the:
answer
primary key.
Unlock the answer
question
A field identified in a record as holding the unique identifier for that record is called the:
answer
key field.
Unlock the answer
question
A schematic of the entire database that describes the relationships in a database is called a(n):
answer
entity-relationship diagram.
Unlock the answer
question
A one-to-one relationship between two entities is symbolized in a diagram by a line that ends:
answer
in two short marks.
Unlock the answer
question
A one-to-many relationship between two entities is symbolized in a diagram by a line that ends:
answer
with a crow's foot preceded by a short mark.
Unlock the answer
question
A table that links two tables that have a many-to-many relationship is often called a(n):
answer
intersection relation.
Unlock the answer
question
The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:
answer
normalization.
Unlock the answer
question
A DBMS makes the:
answer
physical database available for different logical views.
Unlock the answer
question
The logical view of a database:
answer
shows how data are organized and structured on the storage media.
Unlock the answer
question
Which of the following is not a typical feature of DBMS?
answer
Query wizard tool
Unlock the answer
question
Oracle Database Lite is a:
answer
DBMS for small handheld computing devices.
Unlock the answer
question
Access is a:
answer
DBMS for desktop systems.
Unlock the answer
question
MySQL is a:
answer
popular open-source DBMS.
Unlock the answer
question
Microsoft SQL Server is a(n):
answer
DBMS for midrange computers.
Unlock the answer
question
In a relational database, the three basic operations used to develop useful sets of data are:
answer
select, project, and join.
Unlock the answer
question
The select operation:
answer
creates a subset consisting of all records in the file that meets stated criteria.
Unlock the answer
question
The join operation:
answer
combines relational tables to provide the user with more information than is otherwise available.
Unlock the answer
question
The project operation:
answer
creates a subset consisting of columns in a table.
Unlock the answer
question
The data dictionary serves as an important data management tool by:
answer
creating an inventory of data definitions contained in the database.
Unlock the answer
question
An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the:
answer
data dictionary.
Unlock the answer
question
The specialized language programmers use to add and change data in the database is called:
answer
data manipulation language.
Unlock the answer
question
The most prominent data manipulation language today is:
answer
SQL.
Unlock the answer
question
DBMS typically include report-generating tools in order to:
answer
display data in an easier-to-read format.
Unlock the answer
question
The type of database management approach that can handle multimedia is the:
answer
object-oriented DBMS.
Unlock the answer
question
Which of the following database types is useful for storing Java applets as well as handling large numbers of transactions?
answer
Object-relational DBMS
Unlock the answer
question
A data warehouse is composed of:
answer
both historical and current data.
Unlock the answer
question
Which of the following statements about data warehouses is not true?
answer
Data warehouse systems provide easy-to-use tools for managers to easily update data.
Unlock the answer
question
A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:
answer
it typically focuses on a single subject area or line of business.
Unlock the answer
question
Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as:
answer
business intelligence.
Unlock the answer
question
The tool that enables users to view the same data in different ways using multiple dimensions is:
answer
OLAP.
Unlock the answer
question
OLAP is a tool for enabling:
answer
users to obtain online answers to ad hoc questions in a rapid amount of time.
Unlock the answer
question
Data mining is a tool for allowing users to:
answer
find hidden relationships in data.
Unlock the answer
question
In terms of the data relationships found by data mining, associations refers to:
answer
occurrences linked to a single event.
Unlock the answer
question
In terms of the data relationships found by data mining, sequences refers to:
answer
events linked over time
Unlock the answer
question
An alternative to using application server software for interfacing between a Web server and back-end databases
answer
CGI.
Unlock the answer
question
Businesses use ________ tools to search and analyze unstructured data sets, such as e-mails and memos.
answer
text mining
Unlock the answer
question
The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.
answer
data redundancy
Unlock the answer
question
Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called:
answer
data scrubbing
Unlock the answer
question
Which of the following would you use to find patterns in user interaction data recorded by Web servers?
answer
Web server mining
Unlock the answer
question
Which of the following would you use to find out which Web sites with content related to database design were the most often linked to by other Web sites?
answer
Web usage mining
Unlock the answer
