FINAL EDIT: BUS 391 midterm 1 review

What is​ cardinality? Question content area bottom Part 1 A.It defines the foreign keys of a table. B.It corrects and makes the data effective. C.It helps to describe the relationship between two entities. D.It is the process of creating a representation of data. E.It is the process by which tables are redesigned.

.It helps to describe the relationship between two entities

The primary reason that business people must be involved in the development of information systems is that​ __________. Question content area bottom Part 1 A.business people are the ones who understand business needs and requirements B.computer programmers cannot understand the English language C.database developers know how to organize data but​ don't know how to process the data D.Web developers​ don't understand business processes E.network technicians are unfamiliar with business

A. business people are the ones who understand business needs and requirements

Which of the following is NOT a capability of mobile device management​ (MDM) software? Question content area bottom Part 1 A.Automate sending of text messages on behalf of the user B.Perform a​ back-up of the device. C.Install and update software. D.Reporting usage of the device. E.Restoring a device.

A.Automate sending of text messages on behalf of the user

Which of the following statements is​ correct? Question content area bottom Part 1 A.Do not proceed with database design unless the data model is accurate. B.If the data model is​ incorrect, the database can still be used successfully. C.A database is a model of how only managers view their business world. D.If corrections are needed in the database​ structure, the requirements step is the best time to do this. E.The user does not need to dedicate special time to reviewing the data model.

A.Do not proceed with database design unless the data model is accurate.

Which of the components of the​ five-component model is easier to change compared to​ software? Question content area bottom Part 1 A.Hardware B.Data C.Software D.People E.Procedures

A.Hardware

__________ is an assembly of​ hardware, software,​ data, procedures, and people that produce information. Question content area bottom Part 1 A.IS​ (Information Systems) B.CS​ (Computer Systems) C.CIT​ (Computer Information​ Technology) D.MIS​ (Management Information​ Systems) E.IT​ (Information Technology)

A.IS​ (Information Systems)

Which of the following tasks is done by the DBA in the operation​ environment? Question content area bottom Part 1 A.Manage processing rights and responsibilities B.Form steering committee C.Evaluate application design D.Create and staff DBA function E.Validate data model

A.Manage processing rights and responsibilities

Which of the following is true regarding​ N:M relationships? Question content area bottom Part 1 A.N:M relationships are removed by adding another table to the data model. B.An​ N:M relationship poses no problems in a data model. C.N:M relationships allow unique insights to be gained from the data model. D.User review of the data model is avoided when​ N:M relationships are found. E.An advantage of relational database is the ability to cope with​ N:M relationships.

A.N:M relationships are removed by adding another table to the data model.

__________ is an international standard language for processing a database. Question content area bottom Part 1 A.SQL B.DB2 C.RDBMS D.PHP E.HTML

A.SQL

The following are all processing operations of a DBMS EXCEPT​ __________. Question content area bottom Part 1 A.autocorrect data B.insert data C.read data D.modify data E.delete data

A.autocorrect data

When a task that had been performed manually by a human is now performed by the computer side of an information​ system, we say the task has been​ __________. Question content area bottom Part 1 A.automated B.enhanced C.augmented D.accelerated E.optimized

A.automated

Data integrity problems are likely to occur when​ __________. Question content area bottom Part 1 A.data is duplicated B.the data design has a​ N:M relationship C.normal forms are used D.attribute conflicts are not resolved E.minimum cardinalities are not met

A.data is duplicated

If two users of a database access the same record and both attempt to complete an update transaction with that​ record, the ​ __________problem is likely to occur. Question content area bottom Part 1 A.lost update B.Web browsing C.power surging D.transaction processing E.processing

A.lost update

Native applications are typically developed using​ __________ programming languages and are produced by professional programmers. Question content area bottom Part 1 A.object-oriented B.old-fashioned C.linear oriented D.operating system E.firmware

A.object-oriented

Every database table must have a​ __________, a field​ (or fields) that contains a unique value for every table record. Question content area bottom Part 1 A.primary key B.foreign key C.primary element D.predictive key E.relationship line

