MIS Chapter 11 & 6 Quiz Questions

In a student​ database, a column called LastName would be an example of​ a(n) _____________. A. relationship B. attribute C. entity D. file E. record

B. attribute

​A(n) _____________ is a database whose content focuses on historical organizational data. A. historical data house B. data warehouse C. data historicity D. Access Database E. SQL Server

B. data warehouse

Relational tables need to be​ ______________ to help avoid duplicate data. A. ethically analyzed B. normalized C. entitled D. task modeled E. relationally modeled

B. normalized

________ is a term that hardware and software vendors and information technology consultants use to describe the infrastructure for​ warehousing, integrating,​ reporting, and analyzing data that come from the business environment. A. Online analytical processing​ (OLAP) B. Enterprise resource planning​ (ERP) C. Business Intelligence​ (BI) D. International Business Management​ (IBM) E. Business analytics​ (BA)

C. Business Intelligence​ (BI)

​________________ work by creating binary strings​ (e.g., 0s and​ 1s) to find optimal solutions based on a large number of possibilities. A. Neural networks B. Learning management systems C. Genetic algorithms D. Structured systems E. Knowledge management systems

C. Genetic algorithms

Which of the following statements about Hadoop is​ FALSE? A. Hadoop breaks a big data problem down into​ sub-problems. B. Hadoop combines results into a smaller data set that is easier to analyze. C. Hadoop extracts data from multiple tables that have a relationship. D. Hadoop is an open source software framework. E. ​Hadoop's MapReduce was inspired by​ Google's system for processing huge data sets.

C. Hadoop extracts data from multiple tables that have a relationship.

​________________ are unique because the technology is based on the human brain and focuses on pattern recognition from large data sets. A. Learning management systems B. Structured systems C. Neural networks D. Database management systems E. Knowledge management systems

C. Neural networks

in the most ambitious​ vision, ________ involves the attempt to build computer systems that think and act like humans. A. massive online open courses B. mandatory online open classes C. artificial intelligence D. meaningful online operations courses E. meaningful online courses

C. artificial intelligence

The infrastructure for​ warehousing, integrating,​ reporting, and analyzing data to help with decisions and plans is called​ _____________. A. instructional technology B. business wisdom C. business intelligence D. knowledge management E. business analytics

C. business intelligence

An organization interested in a popular open source DBMS on the market would adopt​ ____________. A. Oracle Database B. DB2 C. Access D. MySQL E. Server SQL

D. MySQL

​_______________ databases are by far the most popular type of database on the market today. A. Meta B. Flat C. ​Class-oriented D. Relational E. ​Object-oriented

D. Relational

Which of the following is a popular way to describe relationships​ (i.e., one-to-one,​ one-to-many) in a relational​ database? A. Process model B. Data flow diagram C. Task model D. Data descriptor method E. ​Entity-relationship diagram

E. ​Entity-relationship diagram

The term​ ____________ describes data sets like​ Google's database that are too big for traditional DBMS to handle. A. Big Data B. Oracle Database C. Excel D. Access E. analytics

A. Big Data

Which of the following is used by companies to detect and correct​ incomplete, redundant, or incorrect​ data? A. Data scrubbing B. Referential integrity C. Data mining D. Primary key E. SQL

A. Data scrubbing

Which of the following is NOT a function of a data​ warehouse? A. Filter data B. Catalog data C. Organize and relate data D. Cleanse data E. Obtain datam

A. Filter data

​____________________ is the most popular​ open-source program that allows for storage and analysis of big data. A. Hadoop B. Access C. SQL Server D. Teradata Intelligent Memory E. DBMS

A. Hadoop

Which of the following statements about Microsoft Access is​ FALSE? A. Microsoft Access lacks report generation capabilities. B. Microsoft Access has capabilities for developing desktop system applications. C. Microsoft Access has rudimentary data dictionary capabilities. D. Microsoft Access is a DBMS. E. Microsoft Access works with Crystal​ Reports, a popular report generator.

