ITIS 2P91 MIDTERM QUESTION

CHAPTER 1&2
Which is a set of long range goals that describe the IT infrastructure and identify the major IT
initiatives needed to achieve the goals of the organization?

  A. IT architecture

  B. Feasibility study

  C. IT strategic plan

  D. systems analysis

Which term describes the science of designing machines and work settings to minimize injury
and illness?

  A. robotics

  B. ergonomics

  C. business intelligence

  D. functional area information systems

Which is a computer program designed to support a specific task or business process?

  A. dashboard

  B. expert system

  C. information system

  D. application

Which is data that have been organized so that they have meaning and value to an
organization?

  A. database

  B. information

  C. knowledge

  D. information system

Accountants engineers and lawyers are all examples of knowledge workers.

A. True
B. False
In contemporary organizations, managing the IS function within an organization is the exclusive
responsibility of the IS department.
A. True
B. False

A university registrar who uses her experience with university admissions in reviewing the
applicant grades, application essays, and letters of recommendation, would be applying her
knowledge in your application process.
A. True
B. False

Information technology is facilitating the entry of a wide variety of employees into the
workforce.
A. True
B. False

The digital divide is the gap between data and knowledge.

A. True
B. False

Today's customers have which of the following characteristics?

  A. less knowledge about products

  B. less sophistication

  C. difficulty finding information about products

  D. higher expectations

For many organizations, which is true about business process reengineering?

  A. It is easy to implement.

  B. It has a major impact on the corporate culture.

  C. It has little impact on facilities.

  D. It is inexpensive.

Which is a strategy of producing a large quantity of items, but customizing them to fit the desire
of each customer?

  A. Customer focus

  B. Make-to-order

  C. Mass customization
   D. Personalization

Walmart’s automatic inventory replenishment system, which enables the company to reduce
inventory storage requirements, is an example of which strategy for competitive advantage? c)
Innovation

  A. Cost leadership

  B. Differentiation

  C. Operational effectiveness

  D. Customer-orientation

Which strategy for competitive advantage involves improving the manner in which an
organization executes its internal business processes?

  A. Cost leadership

  B. Differentiation

  C. Innovation

  D. Operational effectiveness

  E. Customer-orientation

CHAPTER 5
1. From simplest to most complex, which is the proper order?

A. Data, information, knowledge

B. Knowledge, data, information

C. Information, data, knowledge

2. What is another name for a data dictionary?

 A. data mart

B. data warehouse

C. metadata repository

D. entity-relationship diagram
3. What does a query do?

 A. organize and sort the data in a database

 B. allocate storage space for a database

 C. eliminate data duplication

 D. retrieve information from a database

4. Which is the data that is deemed most important in the operation of a business?

 A. Metadata

B. Master data

 C. Reference data

 D. Tactical data

5. Which is a process designed to ensure that data within the tables in a relational
database contains the least amount of duplication?

A. Validation

 B. Verification

 C. Normalization

 D. Modeling

6. When data are normalized, attributes in the table depend only on which?

  A. secondary key

  B. common attribute

  C. common row

  D. primary key

7. Which is the process of moving data from various sources into a data warehouse?

  A. Extract, transform, load (ETL)

  B. Online transaction processing (OLTP)

  C. Online analytical processing (OLAP)

  D. Master data management (MDM)

8. Which describes the data in a data warehouse?

  A. Are updated constantly in real time

  B. Can only be accessed at executive level

  C. Are purged constantly as new data enters the system

  D. Are added to on a regular basis, usually in batch mode

9. Which is an example of tacit knowledge?

  A. A set of instructions for applicants to apply for a position in your organization

  B. Understanding of a client’s needs for your products

  C. A monthly sales report

10. Which refers to the process of quickly conducting complex, multidimensional analyses
of data stored in a database that is optimized for retrieval, typically using graphical
software tools?

A. Inferencing

 B. Online analytical processing

 C. Normalization

 D. Data mining

