Chapter 4

Question 1

What are the two types of online processing sYstems

Answer 1

An online transaction processing ( OLTP )

Online analytical processing ( OLAP)

Question 2

OLTP are

Answer 2

systems that supports the core business functions

Question 3

OLAP are

Answer 3

Systems focus on leveraging the data info

Question 4

What , how and when does OLTP process

Answer 4

What : Process transaction
How : Modifies database by changing transaction data
When : real time

Question 5

What how and when does OLAP process

Answer 5

What : process reports and analytics
How : Queries the database to answer real question
When real time

Question 6

What are the level of info systems

Answer 6

Executive support systems ( ESS)
Decision support systems ( DSS)
Management information systems (MIS)
Transaction processing systems ( TPS)

Question 7

Executive support systems ( ESS) is and who use them

Answer 7

support strategic decision making and are subset of decision support systems. and its use by executive leadership

Question 8

Decision support systems (DSS) is and who use them

Answer 8

assist in solving nonroutine problems and unstructured decision making and is use by upper level management

Question 9

Management information systems ( MIS) is and who use them

Answer 9

assist in routine management activities and is use by middle management

Question 10

Transaction processing systems is and who use them

Answer 10

process day to day business activities and provide a foundation for other systems (capture data) and is use by workers

Question 11

What is Batch Processing

Answer 11

is when the data is collected but process later

Question 12

What are the three main benefits of Batch processing

Answer 12

Efficiency
Simplicity
Quality data

Question 13

What are the step of batch processing

Answer 13

business events
create file
update file
schedule batch
update database

Question 14

What is software

Answer 14

the interface between the component and the users

Question 15

What is systems software

Answer 15

specialized software that runs a computer hardware and other hardware

Question 16

What are the type of systems software

Answer 16

Database management systems ( DBMS)
Data communication software
Utility programs

Question 17

Describe Database management systems

Answer 17

used to defined manipulate, retrieve and manage data in the databases : ex: oracle,SQL server

Question 18

Describe Data communication software

Answer 18

provide remote access to exchange data between computer and user ex: email, file transfer protocol

Question 19

Describe utility programs

Answer 19

use for analyzing configuring and optimizing and maintaining a computer ex: antivirus, disk cleaners

Question 20

What are the risk when buying software from third party

Answer 20

Copyright
Data breaches
Disruptions
Updates

Question 21

What are the risk to in house developping software

Answer 21

Budgeting
Scheduling
Technical specifications
External market
Fraud

Question 22

What is cloud computing

Answer 22

provides access to shared resources over
the internet
Allows company to minimize computer resources kept on hand

Question 23

What are the three cloud deployment models

Answer 23

Private (customized, high security)
Public ( readily available , lower cost
Hybrid ( moderate cost and security ,increase flexibility )

Question 24

What are the cloud computing services models

Answer 24

Software as service (SAAS)
Platform as service ( PAAS)
Infrastructure as a service ( IAA)

Question 25

Software as services does

Answer 25

Utilizes the internet to provide customers with applications that are managed by the third-party provider. (ex: google drive, microsoft office)

Question 26

Platform as service does

Answer 26

Provides customers a platform for software development that is delivered remotely. ex: google app engine , Openshift

Question 27

Infrastructure as service does

Answer 27

Provides customers with fully self-service computers, networking, storage, and operating systems through virtualized environments. Ex : amazon wen service, microsoft azure

Question 28

What are the risk as a SaaS cloud provider

Answer 28

Reliability, privacy and security

Question 29

What are control activities for small business

Answer 29

segregation of duties, physical access and logical access

Question 30

What are the two ways a company can grow

Answer 30

Organic and acquisition based growth

Question 31

Whats is acquisition

Answer 31

when one company take control of the other

Question 32

What is a merger

Answer 32

when the new company is a combines of the two business

Question 33

Explain systems integration

Answer 33

The process of joining different systems or substems into one larger system and ensuring that hey function as one systems

Question 34

Explain a lift and shift

Answer 34

is when the acquiring company moves the acquired systems, placing it in the data center maintaining the existing systems as they are and the users have access to all the systems at the same time

Question 35

Explain immediate integration

Answer 35

that when multiples systems requires converting existing data in the system to be retired and migrating it into the new systems and the original systems are then eliminated

Question 36

What us a centralized systems

Answer 36

connect all users to one central location built around a server that all authorized users can acess

Question 37

What are the advantages of centralized systems

Answer 37

easier to set up Data is easy to access Consistency in processing Cost is lower

Question 38

What are the disadvantage of centralized systems

Answer 38

risk of disruption is greater may experience transaction bottlenecks if traffic is high Other location may experience lag time

Question 39

What is decentralized systems

Answer 39

utilizes multiples locations that each maintain a copy of the data needed for its connected systems. Not all users are connected to all acess points

Question 40

What are the advantage of decentralized systems

Answer 40

processing power and data storage needed is reduced higher responsiveness Processing bottlenecks are reduced if one systems fail there are others

Question 41

What are the disadvantage of decentralized systems

Answer 41

increase of security risk Cost of installing is higher

Question 42

What is distributed system

Answer 42

all the users and systems are directly connected to one another across the network, the processing and database are distributed among several business locations

Question 43

What are the advantage of distributed system

Answer 43

communication among the users Real time transaction details are more readily Reduction or complete elimination of expensive central processing site

Question 44

What are the disadvantage of distributed system

Answer 44

expensive difficult to implement

Question 45

What could be solution for disparate systems that cannot easily communicate

Answer 45

ERP ( enterprise resource planning )

Question 46

ERP is

Answer 46

solution that integrate multiple system into single cohesive communication system