Roles of Databases, MS Access Familiarity, and Requirements Gathering: Quiz
Week 1 : Roles of Databases, MS Access Familiarity, and Requirements Gathering - Quiz 1. (TCO 1) A multitier architecture means that computing tasks are divided among different __________. (Points : 4) | programmers levels of management users processes* pg F-4 |
2. (TCO 1) By definition, a three-tier architecture includes clients, ___________, and a data server. (Points : 4) | Web browsers an application server* pg F-11 an email server a proxy server |
3. (TCO 2) A single piece of data, such as a supplier's phone number or an employee's last name, is referred to as (Points : 4) | a record. a field. * an entity. a row. |
4. (TCO 2) A field or set of fields used to uniquely identify a record in a table is (Points : 4) | an entity. a row. a primary key.* a tag. |
5. (TCO 2) A collection of related data items that are specific to an instance of an entity, such as all the data about a specific employee, is (Points : 4) | a table.* a database. a column. a record. |
6. (TCO 2) Which of the following is one of the six types of objects in an Access database? (Points : 4) | files classes folders tables* |
7. (TCO 1) In Access, the purpose of a filter is to (Points : 4) | display a subset of records based on specified criteria*. Pg 85 create a duplicate copy of the database. reduce the size of the database. list records in a specific sequence. |
8. (TCO 1) The purpose of a sort in Access is to (Points : 4) | display only records that match the selected criteria.* list records in a specific sequence. create a relationship between two tables. prevent entering erroneous data. |
9. (TCO 1) You should use Access rather than Excel to manage your data when you (Points : 4)
2. (TCO 1) By definition, a three-tier architecture includes clients, ___________, and a data server. (Points : 4) | Web browsers an application server* pg F-11 an email server a proxy server |
3. (TCO 2) A single piece of data, such as a supplier's phone number or an employee's last name, is referred to as (Points : 4) | a record. a field. * an entity. a row. |
4. (TCO 2) A field or set of fields used to uniquely identify a record in a table is (Points : 4) | an entity. a row. a primary key.* a tag. |
5. (TCO 2) A collection of related data items that are specific to an instance of an entity, such as all the data about a specific employee, is (Points : 4) | a table.* a database. a column. a record. |
6. (TCO 2) Which of the following is one of the six types of objects in an Access database? (Points : 4) | files classes folders tables* |
7. (TCO 1) In Access, the purpose of a filter is to (Points : 4) | display a subset of records based on specified criteria*. Pg 85 create a duplicate copy of the database. reduce the size of the database. list records in a specific sequence. |
8. (TCO 1) The purpose of a sort in Access is to (Points : 4) | display only records that match the selected criteria.* list records in a specific sequence. create a relationship between two tables. prevent entering erroneous data. |
9. (TCO 1) You should use Access rather than Excel to manage your data when you (Points : 4)