Strayer ACC564 (Strayer) Week 9 Quiz 4

ACC 564 (Strayer) Week 9 Quiz 41) Using a file-oriented approach to data and information, data is maintained inA) a centralized database.B) many interconnected files.C) many separate files.D) a decentralized database.2) In a well-structured relational database,A) every table must be related to at least one other table.B) every table must be related to all other tables.C) one table must be related to at least one other table.D) one table must be related to all other tables.3) File-oriented approaches create problems for organizations because ofA) multiple transaction files.B) a lack of sophisticated file maintenanceC) multiple users.D) multiple master files.4) Which statement is true regarding file systems?A) Transaction files are similar to ledgers in a manual AIS.B) Multiple master files create problems with data consistency.C) Transaction files are permanent.D) Individual records are never deleted in a master file.5) The ________ acts as an interface between the database and the various application programs.A) data warehouseB) database administratorC) database Management SystemD) Database System6) The combination of the database, the DBMS, and the application programs that access the database through the DBMS is referred to as theA) data warehouse.B) database administrator.C) database system.D) database manager.7) The person responsible for the database is theA) data coordinator.B) database administrator.C) database manager.D) database master.8) All of the following are benefits of the database approach except:A) Data integration and sharingB) Decentralized management of dataC) Minimal data redundancyD) Cross-functional analysis and reporting9) The physical view of a database system refers toA) how a user or programmer conceptually organizes and understands the data.B) how the DBMS accesses data for a certain application program.C) how and where the data are physically arranged and stored.D) how master files store data values used by more than one application program.10) The ________ handles the link between the way data are physically stored and each user’s logical view of that data.A) data warehouseB) data dictionaryC) database management (DBMS) softwareD) schema11) The logical structure of a database is described by theA) data dictionary.B) schema.C) database management system.D) internal level.12) The schema that provides an organization-wide view of the entire database is known as theA) external-level schema.B) internal-level schema.C) conceptual-level schema.D) logical view of the database.13) A set of individual user views of the database is called theA) conceptual-level schema.B) internal-level schema.C) external-level schema.D) meta-schema.14) A low-level view of the database that describes how the data are actually stored and accessed is theA) conceptual-level schema.B) subschema.C) internal-level schema.D) external-level schema.15) Record layouts, definitions, addresses, and indexes will be stored at the ________ level schema.A) externalB) conceptualC) internalD) meta16) The ________ contains information about the structure of the database.A) data definition languageB) data dictionaryC) data warehouseD) database management system17) Which of the following would not be found in a data dictionary entry for a data item?A) records containing a specific data itemB) physical location of the dataC) source of the data itemD) field type18) The data dictionary usually is maintainedA) automatically by the DBMS.B) by the database administrator.C) by the database programmers.D) by top management.19) Reports produced using the data dictionary could include all of the following except a list ofA) programs where a data item is used.B) synonyms for the data items in a particular file.C) outputs where a data element is used.D) the schemas included in a database.20) Which statement below concerning the database management system (DBMS) is false?A) The DBMS automatically creates application software for users, based on data dictionary parameters.B) The DBMS automatically maintains the data dictionary.C) Users’ requests for information are transmitted to the DBMS through application software.D) The DBMS uses special languages to perform specific functions.21) Which would not generally be considered a data dictionary output report?A) A list of cash balances in the organization’s bank accountsB) A list of all programs in which a data element is usedC) A list of all synonyms for the data elements in a particular fileD) A list of all data elements used by a particular user22) Creating an empty table in a relational database requires use of the ________, and populating that table requires the use of ________.A) DDL; DMLB) DQL; SQLC) DDL; DQLD) DML; DDA23) 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 LanguageB) Data Manipulation LanguageC) Data Report LanguageD) Data Definition Language24) 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 LanguageB) Data Manipulation LanguageC) Data Query LanguageD) Data Update Language25) 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 theA) report writer.B) report generator.C) report creator.D) report printer26) The abstract representation of the contents of a database is called theA) logical data model.B) data dictionary.C) Physical view.D) schema.27) The problem of changes (or updates) to data values in a database being incorrectly recorded is known asA) an update anomaly.B) an insert anomaly.C) a delete anomaly.D) a memory anomaly.28) The potential inconsistency that could occur when there are multiple occurrences of a specific data item in a database is called theA) update anomaly.B) insert anomaly.C) inconsistency anomaly.D) delete anomaly.29) Inability to add new data to a database without violating the basic integrity of the database is referred to as theA) update anomaly.B) insert anomaly.C) integrity anomaly.D) delete anomaly.30) A relational database in which customer data is not maintained independently of sales invoice data will most likely result inA) an update anomaly.B) an insert anomaly.C) a delete anomaly.D) an integrity anomaly. More Questions are Included…