Package Title: Testbank Questions Course Title: IS 5e

Chapter Number: 5

Question Type: True-False

1)It is easy to manage all the data coming into an organization.

2. Increasing amounts of external data need to be considered in making organizational decisions.

3. Data rot refers to the quality of the data itself.

4. There is no difference between master data and transaction data.

5. Big Data is easy to define.

1

6. Big Data has three distinct characteristics that distinguish it from traditional data.

7. Today, large corporations are able to process big data but only at great expense.

8. It is important for applications and data to be dependent on each other.

9. A negative value for a student’s grade point average is an example of a data integrity problem.

10. An entity is a person, place, thing, or event about which information is maintained.

11. An attribute is any characteristic or quality that describes a particular entity.

12. The secondary key is a field that identifies a record with complete uniqueness.

13. Entity-relationship diagrams are documents that show the primary and secondary keys associated with a conceptual data model.

14. You would be an instance of your university’s STUDENT class.

15. The relational database model is based on the concept of three-dimensional tables.

16. Structured query language is a relational database language that enables users to perform complicated searches with relatively simple statements.

17. The data dictionary stores definitions of data elements, characteristics that use the data elements, physical representation of the data elements, data ownership, and security.

3

18. When data are normalized, attributes in the table depend on the primary key and any secondary keys.

19. In a data warehouse, existing data are constantly purged as new data come in.

20. An organization’s data warehouse generally maintains its operational data.

21. Online analytical processing (OLAP) involves the analysis of accumulated data by end users.

22. Data marts are designed for the end-user needs in a strategic business unit or department.

23. Master data are generated and captured by operational systems.

24. Tacit knowledge is the more objective, rational, and technical types of knowledge.

25. Explicit knowledge refers to the cumulative store of subjective learning, which is personal and hard to formalize.

26. Refer to IT’s About Business 5.1: The Rollins Automotive illustrates that a single database can be used to convey information very fast between multiple organizations and software applications.

27. Refer to IT’s About Business 5.2: Storing data in proprietary formats does not pose a great challenge in consolidating and systematically categorizing data from multiple sources.

Question Type: MULTIPLE CHOICE

28. Which of the following is not a source for external data?

1. Commercial databases
2. Corporate databases
3. Sensors
4. Satellites
5. Government reports

5

addressed using data governance.

29. Which of the following is not a reason why managing data is difficult over time?

1. New systems are developed.
2. The media the data are stored on becomes problematic.
3. New sources of data are created.
4. The amount of data increases exponentially.
5. All of these are reasons why managing data is difficult over time.

30. Which of the following are requirements under the Sarbanes-Oxley act? (check all that apply)

1. Public companies must evaluate and disclose the effectiveness of their internal financial controls.
2. Companies must hire independent auditors to verify the disclosures.
3. IT employees are held personally responsible for the release and validity of all filings.
4. Company officers can be held personally liable if the company lacks satisfactory data management policies.
5. Companies will not be held liable if a security breach occurs.

.b.d

31. The amount of data produced worldwide is increasing by       % each year.

1. 10
2. 50
3. 90
4. It is not increasing at all.

32. What are the three distinct characteristics that distinguish big data from traditional data?

1. volume, variety and veracity
2. volume, velocity and verification
3. volume, velocity and variety
4. volume, verification and variety

33. Traditional data formats change             while big data formats change               .

1. slowly, rapidly
2. rapidly, slowly
3. slowly, incrementally
4. both formats of data change at the same rate

34. Why are many organizations turning to NoSQL databases to manage big data?

1. NoSQL databases do not allow for missing data
2. NOSQL databases can process unstructured as well as structured data
3. NoSQL databases have a finite amount of data they can handle
4. NoSQL databases are less expensive than other databases

35. Not including alphabetic characters in a Social Security Number field is an example of

            .

1. Data isolation.
2. Data integrity.
3. Data consistency.
4. Data redundancy.
5. Application/data dependence.

7

36.            occurs when applications cannot access data associated with other applications.

