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.
2
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.
4
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?
A. Commercial databases
B. Corporate databases
C. Sensors
D. Satellites
E. Government reports
29. Which of the following is not a reason why managing data is difficult over time?
A. New systems are developed.
B. The media the data are stored on becomes problematic.
C. New sources of data are created.
D. The amount of data increases exponentially.
E. 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)
a) Public companies must evaluate and disclose the effectiveness of their internal financial
controls.
b) Companies must hire independent auditors to verify the disclosures.
c) IT employees are held personally responsible for the release and validity of all filings.
d) Company officers can be held personally liable if the company lacks satisfactory data
management policies.
e) Companies will not be held liable if a security breach occurs.
31. The amount of data produced worldwide is increasing by ___% each year.
a) 10
b) 50
c) 90
d) It is not increasing at all.
32. What are the three distinct characteristics that distinguish big data from traditional data?
a) volume, variety and veracity
b) volume, velocity and verification
c) volume, velocity and variety
d) volume, verification and variety
33. Traditional data formats change ______ while big data formats change _______.
a) slowly, rapidly
b) rapidly, slowly
c) slowly, incrementally
d) both formats of data change at the same rate
34. Why are many organizations turning to NoSQL databases to manage big data?
a) NoSQL databases do not allow for missing data
b) NOSQL databases can process unstructured as well as structured data
c) NoSQL databases have a finite amount of data they can handle
d) NoSQL databases are less expensive than other databases
35. Not including alphabetic characters in a Social Security Number field is an example of
_____ .
A. Data isolation.
B. Data integrity.
C. Data consistency.
D. Data redundancy.
E. Application/data dependence.
8
36. _____ occurs when applications cannot access data associated with other applications.
A. Data isolation
B. Data integrity
C. Data consistency
D. Data redundancy
E. Application/Data dependence
37. _____ occurs when the same data are stored in many places.
A. Data isolation
B. Data integrity
C. Data consistency
D. Data redundancy
E. Application/Data dependence
38. _____ occurs when various copies of the data agree.
A. Data isolation
B. Data integrity
C. Data consistency
D. Data redundancy
E. 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?
A. Data redundancy
B. Data inconsistency
C. Data isolation
D. Data security
E. Data dependence
9
40. Place the following members of the data hierarchy in their correct order:
A. Bit – byte – field – record – database – file
B. Bit – field – byte – record – file – database
C. Byte – bit – record – field – database
D. Bit – byte – field – record – file – database
E. Bit – record – field – byte – file — database
41. In the data hierarchy, the smallest element is the _____.
A. Record.
B. Bit.
C. Byte.
D. Character.
E. File.
42. A(n) _____ is a logical grouping of characters into a word, a small group of words, or a
complete number.
A. Byte
B. Field
C. Record
D. File
E. Database
43. A(n) _____ is a logical grouping of related fields.
A. Byte
B. Field
C. Record
10
D. File
E. Database
44. A(n) _____ is a logical grouping of related records.
A. Byte
B. Field
C. Record
D. File
E. Database
45. A(n) _____ represents a single character, such as a letter, number, or symbol.
A. Byte
B. Field
C. Record
D. File
E. Database
46. In a database, the primary key field is used to _____.
A. specify an entity
B. create linked lists
C. identify duplicated data
D. uniquely identify a record
E. 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.
A. Primary keys
B. Secondary keys
C. Duplicate keys
D. Attribute keys
E. Record keys
48. As an individual student in your university’s student database, you are a(n) _____ of the
STUDENT class.
A. instance
B. individual
C. representative
D. entity
E. 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?
A. one-to–one
B. one-to-many
C. many-to–one
D. many-to-many
E. 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):
A. attribute.
B. entity.
C. primary key.
D. object.
E. file.
12
51. A database management system is primarily a(n) _____.
A. file-handling program
B. data-modeling program
C. interface between applications and a database
D. interface between data and a database
E. interface between queries and a database
52. In the relational database model, related tables can be joined when they contain common
_____.
A. primary keys
B. rows
C. records
D. columns
E. files
53. _____ tell the database management system which records are joined with others in related
tables.
A. Primary keys
B. Secondary keys
C. Common attributes
D. Common files
E. Common fields
54. Data dictionaries perform all of the following functions except:
A. Providing information on each record.
B. Providing information on why attributes are needed in the database.
C. Defining the format necessary to enter data into the database.
D. Providing information on the name of each attribute.
E. Providing information on how often attributes should be updated.