Week 3 : Tables, MS Access vs. Excel, and Data Integrity – Quiz

QUESTION

Week 3 : Tables,
MS Access vs. Excel, and Data Integrity – Quiz
This quiz contributes 40 points to your overall grade, so
please do your very best!
There are 10 multiple-choice questions, 4 points each (40
points total).
The quiz includes 1 page.
You have 1 hour to complete the quiz.

Question 1. 1.(TCO 2) In a relational database, entities are (Points : 4)

events.
persons.
things.
All
of the above

Question 2. 2.(TCO 2) Physical design refers to (Points : 4)

developing a database model that
will support company operations.
purchasing
your hardware components.
selecting
the specific hardware characteristics based on data storage and data access
requirements.
the
process of converting your ERD into tables and defining your rows and
columns based your entities and attributes.

Question 3. 3.(TCO 3) All of the following explain index usage
EXCEPT (Points : 4)

a primary field uses an
index.
adding
an index to a table might decrease overall database performance slightly.
an
index can reduce the amount of time it takes for Access to run queries and
reports.
indexes
are created using the Index property type.

Question 4. 4.(TCO 2) All of the following should be considered in
designing a relational database EXCEPT
(Points : 4)

compliance with PNPI
regulations.
design
for safety with redundant data.
design
your database for 100-year usage.
store
data in its smallest parts.

Question 5. 5.(TCO 2) All of the following describe a many-to-many
relationship in Access EXCEPT
(Points : 4)

a junction (associative) table
is used.
many
matching records are found in each direction between tables.
may
be used to connect to Oracle and other databases.
there
must be at least two tables.

Question 6. 6.(TCO 2) An associative table is (Points : 4)

used to identify primary keys
between tables.
a
child of two parent tables that are in a many-to-many relationship.
an
integrity element within a table relationship.
a
tool that allows you to locate an excel file.

Question 7. 7.(TCO 3) Which of the following does NOT describe data
redundancy? (Points : 4)

The same data exists in multiple
tables.
The
data is always in linked tables.
Data
updating must be done in multiple table locations.
Data
redundancy can result in data anomalies.

Question 8. 8.(TCO 4) To which of the following does the term cascading
refer? (Points : 4)

Data changes travel from one
table to another.
Data
is put in sequential order.
Queries
can retrieve data at a faster rate.
Records
are arranged in order.

Question 9. 9.(TCO 4) Validation text (Points : 4)

changes the way text data is
formatted.
determines
the maximum length of a Text field.
requires
correct text data input.
specifies
the error message when a rule is violated.

Question 10. 10.(TCO 4) Which of the following is a special-definition
setting used on a field containing an employee’s date of hire? (Points : 4)

Date arithmetic
Constant
Date/time
field
Calculated
field

ANSWER:

REQUEST HELP FROM A TUTOR