INFM 109 Quiz Mod 5 Questions and Answers (100% Correct Elaborations)

Document Content and Description Below

1. An organization may require high-quality data to avoid fines and penalties for non-conformance to regulatoryrequirements. True or False?a. Trueb. False 2. Input/output devices provide data and ins... tructions to the computer and receive results from it.a. Trueb. False 3. A collection of attributes about a specific entity is a _______________.a. recordb. databasec. domaind. file4. A(n)entityis a person, place, or thing (object) for which data is collected, stored, and maintained. 5. A _______________ is a collection of similar entities while a(n) _______________ is a characteristic of an entity.a. domain and recordb. database and keyc. record and foreign keyd. file and attribute 6. Which of the following is not a function of the database management system _______________?a. database data normalization and data cleansingb. database backupc. database recoveryd. database security 7. A database and a database management system are the same thing. True or False?a. Trueb. False 8. A collection of instructions and commands to define and describe data and relationship in a specific database is a_______________.a. database schemab. data definition languagec. data modeld. data manipulation language 9. The process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, or irrelevant records thatreside in a database is called _______________.a. data normalizationb. data concurrency controlc. data managementd. data cleansing 10. In the design of a database, it is not necessary to know how long the data must be stored. True or False?a. Trueb. False 11. The use of primary keys and foreign keys make it impossible to define relationships between the data in two tables ofa relational database. True or False?a. Trueb. False 12. The purpose of data normalization is to _______________.a. remove any inaccurate or incomplete data from the databaseb. insert newer, more current data into the databasec. eliminate data redundancies and ensure data dependencies make sensed. delete old, obsolete data from the database13.ACIDproperties of SQL databases help ensure the integrity of data in the database. 14. Which of the following is not an advantage associated with database-as-a-service (DaaS)?a. It eliminates the installation, maintenance, and monitoring of in-house databases.b. It reduces hardware, software, and staffing related costs.c. The service provider can allocate more or less database storage capacity based on an individual customer'schanging needs.d. The customer has complete responsibility for database security access and database backup. 15. Data governance is a subset of data management. True or False?a. Trueb. False 16. One of the driving reasons behind the need for data management is to manage risk associated with the misstatementof financial data. True or False?a. Trueb. False 17. The individual who is responsible for planning, designing, creating, operating, securing, monitoring, and maintainingdatabases is thedatabase administrator . 18. Which of the following is not a key responsibility of the data governance team?a. develop policy that specifies who is accountable for various aspects of the datab. decide which database technology should be usedc. define processes for how the data is to be stored, archived, backed up, and protected from cyberattacksd. develop standards and procedures that define who is authorized to update, access, and use the data [Show More]

Last updated: 1 year ago

Preview 1 out of 3 pages