Random

Question 1

What is Moore’s law

Answer 1

Computing power doubles every 2 years (~18 months)

Question 1

What is Metcalfe’s Law and network economics

Answer 1

Value or power of a network grows exponentially as a function of the
number of network members.

Question 2

What is total cost of ownership (TCO)

Question 3

What are the 7 components of the IT Infrastructure Ecosystem

Answer 3

1. Computer hardware platforms
2. Operating system platforms
3. Enterprise software applications
4. Data management and storage
5. Networking/telecommunications platforms
6. Internet platforms
7. Consulting system integration services

Question 4

Law of Mass Digital Storage

Answer 4

The amount of data being stored each year doubles

Question 5

Computer Hardware Platforms

Answer 5

• Client machines
  Desktop PCs, laptops
  Mobile computing: smartphones, tablets
  Desktop chips vs. mobile chips
• Servers
• Mainframes

Question 6

System software

Answer 6

Software that manages a computer system at a fundamental level

Question 7

Application software

Answer 7

Software written to address specific needs—to solve problems in the real
world

Question 8

Operating System

Answer 8

• manages computer resources, such as memory and input/output devices
• provides an interface through which a human can interact with the computer
• allows an application program to interact with these other system resources

corporate servers: windows, unix, linux
client level: microsoft, andriod, ios, chrome os

Question 9

Enterprise Software Applications

Answer 9

Largest providers:
- SAP
- Oracle

Middleware providers:
- IBM
- Oracle

Question 10

Main concern of complementary assets is

Answer 10

to optimize returns from information technology investments (it alone cant increase productivity)

Question 11

Business perspective

Answer 11

Calls attention to organizational and managerial nature of information systems

Question 12

Physical data organizations

Answer 12

Database: Group of related files

File: Group of records of same type

Record: Group of related fields

Field: Group of characters as word(s) or number(s)

Question 13

Logical data concepts

Answer 13

Entity: Person, place, thing on which we store information

Attribute: Each characteristic, or quality, describing entity

Question 14

Database Management System (DBMS) does what

Answer 14

• Interfaces between applications and physical data files
  – Separates logical and physical views of data
  – Solves problems of traditional file environment

Question 15

What are traditional file environment problems

Answer 15

• Data redundancy
• Data inconsistency
• Program-data dependence
• Lack of flexibility
• Poor security
• Lack of data sharing and availability

Question 16

Relational DBMS

Answer 16

• Represent data as two-dimensional tables
• Each table contains data on entity and attributes
• Table: grid of columns and rows

Question 17

Records for different entities in relational DBMS

Answer 17

Rows (tuples)

Question 18

Represents attribute for entity in relational DBMS

Answer 18

Fields (columns)

Question 19

Field used to uniquely identify each record

Answer 19

Key field

Question 20

Field in table used for key fields

Answer 20

Primary key

Question 21

Primary key used in second table as look-
up field to identify records from original table

Answer 21

Foreign Key

Question 22

Three basic operations of a relational DBMS (SQL)

Answer 22

SELECT:
 Creates subset of data of all records that meet
stated criteria

JOIN:
 Combines relational tables to provide user with
more information than available in individual tables

PROJECT:
 Creates subset of columns in table, creating tables
with only the information specified

Question 23

Non-relational databases: “No SQL”

Answer 23

– More flexible data model
– Data sets stored across distributed machines
– Easier to scale
– Handle large volumes of unstructured and structured data

Question 24

Databases in the cloud

Answer 24

– Appeal to start-ups, smaller businesses – Amazon Relational Database Service, Microsoft SQ L Azure – Private clouds

Question 25

Blockchain

Answer 25

* Distributed ledgers in a peer-to-peer distributed database * Maintains a growing list of records and transactions shared by all * Encryption used to identify participants and transactions * Used for financial transactions, supply chain, and medical records * Foundation of Bitcoin, and other crypto currencies

Question 26

Big data

Answer 26

Massive sets of unstructured/semi-structured data from web traffic, social media, sensors, and so on

Question 27

Hadoop

Answer 27

Enables distributed parallel processing of big data across inexpensive computers

Question 28

Data marts

Answer 28

Subset of data warehouse that typically focus on single subject or line of business

Question 29

In-memory computing

Answer 29

ses computers main memory (Random Access Memory - RA M) for data storage to avoid delays in retrieving data from (older and slower) disk storage

Question 30

Online Analytical Processing (OLAP)

Answer 30

Supports multidimensional data analysis – Viewing data using multiple dimensions

Question 31

Data Mining

Answer 31

Finds hidden patterns, relationships in datasets

Question 32

Text mining

Answer 32

Extracts key elements from large unstructured data sets

Question 33

Web mining

Answer 33

Discovery and analysis of useful patterns and information from web

Question 34

Data administration

Answer 34

Establishes policies and procedures to manage data

Question 35

Data governance

Answer 35

Deals with policies and processes for managing availability, usability, integrity, and security of data, especially regarding government regulations

Question 36

Database administration

Answer 36

Creating and maintaining database

Question 37

Unstructured

Answer 37

Decision maker must provide judgment, evaluation, and insight to solve problem (non-routine)

Question 38

Structured

Answer 38

Repetitive and routine; involve definite procedure for handling so they do not have to be treated each time as new

Question 39

Semi-structured

Answer 39

Only part of problem has clear-cut answer provided by accepted procedure

Question 40

Senior managers make

Answer 40

many unstructured decisions

Question 41

Middle managers make

Answer 41

more structured decisions but these may include unstructured components

Question 42

Operational managers and employees make

Answer 42

more structured decisions

Question 43

Classical model of management: five functions

Answer 43

Planning, organizing, coordinating, deciding, and controlling

Question 44

Business intelligence

Answer 44

- Infrastructure for collecting, storing, analyzing data produced by business – Databases, data warehouses, data marts

Question 45

Business analytics

Answer 45

Tools and techniques for analyzing data

Question 46

Business Intelligence Environment

Answer 46

1. Data from the business environment 2. Business intelligence infrastructure 3. Business analytics toolset 4. Managerial users and methods 5. Delivery platform: MIS, DSS, ESS 6. User interface

Question 47

Balanced Scoreboard framework

Answer 47

1. Customers 2. Financial 3. Business processes 4. Learning and growth

Question 48

Key performance indicators

Answer 48

measure each dimension of the balanced scoreboard

Question 49

Pivot tables are an example of

Answer 49

Multidimensional analysis /OLAP

Question 50

Geographic information systems (GIS)

Answer 50

Ties location-related data to maps

Question 51

Location analytics

Answer 51

Ability to gain business insight from the location (geographic) component of data

Question 52

Intranet is

Answer 52

a private network that is contained within an organization

Question 53

Extranet is

Answer 53

a private network that allows authorized external users to access specific resources and information from an organization’s internal systems