WGU C175 Questions And Answers

One disadvantage of the DBMS is that it increases the risk of data security breaches. - Answer- False Accurate, relevant, and timely information is the key to____. - Answer- good decision making _____ relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed. - Answer- Performance tuning The response of the DBMS to a query is the ______. - Answer- query result set Field refers to a collection of related records. - Answer- False The DBMS uses the ________ to look up the required data component structures and relationships, thus relieving programmers from having to code such complex relationships in each program. - Answer- data dictionary A(n) ________ is a collection of programs that manages the database structure and controls access to the data stored in the database. - Answer- database management system A _____ is a character or group of characters that has a specific meaning. - Answer- field Data warehouse contains historical data obtained from the_____. - Answer- operational databases The database structure in a DBMS is stored as a ______. - Answer- collection of files The DBMS reveals much of the database's internal complexity to the application programs and users. - Answer- False _____ exists when different versions of the same data appear in different places. - Answer- Data inconsistency A _____ contains at least all of the attribute names and characteristics for each table in the system. - Answer- data dictionary A(n) _____ might be written by a programmer or it might be created through a DBMS utility program. - Answer- application