K201 Lecture Exam

Front 1

T or F: data is free.

Back 1

False

Front 2

What is the difference between IT and IS?

Back 2

IT (hardware & software) + Procedures & People = IS (all 5 components)

Front 3

In the five component framework of an IS, which is the most important?

Back 3

People

Front 4

What is the order in which each component appears (from left to right) in the Five-Component Model?

Back 4

Hardware, Software, Data, Procedures, People

Front 5

What is the difference between data and information?

Back 5

Data: recorded facts or figures.

Information: knowledge derived from data

Front 6

T or F: In order for data to be timely, it must be delivered in real time.

Back 6

False

Front 7

T or F: Good data are always worth the cost, no matter how expensive.

Back 7

False

Front 8

Keeping track of data involving multiple themes should be done with what?

Back 8

Relational database

(lists of data involving a single theme should be stored in a spreadsheet)

Front 9

The data displayed in Design View of a table in an Access database is an example of...

Back 9

metadata

(data that describes data)

Front 10

T or F: A database is simply a group of files or tables.

Back 10

False.

(a database also includes relationships among the rows in the tables and metadata)

Front 11

Match the data elements with the term in which they are often referred.

(bytes, records, fields, tables)

(file, characters, columns, rows)

Back 11

Fields --> columns

Bytes --> characters

Table --> file

Records --> row

Front 12

T or F: Businesses often purchase Information Systems to increase efficiency of their business processes.

Back 12

False

Front 13

What is good data?

Back 13

Accurate

Timely (for your purpose)

Relevant (to context & subject)

Just sufficient

Worth its cost

Front 14

T or F: In order for any organization to consider data "timely" it must be up to the second

Back 14

False

Front 15

Database Management System (DBMS)

Back 15

a program used to create, process, and administer a database

Front 16

What is the difference between a DBMS and a database?

Back 16

DBMS: software program

Database: collection of tables, relationships, and metadata

Front 17

Entity

Back 17

Some thing that the users want to track

(have relationships to eachother)

Front 18

Attributes

Back 18

describe characteristics of the entity

Front 19

I:N

Back 19

one-to-many relationships

Front 20

N:M

Back 20

many-to-many relationships

Front 21

Normalization

Back 21

Process of converting a poorly structured table into two or more well-structured tables (by using a primary key)

Goal: to construct tables such that every table has a single topic/theme (eliminate data duplication)

Front 22

How many primary functions does a DBMS have?

Back 22

3: to create, process, and administer

Front 23

What is a structured query language (SQL)?

Back 23

an international standard language for processing a database

Front 24

T or F: The lost-update problem can be resolved by implementing multi-user database processing.

Back 24

False.

(this is what actually causes the problem. It must be resolved by implementing some type of locking to coordinate activities among multiple users)

Front 25

Which DBMS category does Microsoft Access belong to?

Back 25

Personal DBMS (meant for a single user)

Front 26

Data Model

Back 26

Describes the data and relationships that will be stored in a database.

Front 27

What type of relationship does this describe?

>------<

Back 27

N:M, many-to-many

Front 28

T or F: A table containing normalized data should have 3 or fewer themes.

Back 28

False

(it should contain only one theme)

Front 29

What is the most important phase of the SDLC?

Back 29

Determine Requirements

Front 30

If a project is determined to be feasible in the SDLC, the immediate next step is to....

Back 30

maintain the system

Front 31

The situation that occurs when adding more resources creates inefficiencies is known as....

Back 31

Diseconomies of scale

Front 32

Why are forms important?

Back 32

important for data entry (prevents mistakes & ensures data confidentiality)

Front 33

Is Microsoft Access considered a database?

Back 33

No.

(it is a DBMS)

Front 34

Reports

Back 34

display data in a meaningful way

Front 35

Cardinality

Back 35

Max./min. amount of entities that can be involved in a relationship

Front 36

Which type of relationship would be between a student table and a class table?

Back 36

N:M, many-to-many

Front 37

Business intelligence (BI) systems

Back 37

information systems that process operational, social, and other data to identify patterns, relationships, and trends for use by business professionals.

(contains hardware, software, data, procedures, and people)

Front 38

BI application

Back 38

Software component of a BI system

(analyze data)

Front 39

What are the primary activities in the BI process?

Back 39

acquire data, perform analysis, publish results

Front 40

The patterns, trends, and relationships produced by BI systems are referred to as...

Back 40

Business Intelligence

Front 41

T or F: An inventory report set to run automatically when an item reaches a critical low point is pull publishing

Back 41

False