1. Data isolation
2. Data integrity
3. Data consistency
4. Data redundancy
5. Application/Data dependence

37.            occurs when the same data are stored in many places.

1. Data isolation
2. Data integrity
3. Data consistency
4. Data redundancy
5. Application/Data dependence

38.            occurs when various copies of the data agree.

1. Data isolation
2. Data integrity
3. Data consistency
4. Data redundancy
5. Application/Data dependence

39. You have moved to a different apartment, but your electricity bill continues to be sent to your old address. The Post Office in your town has which problem with its data management?

1. Data redundancy
2. Data inconsistency
3. Data isolation
4. Data security
5. Data dependence

40. Place the following members of the data hierarchy in their correct order:

1. Bit – byte – field – record – database – file
2. Bit – field – byte – record – file – database
3. Byte – bit – record – field – database
4. Bit – byte – field – record – file – database
5. Bit – record – field – byte – file -- database

41. In the data hierarchy, the smallest element is the          .

1. Record.
2. Bit.
3. Byte.
4. Character.
5. File.

42. A(n)            is a logical grouping of characters into a word, a small group of words, or a complete number.

1. Byte
2. Field
3. Record
4. File
5. Database

43. A(n)            is a logical grouping of related fields.

1. Byte
2. Field
3. Record
4. File

9

5. Database

44. A(n)            is a logical grouping of related records.

1. Byte
2. Field
3. Record
4. File
5. Database

45. A(n)            represents a single character, such as a letter, number, or symbol.

1. Byte
2. Field
3. Record
4. File
5. Database

46. In a database, the primary key field is used to           .

1. specify an entity
2. create linked lists
3. identify duplicated data
4. uniquely identify a record
5. uniquely identify an attribute

47.            are fields in a record that have some identifying information but typically do not identify the record with complete accuracy.

1. Primary keys
2. Secondary keys

3. Duplicate keys
4. Attribute keys
5. Record keys

48. As an individual student in your university’s student database, you are a(n)            of the STUDENT class.

1. instance
2. individual
3. representative
4. entity
5. relationship

49. At your university, students can take more than one class, and each class can have more than one student. This is an example of what kind of relationship?

1. one-to-one
2. one-to-many
3. many-to-one
4. many-to-many
5. some-to-many

50. In a university’s relational database, the student record contains information regarding the student’s last name. The last name is a(n):

1. attribute.
2. entity.
3. primary key.
4. object.
5. file.

11

51. A database management system is primarily a(n)           .

1. file-handling program
2. data-modeling program
3. interface between applications and a database
4. interface between data and a database
5. interface between queries and a database

52. In the relational database model, related tables can be joined when they contain common

          .

1. primary keys
2. rows
3. records
4. columns
5. files

53.            tell the database management system which records are joined with others in related tables.

1. Primary keys
2. Secondary keys
3. Common attributes
4. Common files
5. Common fields

54. Data dictionaries perform all of the following functions except:

1. Providing information on each record.
2. Providing information on why attributes are needed in the database.
3. Defining the format necessary to enter data into the database.
4. Providing information on the name of each attribute.
5. Providing information on how often attributes should be updated.

55. In a relational database, every row represents a(n)           .

1. file
2. record
3. attribute
4. primary key
5. secondary key

56. A standardized language used to manipulate data is            .

1. MS-Access
2. Oracle
3. query-by-example language
4. structured query language
5. data-manipulation language

57. Data dictionaries provide which of the following advantages to the organization?

1. They reduce data inconsistency.
2. They enable faster program development.
3. They make it easier to modify data and information.
4. Only B and C
5. All of the above

58.            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. Joining
5. Relational analysis

13

59. When data are normalized, attributes in the table depend only on the          .

1. secondary key
2. common attribute
3. primary key
4. common row
5. common record

60. The data in a data warehouse have which of the following characteristics?

1. They are organized by subject.
2. They are coded in different formats.
3. They are updated in real time.
4. They are typically retained for a defined, but limited, period of time.
5. They are organized in a hierarchical structure.

