Q&A Hero

Q: Which type of DSS allows you to analyze spatial information? A.Geographic information system B.Model information system C.Expert system D.Multidimensional information system

Q: When businesses utilize GIS software to generate maps, we call it _____.

Q: If you were "tweaking" your technology solution so that it worked more efficiently than its original form, what decision making phase would you be in? A.Implementation B.Maintenance C.Choice D.Continuation

Q: The know-how of an expert system actually comes from a(n) _____.

Q: A(n) _____ mimics one ability of the human brain.

Q: A database management system contains five important software components. Which of the following components allows you to define the structure of a database? A.Data definition subsystem B.Data manipulation subsystem C.Application generator subsystem D.Data administration subsystem

Q: A(n) _____ mimics the evolutionary survival-of-the-fittest process to generate increasingly better solutions to a problem.

Q: _____ is a way of simulating human organizations using multiple intelligent agents.

Q: _____ is learning from ecosystems and adapting their characteristics to human organizations.

Q: In a multi-agent system, groups of intelligent agents can work _____ but also _____ with each other.

Q: Data-mining agents are used to shift through a _____ looking for _____.

Q: A swarm intelligence system must be _____ so it can respond to changes in the environment around it.

Q: An expert system and a neural network differ in that the neural network can _____.

Q: Which type of information system is well known for allowing you to view information spatially? A.Expert system B.Decision support system C.Neural network system D.Geographic information system

Q: Which type of constraint ensures the quality of information in a relational database? A.Environmental B.Business constraint C.Integrity constraint D.Production constraint

Q: In what decision making phase do you recognize a problem, need, or opportunity? A.Predication and decision B.Choice C.Preliminary or investigative D.Intelligence

Q: If you were looking at information in a database and you able to see only the information you needed in the format you wanted, what type of database view would you see? A.Logical view B.High-level view C.User view D.Physical view

Q: In what decision making phase do you consider possible ways of solving problems, filling needs, or capitalizing on opportunities? A.Design B.Intelligence C.Choice D.Prediction and decision

Q: If you were a programmer and needed to view information as it was stored by the database, what type of database view would you see? A.Logical view B.Physical view C.Stored view D.Objective view

Q: In what decision making phase do you examine and weigh the merits of solutions, estimate the consequence of each, and choose the best solution? A.Design B.Choice C.Intelligence D.Preliminary or investigative

Q: What must you define before adding any information to a relational database? A.The intended audience B.The physical hardware structure C.The administrative rights of users D.The logical structure of the database

Q: In what decision making phase do you implement solutions and monitor and adjust the environment based on the consequences of these solutions? A.Choice B.Execution C.Implementation D.Maintenance

Q: The _____ allows you to communicate with the DSS.

Q: If you were to identify and investigate a problem in your organization, what decision making phase would you be in? A.Design B.Preliminary or investigative C.Intelligence D.Planning

Q: Which of the following terms represent an organized and structured collection of information? A.Database management system B.Database C.Data dictionary D.Structured query system

Q: Which type of database stores data in a series of logically related two-dimensional tables or files? A.Hierarchical B.File-based C.Conventional D.Relational

Q: In an organization, _____ is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories.

Q: Your student ID is an example of a(n) _____. A.Relation B.Table C.Business rule D.Attribute

Q: A(n) _____ 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: Which term refers to a specific piece of data that is stored in a database file? A.Relation B.Category C.Class D.Attribute

Q: Multidimensional analysis tools use _____ techniques to view information from different perspectives.

Q: Which type of database model organizes and accesses information according to it logical structure rather than its physical structure? A.Hierarchical B.File-based C.Relational D.Conventional

Q: _____ are slice-and-dice techniques that allow you to view multidimensional information from different perspectives.

Q: Which part of a relational database contains the logical structure for the information? A.Data dictionary B.Relation C.Query D.SQL

Q: Which of the following are large electronic repositories of very detailed information? A.Libraries B.Data compilations C.Data collections D.Databases

Q: If you needed to store facts about information that you were collecting, you would store these facts in the _____. A.Relations B.Database management system C.Business rules D.Data dictionary

