Durham Technical Community College

INFORMATION TECHNOLOGY 3063

1)In a job interview, Roy is asked to use a product that he has never used before and is unfamiliar with its functioning. Which of the following skills is the interviewer trying to test?

2. Which of the following statements is TRUE about the management and use of information systems?
3. Why is it not a good idea to tell someone "Look, it's right there in front of you, in the data"?
4. Which of the following is an impact of rapid technological change on job security?
5. As the cost of data processing, storage, and communications is essentially zero, any routine skill can and will be                                                                    .
6. All of the following are strong nonroutine cognitive skills EXCEPT                                  .
7. All of these are characteristics of good data EXCEPT                                   .
8. Data should be relevant both to the                            and                        .
9. In a grocery store, a clerk uses a barcode scanner to read the barcode on an item. Which of the following components of an information system includes this scanning device?
10. Which of the following statements is TRUE of Moore's Law?

11. Which task is an example of abstract reasoning?

12. A group of components that interact to achieve some purpose is referred to as a(n)

                      .

13. The future belongs to business people who can                                         .

14.                        is the ability to model the components of a unit to connect the inputs and outputs among those components into a sensible whole that reflects the structure and dynamics of the phenomenon observed.

15. Whatever career you choose you must                                       systems development.

16. In the Digital Revolution, what new capability could devices accomplish?

17. All of the following are ancillary functions you may have as a manager concerning the use of information systems EXCEPT                                                                                          .

18. Joshua, the CEO of Dunk, Inc., wanted to view the sales by region. His assistant gave him a 100-page report. Joshua could not find the information because the report was not               .

19. Why is it important for business professionals to take an active role in developing and managing information systems?

20. Why is it not a good idea to tell someone "Look, it's right there in front of you, in the data"?

21. What is Google's Project Loon?

22. What is a primary metric for social media companies?

23. Why did Amanda lose her job at eHermes?

24. Since 1990, the most significant determinant of employment and salary is                                  .

25. Which of the following is an impact of rapid technological change on job security?

26. As the cost of data processing, storage, and communications is essentially zero, any routine skill can and will be                                                                    .

27. In a job interview, Lillian is asked to be part of a three-member group and design a mock business process based on the strengths and skills of the group's members. In this case, which of the following skills is the interviewer trying to test?

28. Which of the following is considered the single most important skill for effective collaboration?

29. All of the following are true of experimentation EXCEPT                               

30. The future belongs to business people who can                                         .

31. Which of the following laws speaks about the storage density on magnetic disks?

32. Which of the following statements is TRUE about the management and use of information systems?

33.                        is making a reasoned analysis of an opportunity, envisioning potential solutions, evaluating those possibilities, and developing the most promising ones, consistent with the available resources.

34. If your company's competitive strategy was focus and differentiation, then the company would be known for                                                           .

35. Each stage of the value chain not only adds value to the product but also _

36. Which of the following is TRUE of new entrants?

37. Which of the following statements describes a customer service activity?

38. Which of the following describes suppliers in a position of strong bargaining power?

39. Simpson's Lawn Services decides to offer two free mowing services for all customers who booked garden landscaping in the fall. Which of the following forces is Simpson's Lawn Services addressing?

40. According to Porter, to be effective, an organization's goals, objectives, culture, and activities must be consistent with the organization's                                                                 .

41. Which of the following is TRUE of supporting activities?

42. Porter's model of business activities includes                             , which are interactions across value activities.

43. According to Porter, the processes and systems in an organization pursuing differentiation strategy must                                                        to avoid negative margins.

44. The competitive strategy followed by an organization is derived from the                                of its industry.

45. The difference between the value that an activity generates and the cost of the activity is called the            .

46. Which statement is an example of the threat of substitutions force?

47. What is an example of a rivalry weak force in Porter's model?

48. Which of the following strategies is also called establishing high switching costs?

49. The bargaining power of                            is one of the five competitive forces in Porter's five forces model.

50. Which of the following statements is TRUE of business processes?

51. Which of the following is an example of a competitive strategy employed by a firm?

52. The bargaining power of a customer is weak if                              .

53. The goal of                         , a type of business intelligence analysis, is to create information about past performance.

54.                        is an open source program supported by the Apache Foundation that manages thousands of computers and that implements MapReduce.

55. Which of the following statements is TRUE of a data warehouse?

56.                          is the process of obtaining, cleaning, organizing, relating, and cataloging source data.

57.                          process operational, social, and other data to identify patterns, relationships, and trends for by business professionals and other knowledge workers.

58. Which of the following statements is TRUE of unsupervised data mining?

59. Which option below is an example of a status BI report?

60. Which of the following statements is TRUE of BigData?

61. Big Data has                  meaning that it is generated rapidly.

62. Which of the following statements is TRUE of Hadoop?

63.                          is used to measure the impact of a set of variables on another variable during data mining.

64.                          refers to the level of detail represented by data.

65. Sam is going to use a program that predicts the possibility of a certain outcome based on prior occurrences of related events to predict if a car is most likely to run a red light. He decides to use           .

66. All of the following are areas of research for artificial intelligence (AI) except            .

67.                         , a subset of AI, is the extraction of knowledge data based on algorithms created from training data.

68. Georgia is attempting to solve a mathematical problem. She chooses the correct procedure or        that best fits the situation.

69. Machines lack all of these skills EXCEPT                                            .

70. Artificial Intelligence can be used to increase                                          or the process of making systems operation without human intervention.

71. The                            of business intelligence servers maintains metadata about the authorized allocation of business intelligence results to users.

72.                          are business intelligence documents that are fixed at the time of creation and do not change.

73.                          are reports produced when something out of predefined bounds occurs.

