WGU C175 quizzes 2022 with complete solution 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 1 / 3
A(n) _____ might be written by a programmer or it might be created through a DBMS utility program. Answer- application _____ is the body of information and facts about a specific subject. Answer- Knowledge An XML database supports the storage and management of _____ XML data. Answer- semistructured The only way to access the data in a database is through the DBMS. Answer- True Metadata describe the data characteristics and the set of relationships that links the data found within the database. Answer- True A data warehouse can store data derived from many sources. Answer- True A workgroup database is a(n) _____ database. Answer- multiuser Data is said to be verifiable if_____ Answer- the data always yields consistent results.A desktop database is a _____ database. Answer- single-user _____ is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions. Answer- Data integrity Corporations use only structured data. Answer- False ________ is a special language used to represent and manipulate data elements in a textual format. Answer- Extensible Markup Language (XML) Data processing can be as simple as organizing data to reveal patterns. Answer- True Data is the result of processing raw facts to reveal its meaning.
True
False Answer- False ________ is data about data through which the end-user data are integrated and managed. Answer- Metadata One disadvantage of a database system over previous data management approaches is increased costs. Answer- True ________ relates to activities that make a database operate more efficiently in terms of storage and access speed. Answer- Performance tuning 2 / 3
________ is the result of processing raw data to reveal its meaning. Answer- Information Structural dependence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data. Answer- False Data constitute the building blocks of information. Answer- True An operational database is sometimes referred to as an enterprise database. Answer- False ________ exists when the same data are stored unnecessarily at different places.Answer- Data redundancy _____ serve as the intermediary between the user and the database. Answer- DBMSs One advantage of a database system over previous data management approaches is that the database system is considerably less complex. Answer- False The organization of data within folders in a manual file system is determined by _____.Answer- its expected use ________ databases focus primarily on storing data used to generate information required to make tactical or strategic decisions. Answer- Analytical What refers to the situation where the same data is stored unnecessarily at different places? Answer- Data redundancy Information is produced by processing ________ . Answer- data A(n) ________ is a specific request issued to the DBMS for data manipulation. Answer- query An advantage of database systems is that you needn't perform frequent updates and apply latest patches. Answer- False Raw data must be properly ________ for storage, processing and presentation.Answer- formatted A _____ is a logically connected set of one or more fields that describes a person, place, or thing. Answer- record A(n) ________ develops when all required changes in the redundant data are not made successfully. Answer- data anomaly
- / 3