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
ScholarMatic: Explanation & Answer
Your ready answer from a verified tutor is just a click away for as little as $14.99
Click Order Now to get 100% Original Answer Customized to your instructions!