74.                          is the second primary activity in the business intelligence process.

75.                          is the process of obtaining, cleaning, organizing, relating, and cataloging source data.

76. Which BI activity would a company be participating in if they were cataloging?

77. Which BI activity would a company be participating in if they used data mining to determine when to place rain boots on the shelves?

78. The results generated in the map phase are combined in the                                              phase.

79. Problematic data are termed                                  .

80. Regression analysis is used in                                      .

81.                          are business intelligence documents that are updated at the time they are requested.

82. The use of an organization's operational data as the source data for a business intelligence system is not usually recommended because it                                                                                                 .

83. All of these are examples of AI in a self-driving car EXCEPT                                                  .

84. Without                            machines won't last long.

85. All of these costs are true of human employees EXCEPT                                               .

86.                          is the ability of a machine to simulate human abilities such as vision, communication and learning in order to achieve a goal.

87. What is one benefit of automation?

88.                         , a subset of AI, is the extraction of knowledge data based on algorithms created from training data.

89. What is the goal of strong AI?

90. Virtual reality uses                                to create a completely immersive experience for the user.

91. What is the smallest unit of bitcoin?

92. Cryptocurrencies are                                 that use cryptographic protections to manage and record secure transactions.

93.                          is the decentralized public ledgering system used to record cryptocurrency transactions.

94. Which of the following is NOT a mobile systems cloud use?

95. What is the impact of mobile systems growth on the hardware?

96. Which of the following is TRUE of push data?

97. A                           application is a thick-client application that is designed to work with a particular operating system, and sometimes only with a particular mobile device that runs that operating system.

98. All of the following are reasons why organizations can be as effective with part- time employees and independent contractors EXCEPT                                                                                       .

99. Which of the following is a disadvantage of mobile systems at work?

100. Web applications can be developed by less-skilled, lower-paid employees; they are considerably cheaper to develop than                                                                                      applications.

101. Which of the follow statements is TRUE about mobile devices and procedures?

102. Which of the following statements is TRUE of Web applications developed for mobile systems?

103. Some mobile applications provide                                      chrome, which pops up in the display when appropriate.

104. Which of the following statements about native applications is TRUE?

105. Which of the following is a disadvantage of employees using their mobile systems at work?

106. Which of the following is an example of a cryptocurrency?

107. The                            refers to the idea in which objects are becoming connected to the Internet so that they can interact with other devices, applications, or services.

108. Which of the following will likely be an advantage of self-driving cars?

109. Which programming language is associated with Mac OS and iOS application development?

110. Which of the following is TRUE about the impact of mobile systems on data usage in information systems?

111. Megan has downloaded a new gaming application on her smartphone. When she starts using it, she realizes that command icons and a navigation bar, intended for better user interface, block more than half the screen on her phone. Megan is disappointed with the app and immediately deletes it. With reference to this scenario, which of the following features does the gaming application need to improve?

112. ABC Incorporated has decided to allow employees to use their mobile devices at work. They have decided to treat the devices as if they are owned by

the organization and install a(n)                                     to help them install and update software.

113. Logan, a professional programmer and developer, develops a Web mobile application. The application allows users to book cabs for rides within the city. Which of the following languages is Logan most likely to have used to develop this app?

mobile systems at work. The management noticed a significant increase in employee satisfaction after the policy was instated. Which of the following will be an added advantage to UTN as a result of the policy?

121. Which of the following is a drawback of the relational database processing model?

122. A(n)                           is a program that is used to create, process, and administer a collection of self-describing integrated records.

123. Which of the following is a nonrelational data store developed by Amazon.com?

124. With                           like Microsoft Access, the application, DBMS, and database all reside on the user's computer.

125. The database management system (DBMS) provides applications for processing operations such as .

126. Which of the following is an international standard language for querying databases?

127. A                           is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.

128. The A in ACIS means Atomic and means                                          .

isolated, durable) transactions.

132. The conversion of the existing traditional databases in organizations to NoSQL databases is                .

133. All of the following are elements of a database application EXCEPT

                        .

134. What is an example something that can occur in a database concerning multiuser processing?

138. Monitoring the performance of a database after providing solutions for improving its performance is an activity of the DBMS pertaining to                                                                          .

139. Lists that involve data with multiple themes require a                                         .

140. Which of the following is TRUE of the relational database processing model?

141.                          are browser-based queries that are created when a user clicks on a graphic.

142. With                           like Microsoft Access, the application, DBMS, and database all reside on the user's computer.

143. A cylindrical symbol labeled "database" represents                                           because databases are stored on disks.

144.                          is a popular enterprise database management system (DBMS) product from IBM.

145. Which of the following best describes a byte in a database?

146. Which of the following is a function of the database management system (DBMS)?

147. Which of the following elements of a database application helps in the insertion of new data and the deletion of existing data?

148. Browser-based database applications differ from traditional applications in that they           .

149. Which of the following is an advantage of a content delivery network?

150. Which of the following is true about accessing resources over the Internet?

151. Cloud vendors benefit from                                  because the average cost of production decreases as the size of the operation increases.

152. Until about the late 1980s, organizations primarily used                                             for their internal data processing needs?

153. A                           is an information system that stores user data in many different geographical locations and makes that data available on demand.

154. Thin clients are sometimes called                                     .

155. Which of the following statements is TRUE of cloud-based hosting?

156. Which of the following is an advantage of a private cloud in an organization?

157. If an organization opts for software as a service (SaaS), it will have to

                        .

devices follow.

163. The concept of                               is the idea that all data is treated equally. Companies do not want carriers deciding which sites load quickly.

164. Which protocol standard instructs hardware which wire carries which signal?