A. Microsoft Access lacks report generation capabilities.

Which of the following statements about artificial intelligence is​ true? A. So​ far, there are no computer programs that have demonstrated generalized human intelligence or common sense. B. AI systems include all the characteristics of generalized human intelligence. C. AI systems communicate with humans easily using natural language. D. AI systems have demonstrated that they can apply common sense. E. AI systems can select and achieve goals.

A. So​ far, there are no computer programs that have demonstrated generalized human intelligence or common sense.

​____________ involves providing specific examples of desired inputs and outputs to improve the performance of the machine learning system. A. Supervised learning B. ​Semi-structured knowledge C. Unstructured learning D. Structured knowledge E. Tacit learning

A. Supervised learning

Neural​ networks, expert​ systems, and genetic algorithms are considered​ _______ used with decision making. A. artificial intelligence techniques B. group decision support systems C. structured decision systems D. inference engines E. executive support systems

A. artificial intelligence techniques

A​ ________ is represented by a 0 or 1. A. bit B. file C. byte D. character E. megabit

A. bit

A​ ________ in a database represents a single character such as a letter or number. A. byte B. kilobyte C. bit D. file E. megabit

A. byte

The quality dimension of the​ decision-making process that addresses the ability to articulate the solution process is called the​ ____________ dimension. A. coherence B. due process C. accuracy D. comprehensiveness E. fairness

A. coherence

In an effort to better manage​ data, companies are creating​ ____________ for storing data from a variety of systems​ (i.e., web​ data, social media​ data, IoT​ data), including both structured and unstructured data to be analyzed at a later time. A. data lakes B. RDMSs C. data marts D. Hadoop databases E. HDFSs

A. data lakes

In a student​ database, a collection of related attributes such as​ LastName, FirstName, and StudentNumber creates​ a(n) _______________. A. entity B. file C. relationship D. record E. bit

A. entity

If Megan sends out unauthorized data to another​ organization, she has likely violated the​ company's ______________. A. information policy B. DBMS rules C. data warehouse policy D. primary key guidelines E. data foundations

A. information policy

Siri, a virtual assistant application on​ Apple's iPhone and​ iPad, uses natural language processing to answer​ questions, make​ recommendations, and perform actions. Siri is an example of​ a(n) ________. A. intelligent agent B. virtual reality device C. chatbot D. robot E. augmented reality device

A. intelligent agent

The data​ _______________ language allows you to retrieve information from the database​ (i.e., using the​ SELECT, FROM, WHERE​ commands). A. manipulation B. question C. creation D. definition E. ask

A. manipulation

A​ _______________ uniquely represents a record or row. A. primary key B. foreign key C. prime key D. cost key E. data key

A. primary key

What is the formal name for questioning or making a data request from the​ database? A. query B. A cloud C. DML D. DDL E.

A. query ~A query is a request for data from a database. In most​ DBMS, you would type a series of statements​ (i.e., SELECT,​ FROM, WHERE) to access data.~

In a student​ database, a row that describes the top​ student, including his or her​ LastName, FirstName, and​ StudentNumber, is an example of​ a(n) ______________. A. record B. group C. attribute D. field E. file

A. record

A college admission decision that is entirely based on a mathematical formula is called​ a(n) __________________ decision. A. structured B. ​instinct-based C. unstructured D. ​semi-structured E. random

A. structured

Which of the following is NOT a task that​ today's artificial intelligence systems can​ accomplish? A. Recognize faces and voices. B. Apply common sense. C. Play​ games, such as chess. D. Beat an expert human player in the Jeopardy game. E. Interpret CT scans.

B. Apply common sense.

Which of the following uses a survey to determine the accuracy of a data​ set? A. Data scrubbing B. Data quality audit C. Database D. Datareview E. Data cleansing

B. Data quality audit

