Reference no: EM131316396

Question 1: How often should a business back up its data?

Hourly

Daily

Weekly

As often as needed to alleviate unacceptable risk

Question 2: Which of the following is a detailed process for recovering information or a system in the event of a catastrophic disaster?

Infrastructure Plan

Fault Tolerance Plan

Disaster Recovery Plan

Business Continuity Plan

Question 3: Which of the following details how a company recovers and restores critical business operations and systems after a disaster or extended disruption?

Infrastructure Plan

Disaster Recovery Plan

Business Continuity Plan

Fault Tolerance Plan

Question 4: Which of the following is NOT one of the characteristics of an Agile MIS Infrastructure?

Probability

Usability

Accessibility

Portability

Question 5: Which of the following is NOT a benefit of Cloud Computing?

Increased Dependence on an Internet Connection

Decreased Maintenance Issues

Increased Software Updates

Increased Storage Capacity

Question 6: Which of the following is NOT a trait that contributes to the value of information?

Governance

Software

Quality

Timeliness

Question 7: A collection of related information that is organized for easy storage, manipulation, and retrieval is

a DBMS

a database

metadata

SQL

Question 8: The software that allows creating, reading, updating, and deleting data in a database while controlling access and security is

a DBMS

metadata

a database

SQL

Question 9: Which of the following is NOT an advantage of relational databases over spreadsheets or text documents?

Increased redundancy

Increased flexibility

Increased scalability

Increased security

Question 10: When designing a database, what process helps to ensure the database won't include built-in anomalies?

Data mining

Normalization

ETL

Standardization

Question 11: Which of the following is an advantage of data-driven websites?

Web browsers are easier to use than database querying tools

Web pages can store more data than databases

Web pages ensure referential integrity

Customers usually know how to write their own SQL queries

Question 12: A collection of information gathered from many different operational databases, that supports business analysis and decision making is

An Entity-Relationship Diagram

An impossible dream

A data-oriented design scheme

A data warehouse

Question 13: The process that gets information from databases, makes it conform to a set of common definitions, and puts it into a data warehouse is called:

Extraction, Transformation, and Loading (ETL)

Normalization

Business Analytics

Data Mining (DM)

Question 14: The process which led to one grocery store's discover of a pattern of customers buying diapers and beer is called

DBMS

Data mining

ETL

Normalization

Question 15: Using Business Intelligence to support Decision Making helps to overcome which problem?

Moore's Law

Data rich, Information poor

The missionary-cannibal problem

Communication with people of lower intelligence

Question 16: One of the five networking elements creating a connected world is ______________________, which are standards specifying data formats and rules to be followed during transmission.

Protocols

Convergence

Access Technologies

Providers

Question 17: Which of the following is NOT one of the benefits of a connected world?

Reduced travel

Sharing resources

Enhanced security

Providing opportunities

Question 18: The gap between those who have access to technology and those who do not is called the

Electronic doldrums

Digital divide

Technology gap

Computer malaise

Question 19: Wireless communication categories include:

Security, Access, Integrity, and Ethics

PANs, WLANs, WMANs, and WWANs

Routers, Hubs, Switches, and Firewalls

Batman, Spiderman, Iron man, and Dr. Johnson

Question 20: A mobile application that can tell you where the nearest (to you, no matter where you are) gas station is, would be in which

category of wireless network applications?

Location-Based Services (LBS)

Geographic Information Systems (GIS)

Radio-Frequency Identification (RFID)

Global Positioning System (GPS)

Question 21: Which of the following is NOT an advantage provided by wireless networks?

Privacy

Enhanced mobility

Provides immediate data access

Improves workflow

Question 22: Challenges of Using wireless networks include: protecting against theft, protecting wireless connections, preventing viruses on mobile devices, and:

providing mobile business opportunities

providing alternatives to wiring

increasing location and monitoring capability

addressing privacy concerns

Question 23: Connections which allow communication among different systems and databases, and eliminate the need for manual data entry in to multiple systems are called:

Integrations

networks

functionality

Enterprise systems

Question 24: Maximizing total supply chain effectiveness is one goal of

Database management systems

Supply Chain Management (SCM)

Porter's value chain model

All international businesses

Question 25: Good supply chain management can help eliminate

Profits

Database update anomalies

System security breaches

The bullwhip effect

Question 26: Customer Relationship Management has nothing to do with supporting sales department operations.

No answer text provided.

No answer text provided.

False

True

Question 27: CRM is beneficial to companies because:

it brings customers into conformance with company standards

it isoates employees from personal contact with customers

it keeps annoying customers away

it helps companies treat customers well

Question 28: CRM is important to companies because:

