MIS assignments

profileyugigogo09
_qouiz_.pdf

Final Exam (20%)

Started: Dec 12 at 6pm

Quiz Instructions

Respond to each item with the best answer.

1 pts Question 1

Hourly

Daily

Weekly

As often as needed to alleviate unacceptable risk

How often should a business back up its data?

1 pts Question 2

Infrastructure Plan

Fault Tolerance Plan

Disaster Recovery Plan

Business Continuity Plan

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

1 pts Question 3

Infrastructure Plan

Disaster Recovery Plan

Business Continuity Plan

Fault Tolerance Plan

Which of the following details how a company recovers and restores critical business operations and systems after a

disaster or extended disruption?

1 pts Question 4

Probability

Usability

Accessibility

Portability

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

1 pts Question 5

Increased Dependence on an Internet Connection

Decreased Maintenance Issues

Increased Software Updates

Increased Storage Capacity

Which of the following is NOT a benefit of Cloud Computing?

1 pts Question 6

Governance

Software

Quality

Timeliness

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

1 pts Question 7

a DBMS

a database

metadata

SQL

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

1 pts Question 8

a DBMS

metadata

a database

SQL

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

1 pts Question 9

Increased redundancy

Increased flexibility

Increased scalability

Increased security

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

1 pts Question 10

Data mining

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

Normalization

ETL

Standardization

1 pts Question 11

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

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

1 pts Question 12

An Entity-Relationship Diagram

An impossible dream

A data-oriented design scheme

A data warehouse

A collection of information gathered from many different operational databases, that supports business analysis and decision

making is

1 pts Question 13

Extraction, Transformation, and Loading (ETL)

Normalization

Business Analytics

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:

Data Mining (DM)

1 pts Question 14

DBMS

Data mining

ETL

Normalization

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

1 pts Question 15

Moore's Law

Data rich, Information poor

The missionary-cannibal problem

Communication with people of lower intelligence

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

1 pts Question 16

Protocols

Convergence

Access Technologies

Providers

One of the five networking elements creating a connected world is ______________________, which are standards

specifying data formats and rules to be followed during transmission

1 pts Question 17

Reduced travel

Sharing resources

Enhanced security

Providing opportunities

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

1 pts Question 18

Electronic doldrums

Digital divide

Technology gap

Computer malaise

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

1 pts Question 19

Security, Access, Integrity, and Ethics

PANs, WLANs, WMANs, and WWANs

Routers, Hubs, Switches, and Firewalls

Batman, Spiderman, Iron man, and Dr. Johnson

Wireless communication categories include:

1 pts 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)

1 pts Question 21

Privacy

Enhanced mobility

Provides immediate data access

Improves workflow

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

1 pts Question 22

providing mobile business opportunities

providing alternatives to wiring

increasing location and monitoring capability

addressing privacy concerns

Challenges of Using wireless networks include: protecting against theft, protecting wireless connections, preventing viruses

on mobile devices, and

1 pts Question 23

Integrations

networks

Connections which allow communication among different systems and databases, and eliminate the need for manual data

entry in to multiple systems are called:

functionality

Enterprise systems

1 pts Question 24

Database management systems

Supply Chain Management (SCM)

Porter's value chain model

All international businesses

Maximizing total supply chain effectiveness is one goal of

1 pts Question 25

Profits

Database update anomalies

System security breaches

The bullwhip effect

Good supply chain management can help eliminate

1 pts Question 26

No answer text provided.

No answer text provided.

False

True

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

1 pts Question 27

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

CRM is beneficial to companies because

1 pts Question 28

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

CRM is important to companies because

1 pts Question 29

No answer text provided.

False

True

No answer text provided.

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

1 pts 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

1 pts Question 31

Management Information Systems

More Interstellar Sightings

Minor Irritation Syndrome

My, Isn't it Special!

MIS stands for:

1 pts Question 32

SUMIF()

Vlookup()

ConditionalAdd ()

SORT()

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

1 pts Question 33

No answer text provided.

No answer text provided.

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

False

True

1 pts Question 34

No answer text provided.

False

No answer text provided.

