To answer the following questions, refer to the database below. 6) The following statements regarding the Vendor Orders above are true EXCEPT A) The database requires entering the same vendor contact information multiple times B) The database does not break the referential integrity rule C) The database requires a PO number and and item number to add a vendor record D) Deleting a vendor will also delete inventory information Answer: B Diff: 2 Objective: Q2.4 What is database integrity? 7) To add a vendor to the Vendor Orders table, the following information is required EXCEPT A) PO Number B) Vendor ID C) Item Number D) Vendor name Answer: D Diff: 1 Objective: Q2.4 What is database integrity? 8) The Vendor Orders table contains the following database anomalies EXCEPT A) Normalization problem B) Update problem C) Deletion problem D) Insertion problem Answer: A Diff: 1 Objective: Q2.4 What is database integrity? 9) Separating the database into related tables instead of just one large table helps to eliminate A) Deletion, update, and normalization problems B) Update, insertion, and creation problems C) Insertion, update, and authorization problems D) Deletion, update, and insertion problems Answer: D Diff: 2 Objective: Q2.4 What is database integrity? 10) Normalization is an optimization process that minimizes which of the following? A) Database integrity B) Unauthorized access C) Database access
To answer the following questions, refer to the database below. 6) The following statements regarding the Vendor Orders above are true EXCEPT A) The database requires entering the same vendor contact information multiple times B) The database does not break the referential integrity rule C) The database requires a PO number and and item number to add a vendor record D) Deleting a vendor will also delete inventory information Answer: B Diff: 2 Objective: Q2.4 What is database integrity? 7) To add a vendor to the Vendor Orders table, the following information is required EXCEPT A) PO Number B) Vendor ID C) Item Number D) Vendor name Answer: D Diff: 1 Objective: Q2.4 What is database integrity? 8) The Vendor Orders table contains the following database anomalies EXCEPT A) Normalization problem B) Update problem C) Deletion problem D) Insertion problem Answer: A Diff: 1 Objective: Q2.4 What is database integrity? 9) Separating the database into related tables instead of just one large table helps to eliminate A) Deletion, update, and normalization problems B) Update, insertion, and creation problems C) Insertion, update, and authorization problems D) Deletion, update, and insertion problems Answer: D Diff: 2 Objective: Q2.4 What is database integrity? 10) Normalization is an optimization process that minimizes which of the following? A) Database integrity B) Unauthorized access C) Database access
Test-Bank-for-Accounting-Information-Systems-The-Crossroads-of-Accounting-and-IT-2E-2nd-Edition.docx