customers are always loyal

it is easier than ever for customers to take their business elsewhere

customers never tell others about their business experiences

customers spend their money in as many places as possible

Question 29: ERP Systems integrate all departments and functions into a single IT system (or integrated set of IT systems).

No answer text provided.

False

True

No answer text provided.

Question 30: Which of the following has NOT been (historically and/or the present) a core component of ERP systems?

production and materials management

entrepreneurship

human resources

accounting and finance

Question 31: MIS stands for:

Management Information Systems

More Interstellar Sightings

Minor Irritation Syndrome

My, Isn't it Special!

Question 32: Column A of a spreadsheet contains the names sales representatives. Column B contains the sales amounts for sales completed by each representative. Every time another sale is completed a new row is added to the list. Now you want to calculate the total amount for all sales made by Kristin. A good function to accomplish this easily would be

SUMIF()

Vlookup()

ConditionalAdd ()

SORT()

Question 33: A 3-D formula applies a formula to the same cell in several worksheets at once.

No answer text provided.

No answer text provided.

False

True

Question 34: The only way to get data from a web page into a spreadsheet is to manually re-enter the data.

No answer text provided.

False

No answer text provided.

True

Question 35: Todd has entered a function in his worksheet to calculate the payment amount for a loan. He is thinking of borrowing between 10,000 and 15,000 dollars, at an interest rate between 5% and 7%. He would like to know what the payment would be for each combination of principal (10, 11, 12, 13, 14, and 15 thousand) and interest rate (5%, 5.5%, 6%, 6.5%, and 7%).

a web query

a two-variable data table

a pivot table

the scenario manager

Question 36: After creating a pro forma income statement, Julie realizes that if her assumptions are correct, her business will lose money next year. She tests different assumptions using the scenario manager, but now wants to know how much sales income would be necessary to attain a Net Income of exactly zero (break even). Julie should use:

Solver

a sharp pencil with a BIG eraser

A compound/nested IF function

Goal seek

Question 37: Which of the following includes the three primary network types?

LAN, WAN, MAN

LAN, WAN, SAN

LAN, WAN, XAN

LAN, SAN, XAN

Question 38: What is a large computer network usually spanning a city or a specific infrastructure like a college known as?

Local area network (LAN)

Metropolitan area network (MAN)

Wide area network (WAN)

Secure area network (SAN)

Question 39: The Internet is a hierarchical structure linking different levels of service providers whose millions of devices supply all the interconnections. The three levels outlined in the book from the top down include _____________________.

National service provider (NSP), Regional service provider (RSP), and Internet service provider (ISP)

None of these

Net server point (NSP), Radio server point (RSP), and Internet server point (ISP)

New system provider (NSP), Current system provider (CSP), and Order entry system provider (OSP)

Question 40: What measures network performance by the maximum amount of data that can pass from one point to another in a unit of time?

Bandwidth

Protocol

Frequency

Access

Question 41: What measures bandwidth in terms of numbers transferred or received per unit of time?

Bit rate

Broadband

Protocol

Connection time

Question 42: What is a high-speed Internet connection that is always connected and has a bandwidth greater than 2 Mbps?

None of these

Broadband

Dial up

Analog

Question 43: What is the standard Internet protocol, which provides the technical foundation for the public Internet?

Data streaming and DSL protocols

Data streaming rules and regulations

Internet protocol/Transmission control protocol (IP/TCP)

Transmission control protocol/Internet protocol (TCP/IP)

Question 44: What is a benefit of network convergence?

Multiple services offered from a single vendor

All of these

Multiple devices supported by one provider

The weaving together of voice, data, and video

Question 45: Tracert is a command in the Internet Control Message Protocol (ICMP) that does what?

Encrypts a data transmission between two IP addresses

Identifies all T1 lines between two IP addresses

There is no such command

Returns a list of all nodes traversed between two IP addresses

Question 46: The purpose of the Ping command is to:

determine whether a particular node on a network is active

"wake up" the nodes on a network

disable the target computer

annoy network managers

Question 47: Which of the following properly creates the largest heading?

<head>

<h6>

<h1>

<largest heading>

Question 48: Which of the following properly inserts a picture?

Face.jpg = <img />

<picture source="face.jpg" />

<img src="face.jpg" />

<img> face.jpg </img>

Question 49: HTML stands for:

Hyperactive Text Making Language

Hypertrophyic Muscles and Ligaments

Hypertext Markup Language

High Tech Messaging Language

Question 50: Which of the following correctly creates a "click here" hyperlink to Utah State University's website?

<a href="https://www.usu.edu"> click here </a>

<link src="www.usu.edu"> click here <'link>

