Multiple choice questions:
Question 1. To create a relationship between two tables, you need at least a
data type.
query.
hyperlink.
primary key.
Question 2. Which of the following does NOT describe a many-to-many relationship?
There must be at least two tables.
Many matching records exist in each direction between the tables.
A junction table is used.
You can connect to tables in other databases such as Oracle.
Question 3. Columns in an Access table are called
fields.
records.
relation.
tuples.
Question 4. An associative table is which of the following?
A child of two parent tables that are in a many-to-many relationship
A child of a parent table that is in a one-to-many relationship
A child of a parent table that is in a one-to-one relationship
None of the above
Question 5. Relational table and relationship have different meanings; the difference is
relationships focus on query filters while relational tables focus on filters only.
that there really is no difference.
a relational table defines a logical association between two relationships.
relational table is a two-dimensional structure while the relationship defines an association between the tables.
Question 6. Which data type will increment automatically each time a new record is entered into a table?
AutoNumber
Currency
Date/Time
Number
Question 7. All of the following are true about the Indexed property EXCEPT
an example of a setting is Yes (Duplicates OK).
indexed records are scanned sequentially.
indexing a table speeds the retrieval time.
primary keys must be indexed.
Question 8. Which of the following is NOT true of a hire date field?
A hire date is considered a constant.
A hire date would be defined as a date/time field.
Date arithmetic can be applied to a hire date field.
The years of service field, which shows how long an employee has been with the company.
Question 9. Which of the following is NOT an Access data type?
Text
Currency
Name
Date/Time
Question 10. What is the special character called to represent one or more characters in the Criteria area of a query?
Delimiter
Operand
Wildcard
Operator