Grade Details – All Questions
Question 1. Question
: (TCO 2) Which of the following
is an example of an entity in a business?
Student Answer: Company
Business owner
CEO
Employees
Question 2. Question
: (TCO 2) Which of the following
is NOT a step in the Database Life Cycle?
Student Answer: Database Design
Maintenance and Redevelopment
Performance
Testing
Question 3. Question
: (TCO 3) When troubleshooting a
relationship, all of the following should be done EXCEPT
Student Answer: creating a relationship between like data
types.
checking the size of fields to be used in the
relationship.
checking that the correct type of
relationship is established.
deleting the relationship and field and then
rebuilding.
Question 4. Question
: (TCO 2) A domain is a
Student Answer: group of data types that describe what kind
of information that may be stored in a field.
model of the database.
set of values.
the set of primary and foreign keys in a
database.
Instructor Explanation: Chapter 3: Frost section of book
Question 5. Question
: (TCO 2) All of the following
describe a many-to-many relationship in Access EXCEPT
Student Answer: 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.
Instructor Explanation: Chapter 2: Grauer section of book
Points Received: 4 of 4
Comments:
Question 6. Question
: (TCO 2) A primary key
Student Answer: can be computer generated.
consists of one field only that uniquely
identifies each record in a table.
is a relationship between two or more tables.
All of the above.
Question 7. Question
: (TCO 3) Which of the following
does NOT describe data redundancy?
Student Answer: 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. Question
: (TCO 4) Based on the image,
which statement below is NOT true of the one-to-many relationships?
Student Answer: It is the least used type of relationship.
OrderID is a unique identification number
that would be used in the Orders table and Order Details table.
Each record in the Orders table may match
one, more than one, or no records in the Order Details table.
Each record in the Orders table matches only
one record in the Customers table.
Question 9. Question
: (TCO 4) Which is NOT true of a
calculated field?
Student Answer: It cannot be added to queries or reports.
The value of a calculated field is produced
from an expression.
A calculated field references other fields.
The result is useful at the moment the
calculation is made.
Question 10. Question
: (TCO 4) Which of the following
is a special-definition setting used on a field containing an employee’s date
of hire?
Student Answer: Date arithmetic
Constant
Date/time field
Calculated field