61. The data in a data warehouse:

1. are updated constantly in real time.
2. are updated in batch mode, approximately once per day.
3. are not updated.
4. are purged constantly as new data enter.
5. are available for MIS analysts, but not users.

62. The process of moving data from various sources into the data warehouse is called:

1. uploading.
2. extracting, transforming, and loading.

3. online transaction processing.
4. master data management.
5. online analytical processing.

63. Compared to data warehouses, data marts have which one of the following characteristics?

1. They cost less.
2. They have longer lead times for implementation.
3. They provide for central rather than local control.
4. They contain more information.
5. They are more difficult to navigate.

64.            is a formal approach to managing data consistently across an entire organization.

1. Database management
2. Enterprise information management
3. Data warehousing
4. Data governance
5. Data mart

65.            provide(s) companies with a single version of the truth for their data.

1. Data warehouses
2. Data marts
3. Databases
4. Master data management
5. Enterprise information management

15

66. Organizations are turning to data governance for which of the following reasons?

1. They have too little data.
2. They are responding to federal regulations.
3. Their data are typically structured.
4. Their data are usually located in the organization’s databases.
5. Data across their organizations are generally consistent.

67.            describe the activities of the business, whereas             categorize(s), aggregate(s), and evaluate(s) data generated by the organization’s activities.

1. Transaction data, master data
2. Source data, transaction data
3. Operational data, master data
4. Master data, source data
5. Business dimensional data, databases

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

1. Discovery
2. Knowledge management
3. Decision support
4. Online analytical processing
5. Data mining

69.            can be exercised to solve a problem, whereas             may or may not be able to be exercised to solve a problem.

1. Knowledge, information

2. Data, information
3. Information, data
4. Information, knowledge
5. Data, knowledge

70. Explicit knowledge has which of the following characteristics?

1. objective
2. personal
3. slow
4. costly to transfer
5. ambiguous

71. Tacit knowledge has which of the following characteristics?

1. codified
2. objective
3. unstructured
4. rational
5. technical

72. Historically, management information systems have focused on capturing, storing, managing, and reporting                              knowledge.

1. tacit
2. explicit
3. managerial
4. geographical
5. cultural

17

73. The most important benefit of knowledge management systems is:

1. They improve customer service.
2. They make best practices available to employees.
3. They enable the organization to retain scarce knowledge when employees retire.
4. They improve employee morale.
5. They make product development more efficient.

74. Refer to IT’s About Business 5.3: Database Solution for the German Aerospace Center: The challenges associated with data collection from satellites include the following except:

1. Capturing data in real time
2. Storing data at the satellite
3. Transferring data from the satellite to central databases
4. Storing current and past data collected from the satellites
5. Processing data to compare current and past information to predict future events

75. Refer to IT’s About Business 5.4: Hospital Improves Patient Care with Data Warehouse: A single source of all patient data, accessible to multiple hospitals will have the following benefit
    1. aid in medical research
    2. reduce duplicate tests
    3. eliminate the need for patients to do their own record keeping
    4. faster transfer of high-volume image data across different locations
    5. all of the above

76. Refer to Closing Case – Can Organizations Have Too Much Data? The primary reason why organizations would want to maintain multiple copies of the same data are the regulations and laws.

QUESTION TYPE: TRUE/FALSE

77. For the following entity-relationship diagram, the Student entity would have the foreign key.

21

Question Type: Multiple Choice

78. For the following entity-relationship diagram, the attributes you would NOT expect to see in the Computer entity are

1. manufacturer.
2. type (laptop or desktop).
3. memory size.
4. disk size.
5. student’s dorm room.

79. For the following entity-relationship diagram, what could the primary key be in the Grade entity?

1. Primary key in Student entity
2. Primary key in Course entity
3. Its own primary key.
4. Primary key made up of the primary keys in Student entity and Course entity
5. It doesn’t need a primary key.