MIS Ch 4, 5, 6 Review
Which of the following is an operating system designed for mobile devices? - UNIX - Safari - Google - Android - OS X
Android
Which of the following is a type of optical disk storage? - CD-ROM - Hard Drive - Magnetic Tape - USB flash drive - SSD
CD-ROM
Microsoft SQL Server is a(n) A) DBMS for small handheld computing devices. B) Internet DBMS. C) desktop relational DBMS. D) DBMS for midrange computers.
DBMS for midrange computers
The utilitarian principle asks you to put yourself in the place of others, and think of yourself as the object of the decisions. T/F
False
_____ describes the practices and technologies used to minimize the environmental effects of manufacturing and managing computing devices.
Green computing
DBMS for midrange computers include all of the following EXCEPT A) DB2. B) Oracle. C) Microsoft SQL Server. D) Microsoft Access.
Microsoft access
The tool that enables users to view the same data in different ways using multiple dimensions is -predictive analysis -SQL -OLAP -data mining
OLAP
Which of the following is a high-speed network dedicated to storage that connects different kinds of storage devices, such as tape libraries and disk arrays so they can be shared by multiple servers? LAN ASP Grid SAN SSN
SAN
The most prominent data manipulation language today is: - Access - DB2 - SQL - Crystal Reports
SQL
Which of the following best describes how new information systems can result in legal gray areas? -They are created from sets of logical and technological rules rather than social or organizational mores. -They result in new situations that are not covered by old laws. -They work with networked, digital data, which are more difficult to control than information stored manually. -They are so complex that they cannot be covered by existing laws.
They result in new situations that are not covered by old laws.
A firm's IT infrastructure provides the foundation for supporting all the information systems in the business. T/F
True
Data administration is a special organizational function that manages the policies and procedures through which data can be managed as an organizational resource. T/F
True
Ethics refers to the principles of right and wrong that can be used by individuals to make choices to guide their behavior. T/F
True
HTML specifies how text, graphics, and other contents are placed on a Web page. T/F
True
Web browsers are the primary interface for accessing the World Wide Web through the internet. T/F
True
The FIP principle of Notice/Awareness states that: -consumers should be able to review the data collected about them. -customers must be allowed to choose how their information will be used for secondary purposes other than the supporting transaction. -there must be a mechanism in place to enforce the FIP principles. -data collectors must take responsible steps to assure that consumer information is accurate and secure from unauthorized use. -Websites must disclose their information practices before collecting data.
Websites must disclose their information practices before collecting data.
NORA is: a) an ethical principle b) a sentencing guideline adopted in 1987 mandating stiff sentences on business executives. c) a profiling technology used by the EU. d) a federal privacy law protecting networked data. e) a data analysis technology that finds hidden connections between data in disparate sources.
a data analysis technology that finds hidden connections between data in disparate sources.
Software used to apply the computer to a specific task for an end user is called:
application software
A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because: - a data mart typically focuses on a single subject area or line of business. -all the information is historical. -a data mart uses a Web interface. -all of the information belongs to a single company.
a data mart typically focuses on a single subject area or line of business
ZipRealty, which combines Google Maps with real estate data, is an example of: - cloud computing - SAN - a mashup - a widget - a web service
a mashup
The introduction of new information technology has:
a ripple effect, raising new ethical, social, and political issues.
The feature of social institutions that means mechanisms are in place to determine responsibility for an action is called: -the courts of appeal -the judicial system -accountability -responsibility -due process
accountability
Linux is: - the operating system for android smart phones - the operating system for the Macintosh computer. - an example of open-source software - an example of application software -designed for specific machines and specific microprocessors
an example of open-source software
Which of the following is NOT one of the five steps in the process for analyzing an ethical issue? - identify the options you can reasonably take -assign responsibility -identify the stakeholders -identify and clearly describe the facts - identify the potential consequences of your options
assign responsibility
A characteristic or quality describing an entity is called a(n): - table - tuple - key field - relationship - attribute
attribute
In a relational database, the SELECT operation: a) creates a subset consisting of all records in the file that meet stated criteria. b) identifies the table from which the columns will be selected. c) specifies the content of the database. d) combines relational tables to provide the user with more information than is otherwise available.
creates a subset consisting of all records in the file that meet stated criteria
An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the
data dictionary
Which common database challenge is illustrated by a person receiving multiple copies of an L.L. Bean catalog, each addressed to a slightly different variation of his or her full name? A) data normalization B) data accuracy C) data redundancy D) data inconsistency
data inconsistency
Software that organizes, manages, and processes business data, such as data concerned with inventory, customers, and vendors, is called: - network software - system software - web services software - application software - data management software
data management software
The special organizational function whose responsibilities include the technical and operational aspects of managing data, including physical database design and maintenance, is called ________.
database administration
The practice in law-governed societies in which laws are known and understood, and there is an ability to appeal to higher authorities to ensure that the laws are applied correctly is called: - The courts of appeal - responsibility - liability - accountability - due process
due process
A schematic of the entire database that describes the relationships in a database is called a(n):
entity-relationship diagram.
Today, most system and application software is custom built by in-house programmers. -T/F
false
Data mining is a tool for allowing users to - quickly compare transaction data gathered over many years. - find hidden relationships in data. - obtain online answers to ad hoc questions in a rapid amount of time. - summarize massive amounts of data into much smaller, traditional reports.
find hidden relationships in data
Connecting geographically remote computers in a single network to create a "virtual supercomputer" is called:
grid computing
A data warehouse is composed of: - historical data from legacy systems - current data - internal and external data sources - historic and current internal data
historic and current internal data
In a _____ computing model, companies use their own infrastructure for essential computing tasks and adopt public cloud computing for less critical operations.
hybrid cloud
Immanuel Kant's categorical imperative states that:
if an action is not right for everyone to take, it is not right for anyone to take.
The ethical "no free lunch" rule states that: a) if an action is not right for everyone to take, it is not right for anyone to take b) if an action cannot be taken repeatedly, then it is not right to be taken at any time. c) one should take the action that produces the least harm or incurs the least cost. d) if something someone else has created is useful to you, it has value, and you should assume the creator wants compensation for this work.
if something someone else has created is useful to you, it has value, and you should assume the creator wants compensation for this work.
All of the following are current key technology trends raising ethical issues EXCEPT: - advances in networking technology - data storage improvements - increase in data quality - data analysis advancements - increase in use of mobile devices
increase in data quality
A table that links two tables that have a many-to-many relationship is often called a(n):
intersection relation
Which of the following storage technology stores data sequentially? - USB flash drive - Magnetic tape - RAID -CD-ROM - Magnetic disks
magnetic tape
A DMBS reduces data redundancy and inconsistency by -enforcing referential integrity -uncoupling program and data -utilizing a data dictionary - minimizing isolated files with repeated data
minimizing isolated files with repeated data
The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:
normalization
The type of database management approach that can handle multimedia is the
object oriented DBMS
When a cookie is created during a website visit, it is stored: - on the hard drive of the visitor's computer - in the cloud. - on the ISP's computer - in a web directory - on the website computer
on the hard drive of the visitor's computer
A DBMS makes the: a) logical database available for different physical views. b) relational database available for different physical views. c) physical database available for different logical views. d) physical database available for different relational views.
physical database available for different logical views.
The logical view of a database: - presents data as they would be perceived by end users. -presents an entry screen to the user. -allows the creation of supplementary reports. -shows the relationship between the entities and attributes -shows how data are organized and structured on the storage media.
presents data as they would be perceived by end users.
A field identified in a table as holding the unique identifier of the table's records is called the: a) attribute field b) primary key c) identifying record
primary key
The use of computers to combine data from multiple sources and create digital dossiers of detailed information on individuals is called: - phishing - profiling - spamming - spyware - targeting
profiling
Relational database systems use ____ to ensure that relationships between coupled tables remain constant. -foreign keys -one-to-one ordering -intersection relations -entity-relationship diagrams -referential integrity rules
referential integrity rules
Accepting the potential costs, duties, and obligations for the decisions you make is referred to as: - accountability - ethics - responsibility - liability - due process
responsibility
In a table for customers, the information about a single customer would reside in a single:
row
_______ refers to the ability of a computer, product, or system to expand to serve a larger number users without breaking down.
scalability
In a relational database, the three basic operations used to develop useful sets of data are:
select, project, and join
According to the ____ rules, if an action cannot be taken repeatedly, it is not right to take at all. - categorical imperative - Golden Rule - slippery-slope - risk aversion - utilitarian principle
slippery-slope
Which of the following types of computer is used for weather forecasting on a national or worldwide scale? -Mainframe -PC -minicomputer -server -supercomputer
supercomputer
Software that manages the resources of the computer is called: - application software - network software -data management software -system software -web services software
system software
Which of the following statements about client/server computing is NOT true? - The client is normally a desktop or laptop computer - The bulk of processing occurs on the client. - The client provides the user interface - The server provides security, remote access, and user authentication. - Computing on the internet is based on the client/server model
the bulk of processing occurs on the client
Which of the following best illustrates the relationship between entities and attributes in a database? -the entity CUSTOMER with the attribute PRODUCT -the entity PRODUCT with the attribute PURCHASE -the entity PRODUCT with the attribute CUSTOMER -the entity CUSTOMER with the attribute ADDRESS -the entity ADDRESS with the attribute CUSTOMER
the entity CUSTOMER with the attribute ADDRESS
In a multi-tiered client/server architecture:
the work of the entire network is balanced over several levels of servers.
A computer language translation program is an example of system software. T/F
true
In a relational database, a record is also called a(n): - key field -tuple -entity -table -field
tuple
OLAP is a tool for enabling 1) Users to obtain online answers to ad-hoc questions in a rapid amount of time. 2) Users to view both logical and physical views of data 3) programmers to quickly diagram data relationships. 4) programmers to normalize data
users to obtain online answers to ad-hoc questions in rapid amount of time
What would be a reason for using a workstation rather than a personal computer? - When you need to share resources - When you need to access a network - When you need more powerful computational abilities - When you need to connect to a cloud computing platform - When you need to serve applications and data to client computers
when you need more powerful computational abilities