11. Which is a logical grouping of related fields?

  A. Byte

  B. Database

  C. File

  D. Record

12. As an individual student in your university's student database, you are a(n) ____________
of the STUDENT class.

  A. Representative
   B. Instance

  C. Individual

  D. Entity

13. At your univeristy, students can take more than one class, and each class has more than
one student. This is an example of which kind of relationship?

 A. One-to-one

 B. One-to-Many

 C. Some-to-Many

 D. Many-to-Many

CHAPTER 6

Which refers to the transmission capacity of a network?

  A. Bandwidth

  B. Bandlength

  C. Broadbase

  D. Narrowbase

With this type of transmission, every call opens up a dedicated circuit for the duration of the
call.

  A. Voice over IP

  B. Plain old telephone service (POTS)

  C. Chat rooms

  D. Teleconference

With this type of transmission, phone calls are treated as just another kind of data.

  A. Voice over IP

  B. Plain old telephone service

  C. Chat rooms

  D. Teleconference
Which is the technique of breaking a message into packets, sending the packets along the best
route available, and then reassembling the data?

  A. packet switching

  B. packet caching

  C. packet trading

  D. packet building

Which is the cable medium with the highest bandwidth?

  A. twisted pair

  B. coaxial

  C. fibre optic

  D. cellular

Which converts analog signals into digital signals and vice versa?

  A. front-end processors

  B. Clients

  C. Servers

  D. Modems

Which method of connecting to the Internet operates on the same lines as telephones, and the
Internet is always available.

  A. Cable

  B. Dial-up

  C. DSL

  D. Satellite

In TCP/IP, IP is responsible for:

  A. Disassembling, delivering and reassembling of packets during transmission.

  B. Establishing the Internet connection between two computers.

  C. Sequencing the transfer of packets across the network.

  D. Error checking.
Which of the following have been developed to ensure that computers developed by different
manufacturers can communicate?

  A. Protocols

  B. Client/server architectures

  C. WANs

  D. Application software packages

Which is a restricted network within a company?

  A. extranet

  B. internet

  C. intranet

  D. insidenet

Which connects parts of the intranets of different organizations and allows secure
communications among business partners.

  A. Extranet

  B. Internet

  C. Intranet

  D. World Wide Web

Consider this domain name, www.business.gsu.edu. What is “edu”?

  A. the Top-level domain

  B. the URL

  C. the Web site locator

  D. the name of the computer

Consider this domain name, www.business.gsu.edu. What is “gsu”?

  A. the top-level domain

  B. the name of the organization

  C. the URL

  D. the name of the specific computer

Consider this domain name, www.business.gsu.edu. What is “business”?

  A. Top-level domain

  B. Name of the organization

  C. URL

  D. Name of the specific computer

Which type of portals support communities such as hobby groups or political parties.

  A. Industrywide

  B. Personal

  C. Affinity

  D. Corporate

  E. Commercial

Which is an IT tool used for collaboration?

  A. a meta-search engine

  B. Google Docs

  C. a portal

  D. Web-based call centres

CHAPTER 7

Which of the following is a disadvantage of click-and-mortar organizations?

  A. Limited geographical reach

  B. Added complexity combining two different environments

  C. Customers uncomfortable with online transactions

  D. No face-to-face interaction with customers

Which type of electronic commerce is the largest by volume?

  A. Business-to-employee

  B. Consumer-to-consumer

  C. Business-to-business
   D. Business-to-consumer

Which type of auction does eBay use?

  A. A forward auction

  B. A reverse auction

  C. A physical auction

  D. A simple auction

A vendor asks its business partners to place logos or banners on their Web sites. If customers
click on a logo, visit the vendor’s site, and make a purchase, then the vendor pays a commission
to the partner. This scenario illustrates which business model?

  A. Electronic tendering system

  B. Name-your-own-price

  C. Online direct marketing

  D. Affiliate marketing

