BIS245 Wk3 Quiz

Which statement is true when referential integrity is enforced? It is an automatic option in every table design. Access checks the accuracy of spelling in the tables. It ensures data can be entered into a related table, even if it does not exist in the primary table. A record will not be added to the table if an ID that is referenced does not exist.

A record will not be added to the table if an ID that is referenced does not exist.

A primary key A) can be computer generated. B) consists of one field only that uniquely identifies each record in a table. C) is a relationship between two or more tables. D) All of the above

A) can be computer generated.

Which of the following is NOT a step in the database life cycle? A) Database design B) Maintenance and redevelopment C) Performance D) Testing

C) Performance

A domain is a 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.

C) set of values.

Which of the following is an example of an entity in a business? A) Company B) Business owner C) CEO D) Employees

D) Employees

All of the following explain index usage except 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.

D) indexes are created using the index property type.

All of the following describe a many-to-many relationship in Access except A) a junction (associative) table is used. B) many matching records are found in each direction between tables. C) may be used to connect to Oracle and other databases. D) there must be at least two tables.

D) there must be at least two tables.

To which of the following does the term cascading refer? Data changes travel from one table to another. Data is put in sequential order. Queries can retrieve data at a faster rate. Records are arranged in order.

Data changes travel from one table to another.

What does not define a composite key? Using two or more fields as a primary key Using three fields as a primary key Using two fields as a primary key Using one field as a primary key

Using one field as a primary key

You can reserve space for a field using the PNPI regulations. Sarbanes-Oxley Act. field size property. validation rule.

field size property.