Exam 2

Question 1

Automation is usually bought by a business through:

Answer 1

purchasing applications

Question 2

Horizontal Market:

Answer 2

• widely applicable products and services
• office productivity applications
• Database management systems

Question 3

Vertical Market:

Answer 3

• narrowly applicable products and services
• healthcare, manufacturing, financial services
• more expensive
• vertical subsectors e.g: discrete, process and repetitive manufacturing

Question 4

An organization creating branded applications:

Answer 4

Horizontal Market Applications (my fire is horizontal)

Question 5

Right to use specified number of copies:

Answer 5

license

Question 6

If an application is only for one OS, is it “native” or “thin client”?

Answer 6

native

Question 7

Thin client applications are much easter to access. T/F: The browser affects how well your software runs

Answer 7

true

Question 8

Database Management systems (DBMS)

Answer 8

• is an application not a hardware
• program used to create, process and admin a database

Question 9

A foreign key in a table:

Answer 9

• are used to relate a relational database
• one table to another

Question 10

Columns in a database are also called:

Answer 10

fields

Question 11

Is a table in a database a group of records or fields?

Answer 11

records

Question 12

The record that is a unique identifier for a table (like a student ID) is called:

Answer 12

primary key

Question 13

What does LAN stand for?

Answer 13

• Local Area Network
• Small area, like business or a home

Question 14

What does PAN stand for?

Answer 14

• Personal Area Network
• Just you and your device (when you hotspot for example) ( increases security and expense)

Question 15

What does WAN stand for?

Answer 15

• Wide Area Network
• Large area, can cover the country (like cellular data, booking a flight)

Question 16

If you hire for OS and DBMS services, with server hardware, what would you ask for?

Answer 16

Platform as a service (Paas)

Question 17

Often confused: Which service offers all needs and a bare, blank server:

Answer 17

Infrastructure as a service (Iaas)

Question 18

SaaS

Answer 18

• small
• software as a service
• example: google maps
• software that solves problems

Question 19

A one of a kind application is:

Answer 19

• highly customizable
• made to order
• addresses organization needs

Question 20

Content delivery network:

Answer 20

• decreased or guaranteed load time
• reduced load on origin server
• increased reliability
• protection from DoS attacks
• reduced delivery costs for mobile users
• pay as you go
• will not get you viral

Question 21

CDN

Answer 21

• Sometimes content is too large to be handled by a few static servers, you need to have access to more for peak hours
• Large content is worse for bug changes (music, video)

Question 22

CPU (central processing unit)

Answer 22

• “the brain”
• dual processor and quad processor computers

Question 23

RAM (random access memory)

Answer 23

• CPU works in conjunction with main memory

Question 24

Storage Hardware

Answer 24

• non volatile
• magnetic disks (hard drive)
• solid state storage (SSD)
• thumb drives
• optical disks (CD/DVD)
• volatile - cache and main memory

Question 25

Internet of things (IoT)

Answer 25

idea that objects are connected to the internet so they can interact with other devices, applications or services

Question 26

smartphone

Answer 26

smart device with processing power, memory, internet access and wifi connectivity

Question 27

smart buildings (microsoft)

Answer 27

ID problems like wasteful lighting, competing heating and cooling systems, rogue fans, etc.

Question 28

OS

Answer 28

controls a computers resources: - client (programs that control the client computers resources) - server (programs that control the server computers resources

Question 29

Site license

Answer 29

flat fee to install software product on all company computers or all computers at specific site

Question 30

purpose of database

Answer 30

- organize and keep track of things - keep track of multiple themes - general rule: * single theme - store in a spreadsheet * multiple themes - use a database

Question 31

database

Answer 31

self describing collection of integrated records

Question 32

components of a database:

Answer 32

- a table consists of columns (fields) and rows (records) - the collection of data spanning across all columns (horizontally) - A table is a collection of records

Question 33

Metadata describes:

Answer 33

definitions of tables, fields and relationships

Question 34

4 DBMS operations:

Answer 34

- read - insert - modify - delete data

Question 35

what is the cloud?

Answer 35

Elastic leasing of pooled computer resources over the internet

Question 36

elastic

Answer 36

leased computer resources quickly increased or decreased dynamically, programmatically, organizations only pay for resources used

Question 37

cloud resources are pooled

Answer 37

many different organizations share the same physical hardware through virtualization

Question 38

benefit from economies of scale

Answer 38

- average cost of production decreases as size of operation increases - major cloud vendors operate enormous web farms

Question 39

where did the cloud come from?

Answer 39

- the mainframe era (1960's-1980) - the client server era (1990'2-2000's)

Question 40

advantages of using the cloud:

Answer 40

- small capital requirements - speedy development - superior flexibility and adaptability to growing or fluctuating demand - known cost structure - possible best of breed security/disaster preparedness - no obsolescence - industry wide economies of scale, hence cheaper

Question 41

disadvantages of the cloud:

Answer 41

- dependency of vendor - loss of control over data center location - little visibility into true security and disaster preparedness capabilities - limited by your bandwidth

Question 42

computer network

Answer 42

a collection of computers and devices that communicate with one another over transmission lines or wirelessly