Q: What is another name for a database? A.Information repository B.Data depository C.Data warehouse D.Information depot

Q: Which type of application requires that you know the physical location of information before you are able to access it? A.Database management systems B.Database C.Spreadsheets D.Business intelligence

Q: When information is stored about a purchase or sale, what is stored in a database? A.A transaction B.A table C.A view D.A query

Q: What is the type of field, or group of fields, that can uniquely identify each record in a database? A.Identifying B.Relational C.Primary key D.Main field

Q: To succeed in business and to enable your organization to extract meaningful information from its information repositories, you need which type of application? A.Query-by-example B.Business intelligence C.Information analysis D.SQL

Q: If your phone number was used in a clothing store to uniquely identify you as a customer, the phone number would be considered a(n) _____. A.Identifying field B.Relational field C.Primary key D.Principle key

Q: What application enables your organization to analyze competitor, customer, environmental, and internal data? A.Query-by-example B.Information analysis C.Business intelligence D.SQL

Q: Every primary key can also be a _____ key. A.Foreign B.Secondary C.Identifying D.Relational

Q: Which system allows your organization to gather, process, and update transactional information? A.Online analytical processing (OLAP) B.Business intelligence (BI) C.File management systems (FMS) D.Online transaction processing (OLTP)

Q: What is another name for a database that supports OLTP? A.Business intelligence B.File management C.Records management D.Operational database

Q: Which application supports the manipulation of information to support decision making? A.Online transaction processing (OLTP) B.Records management C.Relational database administration D.Online analytical processing (OLAP)

Q: A senior manager who analyzes internal and external information to analyze marketing campaigns and their affect on customer buying habits is using which type of application? A.Online analytical processing (OLAP) B.Strategic information systems (GIS) C.Knowledge Management D.Customer Management

Q: Which of the following systems contain information from multiple databases? A.Data warehouses B.Data marts C.OLTPs D.Data warehouses and data marts

Q: According to your textbook, a(n) _____ permits you to see the contents of a database file, change the contents, and sort the file.

Q: A(n) _____ contains a subset of a data warehouse.

Q: Query-by-example tools rely heavily upon the _____ within a database to find information.

Q: In an organization, _____ plans for, oversees the development of, and monitors the information resource.

Q: _____ and _____ both extract data meeting specific criteria from a database, but have different user interfaces.

Q: A(n) _____ subsystem permits the user to develop transaction-intensive applications.

Q: A(n) _____ subsystem controls facilities for backing up the database and establishing security.

Q: A(n) _____ subsystem contains facilities for concurrency control.

Q: A(n) _____ subsystem controls facilities for change management.

Q: The primary key of the Customer file is the Customer ID field and the primary key of the Order file is the Order ID field. Therefore, the _____ field would be used to create a logical relationship between the Customer and Order files.

Q: _____ maintain statistics regarding how the DBMS engine physically accesses information.

Q: If a salesperson attempts to order merchandise for a customer not in the customer database, the database will typically generate an error message. This message indicates that a(n) _____ has been violated.

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

Q: A database management system helps you specify the _____ organization of data within a database.

Q: _____ permit users to examine the impact of proposed structural changes on a database.

Q: Microsoft Access is an example of a(n) _____.

Q: A(n) _____ is a multidimensional method of storing data for analysis.

Q: A(n) _____ represents how data is physically stored on a storage device.

Q: A(n) _____ is a multidimensional representation of information.

Q: A(n) _____ represents how users see information to meet their particular business needs.

Q: To determine the impact of an advertising blitz based on a specific product line for the northern region in the 4th quarter, a _____ would be used.

Q: A(n) _____ subsystem is used to create and maintain the data dictionary.

Q: Because data warehouses are not transaction-oriented, they only support _____.

Q: Views are located within the _____ subsystem of the DBMS.

Q: A(n) _____ uses artificial intelligence to build business intelligence.

Q: Report generators are contained within the _____ of the DBMS.

Q: _____ help users apply various mathematical models to information stored in a data warehouse to discover new information.

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.