A.primary key

In​ databases, a group of similar rows or records is called a​ __________. Question content area bottom Part 1 A.table B.field C.relationship D.column E.row

A.table

A native application is sometimes referred to as​ a(n) __________. Question content area bottom Part 1 A.thick-client application B.cloud service C.grid application D.zero-client application E.enterprise program

A.thick-client application

The software that is used at your​ veterinarian's office to keep track of your​ pet's health​ records, vaccinations, and appointments is a type of​ __________. Question content area bottom Part 1 A.vertical market application B.communication protocol C.operating system D.server software E.horizontal market application

A.vertical market application

Users in motion require all the following cloud resources EXCEPT​ __________. Question content area bottom Part 1 A.wireless connectivity B.data sources C.Web sites D.email service E.application code

A.wireless connectivity

Components of an information system consist of all the​ following, EXCEPT​ __________. Question content area bottom Part 1 A.hardware and software B.organizational environment C.data D.procedures to follow E.people

B. organizational environment

A collection of devices designed to process requests from multiple computers and users is known as a​ __________. Question content area bottom Part 1 A.laptop B.server farm C.tablet D.personal computer E.server

B. server farm

__________ is the nonroutine cognitive skill dealing with the ability to make and manipulate models. Question content area bottom Part 1 A.Ability to experiment B.Abstract reasoning C.Systems thinking D.Ethics E.Collaboration

B.Abstract reasoning

__________ is defined as knowledge derived from data. Question content area bottom Part 1 A.Decision making B.Information C.Judgment D.Insight E.Problem solving

B.Information

We are currently living in the​ __________, an era characterized by the​ production, distribution, and control of information as the primary economic driver. A.Nerd Age B.Information Age C.Tech Age D.Cloud Age E.Computer Age

B.Information Age

​__________ is best defined as the management and use of information systems that help organizations achieve their strategies. Question content area bottom Part 1 A.CIT​ (Computer Information​ Technology) B.MIS​ (Management Information​ Systems) C.IT​ (Information Technology) D.CS​ (Computer Systems) E.IS​ (Information Science)

B.MIS​ (Management Information​ Systems)

Which of the following is NOT a purpose of a database management system​ (DBMS)? Question content area bottom Part 1 A.Establish relationships between tables. B.Port the data to the Internet C.Create tables. D.Enable data to be added and modified. E.Enable the data to be backed up.

B.Port the data to the Internet

A business acquires a new software​ product, installs it on its​ hardware, and converts the data to be processed by the software. The business is unhappy with the performance of the new software product. A common reason for this problem is​ __________. Question content area bottom Part 1 A.the network cannot support the data transmissions B.The people were inadequately trained on how to use the new system C.the hardware is not functional D.the software is full of errors E.the software performs the wrong tasks

B.The people were inadequately trained on how to use the new system

The explosive growth in data expected through 2031 means that​ __________ is even more important. Question content area bottom Part 1 A.data prediction B.business intelligence C.data prioritization D.spyware E.data outsourcing

B.business intelligence

Current 3D printing technology​ __________. Question content area bottom Part 1 A.is basically focused on toy manufacturing B.can print in an array of materials C.is unlikely to affect existing industries significantly D.is unable to create objects with much strength E.is limited to plastic materials

B.can print in an array of materials

The component of a computer that selects​ instructions, processes​ them, performs arithmetic and logical​ comparisons, and stores results of operations in memory is known as the​ __________. Question content area bottom Part 1 A.storage hardware B.central processing unit​ (CPU) C.optical drive D.application software E.main memory

B.central processing unit​ (CPU)

A software vendor pitches a new sales force automation software product to your​ company's VP of Sales and Marketing. Before purchasing such a​ product, it is essential​ to: Question content area bottom Part 1 A.consider what your competition is doing. B.consider all five components of the IS. C.talk to your company programmers. D.carefully select the appropriate operating system for your specific industry. E.have a team of designers and developers create a​ one-of-a-kind custom developed software application.

