Q&A Hero

Q: A(n) _____ allows you to see the contents of a database file, make whatever changes you want, perform simple sorting, and query to find the location of specific information.

Q: A(n) _____ defines formats of reports and what information you want to see in a report.

Q: _____ is a standardized fourth-generation query language found in most DBMSs.

Q: _____ is knowledge about your customers, your competitors, your partners, your competitive environment, and your own internal operations.

Q: _____ allows you to query by pointing, clicking, and dragging and then specifying a selection criteria.

Q: _____ is responsible for the more technical and operational aspects of managing the information contained in organizational databases.

Q: A(n) _____ contains facilities to help you develop transaction-intensive applications.

Q: _____ are software tools used to query information in a data warehouse.

Q: _____ ensure the validity of database updates when multiple users attempt to access and change the same information.

Q: _____ are databases that support OLTP.

Q: A database consists of _____ and a(n) _____.

Q: _____ is the manipulation of information to support decision making.

Q: A(n) _____ uniquely identifies each record.

Q: _____ is the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information.

Q: A(n) _____ is a primary key from one table placed within a second table to establish a relationship between the two tables.

Q: The term relation often describes each _____ table or file in the relational model.

Q: The _____ uses a series of logically related two-dimensional tables or files to store information in the form of a database.

Q: A(n) _____ is a collection of information that you organize and access according to the logical structure of that information.

Q: Data-mining tools support the concept of OLTP in manipulating information to support decisions.

Q: Multidimensional analysis (MDA) tools are slice-and-dice techniques that allow you to view multidimensional information from different perspectives.

Q: A data mart is a subset of a data warehouse in which only a focused portion of the data warehouse information is kept.

Q: An intelligent agent utilizes artificial intelligence to "discover" information in data warehouses.

Q: Intelligent agents are used in OLAP and in online searching.

Q: Data marts focus on the entire organization, while data warehouses focus on specific needs.

Q: Data administration is the function in an organization that is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories.

Q: There is no way to examine the impact of proposed changes on an existing database.

Q: Data warehouses always uses 2D tables to store data.

Q: A data warehouse is a logical collection of information gathered from many different operational databases used to create business intelligence that supports business analysis activities and decision-making tasks.

Q: A hypercube is a two-dimensional representation of information.

Q: Data warehouses support transaction processing.

Q: The data manipulation subsystem is often the interface between the user and the information contained in the database.

Q: Report generators help you quickly define formats of reports and what information you want to see in a report.

Q: Query-by-example (QBE) tools help you graphically design the answer to a question.

Q: The data administration subsystem is used to create the data dictionary.

Q: Backup and recovery facilities are included in the data administration subsystem.

Q: The data definition subsystem includes security management facilities.

Q: Structured query language (SQL) is a standardized first-generation query language found in most DBMSs.

Q: There can be duplicate primary keys in the same file in a database.

Q: QBE allows you to query by pointing, clicking, and dragging, unlike SQL.

Q: Foreign keys uniquely identify records.

Q: The data dictionary includes query optimization facilities.

Q: A primary key from one file and a foreign key from another file are used to create a relationship between two files in a relational database.

Q: Query optimization facilities are used to create backups just in case the database is damaged or lost.

Q: If a salesperson attempts to order merchandise for a customer who should but does not exist in the customer database, the database will typically generate an error message. This message indicates that an integrity constraint has been violated.

Q: Database security and network security are the same thing.

Q: A physical view represents how the users view the data.

Q: The acronym DBMS stands for Database Marketing System and is a type of database designed to support the marketing function within a business.

Q: A database management system (DBMS) allows you to specify the logical organization for a database and access and use the information within a database.

Q: The logical view of information focuses on how you arrange and access information to meet the needs of the business.

Q: If you need to add a new field to a database, you would use the data manipulation system.

Q: XYZ, Corp. would like to determine advertising strategies for customers who buy high-priced products. It would use OLTP on its data warehouse.

Q: A database is a collection of information that you organize and access according to the logical structure of that information.

Q: A relational database model uses a series of physically related two-dimensional tables or files to store information in the form of a database.

