WGU C175 QUIZZES QUESTIONS WITH CORRECT ANSWER

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