|
What are the different types of information? |
Levels, formats, granularities |
|
Which of the following represents the different information levels? |
Individual, department, enterprise |
|
Which of the following represents the different information formats? |
Document, presentation, spreadsheet, database |
|
Which of the following represents the different information granularities? |
Detail, summary, aggregate |
|
All of the following are characteristics of information, except: |
Quantity |
|
What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks? |
Transactional information |
|
Which of the following is an example of transactional information? |
A. Withdrawing cash from an ATM B. Making an airline reservation C. Purchasing stock D. All of the above |
|
________________ achieved great success by managing information, while _________ was unsuccessful at managing information. |
Samsung Electronics, Staples |
|
What encompasses all organizational information and its primary purpose is to support the performing of managerial analysis tasks? |
Analytical information |
|
Which of the following is an example of transactional information? |
purchasing stock |
|
What is immediate, up-to-date information? |
Real-time information |
|
What provides real-time information in response to query requests? |
Real-time systems |
|
What is one of the biggest pitfalls associated with real-time information? |
It continually changes |
|
Which of the following is not one of the five characteristics common to high quality information? |
Quantity |
|
Which of the following implies that aggregate or summary information is in agreement with detailed information? |
Consistency |
|
Which of the following implies that information is current with respect to the business requirement? |
Timeliness |
|
What is it called when each transaction, entity, and event is represented only once in the information? |
Uniqueness |
|
What is a real-time system? |
Provides real-time information in response to query requests |
|
Organizational information comes at different levels and in different formats and granularities. |
True |
|
Reports for each sales person, product, and part are examples of detail or fine information granularities. |
True |
|
Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry. |
True |
|
Timely information must be up-to-the-second to be accurate. |
False Timely information can change for each business decision. Some decisions require weekly information while others require daily information. |
|
Which of the following types of information can be found in a database? |
A database maintains information on inventory, transactions, and employees. |
|
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? |
Hierarchical database |
|
Which of the following database structures offers a flexible way of representing objects and their relationships? |
Network database |
|
In the relational database model, what is a person, place, thing, transaction, or event about which information is stored? |
Entity |
|
In the relational database model, what are characteristics or properties of an entity? |
Attribute |
|
What are characteristics or properties of an entity called? |
A. Attributes B. Fields C. Columns D. All of the above Attributes are also called fields or columns. |
|
Why do relational databases use primary keys and foreign keys? |
To create logical relationships |
|
What is a primary key? |
A field (or group of fields) that uniquely identifies a given entity in a table |
|
What is a foreign key? |
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables |
|
All of the following are advantages of database-stored information, except: |
Increased information redundancy |
|
Which of the following is incorrect in reference to a database? |
Information is accessed by physical structure |
|
What is the physical view of information? |
Deals with the physical storage of information on a storage device such as a hard disk |
|
Which of the following is correct in reference to a database? |
A database can support many logical views |
|
What refers to how well a system can adapt to increased demands? |
Scalability |
|
Which of the following measures how quickly a system performs a certain process or transaction? |
Performance |
|
What is information redundancy? |
A. Duplication of information B. Storing the same information in multiple places C. Storing duplicate information in multiple places D. All of the above |
|
What is the primary problem with redundant information? |
A. It is difficult to determine which values are the most current B. It is often inconsistent C. It is difficult to determine which values are the most accurate D. All of the above |
|
Which of the following is true in regards to the elimination of redundant information? |
Improves information quality |
|
What are the rules that help ensure the quality of information? |
Integrity constraints |
|
What are the rules that enforce basic and fundamental information-based constraints? |
Relational integrity constraint |
|
Which of the following is a valid type of integrity constraint? |
Business-critical integrity constraint |
|
What type of integrity constraint does not allow someone to create an order for a nonexistent customer? |
Relational integrity constraint |
|
All of the following are business-critical integrity constraints, except: |
System will not allow returns of fresh produce after 15 days past delivery |
|
Which of the following uses a DBMS to interact with a database? |
A. Users of accounting programs B. Users of human resource programs C. Users of marketing programs D. All of the above |
|
What is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database? |
Data-driven website |
|
What type of website is best to build for a general informational website with static information? |
Static website |
|
What type of website is best to build for a website with continually changing information including press releases, new product information, and updated pricing? |
Data-driven website |
|
Which of the following is not an advantage of building a data-driven website? |
Minimizes or reduces efficiency |
|
What is a forward integration? |
Takes information entered into a given system and sends it automatically to all downstream systems and processes |
|
What is a backward integration? |
Takes information entered into a given system and sends it automatically to all upstream systems and processes |
|
What is an integration? |
Allows separate systems to communicate directly with each other |
|
A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table. |
FALSE A primary key is a field (or group of fields) that uniquely identifies a given entity in a table. |
|
Relational integrity constraints are rules that enforce basic and fundamental information-based constraints. |
True |
|
A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database. |
True |
|
Ideally, an organization only wants to build forward integrations. |
FALSE Ideally, an organization wants to build both forward and backward integrations. |
Share This
Flashcard
