DBMS Assessment Exam

DBMS Assessment Exam The word ____ indicates that the facts have not yet been processed to reveal their meaning. - raw Processed data, or ____, can be used as the foundation for decision making. - information Raw data must be properly ____ for storage, processing, and presentation. - formatted What is a key characteristic of knowledge? - "new" knowledge can be derived from "old" knowledge Accurate, relevant, and timely ____ is the key to good decision making. - information What is the name for data about data? - metadata Data management is a discipline that focuses on ____. - the proper generation, storage, and retrieval of data What is a benefit of using a DBMS? - they help create an environment for end users to have access to more data The ____ manages interaction between the end user and the database. - DBMS The ____ receives all application requests and translates them into the complex operations required to fulfill requests. - DBMS An ad hoc query is a ____. - spur-of-the-moment question Wider access to well-managed data promotes a(n) ____ view of the organization's operations and a clearer view of the big picture. - integrated What is the name for an answer to a query that the DBMS sends back to the application? - query result set A single-user database that runs on a personal computer is called a(n) ____ database. - desktop A database that supports data distributed across several different sites is called a(n) ____ database. - distributed The ____ is a specialized database that stores data in a format optimized for decision support. - data warehouse Another name for a production database is a ____ database. - transactional John is working in the customer table and needs to know what customers are located in Florida. To find the information he would ____. - create a new query How many users does a workgroup database usually support? - 50 Which of the following products do not provide an enterprise database? - MS Access The design of a ____ database recognizes the use of historical and aggregated data. - data warehouse Data processing (DP) specialists are in existence because of ____. - the need to track data and produce required reports A ____ system is composed of software, hardware, data, procedures and people. - database Where was a traditional file system normally stored? - file cabinet