(this is push publishing since it's executed automatically)

Front 42

What is the first primary activity in the BI process?

Back 42

acquire data

Front 43

T or F: One of the main benefits of BI analysis is that there are no discrepencies in the data acquired from multiple sources.

Back 43

False

Front 44

Data mining

Back 44

the application of statistical techniques to find patterns & relationships among data for classification and prediction.

Front 45

What is true of unsupervised data mining?

Back 45

analysts don't create a model/hypothesis before running the analysis

Front 46

Supervised data mining

Back 46

data miners develop a model prior to the analysis and apply statistical techniques to estimate parameters of the model

Front 47

T or F: A common business application of decision trees is to classify loans by likelihood of default

Back 47

True

Front 48

T or F: The process by which netflix recommends movies/ TV shows is an example of BI systems being utilized in the entertainment industry.

Back 48

True

Front 49

Manage risk

Back 49

to proactively balance trade off between risk and cost

Front 50

Technical Safeguards

Back 50

involve the hardware & software components of an IS

Front 51

Identification

Back 51

identifies the user (username)

Front 52

Authentication

Back 52

authenticates the user (password)

Front 53

Encryption

Back 53

process of transforming clear text into coded, unintelligible text for secure storage or communication

Front 54

https

Back 54

most secure communications over internet use this protocol.

data is encrypted using Secure Sockets Layer (SSL): uses a combination of public key and symmetric encryption

Front 55

Firewall

Back 55

computing device that prevents unauthorized network access

Front 56

Malware

Back 56

category of software that includes viruses, spyware, and adware

Front 57

Worm

Back 57

Virus that self-propogates using internet or other network

Front 58

Design Secure Applications

Back 58

Prevent common attacks like SQL injection attacks

Front 59

Data Safeguards

Back 59

protect databases & organizational data

Front 60

Data administration

Back 60

In charge of developing data policies and enforcing data standards (organization-wide function)

Front 61

Database administration

Back 61

Function that pertains to a particular database.

Develop procedures & practices to ensure efficient & orderly multiuser processing, control changes, and protect databases.

Front 62

Human Safeguards

Back 62

Involve people & procedure components of an IS.

hiring & screening, termination policies, position definitions, dissemination of policies & enforcement

Front 63

A _____ is a person or an organization that seeks to obtain or alter data or other IS assets illegally, without the owner's permission or knowledge

Back 63

Threat

Front 64

Pretexting, sniffing, spoofing, and phishing are all examples of....

Back 64

unauthorized data disclosure

Front 65

In order to access your student records, you must authenticate with your IU username & passphrase. This is an example of which safeguard?

Back 65

Technical

Front 66

T or F: Encryption is a type of data safeguard

Back 66

False and true..?

Front 67

Nonword passwords are vulnerable to a _____ attack in which the password cracker tries every possible combination

Back 67

Brute Force

Front 68

What will be displayed in the address bar to let you know you're using SSL protocal?

Back 68

https

Front 69

________ refers to an organization-wide function in charge of developing data policies & enforcing data standards

Back 69

Data administration

Front 70

_______ protect databases and other organizational data

Back 70

Data safeguards

Front 71

What is true about human safeguards for employees?

Back 71

user accounts should give users the least possible privilege needed to perform their jobs

Front 72

T or F: Email spoofing is a synonym for phishing

Back 72

True

Front 73

How should organizations respond to security threats?

Back 73

Establish a company-wide security policy

(technical, data, and human safeguards)

Manage Risk

(proactively balance trade- off's between risk and cost)

Front 74

Cooperation

Back 74

group of people working together to accomplish a job

Front 75

Collaboration

Back 75

group of people working together to achieve a common goal via a process of feedback and iteration

Front 76

Primary purposes of collaboration

Back 76

become informed *

make decisions

solve problems

manage projects

Front 77

Operational decisions

Back 77

support day-to-day activities

Front 78

Managerial decisions

Back 78

about the allocation & utilization of resources

Front 79

Strategic decisions

Back 79

support broad-scope, organizational issues

Front 80

Synchronous Communication

Back 80

occurs when all team members meet at the same time

(conference calls, video calls, chat room)

Front 81

Asynchronous Communication

Back 81

occurs when team members do not meet at the same time

(e-mail, text messages, etc)

Front 82

What is the difference between version management and version control?

Back 82

Version Management: tracks changes to documents and provides features/functions to accommodate concurrent work

Version Control: process that occurs when the collaboration tool limits, and sometimes directs, user activity

Front 83

What is the key difference between collaboration & cooperation?

Back 83

Collaboration gives importance to iteration & feedback

Front 84

Which is a primary purpose of collaboration?

Back 84

Becoming informed

Front 85

Kyra, a plant supervisor, orders 500 units of Type-2 steel beams for the coming month. She has made a ________ decision.

Back 85

Operational

Front 86

Project leaders have to make decisions on the allocation & utilization of materials and labor. Such decisions are called _________.

Back 86

Managerial decisions

Front 87

An organization uses a formula to compute the reorder quantity of an item in inventory. This is an example of a _______ decision process.

Back 87

structured

Front 88

The need for collaboration is greatest for ________ decisions.

Back 88

strategic

Front 89

T or F: Margaret arranges for a multiparty text chatting session. This is an example of asynchronous communication.

Back 89

False.

(this is an example of synchronous communication because all have agreed to text at the same time)

Front 90

Version-management systems _______.

Back 90

track changes to shared documents