WGU C175 quizzes with 100% correct answers

WGU C175 quizzes with 100% correct answers One disadvantage of the DBMS is that it increases the risk of data security breaches. False True -Answer-False Accurate, relevant, and timely information is the key to _______. knowledge good decision making data management understanding -Answer-good decision making _____ relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed. Database design Query access Database management Performance tuning -Answer-Performance tuning The response of the DBMS to a query is the ______. integrated view of the data query result set ad hoc response ad hoc query -Answer-query result set Field refers to a collection of related records. False True -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. file record field database -Answer-field Data warehouse contains historical data obtained from the_____. desktop database enterprise databases workgroup databases operational databases -Answer-operational databases The database structure in a DBMS is stored as a ______. single file collection of files set of key/value pairs collection of queries -Answer-collection of files The DBMS reveals much of the database's internal complexity to the application programs and users. True False -Answer-False _____ exists when different versions of the same data appear in different places. Conceptual dependence Data inconsistency Poor data security Structural dependence -Answer-Data inconsistency A _____ contains at least all of the attribute names and characteristics for each table in the system. logical schema relational schema data dictionary database -Answer-data dictionary A(n) _____ might be written by a programmer or it might be created through a DBMS utility program. application database management system