B.consider all five components of the IS.

In the context of a​ database, __________ is data that describes the content of the database. Question content area bottom Part 1 A.predictive data B.metadata C.meta-elements D.megadata E.key data

B.metadata

When you state a business rule that pertains to your​ organization, such as​ "At my​ university, a student must declare a​ major," you are actually defining the​ __________ of the relationship between students and majors. Question content area bottom Part 1 A.maximum cardinality B.minimum cardinality C.foreign keys D.normality E.relational limits

B.minimum cardinality

The program that controls the computing​ device's resources is termed the​ __________. Question content area bottom Part 1 A.main memory B.operating system C.controller D.application system E.firmware

B.operating system

A financial analyst for a real estate investment firm is responsible for evaluating the financing options for potential property acquisitions. The analyst receives a​ 15-page fact report for each proposed acquisition. Within that​ report, the analyst must search in multiple places for the details of the financing options. For the financial​ analyst's purposes, the report is deficient in​ __________. Question content area bottom Part 1 A.acceptability B.relevancy C.timeliness D.satisfaction E.accuracy

B.relevancy

Which of the following is a proper justification for developing an information​ system? Question content area bottom Part 1 A.The sheer joy of exploring technology B.Avoiding the company​ "falling behind the technology​ curve" C.Helping people in a business to achieve the goals and objectives of that business D.Incorporating the most recently released tablets and smartphones E.Showing that the company has a social networking presence

C. Helping people in a business to achieve the goals and objectives of that business

The components of the​ five-component model that actually do things are​ __________. Question content area bottom Part 1 A.hardware and data B.software and procedures C.hardware and people D.software and data E.hardware and software

C. hardware and people

According to​ __________, the density of storage on magnetic disks is increasing at an exponential rate. Question content area bottom Part 1 A.Metcalfe's Law B.Moore's Law C.Kryder's Law D.Bell's Law E.Nielsen's Law

C. ​Kryder's Law

To complete a​ project, a user needs to have both Windows and Linux operating systems installed on his computer. This can be accomplished through​ __________. Question content area bottom Part 1 A.PC visualization B.server virtualization C.PC virtualization D.service cloning E.desktop virtualization

C.PC virtualization

Web applications are characterized by which of the​ following? Question content area bottom Part 1 A.They are expensive to develop and support. B.They can run only on a single type of device. C.They can be run on multiple operating systems without modifications. D.They are highly secure and easy to use. E.They can use the unique capabilities of the hardware device.

C.They can be run on multiple operating systems without modifications.

The most widely used operating system on personal computers today is​ __________. Question content area bottom Part 1 A.Android B.Symbian C.Windows D.iOS E.Linux

C.Windows

Which of the following is likely to occur in the​ future? Question content area bottom Part 1 A.Students no longer need to cultivate personal creativity and​ problem-solving skills. B.Future jobs will require less technical skills. C.Your car knows exactly when to​ self-start so it is warm when you get in D.Web applications will disappear

C.Your car knows exactly when to​ self-start so it is warm when you get in

To represent alphabetic characters in computer​ memory, you use a storage unit called​ a(n) __________. Question content area bottom Part 1 A.element B.bit C.byte D.factor E.symbol

C.byte

The designers of a database typically begin by developing a​ __________ to construct a logical representation of the database before it is implemented. Question content area bottom Part 1 A.network diagram B.line drawing C.data model D.3D representation E.process model

C.data model

To represent​ relationships, __________ are added to tables. Question content area bottom Part 1 A.value keys B.locking keys C.foreign keys D.entity keys E.normalized keys

C.foreign keys

A​ __________ is a program that is written to use a particular operating system. Question content area bottom Part 1 A.Web application B.smart device C.native application D.client E.Web browser

C.native application

f eHermes chooses to use a SQL DBMS such as​ MySQL, it will be able to​ __________. Question content area bottom Part 1 A.use a​ new, unfamiliar product to create the database B.face some risk and uncertainty while developing the database C.store only the metadata about each customer product image in the database D.gain knowledge and experience with a new form of database E.store the image files in the same database as the metadata

