WorksheetsFINAL TEST MGT300 INFORMATION TECHNOLOGY IN BUSINESS
Total questions: 42
Worksheet time: 4hrs 50mins
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
Which of the following is a form of statistical analysis?
Market basket analysis
Prediction of planning
Cluster analysis
Forecasting
Which of the following is NOT of the main links in the supply chain?
Materials flow from suppliers and their “downstream” suppliers at all levels
Distribution of products to customers and their “downstream” customers at all levels
Transformation of materials into semi finished and finished products – the organization’s own production processes
Improve customer service levels are measured by on-time shipments of the right quality product in the appropriate quantity.
DSSs allow managers to examine performance and relationships over the supply chain and among:
Suppliers
Transportation options
Other factors that optimize supply chain performance
All of the above
What is the set of processes that plans for and controls the efficient and effective transportation and storage of suppliers from suppliers to customers?
Logistics
Demand planning
Supply chain planning
Supply chain execution
What is an organization performing when it asks questions such as “why was customer revenue so high”?
CRM reporting technologies
CRM processing technologies
CRM processing technologies
CRM predicting technologies
Which of the following is NOT CRM business drivers?
Accountability
Inventory control
Increase revenues
Automation/productivity/efficiency
Which of the following analytical CRM tools slice-and-dice customer information to create made-to-order views?
Supports traditional transactional processing
Supports day-to-day front-office operations
Supports operations that deal directly with the customers
All of the above
Who are the primary users of SCM systems?
Sales, marketing, customer service
Accounting, finance, logistics, and production
Customers, resellers, partners, suppliers, and distributors
Sales , customers, resellers, partners, suppliers, and distributors
What is an IT–based set of tools that supports the work of teams by facilitating the sharing and flow of information?
Collaboration system
Structured collaboration
Unstructured collaboration
Content management system
Which of the following is the top reason why organizations launch knowledge management systems?
Reduce costs
Increase profits or revenues
Develop new products or services
Improve customer retention and/or satisfaction
Reports for each sales person, product, and part are examples of detail or fine information granularities.
TRUE
FALSE
Timely information must be up-to-the-second to be accurate.
TRUE
FALSE
Data-driven business intelligence occurs when users run queries or use analytical tools, such as a Pivot Table, on a database that is attached to a Web site.
TRUE
FALSE
Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.
TRUE
FALSE
One of the advantages found in a relational database is increased information redundancy.
TRUE
FALSE
The data warehouse is a location for all of a business’s information.
TRUE
FALSE
Extraction, transformation, and loading is a process that extracts information from internal databases, transforms the information using a common set of enterprise definitions, and loads the information into an external database.
TRUE
FALSE
The primary purpose of a data warehouse is to perform transactional processes
TRUE
FALSE
A genetic algorithm is an artificial intelligence system that mimics the evolutionary, survival-of-the-fittest process to generate increasingly better solutions to a problem
TRUE
FALSE
The ultimate goal of AI is the ability to build a system that can mimic human intelligence.
TRUE
FALSE
Consolidation, drill-down, and slice-and-dice are the three most common capabilities offered in an EIS.
TRUE
FALSE
The customers’ customer is upstream in the supply chain.
TRUE
FALSE
Deploy in incremental phases and measure and communicate success is one of the keys to success for SCM.
TRUE
FALSE
Information technology’s primary role in supply chain management is creating the integrations or tight process and information linkages between functions within a firm - such as marketing, sales, finance, manufacturing, and distribution – and between firms.
TRUE
FALSE
RFM stands for Regency, Frequency, and Monetary.
TRUE
FALSE
CRM is a technology based on the premise that those organizations that understand the needs of individual customers are best positioned to achieve sustainable competitive advantage in the future
TRUE
FALSE
The primary difference between operational CRM and analytical CRM is the direct interaction between the organization and its suppliers.
TRUE
FALSE
A collaboration system is an IT–based set of tools that supports the work of teams by facilitating the sharing and flow of information.
TRUE
FALSE
E-commerce is the conducting of business on the Internet, not only buying and selling, but also serving customers and collaborating with business partners.
TRUE
FALSE
One of the primary reasons for ERP explosive growth is that an ERP system is a logical solution to the many incompatible applications found in business today.
TRUE
FALSE
Discuss any TWO (2) advantages of database from a business perspective.
Elaborate differences between E-Commerce and E-Business.
