FINAL TEST MGT300 INFORMATION TECHNOLOGY IN BUSINESS

Which of the following

represents the different information levels?

• Detail, summary, aggregate

• Individual, department, enterprise

• Document, presentation, spreadsheet, database

• Individual, document, presentation, spreadsheet, database

What is one of the biggest pitfalls associated with real-time information?

• It is only available to high-level executives due to the expense

• It is only available in aggregate levels of granularity

• It continually changes

• It rarely changes

Which of the following database structures stores information in a tree-like structure that allows repeating information using parent/child relationships, in such a way that it cannot have too many relationships?

• Hybrid database

• Network database

• Hierarchical database

• Relational database model

In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?

• Entity

• Attribute

• Constraint

• Relationships

Which of the following is incorrect in reference to a database?

• Can be relational or network

• Information is accessed by logical structure

• Information is accessed by physical structure

• Users can access different views of information

A data warehouse is a __________ collection of information-gathered from many different __________ databases-that supports business analysis activities and decision-making tasks.

• Physical, transactional

• Physical, operational

• Logical, transactional

• Logical, operational

What is data mining?

• A particular attribute of information

• The common term for the representation of multidimensional information

• Process of analyzing data to extract information not offered by the raw data alone

• Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making

When does information cleansing occur in the data warehouse?

• During the ETL process

• On the information, once it is in the data warehouse

• During the ETL process and once it is in the data warehouse

• During the ETL process and before it is in the data warehouse

Which of the following is the most commonly used form of AI in the business area?

• Neural network

• Expert systems

• Intelligent system

• Artificial intelligence

What is an artificial intelligence system that mimics the evolutionary, survival-of-the-fittest process to generate increasingly better solutions to a problem?

• Neural network

• Intelligent system

• Genetic algorithm

• Artificial intelligence