Which type of e-commerce is also known as e-tailing?

  A. Business-to-business

  B. Collaborative commerce

  C. Business-to-consumer

  D. Consumer-to-business

What is it called when a fully automated electronic commerce transaction eliminates

middlemen?

  A. Disintegration

  B. Supply chain integration

  C. Disintermediation

  D. Value-added services

Difficulties in order fulfillment are most closely associated with which type of electronic
commerce?

  A. Business-to-business

  B. Business-to-consumer
   C. Mobile commerce

  D. Business-to-employee

Which type of advertising is automatically launched by some trigger and appears behind the
active window?

  A. keyword banner

  B. random banner

  C. pop-up ad

  D. pop-under ad

Which type of advertising offer(s) consumers incentives to accept advertising and e-mail
voluntarily?

  A. Personalized marketing

  B. Permission marketing

  C. Paper catalogs

  D. Direct mail

Which term refers to online word-of-mouth marketing?

  A. Permission marketing

  B. One-to-one marketing

  C. Personalized marketing

  D. Viral marketing

Which type of exchange connects buyers and sellers in a given industry?

  A. Functional

  B. Horizontal

  C. Mixed

  D. Vertical

Which marketplace model has the key mechanisms of forward auctions and electronic catalogs
that can be customized for each large buyer?

  A. buy-side

  B. sell-side
   C. group purchasing

  D. desktop purchasing

What term refers to the practice of registering or using domain names for the purpose of
profiting from the goodwill or trademark belonging to someone else?

  A. Domain spoofing

  B. Domain masquerading

  C. Domain tasting

  D. Cybersquatting

CHAPTER 8

Which systems are widely used for high-volume, long-distance, point-to-point communication?

  A. GPS

  B. Microwave

  C. Satellite

  D. Wireless

Which satellites maintain a relatively fixed position?

  A. GEO satellites

  B. LEO satellites

  C. MEO satellites

  D. NEO satellites

GPS is a wireless system that uses which type of satellites.

  A. GEO

  B. LEO

  C. MEO

  D. NEO

Which wireless technology is commonly used for TV and DVD remote control devices?

  A. Bluetooth

  B. Near-field communications
   C. WiMAX

  D. Infrared

Which is a wireless standard that enables temporary, short-range connection between mobile
devices?

  A. Bluetooth

  B. Wireless application protocol

  C. Short message service

  D. Wi-Fi

With the shortest range of any wireless network, this technology is designed to be used with
contactless credit cards.

  A. Near-field communications

  B. Bluetooth

  C. Ultra-wideband

  D. Wi-Fi

Putting ads on top of taxicabs in New York City that change as the cabs travel around the city is
an example of which?

  A. Viral marketing

  B. Permission advertising

  C. Location-based advertising

  D. Direct marketing

Where do we find the most use of RFID in a business?

  A. Transaction processing

  B. Supply chain management

  C. Enabling communications with customers

  D. Decreasing network costs

What do we call the act of locating wireless local area networks while moving around a city?

  A. Eavesdropping

  B. RF jamming
   C. Cybersquatting

  D. War driving

Which is an unauthorized access point to a wireless network?

  A. Illegal access point

  B. RF access point

  C. Rogue access point

  D. War drive access point

Although rogue access devices can be installed innocently, they can also be installed by an
attacker trying to gain unauthorized access to a wireless network. In such cases, what are these
devices called?

  A. Unencrypted node

  B. Evil twin

  C. Open node

  D. Illegal server

TG 1&2
Moore’s Law predicted that microprocessor complexity would do which?

  A. Double every year.

  B. Double every two years.

  C. Increase slowly.

  D. Decrease rapidly.