C.store only the metadata about each customer product image in the database

Throughout your​ career, you must​ __________ in a​ system's development to create an information system that meets your needs. Question content area bottom Part 1 A.perform oversight B.fill out a survey C.take an active role D.take a passive role E.take an indirect role

C.take an active role

The advantages of​ self-driving cars include all the following EXCEPT​ __________. Question content area bottom Part 1 A.fuel usage will decrease B.fewer accidents and traffic violations will be incurred C.they will be far more expensive to own and operate over time than current automobiles D.families will only require one vehicle E.insurance rates will decrease

C.they will be far more expensive to own and operate over time than current automobiles

Which of the following is NOT a generally accepted definition of​ information? Question content area bottom Part 1 A.Data presented in a meaningful context B.A difference that makes a difference C.Data processed by​ summing, ordering,​ averaging, grouping,​ comparing, or other similar operations D.Judgment developed from experience E.Knowledge derived from data

D. Judgment developed from experience

Question content area top Part 1 The purpose of a database is to​ __________. Question content area bottom Part 1 A.eliminate the need to learn about spreadsheets B.keep track of things that share a single theme C.make the use of the cloud more straightforwardly D.keep track of things that involve multiple themes E.eliminate the need to learn programming

D. keep track of things that involve multiple themes

The current mismatch between​ employers' demand for technical skills and the technical skills available from employees is called the​ __________. Question content area bottom Part 1 A.employee skill imbalance B.employee/employer skill chasm C.tech skill puzzle D.technology skills gap E.tech job divide

D. technology skills gap

__________ reflects the fact that as more digital devices are connected to a​ network, the network becomes more valuable. Question content area bottom Part 1 A.Moore's Law B.Nielsen's Law C.Bell's Law D.Metcalfe's Law E.Kryder's Law

D. ​Metcalfe's Law

The statement that​ "a new computer class forms roughly each decade establishing a new​ industry" is recognized as​ __________ Law. A.Moore's B.Metcalfe's C.Nielsen's D.Bell's E.Kryder's

D.Bell's

The​ __________ will allow all the devices in your home to be connected and will enable it to see​ what, how, and when you do things and anticipate your needs. Question content area bottom Part 1 A.capacity of 3D printing B.advances in​ self-driving cars C.improvements in​ vertical-market software D.Internet of Things E.relaxation of BYOD policies

D.Internet of Things

Every normalized table has​ __________. Question content area bottom Part 1 A.repeating fields B.duplicated data C.multiple topics D.a single theme E.data integrity problems

D.a single theme

Characteristics of traditional database application programs include all the following EXCEPT​ __________. Question content area bottom Part 1 A.involving a server to house and serve data B.being thick client applications C.being written in programming languages like​ COBOL, C++, and VisualBasic D.being accessed via browsers E.requiring that the application programs be installed on the user computers

D.being accessed via browsers

Due to the rapid evolution in computing​ technology, all the following changes are expected in​ 2031, EXCEPT​ __________. Question content area bottom Part 1 A.homes will no longer have TVs hanging on the walls B.computer technology such as desktops and laptops will have disappeared C.computers will not look like the computers we have today D.computers will support fewer applications and services E.employer's systems will support different employee working styles and locations

D.computers will support fewer applications and services

In data​ modeling, a(n)​ __________ is something that the users want to store data about. Question content area bottom Part 1 A.primary key B.attribute C.relationship D.entity E.foreign key

D.entity

​Potentially, mobile systems can provide​ __________ data to the user. Question content area bottom Part 1 A.someone​ else's B.irrelevant C.inappropriate D.just-in-time E.too much

D.just-in-time.

Open-source software is​ __________. Question content area bottom Part 1 A.tightly controlled and difficult to obtain B.one-of-a-kind software C.not licensed D.licensed through the GNU general public license agreement E.limited only to operating systems software

D.licensed through the GNU general public license agreement