​_____________ identify patterns within massive amounts of data by building models and then making adjustments to improve those models. A. Genetic algorithms B. Neural networks C. Neutral networks D. Structured networks E. Drill downs

B. Neural networks

​______________ analytics has been used by companies like FedEx to determine the impact of price changes on sales. A. Case B. Predictive C. Parameterized D. Inductive E. Integrated

B. Predictive

While many intelligent systems require human interaction to utilize and achieve a​ solution, _____ are built to run in the background of systems and make decisions without human intervention. A. neural networks B. intelligent agents C. genetic algorithms D. fuzzy bots E. expert systems

B. intelligent agents

A(n) __________ key uniquely identifies a row or record in a table. A. initial B. primary C. foreign D. secondary E. domestic

B. primary

Deciding on where to go to lunch based on what sounds good at the time is called​ a(n) ________________ decision. A. structured B. unstructured C. ​formula-based D. ​semi-structured E. random

B. unstructured

Which of the following is a FALSE statement regarding the evolution of​ AI? A. Natural language speech recognition errors have dropped from 15 percent to 5 percent. B. There have been few fundamental conceptual breakthroughs in AI in this​ period, or in understanding how humans think. C. Image recognition error rates have stabilized at about 25 percent. D. Language translation programs achieve about 85 percent accuracy compared to humans. E. AI evolution has been enhanced by the drastic reduction in the cost of computer processing and the growth in the power of processors.

C. Image recognition error rates have stabilized at about 25 percent.

Which of the following is a set of metrics that enables executives to understand how the company is​ doing? A. Business intelligence reports​ (BIR) B. Business performance metrics​ (BPM) C. Key performance indicators​ (KPI) D. Drill down reports​ (DDR) E. Business assessment reports​ (BAR)

C. Key performance indicators​ (KPI)

Which tool enables users to view the same data in different ways using multiple​ dimensions? A. Hadoop B. OLTP C. OLAP D. SQL E. Clustering

C. OLAP

What is the most prominent data manipulation language and method to​ "question" a​ database? A. Standard Query Process B. Structured Question Language C. Structured Query Language D. Simple Question Language E. Data Definition Language

C. Structured Query Language

What are the major forces driving the rapid evolution of​ AI? A. The advancement of image recognition programs and natural language speech recognition systems B. The refinement of algorithms by tens of thousands of AI software engineers and university research centers C. The development of Big Data databases generated by the​ Internet, e-commerce, the Internet of​ Things, and social media D. The significant investment from business and governments E. The drastic reduction in the cost of computer processing and the growth in the power of processors

C. The development of Big Data databases generated by the​ Internet, e-commerce, the Internet of​ Things, and social media

In the Star Wars​ movies, C-3PO is a robot that emulates human behavior and​ thought, which is called​ ________________. A. business analytics B. business intelligence C. artificial intelligence D. artificial wisdom E. business wisdom

C. artificial intelligence

Microsoft Azure SQL is an example of a​ _________________ database. A. local B. network C. cloud D. flat E. text

C. cloud

To improve user comprehension and​ learning, ______________ tools are included in business analytics software suites. A. group decision support system B. production reporting C. data visualization D. big data E. sensitivity analysis

C. data visualization

The stage of the​ decision-making process where identifying and exploring potential solutions takes place is the​ ____________ phase. A. choice B. evaluation C. design D. intelligence E. implementation

C. design

A​ _______________ is used to link the SUPPLIER and PART tables by entering SupplierID in the PART table A. prime key B. data key C. foreign key D. cost key E. primary key

C. foreign key

The balanced scorecard method is based on​ __________ dimensions of a​ firm's performance. A. five B. three C. four D. two E. six

C. four

Starbucks uses an application to determine where to open new stores. The application identifies geographic locations that will produce a high​ sales-to-investment ratio and​ per-store sales volume. This is an example of​ a(n) ________ information system. A. operational B. countrywide C. geographic D. geodesic E. ​case-based

C. geographic

