Question 1. Which of the following is an example of an entity in a business?
Company
Business owner
CEO
Employees
Question 2. Which of the following is NOT a step in the Database Life Cycle?
Database Design
Maintenance and Redevelopment
Performance
Testing
Question 3. All of the following explain index usage EXCEPT
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. A crow's foot
is a Boolean field.
is used to describe attributes.
points to the child table.
points to the parent table.
Question 5. A one-to-many relationship is
a relationship that guarantees that a record is unique.
an association between a record and its fields.
used to describe attributes.
when a row in one table is matched to multiple rows in a second table and a row in the second table is matched back to a row in the first table.
Question 6. An associative table is
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. Which does NOT apply to the following relationship image?
A one-to-many relationship is shown between Orders and Order Details.
The display is showing the Design View of relationships.
Order Details has a composite primary key.
Within the Orders Details table, the ProductID field will contain unique values only.
Question 8. Entity attributes are represented as
fields.
files.
records.
tables.
Question 9. Which of the following is NOT true of a birth date field?
A birth date is considered a constant.
A birth date would be defined as a date/time field.
The Age field is the same as a birth date field.
Date arithmetic can be applied to a birth date field.
Question 10. Which of the following is a special-definition setting used on a field containing an employee's date of hire?
Date arithmetic
Constant
Date/time field
Calculated field