CIS 372 database Mod1,2,3,4 | 78 Questions and Answers
___is the duplication of data or the d. Data redundancy
storing
of the same data in more than one
place.
a. Data security
b. Data inconsistency
c. Data independence
d. Data redundancy
Which of the following is not a a. Prevents orphan records
problem associated with
redundancy?
a. Prevents orphan records
b. Makes updating data more
cumbersome and time-
consuming
c. Can lead to inconsistencies
d. Results in more frequent data
errors
A(n)___is a person, place, object, b. entity
event, or
idea for which you want to store
and process data.
a. attribute
b. entity
c. relationship
d. flat file
A(n)___is a characteristic or property d. attribute
of an
entity.
a. metadata
b. database
c. flat file
d. attribute
,A(n)___exists between two entities c. one-to-many relationship
when
each row in the first entity
matches many rows in the second
entity, and each row in the
second entity matches only one
row in the first entity.
a. record
b. many-to-many relationship
c. one-to-many relationship
d. attribute
A(n)___is a structure that contains c. relational database
data
about many categories of
information as well as the
relationships between those
categories.
a. table
b. data file
c. relational database
d. software stack
Which of the following describes b. Use a common field in the two tables to tie the related records
how to create a one-to-many from each table together.
relationship in a database
system?
a. Insert a new table between two
existing tables.
b. Use a common field in the two
tables to tie the related
records from each table
together.
c. Create an entity-
relationship (E-R) diagram.
d. Include multiple entries in a single
field.
In a(n)__, rectangles represent a. entity-relationship (E-R) diagram
entities
and display their attributes; lines
represent relationships between
connected entities.
a. entity-relationship (E-R) diagram
b. unstructured data file
c. spreadsheet
d. software stack
Which of the following defines a d. A program through which users interact with the data stored in a database
DBMS?
a. A collection of data that
, corresponds to one record
b. A file used to store data about
a single entity
c. The person or group in
charge of a database
d. A program through which users
interact
with the data stored in a database
___is the duplication of data or the d. Data redundancy
storing
of the same data in more than one
place.
a. Data security
b. Data inconsistency
c. Data independence
d. Data redundancy
Which of the following is not a a. Prevents orphan records
problem associated with
redundancy?
a. Prevents orphan records
b. Makes updating data more
cumbersome and time-
consuming
c. Can lead to inconsistencies
d. Results in more frequent data
errors
A(n)___is a person, place, object, b. entity
event, or
idea for which you want to store
and process data.
a. attribute
b. entity
c. relationship
d. flat file
A(n)___is a characteristic or property d. attribute
of an
entity.
a. metadata
b. database
c. flat file
d. attribute
,A(n)___exists between two entities c. one-to-many relationship
when
each row in the first entity
matches many rows in the second
entity, and each row in the
second entity matches only one
row in the first entity.
a. record
b. many-to-many relationship
c. one-to-many relationship
d. attribute
A(n)___is a structure that contains c. relational database
data
about many categories of
information as well as the
relationships between those
categories.
a. table
b. data file
c. relational database
d. software stack
Which of the following describes b. Use a common field in the two tables to tie the related records
how to create a one-to-many from each table together.
relationship in a database
system?
a. Insert a new table between two
existing tables.
b. Use a common field in the two
tables to tie the related
records from each table
together.
c. Create an entity-
relationship (E-R) diagram.
d. Include multiple entries in a single
field.
In a(n)__, rectangles represent a. entity-relationship (E-R) diagram
entities
and display their attributes; lines
represent relationships between
connected entities.
a. entity-relationship (E-R) diagram
b. unstructured data file
c. spreadsheet
d. software stack
Which of the following defines a d. A program through which users interact with the data stored in a database
DBMS?
a. A collection of data that
, corresponds to one record
b. A file used to store data about
a single entity
c. The person or group in
charge of a database
d. A program through which users
interact
with the data stored in a database