Relational databases enforce​ ______________ integrity to​ ensure, for​ instance, that a teacher​ can't be assigned to a CLASS table unless there is already a record for that teacher in the TEACHER table. A. task model B. data flow C. referential D. ethical E. secondary

C. referential

Volkswagen Group has​ ________ systems that display digitally constructed interior and exterior components of a vehicle. Interior and exterior component options can be quickly changed during the design process. A. neural B. expert C. virtual reality D. learning management E. fuzzy logic

C. virtual reality

A method that allows complex business calculations to be performed on very large data sets in seconds is termed​ __________ computing. A. Big Data B. analytical C. ​in-memory D. ​disk-based E. power

C. ​in-memory

Developing a marketing plan is best characterized as​ a(n) ________. A. unstructured decision by senior management B. structured decision by senior management C. ​semi-structured decision by middle management D. structured decision by operational management E. structured decision by middle management

C. ​semi-structured decision by middle management

Which of the following best describes a pivot​ table? A. A chart tool that can rotate columnar data quickly and visually B. A visual tool for presenting performance data that users define C. A tool for performing a sensitivity analysis D. A spreadsheet tool that allows users to filter data and isolate the impact of one or more parameters E. A tool with the capabilities for linear​ forecasting, what-if scenario​ analysis, and data​ analysis, using standard statistical tools

D. A spreadsheet tool that allows users to filter data and isolate the impact of one or more parameters

Which statement about big data is​ FALSE? A. Big data can consist of multimedia files like​ graphics, audio, and video. B. Big data is generated rapidly. C. ​"Big data" data sets are at least a petabyte in size. D. Big data can be processed with traditional techniques. E. Big data has a variety of data with structured data and​ free-form text and logs.

D. Big data can be processed with traditional techniques.

Which of the following statements about relational databases is​ FALSE? A. A​ customer's name would not make a good primary key. B. A primary key cannot be duplicated. C. A foreign key can be duplicated. D. Each table must have a​ one-to-one relationship to another table. E. The​ entity-relationship diagram depicts the relationships among tables in a database.

D. Each table must have a​ one-to-one relationship to another table.

