Georgia State University

CIS 2010

Chapter 5

1. Which of the following problems do organizations face when managing data?
   1. Collecting the vast amounts of data that are being generated
   2. Storing the data that are being collected
   3. Processing and analyzing the data that are being stored
   4. All of these

 

2. The term “data rot” refers to

 

1. 1. Data that no longer serve a purpose.
   2. The deterioration of the medium on which the data are stored.
   3. Data that are irrelevant or contain errors.
   4. All of these

 

 

3. Data redundancy refers to:

 

1. 1. Storing data in a single central location.
   2. Sharing data with others.
   3. Having copies of the same data in multiple locations.
   4. All of these

4. In the United States, federal law requires companies to store, evaluate, and disclose financial data for fixed periods of time, even if the company no longer has any use for the data. True/False

 

 

 

5. The management of data across the entire organization is most accurately defined as:
   1. Data integration.
   2. Data control.
   3. Data governance.
   4. Data administration.

 

 

6. Social data is not a form of big data. True/False

 

7. NoSQL databases can process both structured and unstructured data.

 

 

8. The use of databases enables organizations to (choose all that apply):

 

1. 1. Eliminate data redundancy.
   2. Minimize data isolation.
   3. Minimize data inconsistency.

1. 4. Minimize data security risks.
   5. Eliminate data integrity.

 

 

 

9. A database must be associated with only one computer program or information system. True/False

 

 

 

10. A group of related fields is generally called a data file.

 

 

 

11. A data model is the diagrammatic representation of a database that clearly defines a database’s     ,        and                 .

 

1. Entities, attributes, relationships.
2. Entity classes, hierarchy, files.
3. Data hierarchy, data attributes, data files.
4. Entity classes, entity attributes, entity files.

 

 

12. A standardized language used to manipulate data is                    .

 

1. MS-Access
2. Oracle
3. Query-by-example language
4. None of these

 

13. A relational database typically consists of one large two-dimensional table.

 

 

 

14.                is a method for analyzing and reducing a relational database to its most streamlined form.

 

1. Structured query
2. Normalization
3. Query-by-example
4. Relational analysis

 

15. The data dictionary stores definitions of data elements, characteristics that use the data elements, physical representation of the data elements, data ownership, and security. True/False

 

 

 

16. A data warehouse is a low-cost, scaled-down version of a data mart designed for the end-user needs in a department in a large organization. True/False

 

 

 

17. Operational data that are constantly updated are stored in:

 

1. Data warehouses.
2. Data marts.
3. Databases.
4. All of these

 

18. Online analytical processing involves the analysis of accumulated data by end users. True/False

 

 

 

19.             is the cumulative store of subjective or experiential learning.

 

1. Tacit knowledge
2. Explicit knowledge
3. Intellectual capital
4. None of these

 

 

20. Knowledge management systems (KMS) are used by organizations to capture, store, and disseminate knowledge within the organization. True/False

 

 

 

21.                is a process that helps organizations identify, select, organize, disseminate, transfer, and apply expertise that is part of the organization’s memory and typically resides inside the organization in an unstructured manner.

 

1. Discovery
2. Knowledge management
3. Decision support
4. Data mining