mangt 366 final
Which should be moved: Tiger and Lion by Rabbit and Cow, filtered by Dog
I should move tiger and lion
Think about IT's role in supply chain management, which of the following statements is INCORRECT in regards to IT's role in supply chain management
IT's role is to determine patterns of behavior that the company can use to generate profiles for each entity and/or user
Neural networks excel at......
Optimization Satisfying Generating better solutions to a problem Giving you advice pattern recognition PATTERN RECOGNITION
Data base model that uses a series of two dimensional tables
Relational data base table
Files created using Microsoft access fits which database model?
Relational database model
Used to query a database
SQL
An executive information system is most likely to support
Spreadsheet development Inventory reorder decisions Daily employee assignment choices Strategic planning The update of a product or inventory database STRATEGIC PLANNING
A spreadsheet is an example of a(n)
Expert system Genetic algorithm Decisions support system Intelligent agent Transaction processing system DECISION SUPPORT SYSTEM
XYZ software modifies its approach to reflect experiences in the previous contest
Expert system Genetic algorithm Neural network Decision support system Intelligent agent NEURAL NETWORK
_______are designed to help managers choose one course of action when they are faced with many alternatives
Expert system Neural networks Data minng systems A decision support system Enterprise resource planning systems (ERP) DECISION SUPPORT SYSTEM
An expert system is fundamentally the same as a DSS
FALSE
Fuzzy logic works like the human brain in that it needs precise facts to process information
FALSE
If an expert system recognizes a new pattern, it can set up a rule based on it
FALSE
The program Microsoft access that you use to crete your assignment file query file
FALSE
When you use the filtering features of microsoft access, you specify criteria
FALSE
CRM is a technology based on understanding the needs of customers
FAlse
Which of the following Excel tabs is used to access macro functionally
Formulas Developer VBA Data Insert DEVELOPER
A research area in computer science that allows shades of gray rather than yes/no answers is called
Fuzzy logic
A recorded keystroke macro is relatively quick and easy way to create a macro where the application captures what you do and the actions that you take
TRUE
Items containing an embedded radio frequency id chip (RFID) can easily be tracked as they pass within range of a receiving device
TRUE
The concept & purpose of data dictionary XML schema is the same
TRUE
XYZ software modifies it's approach to reflect experiences in the previous contest
neaural network
Those in attendance at a recent Super Bowl unknowingly had their faces scanned by surveillance equipment and the resulting image of each person was compared to a database of "known troublemakers". Which of the following forms of artificial intelligence made it possible to achieve these matches?
A decision support system An expert system Intelligent agents A neural network Genetic algorithm NEURAL NETWORK
What AI system is an adaptive system that works independently carrying out specific, repetitive, or predictable tasks?
A decision support system An intelligent agent A neural network A genetic algorithm An Expert system INTELIGENT AGENT
Which of he following BEST DESCRIBES what XML can be used for
A. Displaying data on internet web pages B. Querying data in a database C. Performing what-if analysis in a spreadsheet D. Describing what data is when it is being electronically transmitted E. Providing communications in both wired and wireless networks. Describing what data is when it is being electronically transmitted
You are a sales representative for a publisher of college textbooks. Your sales area includes the states of Kansas, Missouri, Oklahoma, Colorado, Nebraska, and Texas. There are many college campuses spread throughout this six state area. Your goal is to visit each campus, but you want to make sure that you arrange your campus visits so that your travel the least amount of distance (in miles) between all of the different campuses. What type of information technology system will you use to determine the BEST ROUTE for you to take?
A. Genetic Algorithm B. Neural network C. Expert System D. Decision support system E. Transaction processing system GENETIC ALGORITHM
You are using a computer system that asks you questions regarding dogs and your preferred characteristics. When you have answered a sufficient number of questions, the system makes a recommendation regarding the type of dog that you should purchase. This system is a:
A. Neural network B. Intelligent agent C. Expert system D. Decision support system E. Genetic algorithm EXPERT SYSTEM
Businesses create_____to see relationships in the data
A. Pivot tables B. If Functions C. Vlookup functions D. Queries E. Absolute and mixed cell references PIVOT TABLES
Which of the following statements is NOT correct
A. Shopbots are a form of intelligent agent that will search the internet on behalf of individual consumers, looking for the best prices for good and bidding in online auctions. B. Airlines are beginning to use optimization software to save money on the costs associated with each flight by reducing the number of miles traveled. C. Artificial intelligent computer systems are capable of performing many human like tasks, but they are still unable to learn from experiences when they perform these tasks. D. Intelligent agents are being created to manage data flows through networks. They will be able to determine the best way to route data in order to avoid clogging or overloading. Artificial intelligent computer systems are capable of performing many human like tasks, but they are still unable to learn from experiences when they perform these tasks.
When working in Excel,_______find the very best answer given various constraints that you must work around or take into account, ________tells you what must happen to get a certain desired results while _____ can be conducted using variable and two variable data tables.
A. What-if analysis, goal seek, solver B. Solver, goal-seek, what-if analysis C. What-if analysis, solver, goal seek D. Solver, what-if analysis, goal seek E. Goal seek, solver, what-if analysis SOLVER, GOAL SEEK, WHAT-IF ANALYSIS
A PMT function is placed in cell A4. At which cell---A1,A2,A3, or A4 will contain the amount of the loan, given the function =PMT(A1,A2,A3)?
A1 A3 A2 A4 A5 A3
You have been asked to calculate the monthly PMT for a loan amount. The number of years is placed in cell A1. The yearly interest rate is placed in A2. Which of the following is correct when using the PMT function wizard
A2/12 goes in the rate box and A1*12 goes in the nper box
The various conceptual layers of a data
An excel pivot table through warehouse its rows, columns, report filters.
An artificial system that can learn because it's patterned after the human brain called
An expert system A decision support system A neural network A genetic algorithm Intelligent agent A NEURAL NETWORK
Which form of artificial intelligence system can be used to detect possible credit card fraud?
An expert system A neural network A genetic algorithm An intelligent agent A decision support system A NEURAL NETWORK
An intelligent agent can
Apply rules to solve a problem Generate several generations of solutions, improving each time Recognize patterns Act independently on your behalf ACT INDEPENDENTLY ON YOUR BEHALF
A mechanical device equipped with simulated senses and capability of taking action on its own is called
Artificial intelligence decision support system A neural network a robot An expert system A fuzzy logic using genetic algorithm A ROBOT
A TPS's is used to __________business processes
Automate Streamline bottleneck reinvent provide redundancy for AUTOMATE
Zena Xavier is a pharmacist. She uses a computerized information system that stores knowledge and makes inferences/recommendations during interaction
Expert system
RFID is an element of this, along with the ability to see from end to end
CRM RFID SCM SQL XML SCM
Which of the following BEST DESCRIBES the process of having real-time visibility throughout the entire process with accurate information flowing between all of the parties involved
CRM RFID SCM SQL XML SCM
Indicates what the data really is
CRM SCM RFID XML SQL XML
Which of the following is an example of optimization in Excel?
Creating an IF statement Using a solver Using Vlookup Determining the monthly payment using the PMT function Creating an absolute or mixed cell reference using the $ sign USING A SOLVER
One of the SQL definitions are incorrect
Criteria is used to narrow
The SQL field that forms the basis of a relationship between two tables
Customer ID
Recognizing a signature is a problem best suited to
Expert system Decsion support system neural network Geographic information system Genetic algorithm NEURAL NETWORK
Helps you create and maintain data dictionary
Data definition subsystem
The subsystem of a database management system that lets you see the content of a data file
Data manipulation subsystem
The spell checker, grammar checker and other wizards commonly found in Microsoft Office are examples of what type of agent?
Data mining agent Information agent User agent Monitoring and surveillance agent Network administration agent MONITORING AND SURVEILLANCE AGENT
Buyer agents, shop bots and googlebots are examples of what type of agent?
Data-mining agent Monitoring and surveillance agent Information agent User agent Network administration agent INFORMATION AGENT
________application should be considered whenever formulas and complex calculations are required.
Database Spreadsheet Word processing Web browsing software Operating system SPREADSHEET
I want to create and view the relationships between the different tables that I have created. When using Microsoft Access, I will access that functionally by using which of the following tabs
Database Tools tab
A type of organizational computer system designed specifically to facilitate the capture and use of wisdom and knowledge of specialists is a(n)
Enterprise resource planning system Decision support system Expert system Neural networks Executive information system EXPERT SYSTEM
Those in attendance at a recent super bowl unknow
Neural network
XYZ software modifies its approach to reflect experiences in the previous contest
Neural network
Which of the following is a valid primary key?
None are valid
Multiple choice questions are considered to be ______ while essay questions are considered to be _____
Nonstructured, structured Quantifiable, subjective Subjective, qualitative Quantifiable, objective Satisfying, well structured decision types QUANTIFIABLE , SUBJECTIVE
To use a decision support system, the user must be knowledgeable about the problem solving steps and must make the ultimate recommendation. To use artificial intelligence, the user does not have to have the same level of knowledge or that level of participation because the system makes the ultimate decision
TRUE
Which of the following statements regarding CRM is NOT accurate
The primary difference between operational CRM and analytical CRM is the direct interaction
One of the following items is not an example of analytical CRM
The shipment tracking features on the web sites of Federal Express and UPS that let a customer find their own answers
Create a pivot table where, Tiger and Lion by Rabbit and Cow, filtered by Dog
Tiger and lion are data points, rabbit is a row, cow is a column and the tale is filtered by dog
Which of the following statements regarding Excel data and Pivot Tables is incorrect?
To sort Excel data, the columns being sorted need to be adjacent (side-by-side)
Each Friday, a production manager supervising 10 factory workers must determine the number of dedicated robotic work stations that would need to produce 100 car door assembles for the upcoming week. The work conditions/constraints vary so that the factors that resulted in one answer one week may result in a different answer the next week. A(n) _______ would be the type of business information system she would consult.
a. Decision support system b. Executive information system c. Transaction processing system d. intelligent agent e. expert system DECISION SUPPORT SYSTEM
You are the sales manager and it is the end of the year. You have decided to examine the company's sales database containing data for the hundreds of different products that are sold by your company. Which of the following is considered information?
a. Quantity sold for each product each day b. Date sold for each item c. Best selling item by month d. all of the above items are considered information e. None of the above are considered to be information BEST SELLING ITEM BY MONTH
A XML _______ describes how to format XML data. The XML _____ stores your XML data. When XML information is exchanged electronically someone who has your ______knows what the information that you will be sending them or exchanging with them will look like.
a. Style sheet, instance document, schema b. Schema, instance doc, stylesheet c. Instance doc, schema, stylesheet d. Stylesheet, schema, instance doc e. Schema, stylesheet, instance doc STYLE SHEET , INSTANCE DOC, SCHEMA
Which of the following statements DOES NOT FIT the concept of "resources and application hosted remotely over the internet?
a. When the browser detects a software upgrade, it is automatically pushed down from the server to the user and installed on the user's local machine. b. The current recognized leader is google c. The interface to the applications software is through a web browser d. The total cost of ownership is reduced e. It follows the "software as a service model" where the application is licensed to customers as service on demand. When the browser detects a software upgrade, it is automatically pushed down from the server to the user and installed on the user's local machine.
