BIS245 Week 4 Quiz 2017 (All Correct)

QuestionQuestion 1.1. (TCO 1) A storage location in a database that holds related information is a (Points : 4)query.form.report.table.Question 2.2. (TCO 2) All of the following are Access data types EXCEPT (Points : 4)autonumber.date/time.number.string.Question 3.3. (TCO 2) In Access, query results are displayed in which view? (Points : 4)datasheet.form.recordset.report.Question 4.4. (TCO 2) Access has _____ data types. (Points : 4)sixeight1012Question 5.5. (TCO 2) All of the following describe a many-to-many relationship in Access EXCEPT (Points : 4)a junction 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 four tables.Question 6.6. (TCO 2) Another term for an expression is (Points : 4)formula.function.parameter.query.Question 7.7. (TCO 2) Which Access data type would you use to store $23.58? (Points : 4)CalculatedCurrencyMoneyNumberQuestion 8.8. (TCO 2) A primary key (Points : 4)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 aboveQuestion 9.9. (TCO 6) 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 10.10. (TCO 6) Which of the following is true about a crosstab query? (Points : 4)It is an action query.It is used to retrieve parameter data.It summarizes a data source into rows and columns with aggregate data displayed at the intersection of the rows and columns.It summarizes unmatched records from a data source.