OIM 471 Ch. 1, 4, 5 & CE5
A basic list of email addresses is considered ____________. A. data B. management C. information D. tacit E. relational
A
A popular DBMS product created by IBM is _________________. A. DB2 B. Oracle C. SQL Server D. MySQL E. Access
A
Another word for field is ________. A. column B. row C. byte D. table E. record
A
Digital revolution did not just mean that new "digital" equipment would replace the old mechanical or analog equipment. It included all of the following features EXCEPT which one? A. Development of the computer B. About every 10 years, new classes of digital devices have emerged. C. Faster processors D. Growth of the internet E. In the 1990s, we saw the rise of the Internet
A
Moore's law states that the number of transistors per square inch on an integrated chip doubles every ________ months. A. eighteen B. six C. twelve D. thirty E. twenty-four
A
The lost-update problem occurs when ________. A. two users in a multi-user environment attempt to make the same updates to the database at the same time, so that one erases the effect of the other B. a program aborts after performing an update on the database C. an update request to the DBMS gets lost in network traffic and never gets accomplished D. the DBMS performs an update, but the application is not informed about the change E. the database management system fails to perform a requested update, and the user is not informed of the situation
A
Using SQL Server, how was eHermes planning on storing images in the database? A. Using metadata and storing URLs of the file B. Using embedded images C. Using a blob datatype D. Using a VarChar datatype E. using Microsoft Paint
A
Which best describes the purpose of a primary key? A. A unique identifier B. The same identifier in every row C. A common data value in each record D. Points to a field E. A placeholder for another value
A
Which of the following is NOT a characteristic of a quality mobile application? A. Working only on the Firefox browser B. Using context-sensitive chrome when needed C. Being designed to scale and share (display and data) and use the cloud D. Featuring content and supporting direct interaction E. Providing animation and lively behavior
A
Which of the following is NOT a mobile device? A. Desktop computer B. Smartphone C. Smartwatch D. Tablet E. Small, light laptop
A
Which of the following is NOT part of a mobile device user interface (UI)? A. Hardware B. Toolbars C. Menus D. Dialog boxes E. Windows
A
Which of the following is a task using a thin-client? A. Checking Gmail B. Creating an Access database C. Taking a picture with a mobile device D. Printing a picture to a wired local printer E. Creating a Microsoft Word document
A
Which of the following is a type of server operating system? A. Unix B. Windows 10 (Mobile) C. iOS D. MacOS E. Android
A
Which of the following is an example of metadata? A. The data type of a field B. The value of a primary key C. An employee's first and last name D. A DBMS E. A cylindrical circle in a database diagram figure
A
Which of the following operating systems falls under the mobile client category? A. iOS B. Linux C. Windows D. Unix E. Mac OS
A
Which of the following statements is FALSE? A. Mobile systems have very little impact on business and society today. B. Mobile use is favored by the young. C. The younger the age group, the greater the percentage of people with mobile devices. D. Worldwide mobile subscriptions outnumber fixed lines by seven to one. E. Younger people have more mobile devices per capita than older groups.
A
Which statement about Web applications is FALSE? A. The costs of development are always high. B. Developing sophisticated applications may require high skill and pay. C. Simple applications can be developed by entry-level technical employees. D. The costs vary from low to high. E. The application is limited by Web browser capabilities.
A
Who knows if a database needs to be updated or changed? A. The user B. The database administrator C. The information technology manager D. The administrative assistant E. The chief information officer
A
With the emergence of artificial intelligence (AI) to improve business efficiency, 74 percent of companies plan to implement AI extensively over the next 3 years. Unfortunately, research indicates only about ____________ percent of employee are prepared to participate in discussions related to AI. A. 25 B. 5 C. 50 D. 10 E. 75
A
Joshua's supervisor requests information on video game console sales from the Midwest region. Joshua should use what type of database element? A. Report B. Special purpose processing C. Out-of-stock report D. Form E. Query
A
____________ is a characteristic of good data intended to reduce the inundation of data provided to management to help guide decision making. A. 'Just Barely Sufficient' B. 'Timely' C. 'Accurate' D. 'Worth Its Cost' E. 'Relevance'
A
_____________ is computer code written and understood by humans. A. Source code B. Open Source C. Machine code D. Firefox E. LibreOffice
A
After comparing alternatives for data storage, management at eHermes selected ______________ as their database. A. MySQL B. Microsoft SQL Server C. MongoDB D. Access E. Oracle
B
Providing a list of every product UPC code to the company's CEO is likely not useful and lacks relevance with regards to ____________. A. timeliness B. context C. the subject at hand D. accuracy E. being just barely sufficient
B
The digital revolution oversaw the rise and growth of both the Internet and Ethernet. Specifically, which decade did the dot-com phenomenon occur in order to facilitate the rise of the today's known tech giants? A. 1940s B. 1990s C. 1970s D. 1950s E. 2000 - 2009
B
The first disruptive force discussed in the text that has the power to change business is ________________. A. thin-clients B. the Internet of Things C. server farms D. 3D printing E. virtualization
B
The purpose of a database is to ___________. A. keep track of grades for students B. keep track of things C. create data D. keep a spreadsheet E. organize names
B
Three of the most important elements of information systems management include maintaining, adapting, and ________. A. configuring B. developing C. hiding D. securing E. differentiating
B
What is the difference between a DBMS and a database? A. A DBMS is a collection of tables, relationships, and metadata; a database is software. B. A DBMS is software; a database is a collection of tables, relationships, and metadata. C. A DBMS is a table; a database is a relational spreadsheet. D. A DBMS contains rows; a database contains tables. E. A DBMS uses SQL; a database uses MySQL.
B
Which cognitive skills are needed to effectively prepare a workforce to adapt within rapidly changing technology and increased international competition? A. Collaboration B. Nonroutine cognitive skills C. System thinking D. Abstract reasoning E. Ability to experiment
B
Which of the below is NOT an open source project? A. Cassandra B. Microsoft Office C. Ubuntu D. Hadoop E. Apache
B
Which of the five components of a hospital's information system pertains to the steps, processes, and rules nurses must follow when entering patient information? A. software B. procedures C. data D. people E. hardware
B
Which of the following are you NOT likely to experience as a result of the advent of smart cars in the future? A. Your car will be easier to drive. B. You will probably own more cars than before. C. Your car will be safer. D. Your car will be cheaper to own and drive. E. You will be more likely to travel by car than by plane for long trips.
B
Which of the following is NOT a component of information systems (IS)? A. Hardware B. The government C. People D. Procedures E. Data
B
Which of the following is NOT a native application development language? A. Objective-C B. HTML5 C. Java D. Swift E. C#
B
Which of the following is NOT a type of hardware? A. Server B. Program C. Personal computer D. Tablet E. Phablet
B
Which of the following statements is true regarding the rise of nontraditional DBMSs? A. More and more queries involve joins between multiple tables in a database. B. There is a need to process less structured data such as business documents and nontraditional data types (e.g., free-form text, audio, and video) in distributed environments. C. All data requires normalization. D. Microsoft's SQL Server and Oracle's relational DBMS are the wave of the future in the Big Data world. E. Data is primarily stored in relational databases.
B
Which of the following statements related to the use of personal devices at work is true? A. Employees never resist turning over to management their own personal hardware because they realize that this is in the organization's best interests. B. The most controlling policy is for the organization to declare that it owns any mobile device that employees connect to its network. To be enforceable, this policy must be part of the employee's contract. C. A BYOD (bring your own device) policy is a statement requiring that employees use their own device for organizational business. D. Advantages of the employee use of mobile devices at work are data inclusion and the increase in time availability. E. Mobile device management (MDM) software helps users to manage the organization's devices as if they were owned by the user.
B
Why is adaptation such an important measure when managing information systems? A. To keep the company modern with new technology B. To fit in with new requirements C. Because the firm is falling behind the technology curve D. Because the IT manager declares so E. For the firm to show it has social networking presence on the Web
B
Working in an MIS environment results in encounters of products and IS applications such as the Microsoft spreadsheets with which the user may have minimal experience. Which of the four cognitive skills is specifically applicable in such an encounter? A. Abstract reasoning B. Ability to experiment C. System module development D. Conceptualization E. System thinking
B
All of the following are disadvantages of employees using mobile systems at work EXCEPT ________. A. loss of control of data B. data loss or damage C. greater need for training D. compatibility problems E. risk of infection
C
All of the following are resources in the cloud EXCEPT ________. A. data sources B. application codes C. mobile phones D. Web sites E. services such as IM and email
C
The computer program that is loaded onto a computer's hard drive, controls the computer's main memory, and has access to input and output devices and other hardware resources is called ____________. A. firmware B. open source software C. the operating system D. the CPU E. application software
C
The famous psychologist Gregory Bateson defined information as ____________. A. processed data B. data processed by summing, ordering, averaging, grouping, comparing, or other similar operations C. a difference that makes a difference D. data presented in a meaningful context E. knowledge derived from knowledge
C
What is the purpose of a DBMS? A. To be the repository of a company's data B. To provide forms and screens to end users, enabling them to add to or modify the company's data in a user-friendly manner C. To create, process, and administer databases D. To control access to the storage media that holds a company's data E. To provide a visual output of the company's data in a user-friendly manner to end users
C
What was the goal of eHermes' use of Google's image classifier system? A. eHermes wanted to reduce product theft. B. eHermes wanted to improve product quality. C. eHermes wanted to speed up the process of inventorying new items. D. eHermes wanted to improve its database design. E. eHermes wanted to improve its distribution channels.
C
Which category of nonrelational databases consists of DBMS products that process databases in main memory? A. NewSQL DBMS B. Oracle DBMS C. In-memory DBMS D. 64-bit Main Memory DBMS E. Main Memory DBMS
C
Which of the following is NOT a component of an information system? A. Data B. Software C. E-commerce D. Procedures E. Hardware
C
Which of the following is NOT a function of mobile device management (MDM) software? A. They wipe employer software and data from devices in the event the device is lost or the employee leaves the company. B. They back up and restore mobile devices. C. They prolong the life of mobile devices. D. They install and update software. E. They report usage of the mobile devices.
C
Which of the following is NOT an important element of effective collaboration? A. Willingness to share ideas with others B. A work product that is better than that produced by a single person C. Being nice D. Giving effective feedback E. Receiving critical feedback
C
Which of the following is NOT one of the major elements in a mobile system? A.Cloud-based resources B. Users in motion C. Gaming laptops D. Mobile devices E. Wireless connectivity
C
Which of the following is a Web Application development language? A. Swift B. Objective-C C. JavaScript D. C++ E. Java
C
Which of the following is an accurate list of devices that are considered mobile devices? A. Smartphone, tablet, small, light laptop computer, and Xbox B. Smartphone, tablet, small, light laptop computer, and all-in-one computer C. Smartphone, tablet, small, light laptop computer, and a smartwatch D. Server, tablet, small light laptop computer, and a smartwatch E. Smartphone, tablet, small light laptop computer, and PS4
C
Which of the following statements about the iOS operating system is FALSE? A. It is custom-developed software. B. It is used on iPhone, iPod Touch, and iPad. C. It is available for free from Apple, Inc. D. It is not licensed by Windows. E. It is not a type of server.
C
Writing an SQL statement to determine that the maximum salary in the company is $400,000 represents ____________, because it's presented in a meaningful context. A. data B. a relational database management system C. information D. a database management system E. management
C
eHermes used ____________ image classifier to speed up the process of inventorying new items by automatically recognizing them. A. Oracle's B. MongoDB's C. Google's D. Microsoft's E. NoSQL's
C
All of the following are potential impacts of self-driving cars EXCEPT________. A. no DUI citations B. fuel savings C. more car sharing D. more traffic tickets E. lower insurance premiums
D
Computers represent data using ___________, also called bits. A. cache B. clients C. CPUs D. binary digits E. CDs
D
The hardware component that reads instructions from main memory, performs arithmetic and logical operations, and then stores results back into memory, is called the ____________. A. PC B. RAM C. CD D. CPU E. server
D
What would the ability to model the components of a system be called so that the end result of this process reflects the dynamics and structure of the system under observation? A. Collaboration B. System experimentation C. System module development D. Systems thinking E. Abstraction
D
Which of the following describes the purpose of a query? A. Structuring the presentation of data using sorting, grouping, filtering, and other operations B. Manually inserting new data into the database C. Using MySQL D. Searching the database based on data values provided by the user E. Providing security
D
Which of the following statements is FALSE? A. A user interface is the presentation format of an application. B. A user experience (UX) refers not only to both the UI and the way that the application affects the user's emotions and motivation to continue to use the interface. C. Chrome is a term that refers to the visual overhead in a computer display. D. Context-sensitive chrome is always visible on the display. E. Using content to drive application behavior is called direct interaction.
D
_________ is a set of tools developed for creating a free Unix-like operating system. A. Android B. Windows Server C. Open source D. GNU E. MacOS
D
A database administrator (DBA) has all of the following tasks EXCEPT to _________________. A. evaluate application design B. conduct training C. manage configuration changes D. manage security E. create and staff programming functions
E
A database consists of the following components: A. Records + fields + rows B. Primary Key + Key + Unique Identifier C. Metadata + Primary Key + Rows D. Bytes + columns + rows E. Tables + Relationships+ Metadata
E
All of the following are examples of nonrelational databases EXCEPT ________. A. Bigtable B. Oracle NoSQL Database C. Dynamo D. Cassandra E. Oracle DBMS
E
All of the following can make a device "smart" EXCEPT ________. A. adding Wi-Fi connectivity B. adding more memory C. adding Internet access D. adding more processing power E. upgrading the display
E
Although a significant technology skills gap currently exists, only about ____________ percent of CEOs plan to increase investments in technology-related training. A. 20 B. 10 C. 25 D. 50 E. 3
E
Deciding if you require real time or batch processing some hours later is related to the ____________ characteristic of good data. A. 'Accurate' B. 'Relevance' C. 'Just Barely Sufficient' D. 'Worth Its Cost' E. 'Timely'
E
In any case, better performance is only achieved upon effective coordination of the individual components of a production entity. Which production components did Google's Project Loon plan to use to achieve adequate Internet access across the globe? A. Low earth satellites B. Wi-Fi networks C. Geostationary satellites D. Ethernet connection E. Inflated balloons floating around the world
E
Providing 30-year mortgage information to someone interested in a short-term loan would lack relevance with regards to ____________ A. the subject at hand B. data accuracy C. being just barely sufficient D. timeliness E. the subject
E
The term ACID transactions refers to which of the following? A. Algorithmic, controlled, independent, durable B. Algorithmic, consistent, independent, durable C. Atomic, calculated, inviolate, dependable D. Automatic, calculated, independent, durable E. Atomic, consistent, isolated, durable
E
When source code is compiled, it becomes ________. A. firmware B. closed source C. an operating system D. open source E. machine code
E
Which is an example of a database? A. Google Docs B. Microsoft Excel C. Facebook D. LinkedIn E. A cellphone contact list
E
Which of the following is a true statement about job growth trends between 2012 and 2016? A. Architecture and engineering jobs showed the most substantial negative growth rates during this time. B. Computer systems design and related services showed a dramatic drop in jobs due to the dot-com bust and have not recovered. C. Jobs related to education far exceeded the growth rate of any other job category. D. All job categories showed a downward trend during this time interval. E. The average growth rate for information systems-related jobs is twice that of the average for all occupations.
E
____________ describes the scenario where demand for information systems professionals, and its associated technology skills exceeds availability. A. The growth of information systems internationally B. Abstract reasoning C. Systems thinking D. The ability to experiment E. The technology skills gap
E
__________ is an international standard language for database development and querying. A. MySQL B. MongoDB C. Metadata D. SQL Server E. SQL
E
____________ is defined as knowledge derived from ____________ A. Data; information B. Data; databases C. Management; information D. Information; management E. Information; data
E
_______________ consists of electronic components and related gadgetry that input, process, output, and store data according to instructions encoded in computer programs or software. A. Computer software B. The CD C. The CPU D. RAM E. Computer hardware
E