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.
