Exam 2 Flashcards

1
Q

Automation is usually bought by a business through:

A

purchasing applications

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Horizontal Market:

A
  • widely applicable products and services
  • office productivity applications
  • Database management systems
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Vertical Market:

A
  • narrowly applicable products and services
  • healthcare, manufacturing, financial services
  • more expensive
  • vertical subsectors e.g: discrete, process and repetitive manufacturing
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

An organization creating branded applications:

A

Horizontal Market Applications (my fire is horizontal)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Right to use specified number of copies:

A

license

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

native

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Database Management systems (DBMS)

A
  • is an application not a hardware
  • program used to create, process and admin a database
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

A foreign key in a table:

A
  • are used to relate a relational database
  • one table to another
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Columns in a database are also called:

A

fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

records

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

primary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What does LAN stand for?

A
  • Local Area Network
  • Small area, like business or a home
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What does PAN stand for?

A
  • Personal Area Network
  • Just you and your device (when you hotspot for example) ( increases security and expense)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What does WAN stand for?

A
  • Wide Area Network
  • Large area, can cover the country (like cellular data, booking a flight)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

Platform as a service (Paas)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

Infrastructure as a service (Iaas)

18
Q

SaaS

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

A one of a kind application is:

A
  • highly customizable
  • made to order
  • addresses organization needs
20
Q

Content delivery network:

A
  • 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
21
Q

CDN

A
  • 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)
22
Q

CPU (central processing unit)

A
  • “the brain”
  • dual processor and quad processor computers
23
Q

RAM (random access memory)

A
  • CPU works in conjunction with main memory
24
Q

Storage Hardware

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

Internet of things (IoT)

A

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

26
Q

smartphone

A

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

27
Q

smart buildings (microsoft)

A

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

28
Q

OS

A

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

29
Q

Site license

A

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

30
Q

purpose of database

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

database

A

self describing collection of integrated records

32
Q

components of a database:

A
  • 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
33
Q

Metadata describes:

A

definitions of tables, fields and relationships

34
Q

4 DBMS operations:

A
  • read
  • insert
  • modify
  • delete data
35
Q

what is the cloud?

A

Elastic leasing of pooled computer resources over the internet

36
Q

elastic

A

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

37
Q

cloud resources are pooled

A

many different organizations share the same physical hardware through virtualization

38
Q

benefit from economies of scale

A
  • average cost of production decreases as size of operation increases
  • major cloud vendors operate enormous web farms
39
Q

where did the cloud come from?

A
  • the mainframe era (1960’s-1980)
  • the client server era (1990’2-2000’s)
40
Q

advantages of using the cloud:

A
  • 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
41
Q

disadvantages of the cloud:

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

computer network

A

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