<a href="https://www.usu.edu" id="click here" />

click here "https://www.usu.edu"

Question 51: What is wrong with the following section of HTML code?:

<ol> <li>second

<li> first

<li> third

The list items are in the wrong order

The first tag should be <ul> instead of <ol>

Nothing

There are no ending tags

Question 52: Why would a developer use this tag: <p id="forfun">instead of this tag: <p /> ?

 

The ID allows the developer to assign specific styles to that one paragraph only

There is no difference and therefore no reason to use one over the other

"forfun" is a special HTML command that creates fun

The second one is incorrect and will crash the browser

Question 53: Which of the following tags is not part of a correctly made table in HTML?

<end-of-table>

<tr>

</table>

<table>

Question 54: Both of the following numeric codes for colors produce red. What is the difference between them?

#ff0000

#660000

it will depend on the browser

#660000 is lighter and #ff0000 is darker

#660000 is darker and #ff0000 is lighter

There is no difference

Question 55: In CSS, the background color for a page element (such as table or body) is specified properly by which of the following?

{background-color: #fe23ab}

background {color: fe23ab}

{background-color: #fe23ab

backgound color: hot pink

Question 56: Which of the following is not part of the CSS box model?

padding

margin

spacing

border

Question 57: A developer would like to style some text to be quite large. Which style specification would accomplish this?

font-size; 50

{font-size: 50}

{font-size: quite large}

{font-size: 50%}

Question 58: Which item in an HTML page will be styled by the following?

#special {background-color: bisque; color: red; transform: rotate(60deg)}

Anything with ID="special" in its opening tag

I don't know but it will look really cool!

Anything in the file called "special.htm"

only paragraphs after the <special> tag and before the </special> tag

Question 59: What is wrong with the following style specification?

h1,h3,h6 {text-align: center}

Nothing is wrong. It should work fine.

It should say "middle" instead of "center"

There should be a semi-colon before the last curly bracket

You can't list tag names with commas like that

Question 60: What do the letters CSS stand for?

Webpage Appearance Change (in German)

Creative Style Sheets

Computer Style Sheets

Cascading Style Sheets

Question 61: Which of the following correctly links an HTML page to an external stylesheet?

<style> styler.css </style>

<link rel="stylesheet" type="text/css" href="styler.css" />

<style src="https://styler.css" />

<css> styler.css </css>

Question 62: What is the effect of the following CSS specification?

table {width: 50%}

All tables will shrink to 50% of their original size.

All tables will be 50% as wide as the page.

There will be no effect because the specification contains an error

Only the first table will be moved 50% away from the left margin

Question 63: A developer wants to style the word "big" differently than the rest of this sentence. How should the HTML be coded?

A developer wants to style the word <style: different>"big"</style> differently than the rest of this sentence.

A developer wants to style the word "<span ID="special">big</span>" differently than the rest of this sentence.

A developer wants to style the word "<font-change>big</font>" differently than the rest of this sentence.

No change in the HTML; the change is in the CSS file.

Question 64: How is XML different from HTML?

XML allows the user to define tags. In HTML tags are pre-defined.

HTML is very common but XML is rarely used

XML is only for spreadsheet applications. HTML is for the Internet

XML is the future. It will eventually replace HTML.

Question 65: What is the result of the following Excel function, assuming cell C1 has the value 100.

=if(c1>250,"high", if(c1>100, "medium", "low"))

high

low

an error message

medium

Question 66: What is the result of the following Excel function, assuming cell C1 has the value 100.

=if(c1<=100,"low", if(c1<=250, "medium", "high"))

high

an error message

low

medium

Question 67: What is the result of the following function, assuming cell C1 has the value: Richard = proper(C1)

RICHARD

richard

Richard

rICHARD

Question 68: Which of the following would result in a higher monthly payment amount?

=PMT(5%,5,50000,0,0)

No answer text provided.

=PMT(5%,5,50000,0,1)

No answer text provided.

Question 69: Which markup language is used in the following code?

<Airport>

<City> Salt Lake City </city>

<code> SLC </code>

</airport>

UML - universal markup language

none of these

XML - extensible markup language

HTML - hypertext markup language

Question 70: What is the result of the following Excel function, assuming cell c1 has the value: Go#Froggy

=substitute(C1,"#"," ")

#########

Go#Froggy

Go Froggy

An error message

Question 71: In Excel, what is a "delimiter"?

none of these

An indicator of the maximum number of rows or columns

A special character (such as a tab or space) that separates data

Data that has been "embedded" from an external file

Question 72: Which major in the Huntsman School consistently has the highest placement rate and the highest starting salaries?

Business Administration

Marketing

Accounting

MIS