Q: Assume you have an order entry database with an Order file and a Customer file. The Order Date field most likely would be the common field used to relate the two files.

Q: A database actually consists of three parts: information, the logical structure of that information, and tables.

Q: Which of the following functions plans for, oversees the development of, and monitors the information resources of an organization? A.Data administration B.Strategic management C.Information resource planning D.Operational planning

Q: A data dictionary is a two-dimensional table used to store data within a relational database.

Q: Which organizational function is responsible for the more technical and operational aspects of managing information repositories? A.Database administration B.Strategic management C.Information resource planning D.Operational planning

Q: A primary key must consist of one and only one field.

Q: Which organizational function is responsible for developing security procedures for an organization? A.Data security B.Data protection C.Information resource management D.Database administration

Q: What is the difference between data administration and database administration? A.Data administration focuses on strategic management whereas database administration focuses on operational issues B.Data administration focuses on OLTP whereas database administration focuses on OLAP C.Data administration and database administration are terms that can be used interchangeably D.Data administration focuses on the development of the data dictionary whereas database administration focuses on the raw data

Q: What is the term used to describe the sharing of information regardless of title or department. A.Open source B.Data mining C.Information sharing D.Data distribution

Q: A key consideration in today's business environment is ______ or the assigning of responsibility for ensuring the quality of information. A.Accountability B.Information ownership C.Data security D.Data management and control

Q: If your student information had two different birth dates for you, your data would not be considered _____.A.LegitimateB.CorrectC.CleanD.Acceptable

Q: Business intelligence is knowledge about your customers, your competitors, your partners, your competitive environment, and your own internal operations.

Q: Operational databases are databases that support OLAP.

Q: Online analytical processing (OLAP) is the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information.

Q: If an employee needs to change the details of a specific customer order, he/she would use OLTP (online transaction processing).

Q: If you were working for a large pharmaceutical company and building a sales report on current prescription writing habits of doctors, what type of information repository would you be most likely working with? A.Data warehouse B.Operational database C.Transactional database D.Data mart

Q: If you were comparing information from various divisions of an organization for instance, sales, marketing, and production, what type of information repository would you most likely work with? A.Data mart B.Data warehouse C.Hypercube database D.Data mining

Q: What is a data warehouse? A.A large hardware environment that supports multiple platforms B.A logical collection of information gathered from many different operational databases to create business intelligence C.An operational database system used to manage and analyze transactional data D.An accumulation of all operational data stored by large organizations

Q: What is the objective of business intelligence (BI)? A.To process transactional information efficiently and effectively B.To provide decisions makers with a great deal of information C.To provide timely and quality information to decision makers D.To process external information or information that is purchased from outside vendors

Q: What does it mean for a data warehouse to be multidimensional? A.The database stores data, facts, and definitions for all stored information B.Data can be linked to other sources of internal and external information C.The files stored in a warehouse contain multiple layers of columns and rows D.Customer information can be related to sales, departmental, and organizational information

Q: When business intelligence is focused on the external competitive environment, it is known as _____. A.External information B.Trends C.Competitive intelligence D.Competitor knowledge

Q: What is a hypercube? A.A hyper text link stored in a database B.Data definitions that are linked to other related, but external, attributes or fields C.Database that is built on Internet technology D.Multidimensional representation of information

Q: What is a digital dashboard? A.A new type of electronic dashboard for high-priced cars that displays GPS information alongside of traditional information B.A learning environment for online educational courses C.A computer tool that provides competitive information from external sources D.A computer screen that provides tailored, current snapshots of information and trends

Q: What is the purpose of a data warehouse? A.Backup and recovery B.To support decision making and OLAP C.To support transaction processing and OLTP D.To support, backup and recovery, OLAP, and OLTP

Q: What type of software tool is used to query information stored in a data warehouse? A.OLTP B.Analytical C.Data-mining D.Decision support

Q: Data-mining tools include all but which of the following? A.Query-and-reporting B.Intelligent agents C.Data manipulation D.Statistical

Q: In a data warehouse, which tool would you use to build reports quickly and without having to write programming code? A.Application generator B.Intelligent agents C.Multidimensional analysis tools D.Query-and-reporting tools