Which term refers to software programs that help with repetitive and predictable tasks​ (i.e., Apple's​ Siri)? A. Wisdom agent B. Knowledge agent C. Learning agent D. Intelligent agent E. Genetic agent

D. Intelligent agent

Which statement about managing and controlling data within a company is​ FALSE? A. Large companies may have several​ departments, each handling specific tasks involving data assurance for the firm. B. An information policy establishes who can access what information within a firm. C. An information policy would establish who in human resources could access employee data. D. The actual physical database is never created by the database administration of a company. E. As part of​ control, a firm may set a policy about passwords for accessing data.

D. The actual physical database is never created by the database administration of a company.

A​ _______________ is represented as a column in a database table that represents things like a​ person's first​ name, last​ name, and age. A. bit B. file C. record D. field E. byte

D. field

Volkswagen Group is experimenting with​ ________ to speed up vehicle design and development and to identify potentially costly design problems earlier in the development cycle. A. predictive analytics B. crowdsourcing C. augmented reality D. virtual reality E. analytical simulations

D. virtual reality

Which component of the​ decision-making process consists of​ discovering, identifying, and understanding organizational​ problems? A. Choice B. Design C. Implementation D. Wisdom E. Intelligence

E. Intelligence

If you need a DBMS for large commercial use on a​ mainframe, which of the following is a viable​ option? A. Microsoft Excel B. Microsoft Explorer C. Microsoft Project D. Microsoft Access E. Microsoft SQL Server

E. Microsoft SQL Server

____________ reports allow users to enter several variables​ (i.e., region and​ date) to produce a​ decision-making report. A. Inductive B. Integrated C. ​Drill-down D. Predictive E. Parameterized

E. Parameterized

What is the first step in effectively managing data for a​ firm? A. Normalize the data. B. Back up the data. C. Cleanse the data. D. Audit the data quality. E. Specify the information policy.

E. Specify the information policy.

Which of the following does NOT need to be addressed in an​ organization's information​ policy? A. Who is responsible for updating and maintaining the information B. Where information can be distributed C. Which users and organizational units can share information D. Procedures and accountabilities around managing data resources E. What the relationships inside the data are

E. What the relationships inside the data are

A quick report created by the user that is based on his or her own SQL code is called​ a(n) __________ report. A. parameterized B. forecast model C. scenario model D. drill down E. ad hoc

E. ad hoc

Creating visual representations of data through​ charts, graphs, and dashboards is formally called​ ____________________. A. knowledge management B. report visualization C. HTML reporting D. database development E. data visualization

E. data visualization

The purpose of​ a(n) _________ system is to capture best practice solutions and program them into a set of rules in a software program. A. knowledge B. learning C. amateur D. hybrid E. expert

E. expert

The most common use of​ non-relational database management systems is for managing​ ________. A. text data only B. data within local area networks C. customer relationship data D. smaller data sets from corporate partners E. extremely large data sets

E. extremely large data sets

Data​ ________ is important because it establishes an​ organization's rules for​ sharing, disseminating,​ acquiring, standardizing, and classifying data. A. processing B. administration C. auditing D. ownership E. governance

E. governance

An advantage of the balanced scorecard framework is the ability to automate the flow of information on​ __________, so that executives are kept fully informed about business performance. A. ​what-if analyses B. indirect goods C. scenarios D. location analysis E. key performance indicators

E. key performance indicators

Most AI development today involves some kind of​ ________. A. expert system B. inference engine C. ​IF-THEN rules D. thorough​ in-depth interviews E. machine learning

E. machine learning

The financial industry uses​ ________ to discern patterns in vast pools of data that might help investment firms predict the performance of​ equities, corporate bond​ ratings, or corporate bankruptcies. A. intelligent agents B. unsupervised learning C. genetic algorithms D. supervised learning E. neural networks

E. neural networks

The quality dimension of the​ decision-making process that addresses efficiency of resource utilization of affected parties is called the​ __________ dimension. A. coherence B. comprehensiveness C. due process D. fairness E. speed

E. speed

Unlike business intelligence​ (BI), business analytics​ (BA) focuses mostly on​ ________. A. data warehousing B. integrating data C. data management D. SQL E. tools and techniques for analyzing data

E. tools and techniques for analyzing data

The​ "3V's" used to characterize big data include​ volume, variety, and​ _______. A. veracity B. vigor C. vastness D. value E. velocity

E. velocity

_____________ are used to find an optimal solution for specific problems by examining a very large number of alternative solutions for that problem. A. ​Drill-down patterns B. ​Geo-parsing methods C. Neural networks D. Structured logic E. Genetic algorithms

E. Genetic algorithms

Which of the following statements about a business intelligence environment is​ FALSE? A. All BI environments require a set of software tools used to analyze and track the progress of the business. B. Data from a business environment is both structured and unstructured. C. ​Today's BI environment features suites for data visualization that enhance learning and interpretation. D. The underlying foundation of BI is a powerful database system. E. A business intelligence​ (BI) environment is expensive to purchase.

E. A business intelligence​ (BI) environment is expensive to purchase.

Which of the following is an example of a DBMS desktop system geared toward smaller business data​ needs? A. Oracle Database B. MySQL C. SQL Server D. DB2 E. Access

E. Access ~Microsoft Access is a DBMS for desktop​ systems, whereas​ DB2, Oracle​ Database, and Microsoft SQL Server are DBMS for large mainframes and midrange computers. MySQL is a popular​ open-source DBMS. All these products are relational DBMSs that support a relational database.~

Which of the following involves searching for patterns and relationships among​ data? A. Knowledge management B. Data marting C. Data warehousing D. Data processing E. Data mining

E. Data mining