ais ch 4 PART 2
23) When the human resources manager wants to gather data about vacation and personal day usage by employees and by departments, the manager would use which language? A) Data Query Language B) Data Manipulation Language C) Data Report Language D) Data Definition Language
A
24) If a national sales tax were implemented, which language would be used to add a new field in the sales table to track the sales tax due? A) Data Definition Language B) Data Manipulation Language C) Data Query Language D) Data Update Language
A
25) The feature in many database systems that simplifies the creation of reports by allowing users to specify the data elements desired and the format of the output. is named the A) report writer. B) report generator. C) report creator. D) report printer.
A
26) The abstract representation of the contents of a database is called the A) logical data model. B) data dictionary. C) physical view. D) schema.
A
27) The problem of changes (or updates) to data values in a database being incorrectly recorded is known as A) an update anomaly. B) an insert anomaly. C) a delete anomaly. D) a memory anomaly.
A
28) The potential inconsistency that could occur when there are multiple occurrences of a specific data item in a database is called the A) update anomaly. B) insert anomaly. C) inconsistency anomaly. D) delete anomaly.
A
32) The delete anomaly A) may result in unintentional loss of important data. B) is usually easily detected by users. C) restricts the addition of new records. D) prevents users from deleting outdated data from records or tables.
A
33) The update anomaly in file-based systems or unnormalized database tables A) occurs because of data redundancy. B) restricts addition of new fields or attributes. C) results in records that cannot be updated. D) is usually easily detected by users.
A
34) In a relational database, requiring that every record in a table have a unique identifier is called the A) entity integrity rule. B) referential integrity rule. C) unique primary key rule. D) foreign key rule.
A
42) What is one potential drawback in the design and implementation of database systems for accounting? A) Double-entry accounting relies on redundancy as part of the accounting process but well-designed database systems reduce and attempt to eliminate redundancy. B) Relational DBMS query languages will allow financial reports to be prepared to cover whatever time periods managers want to examine. C) Relational DBMS provide the capability of integrating financial and operational data. D) Relational DBMS can accommodate multiple views of the same underlying data; therefore, tables storing information about assets can include data about both historical and replacement costs.
A
44) In a well-designed and normalized database, which of the following attributes would be a foreign key in a cash receipts table? A) Customer number B) Cash receipt date C) Remittance advice number D) Customer check number
A
29) Inability to add new data to a database without violating the basic integrity of the database is referred to as the A) update anomaly. B) insert anomaly. C) integrity anomaly. D) delete anomaly.
B
30) A relational database in which customer data is not maintained independently of sales invoice data will most likely result in A) an update anomaly. B) an insert anomaly. C) a delete anomaly. D) an integrity anomaly.
B
35) The database requirement that foreign keys must be null or have a value corresponding to the value of a primary key in another table is formally called the A) entity integrity rule. B) referential integrity rule. C) rule of keys. D) foreign key rule.
B
36) In a well-structured database, the constraint that ensures the consistency of the data is known as the A) entity integrity rule. B) referential integrity rule. C) logical view. D) consistency integrity rule.
B
31) The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the ________ anomaly. A) purge B) erase C) delete D) integrity
C
38) Identify the aspect of a well-structured database that is incorrect. A) Data is consistent. B) Redundancy is minimized and controlled. C) All data is stored in one table or relation. D) The primary key of any row in a relation cannot be null.
C
39) In the database design approach known as normalization, the first assumption made about data is A) there is no redundancy in the data. B) the delete anomaly will not apply since all customer records will be maintained indefinitely. C) everything is initially stored in one large table. D) the data will not be maintained in 3NF tables.
C
37) Which statement below is false regarding the basic requirements of the relational data model? A) Every column in a row must be single-valued. B) All non-key attributes in a table should describe a characteristic about the object identified by the primary key. C) Foreign keys, if not null, must have values that correspond to the value of a primary key in another table. D) Primary keys can be null.
D
40) The database design method in which a designer uses knowledge about business processes to create a diagram of the elements to be included in the database is called A) normalization. B) decentralization. C) geometric data modeling. D) semantic data modeling.
D
41) Which of the statements below is incorrect? A) Semantic data modeling facilitates the efficient design of databases. B) Semantic data modeling facilitates communicating with the intended users of the system. C) Semantic data modeling allows a database designer to use knowledge about business processes to design the database. D) Semantic data modeling follows the rules of normalization in the design of a database.
D
43) Which is probably the most immediate and significant effect of database technology on accounting? A) replacement of the double entry-system B) change in the nature of financial reporting C) elimination of traditional records such as journals and ledgers D) quicker access to and greater use of accounting information in decision-making
D