Final exam study review LATEST EXAM VERSION GRADED A+ |
ASSURED SUCCESS !!
Why is an index created on a database column? - ANSWER-To
optimize data
retrievals
What is a methodology for organizing attributes into tables? -
ANSWER-Data
normalization
What would this SQL statement accomplish? - ANSWER-List
all entries in the
PRODUCT
table
A product marketing company publishes an Internet-based
newsletter about their
new products to increase their
customer base.
What is an advantage that this company will gain from investing
in a relational database management system that will store
,customer information? – ANSWER-Improved query response
times
In which two ways does a database management system
environment increase
effectiveness in working
with data?
Choose 2 answers. - ANSWER-1. It enables data sharing
2. It permits storage of vast volumes of data
Sales data, detailing the customer names, products sold, and
salespersons, is
kept in a
database.
Which kind of data in this database would qualify as
intersection data related to
both the product and salesperson entities? - ANSWER-
Customer names
What is an attribute or group of attributes that uniquely
identify a tuple in a
, relation? - ANSWER-
Primary key
What is necessary for a primary key in one relation of a
database to match with
its corresponding foreign key in another relation of the
same database? -
ANSWER-A domain of
values
What uniquely identifies each entity in a collection of
entities but is not the
primary key? - ANSWER-The
alternate key
What is a term for a set of columns in a table that can
uniquely identify any
record in that table without referring to other data? - ANSWER-
Candidate key
What happens to the original data in database indexing? -
ANSWER-It is copied
to the
index