1. (TCO 2) In a relational database, entities are (Points : 4) A. events. B. per

Question

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

4) A. events.

B. persons.

C. things.

D. All of the above

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

A. developing a database model that will support company operations.

B. purchasing your hardware components.

C. selecting the specific hardware characteristics based on data storage and data access requirements.

D. 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. a primary field uses an index.

B. adding an index to a table might decrease overall database performance slightly.

C. an index can reduce the amount of time it takes for Access to run queries and reports.

D. indexes are created using the Index property type.

Question 4. 4. (TCO 2) A domain is a (Points : 4)

A. group of data types that describe what kind of information that may be stored in a field.

B. model of the database.

C. set of values.

D. the set of primary and foreign keys in a database.

Question 5. 5. (TCO 2) A one-to-many relationship is (Points : 4)

A. a relationship that guarantees that a record is unique.

B. an association between a record and its fields.

C. Used to describe attributes.

D. 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. 6. (TCO 2) An associative table is (Points : 4)

A. used to identify primary keys between tables.

B. a child of two parent tables that are in a many-to-many relationship.

C. an integrity element within a table relationship.

D. a tool that allows you to locate an excel file.

Question 7. 7. (TCO 3) Data validation refers to (Points : 4)

A. a set of constraints that helps control illegal data entry.

B. correcting data errors after they are entered into a table.

C. duplicating a primary key in a table.

D. typing data accurately into a table.

Question 8. 8. (TCO 4) What Access data type would you use to store $23.58? (Points : 4)

A Calculated

B Currency

C Money

D Number

Question 9. 9. (TCO 4) Which of the following is NOT true of a birth date field? (Points : 4)

A. A birth date is considered a constant

B. A birth date would be defined as a date/time field.

C.The age field is the same as a birth date field.

D. Date arithmetic can be applied to a birth date field.

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)

A. Date arithmetic

B Constant

C. Date/time field

D. Calculated field

Explanation / Answer

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

D. All of the above

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

D. 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)

B. adding an index to a table might decrease overall database performance slightly.

Question 4. 4. (TCO 2) A domain is a (Points : 4)

A. group of data types that describe what kind of information that may be stored in a field.

Question 5. 5. (TCO 2) A one-to-many relationship is (Points : 4)

D. 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. 6. (TCO 2) An associative table is (Points : 4)

A. used to identify primary keys between tables.

Question 7. 7. (TCO 3) Data validation refers to (Points : 4)

B. correcting data errors after they are entered into a table.

Question 8. 8. (TCO 4) What Access data type would you use to store $23.58? (Points : 4)

B Currency

Question 9. 9. (TCO 4) Which of the following is NOT true of a birth date field? (Points : 4)

C.The age field is the same as a birth date field.

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)

C. Date/time field

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.