True

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

1 pts Question 35

a web query

a two-variable data table

a pivot table

the scenario manager

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%).

This is the perfect setup for

1 pts Question 36

Solver

a sharp pencil with a BIG eraser

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:

A compound/nested IF function

Goal seek

1 pts Question 37

LAN, WAN, MAN

LAN, WAN, SAN

LAN, WAN, XAN

LAN, SAN, XAN

Which of the following includes the three primary network types?

1 pts Question 38

. Local area network (LAN)

Metropolitan area network (MAN)

Wide area network (WAN)

Secure area network (SAN)

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

1 pts Question 39

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)

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 _____________________.

1 pts Question 40

Bandwidth

Protocol

Frequency

Access

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

time?

1 pts Question 41

Bit rate

Broadband

Protocol

Connection time

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

1 pts Question 42

None of these

Broadband

Dial up

Analog

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

1 pts 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)

1 pts Question 44

Multiple services offered from a single vendor

All of these

Multiple devices supported by one provider

The weaving together of voice, data, and video

What is a benefit of network convergence?

1 pts Question 45

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

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

1 pts Question 46

determine whether a particular node on a network is active

"wake up" the nodes on a network

disable the target computer

The purpose of the Ping command is to:

annoy network managers

1 pts Question 47

<head>

<h6>

<h1>

<largest heading>

Which of the following properly creates the largest heading?

1 pts Question 48

Face.jpg = <img />

<picture source="face.jpg" />

<img src="face.jpg" />

<img> face.jpg </img>

Which of the following properly inserts a picture?

1 pts Question 49

Hyperactive Text Making Language

Hypertrophyic Muscles and Ligaments

Hypertext Markup Language

High Tech Messaging Language

HTML stands for:

1 pts Question 50

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

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

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

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

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

1 pts Question 51

The list items are in the wrong order

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

Nothing

There are no ending tags

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

<ol> <li>second

<li> first

<li> third

1 pts Question 52

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

Why would a developer use this tag: <p id="forfun">

instead of this tag: <p /> ?

1 pts Question 53

<end-of-table>

<tr>

</table>

<table>

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

1 pts Question 54

it will depend on the browser

#660000 is lighter and #ff0000 is darker

#660000 is darker and #ff0000 is lighter

There is no difference

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

#ff0000

#660000

1 pts Question 55

{background-color: #fe23ab}

background {color: fe23ab}

{background-color: #fe23ab

backgound color: hot pink

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

1 pts Question 56

padding

margin

spacing

border

Which of the following is not part of the CSS box model?

1 pts Question 57

font-size; 50

{font-size: 50}

{font-size: quite large}

{font-size: 50%}

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

1 pts Question 58

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

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

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

1 pts 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

1 pts Question 60

Webpage Appearance Change (in German)

Creative Style Sheets

Computer Style Sheets

Cascading Style Sheets

What do the letters CSS stand for?

1 pts Question 61

<style> styler.css </style>

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

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

<css> styler.css </css>

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

1 pts Question 62

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

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

What is the effect of the following CSS specification?

table {width: 50%}

There will be no effect because the specification contains an error

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

1 pts Question 63

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.

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

1 pts Question 64

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.

How is XML different from HTML?

1 pts Question 65

high

low

an error message

medium

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"))

1 pts Question 66

high

an error message

low

medium

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"))

1 pts Question 67

RICHARD

richard

Richard

rICHARD

What is the result of the following function, assuming cell C1 has the value: Richard

=proper(C1)

1 pts Question 68

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

No answer text provided.

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

No answer text provided.

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

1 pts Question 69

UML - universal markup language

none of these

XML - extensible markup language

HTML - hypertext markup language

Which markup language is used in the following code?

<Airport>

<City> Salt Lake City </city>

<code> SLC </code>

</airport>

1 pts Question 70

#########

Go#Froggy

Go Froggy

An error message

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

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

1 pts Question 71

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

In Excel, what is a "delimiter"?

Quiz saved at 4:41am

1 pts Question 72

Business Administration

Marketing

Accounting

MIS

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

Submit Quiz