Which is (are) the part of primary storage that holds a software program (or a portion of it. and
small amounts of data when they are brought from secondary storage?

  A. Read-only memory

  B. Random access memory

  C. Cache memory

  D. Registers

Which two adjectives describes random access memory?

  A. Volatile, temporary
   B. Nonvolatile, permanent

  C. Volatile, permanent

  D. Volatile, inexpensive

Which is the type of primary storage, located closest to the CPU, where the computer can
temporarily store blocks of data used most often?

  A. Read-only memory.

  B. Registers.

  C. Random access memory.

  D. Cache memory.

Which is the type of primary storage where certain critical instructions are safeguarded because
the storage is nonvolatile and the instructions can be read only by the computer and not
changed by the user?

  A. Read-only memory.

  B. Random access memory.

  C. Cache memory

  D. Registers

Which are electronic storage devices that contain no moving parts.

  A. Hard drives

  B. Flash memory devices

  C. DVDs

  D. CDs

Desktop PCs are an example of which type of computers?

  A. mainframe computers

  B. microcomputers

  C. midrange computers

  D. supercomputers

Airline reservation systems are an example of which type of computers?

  A. mainframe computers
   B. microcomputers

  C. midrange computers

  D. supercomputers

Which of the following is an example of an output technology?

  A. Joystick

  B. Keyboard

  C. Printer

  D. RFID scanner

Which of the following is an example of an input technology?

  A. Monitor

  B. Mouse

  C. Printer

  D. Plotter

Which is an example of secondary storage?

  A. A hard drive

  B. Cache memory

  C. RAM

  D. ROM

Which is(are) a written description of a computer program’s functions?

  A. Explanatory instructions

  B. Documentation

  C. Graphical user interface

  D. Plug and play

Which is the set of computer instructions that provides specific functionality to a user?

  A. Transaction processing software.

  B. Application software.

  C. General software.
   D. Systems software.

Which concept refers to the ability of computing products to work together?

  A. Open-source software

  B. Software-as-a-Service

  C. Object-oriented software

  D. Open systems

Which is software whose source code is available at no cost to developers and users?

  A. Freeware

  B. Shareware

  C. Open-source software

  D. Software-as-a-Service

Which allows users to exert direct control of icons on the computer screen?

  A. Systems software

  B. Application software

  C. Graphical user interface

  D. Plug-and-play

Which is the main system control program, which supervises the overall operations of the
computer, allocates CPU time and main memory to programs, and provides an interface
between the user and the hardware.

  A. application software

  B. GUI

  C. operating system

  D. social interface
TED TALK REFLECTION

TECHNOLOGY & STRATEGY

What is the "glue" that holds value chains together?

  A. Primary activities

  B. Support activities

  C. Transaction costs

  D. Economies of scale

With recent advances in technology and the Internet, what is true about transaction costs?

  A. Transaction costs are becoming more volatile.

  B. Transaction costs are increasing.

  C. Transaction costs are stable

  D. Transaction costs are decreasing.

During the first phase of the Internet and World Wide Web, what did the encylopedia industry
experience?

  A. Disintermediation

  B. Vertical integration

  C. Economies of scale

  D. Collosal sharing

Wikipedia replaced the encylopedia industry. Wikipedia is an example of which?

  A. Crowdsourcing

  B. Deconstruction

  C. Economies of scale

  D. The bargaining power of suppliers

Individualized medicine is an example when the data needs are bigger than our current
organizations or insititutions. How does Philip Evans describe the change required for
individualized medicine to become a reality.

  A. Colossal sharing

  B. Fragmentation

  C. Disintermediation

  D. Vertical integration

Which is an example of how technology changes scale economies, so that "small is beautiful".

  A. The electrical grid

  B. The phamaceutical industry

  C. Health care

  D. The telecom industry

ADWORDS AUTION
How does a second-price auction work?

  A. The second highest bidder wins because the highest bidder has overbid and will
experience buyer's regret.

  B. The second highest bidder is the winner but has to pay the highest bid.

  C. The highest bidder wins but only pays the difference between his bid and the second
highest bid.

  D. The highest bidder wins, but only pays the amount of the second highest bid.

Besides the bid amount, what else is included in the Ad Rank score? (Choose all that apply.)
 A. keyword formatting
 B. ad relevance
 C. ad formats
 D. conversion rate
 E. landing page experience
 F. click-through rate
Answer Key:B, C, E, F

If you want to pay a lower price, what can you do? (Choose all that apply.)
 A. Increase your bid
 B. Use Google's "ad formats"
 C. Increase the quality of your site.
 D. Decrease your bid.

Answer Key:B, C

If you want to move your ad up in the rankings, what can you do to increase your ad rank?
(Choose all that apply.)
 A. Make multiple landing pages
 B. Add Google "ad formats"
 C. Increase your bid.
 D. Increase the quality of your site.

Answer Key:B, C, D

BIG DATA IS BETTER DATA

Which is true about apple pie?

  A. It is America's favourite pie.

  B. It is America's most common second-favourite pie

  C. It is only sold in 30 cm. size pies

  D. It is only sold in 11 cm. size pies.

Answer Key:B

Why are we now seeing major advances in self-driving cars?

  A. All of the rules of the road are now enshrined in software

  B. Computer memory is cheaper

  C. Machine learning means the cars can learn to drive through experience.

  D. Computer processing is faster

Answer Key:C

What kind of jobs are most threatened by machine learning?

  A. Low skilled, blue collar jobs
   B. White collar, professional jobs

  C. Service jobs

  D. Manual labour jobs

Answer Key:B

MASSIVE SCALE ONLINE COLLABORATION

What does the acronym O.C.R. stand for?

  A. Optical Character Recognition

  B. Optimal Codex Regulation

  C. Orthoganol Compression Regime

  D. Official Code Red

Answer Key:A

In Re-CAPTCHA, why are two words presented to the user?

  A. Only a human, and not a computer, will be able to tell which word is real and which
word is fabricated.

  B. One word is unknown and needs to be digitized and the other is known and proves
the user is a human.

  C. One word needs to be digitized and the second word needs to be translated.

  D. Both works are unknown and the combination of two right answers is strong proof
that the user is a human.

Answer Key:B

Before advanced information technologies were available, coordination costs limited the
number of people that could work collaboratively on a project. Large-scale achievements such
as the pyramids or landing on the moon were limited to coordinating the work of
approximately how many people?
   A. 1,000 people

  B. 100,000 people

  C. 1,000,000 people

  D. 100,000,000 people

Answer Key:B

Luis von Ahn wanted to translate the Web for free. Which did he list as major obstacles to this
objective? (Mark as many as apply.)
 A. Computer translation services are not good enough yet.
 B. The small size of non-English Wikipedia sites
 C. Lack of bilinguals
 D. Motivation to translate

Answer Key:A, C, D

Mr. Splashy Pants

In the video, which government was Greenpeace trying to influence as far as whaling
regulations?

  A. The Japanese government

  B. The American government

  C. The government of Spain

  D. The Canadian government

Answer Key:A
What was Greenpeace's initial reaction to the poll result that chose Mr. Splashy Pants?

  A. They extended the poll deadline.

  B. They banned Reddit users from voting

  C. They immediately developed related fundraising products

  D. They chose a different name.

Answer Key:A
After the extended deadline for the poll, the percentage in favour of Mr. Splashy Pants
increased. What did Greenpeace do?
   A. Named the whale Mr. Splashy Pants but discontined the online portion of the anti-
whaling campaign.

  B. Named the whale Mr Splashy Pants and developed and sold related fundraising
products.

  C. Named the whale Ohuna and continued with the full online anti-whaling campaign.

  D. Discontinued the on-line portion of the anti-whaling coampaign.

Answer Key:B

Relational Database
You do volunteer work at the local animal shelter. They want you to make a database to keep
track of the people who adopt pets. They would like to send each adopter a thank you letter
accompanied by a request to donations.They would also like to keep track of how many pets
were adopted out of the shelter, by the month and year. Finally, they want to be able to see if a
person has previously adopted a pet and when. Adopters are identified by household and the
shelter has decided to use the household phone number to uniquely identify each household.
Pets are identified by a tag number. A pet can only be adopted by one household. Households
may adopt more than one pet.

You have decided that two tables are required for this database, an ADOPTER table and a PET
table. List the fields that should be in the ADOPTER table.

Model Short Answer:

At a minimum, the ADOPTER table should have the following fields:

 AdopterPhone
 AdopterLName
 AdopterFName
 AdopterAddress

You do volunteer work at the local animal shelter. They want you to make a database to keep
track of the people who adopt pets. They would like to send each adopter a thank you letter
accompanied by a request to donations.They would also like to keep track of how many pets
were adopted out of the shelter, by the month and year. Finally, they want to be able to see if a
person has previously adopted a pet and when. Adopters are identified by household and the
shelter has decided to use the household phone number to uniquely identify each household.
Pets are identified by a tag number. A pet can only be adopted by one household. Households
may adopt more than one pet.

You have decided that two tables are required for this database, an ADOPTER table and a PET
table. List the fields that should be in the PET table.

Model Short Answer:

The PET table could have the following fields (the first three are mandatory for the database
requirements):
TagNumber
AdopterPhone
AdoptionDate
PetName
PetSpecies
PetBreed
PetColour
PetAge
RabiesShot (y/n)
etc.

What is the primary key in the ADOPTER table?

  A. AdopterLName

  B. AdopterPhone

  C. AdopterFName

  D. AdopterAddress

Answer Key:B
What is the primary key in the PET table?

  A. AdopterPhone

  B. PetName

  C. AdoptionDate

  D. TagNumber

Answer Key:D
Which field is a foreign key?

  A. AdopterPhone in the PET table

  B. AdopterPhone in the ADOPTER table

  C. AdoptionDate in the PET table

  D. PetName in the PET table

Answer Key:A

 Warriors of the Net

In the film, who labels the packages with sender's address, receiver's address and type of
packet?

  A. Mr. I.P.

  B. The Web Server

  C. The Proxy Server

  D. The Router Swit

Which transfers packets from one network to another? He is also a "symbol of control in a
disorganized world".

  A. The proxy server

  B. The firewall

  C. The network interface

  D. The router

Answer Key:D
What does the proxy server do?

  A. Provides responses to client inquiries.

  B. Transfers packets from one network to another.

  C. Allows certain authorized packets to bypass the firewall.

   D. Examines the URL destination of outgoing packets to see if they are "allowed" by the
organization

Answer Key:D
Which functions does the firewall perform? (Mark as many as apply.)

 A. 
Directs packets according to receiver's address.

 B. 
Sends replacement packages if acknowledgement of receipt is not received.

 C. 
Prevents sensitive corporate information from going out on the Web.

 D. 
Prevents malicious packets from entering the corporate network.

Answer Key:C, D

 You don't need an app for that

 Toby Shapshak describes Africa as not just "mobile first", but "mobile only".
True
False

Answer Key:True
Where was "pay as you go" mobile phone service developed?

  A. Japan

  B. Africa

  C. United States of America

  D. China

Answer Key:B
What does Toby Shapshak says is a critical characteristic of mobile devices in Africa?

  A. Durability

  B. Good battery life

   C. 5G capability

  D. Minimum 8 Gb storage

Answer Key:B

Which are true about M-pesa - the mobile money transfer system develped by Vodacom?
(Select all that apply.)
 A. Uses Short Messaging Servce (SMS)
 B. Works on flip-phones
 C. Requires 4G cellular technology
 D. Was initially developed in Japan
 E. Requires a smart phone
 F. Uses Bluetooth
 G. Accounts for 40% of Kenya's GDP

Answer Key:A, B, G

Getting timely and relevant information to farmers can make the difference between
subsistance farming and abundance farming.
True
False

Answer Key:True