he elements that make up a database application​ are: forms, application​ programs, reports, and​ __________. Question content area bottom Part 1 A.backups B.performance monitors C.relationships D.queries E.data views

D.queries

The three essential elements of the definition of a database are​ __________. Question content area bottom Part 1 A.fields; relationship among fields in​ tables; metadata B.tables; metadata; validation rules C.validation​ rules; data; tables D.tables; relationship among rows in​ tables; metadata E.tables; relationship among rows in​ tables; validation rules

D.tables; relationship among rows in​ tables; metadata

One vital component of your professional behavior regarding computing systems today is the creation of​ __________. Question content area bottom Part 1 A.spyware B.BYOD policies C.cyber sleuths D.data validation procedures E.strong passwords

E. strong passwords

With​ today's focus on Internet​ applications, it is far less necessary that database systems impose​ __________ restrictions on transaction processing. Question content area bottom Part 1 A.EPIC B.ELITE C.ELAC D.AVID E.ACID

E.ACID

Which of the following is NOT one of the nonroutine cognitive skills needed today​ (according to Robert​ Reich)? Question content area bottom Part 1 A.Collaboration B.Ability to experiment C.Abstract reasoning D.Systems thinking E.Ability to speculate

E.Ability to speculate

Which of the following statements about software is​ true? Question content area bottom Part 1 A.Operating systems for clients and servers is identical. B.It is perfectly fine for an organization to buy one copy of a software product and copy it on to all its computers. C.Organizations make a lot of money selling licenses to open source software. D.Buying software means you own the software code. E.Buying software means you own a license to use the software.

E.Buying software means you own a license to use the software.

__________ are​ touchscreen-oriented and provide​ context-sensitive, pop-up menus. Question content area bottom Part 1 A.Open-source applications B.Off-the-shelf applications C.Vertical-market applications D.Horizontal-market applications E.Modern-style applications

E.Modern-style applications

Which of the following is true regarding employee use of mobile systems at​ work? Question content area bottom Part 1 A.Employers are concerned about the loss of employee productivity. B.There is little risk of data loss when employees use their own devices for work. C.Most organizations encourage employees to bring their own devices. D.Organizations expect employee use of mobile systems to increase expenses. E.Most companies have avoided setting official​ mobile-use policies.

E.Most companies have avoided setting official​ mobile-use policies.

If a student can have multiple​ majors, and advisors for each major are assigned to multiple​ students, this would be an example of​ a(n) __________ relationship. Question content area bottom Part 1 A.one-of-a-kind B.1:1 C.0:M D.1:N E.N:M

E.N:M

Smart devices require all the following components EXCEPT​ __________. Question content area bottom Part 1 A.a power source B.wireless network connectivity C.memory D.microprocessors E.a printer

E.a printer

To be considered high​ quality, data must have all the following characteristics EXCEPT​ __________. Question content area bottom Part 1 A.accuracy B.relevancy C.timeliness D.worth its cost E.competitiveness

E.competitiveness

An organization has identified a new business process that will revolutionize its industry. To obtain the software that will be needed to support this business​ process, it will be necessary for the organization to​ __________. Question content area bottom Part 1 A.buy a horizontal application off the shelf B.abandon the idea since no software exists C.buy a​ one-of-a-kind application off the shelf D.buy a horizontal application off the shelf and customize it E.develop a​ one-of-a-kind application using custom development

E.develop a​ one-of-a-kind application using custom development

Storage based on magnetic disks and optical disks is considered​ __________. Question content area bottom Part 1 A.software B.optical storage C.volatile memory D.processing speed E.nonvolatile memory

E.nonvolatile memory

After an​ analysis, you are told that it will cost​ $100,000 to modify an information system so that it captures several new facts about your customers. Knowing those additional facts will help you to increase sales by an estimated​ $500 per year. You conclude that the information provided by this data is​ __________. Question content area bottom Part 1 A.not timely. B.irrelevant. C.inaccurate. D.more than sufficient. E.not worth its cost.

E.not worth its cost.