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