MIS 7+8 – Flashcards
Unlock all answers in this set
Unlock answersquestion
Which of the following types of information can be found in a database?
answer
All of these
question
Which of the following database structures stores information in a treelike structure that allows repeating information using parent/child relationships, in such a way that it cannot have too many relationships?
answer
Hierarchal database
question
Which of the following database structures offers a flexible way of representing objects and their relationships?
answer
Network database
question
In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?
answer
Entity
question
In the relational database model, what is a characteristic or property of an entity?
answer
Attribute
question
What are characteristics or properties of an entity called?
answer
All of these
question
Why do relational databases use primary keys and foreign keys?
answer
to create logical relationships
question
What is a primary key?
answer
A field (or group of fields) that uniquely identifies a given entity in a table
question
What is a foreign key?
answer
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables
question
All of the following are advantages of a database stored information except:
answer
Increased information redundancy
question
Which of the following is incorrect in reference to a database?
answer
Can be relational or network *** C7Q11
question
What is the physical view of information?
answer
Deals with the physical storage of information on a storage device such as a hard disk
question
Which of the following is correct in reference to a database?
answer
A database can support many logical views
question
What refers to how well a system can adapt to increased demand?
answer
Scalability
question
Which of the following measures how quickly a system performs a certain process of transaction?
answer
Performance
question
What is information redundancy?
answer
All of these
question
What is the primary problem with redundant information?
answer
It is often inconsistent
question
Which of the following is true in regard to eliminating redundant information?
answer
Improves information quality
question
What are the rules that help ensure the quality of information?
answer
Integrity constraints
question
What are the rules that enforce basic and fundamental information-based constraints?
answer
Relational integrity constraints
question
Which of the following is a valid type of integrity constraint?
answer
Business-critical integrity constraint**
question
What type of integrity constraint does not allow someone to create an order for a nonexistent customer?
answer
Relational integrity constraint
question
All of the following are business-critical constraints except:
answer
System will not allow returns of fresh produce after 15 days past delivery
question
Which of the following uses a DBMS to interact with a database?
answer
All of these
question
What is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database?
answer
Data-driven website
question
What type of website is best to build for a general information website with static information?
answer
Static website
question
What type of website is best to build for a website with continually changing information, including press releases new product info and updated pricing?
answer
Data-driven website
question
Which of the following is not an advantage of building data-driven website?
answer
Minimizes or reduces efficiency
question
What is a forward integration/
answer
Takes information entered into a given system and sends it automatically to all downstream systems and processes
question
What is a backward integration?
answer
Takes information entered into a given system and sends it automatically to all upstream systems and processes
question
What is an integration?
answer
Allows systems to communicate directly with each other
question
A data warehouse is a
answer
Logical, operational
question
All of the following are reasons why operational systems are not appropriate for business analysis except:
answer
Operational systems are integrated
question
What do data warehouses support?
answer
OLAP and analytical processing
question
Which of the following describes ETL?
answer
A process that extracts information from internal and external databases
question
What is data mining?
answer
Process of analyzing data to extract information not offered by the raw data alone
question
What does the Data Warehousing Insitute estimate that low-quality
answer
$600 billion
question
When does information cleansing occur in the data warehouse?
answer
During the ETL process and once it is in the data warehouse
question
Which of the following statements is true regarding customer information?
answer
All of these
question
Which of the following occurs during data cleansing?
answer
All of these
question
Which of the following statements is true?
answer
The more complete and accurate an organization wants to get its information the more it costs
question
What is information that people use to support their decision-making efforts?
answer
Business intelligence
question
Which of the following does not draw a parallel between the challenges in business and the challenges of war?
answer
Responding to the resultant information
question
Which of the following is not one of the principle BI enablers?
answer
Corporate culture
question
Why is Ben & Jerry's using business intelligence?
answer
To improve quality
question
Why is Noodles & Company using bi
answer
To improve financial analysis
question
Why would a business use data warehouse that offers strategic level, external, integrated, and historical information?
answer
All of these
question
What is the primary purpose of a data warehouse?
answer
To aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities
question
Land's End created an organization-wide data
answer
Build a data mart
question
A relational database contains information in a series of two-dimensional tables. How is data contained in a data warehouse and data mart?
answer
Information is multidimensional, meaning it contains layers of columns and rows
question
What is a dimension?
answer
A particular attribute of information
question
A dimension is a particular attribute of information. What is the common term for the representation of multidimensional information?
answer
Cube
question
Achieving perfect information is almost impossible. Which two variables are used to determine the trade-off for perfect information?
answer
Accuracy versus completeness
question
Which of the following are the principle BI enablers?
answer
Technology, people and corporate culture
