Roles of IT in Business Flashcards

1
Q

Governance is primarily the responsibility of?

A

Board of directors

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

Selling a digitized product (online book for example) can decrease its _____ and improve its ______.

A

Decrease its costs and improve quality

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

Digitization is a description of how ______ is changing in business.

A

Technology

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

Processes and structures, implemented by the board, to achieve organizational goals.

A

Governance

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

What concerns the transformation of nonelectric data to electronic form?

A

Digitization

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

Describe scope and scalability. How are they different?

A

Scope - concerns whether a system is built too small or too large
Scalability - concerns whether a system can expand with growth.

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

When a customer database spreadsheet can’t keep up with rapid growth of a business, this issue is related to?

A

Scope and scalability

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

Lack of strategic focus relates to an unnecessary task. See example on flashcard.

A

Gus McCrae, an accountant at Lonesome Dove Cattle Ranch, builds a spreadsheet to track cow movements between locations. However, there are so few movements of cattle between locations that the spreadsheet is unhelpful.

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

Management reporting systems exist to aid decisions and reporting. What is the most important design element in creating a management reporting system?

A

Types of decisions to be made

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

What are five different types of IT systems? These are system types based on activity.

A
  1. Operational systems
  2. Management Info Systems (MIS)
  3. Decision Support Systems (DSSs)
  4. Knowledge work systems
  5. Enterprise Resource Planning Systems (ERPs)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Transaction processing systems (TPS) would fall under which category of systems?

A

Operational systems

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

Accounting Information systems (AISs) would fall under which category of systems?

A

Accounting information systems (AISs)

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

Executive support systems (ESSs), data-driven DDSs, model-driven DSSs, and group support systems GSSs would fall under which category of systems?

A

Decision support systems (DSSs)

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

Office automation systems (OASs) would fall under which category of systems?

A

Knowledge work systems

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

Which IT system would be most appropriate for examining large sets of data?

A

Data-driven DSSs

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

This system supports the day-to-day activities of the business (purchasing of goods and services, manufacturing activities, sales to customers, cash collections, payroll, # of hours employees worked, etc.)

A

Transaction processing system (TPS)

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

This system provides information to mid- and upper-level management to assist them in managing non-routine problems and in long-range planning.

A

Decision support system (DSS)

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

This system provides generic support to clerical level employees and include many of the typical programs found on personal computers (word processing, spreadsheets, end-user databases, etc.).

A

Office automation system (OAS)

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

What is a key characteristic of a non-financial transaction?

A

No debit or credit entry made. Example: sending purchase order to vendor to purchase an item for re-sale

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

This system takes planning information (budgets, forecasts, etc.) data and compare it to actual results in periodic management reports (summary reports, variance reports, and exception reports?

A

MIS. Similar to budget system.

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

Which system will include external data? Which system places a great emphasis on external information.

A

ESS (Executive support system)

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

This system is designed to support routine management problems based primarily on data from transaction processing systems and, thus, would not be appropriate to provide support for this type of decision.

A

MIS (management info system)

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

This system facilitates the work of professional level employees (engineers, accountants, attorneys, etc.) by providing information relevant to their day-to-day activities (e.g., how the company has handled specific types of audit exceptions) and/or by automating some of their routine functions and, thus, would not be appropriate to provide support for this type of decision.

A

Knowledge management system (KMS)

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

This system provides information to mid- and upper-level management to assist them in managing non-routine problems and in long-range planning.

A

Decision support system (DSS)

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

This system is a subset of DSS that are especially designed for forecasting and making long-range, strategic decisions, and they place greater emphasis on external data.

A

Executive support system (ESS)

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

Increased responsiveness and flexibility while aiding in the decision-making process is an advantage of what system?

A

ERP

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

This IT system is designed to improve the productivity of office work.

A

Office automation system. Office automation systems include the software tools of daily work, including word processing programs, spreadsheets, email, and electronic calendars.

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

What do neural networks, case-based reasoning systems, and intelligent agents all have in common?

A

They all learn from experience.

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

This system does not learn from experience. It simply executes rules.

A

Rule-based expert systems

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

Desktop client, application, and database are all layers on a what?

A

Three-tiered architecture that most client/server applications operate on.

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

A __________ is a database archive of an organization’s operational transactions (sales, purchases, production, payroll, etc.) over a period of years. External data that might be correlated with these transactions, such as economic indicators, stock prices, and exchange rates, are also included.

A

Data warehouse

32
Q

______ is the process of sorting through data maintained in a data warehouse in an effort to identify relationships between data fields or events. Also, it’s the process of performing statistical analysis and automatically searching for patterns in large volumes of data.

A

Data mining

33
Q

With regards to data warehouses

  1. The bulk of the data found in a data warehouse comprises historical ______ data.
  2. ________ is one of the principal functionalities offered by data mining software. It is a major component of data mining software.
A
  1. Operational

2. Pattern recognition

34
Q

What is the critical success factor in data mining?

A

Pattern recognition.

These relationships are often classified as sequences (one event leads to another) or associations (one event is correlated with another event). The ability to recognize these patterns is, thus, critical to successful data mining.

35
Q

With regards to flat file systems

  1. Flat file systems contains ______ of data redundancy (high or little)
  2. Flat file systems are program independent. This is because the program independence of flat file systems means that multiple programs must be used to read, access and process the data. Is this an advantage or disadvantage?
A
  1. High

2. Disadvantage

36
Q

A _______ is focused on a particular market or purpose and contains only information specific to that objective. This is also a specialized version of a data warehouse that contains data that is pre-configured to meet the needs of specific departments.

A

Data mart

37
Q

A _______ is a generic term applied to information stored in some type of structured manner.

A

Data store

38
Q

An __________ is a database that can maintain information about complex objects, and it demonstrates the basic characteristics of object oriented programming (inheritance, encapsulation, etc.).

A

Object-oriented database

39
Q

Between data warehouse and data mart, which one is more specialized and support more specific needs?

A

Data mart is more specialized and supports more specific needs

40
Q

Is external data included in data mart or data warehouse or both?

A

Both

41
Q

When you are given a scenario in a problem, when would it be most appropriate to use data mining.

A

When you are looking for patterns in large amounts of data

42
Q

Slice and dice means to look at data by ______.

A

subunit

43
Q

Problem: If you are looking at online summary and want to determine why the cost of a particular item is high, what is the most appropriate technique to do?

A

Drill down. Meaning moving from summary to detailed information to determine high costs.

44
Q

A _______ structure refers to how people are organized at an organization. (Hint: Neo Keanu Reeves)

A

Matrix organization

45
Q

An accounting system that stores data in multiple tables (i.e., matrices) that are linked by common key fields. This is called a?

A

Database system

46
Q

A data mart is a specialized type of ____________ that is tailored to the needs of a(n) _______.

A
  1. Data warehouse

2. Organization

47
Q

This system is an automated system that that uses information obtained and integrates expert advice for user.

A

Expert system

48
Q

Analysis of data in a database using tools which look for trends or anomalies without knowledge in advance of the meaning of the data is referred to as? It uses tools which look for trends or anomalies without such advance knowledge.

A

Data mining

49
Q

________ is a branch of computer science that involves computer programs that can solve specific problems creatively.

A

Artificial intelligence

50
Q

_______ involves computer creation of an artificial, three-dimension world that may be interacted with.

A

Virtual reality

51
Q

With regards to databases, the _______________ controls the storage and retrieval of the information maintained in a database and is responsible for maintaining the referential integrity of the data.

A

Database management system (DBMS)

52
Q

With regards to databases, ___________ is used to extract information from the database.

A

Data query language (DQL)

53
Q

With regards to databases, ___________ is used to add, update, and delete data.

A

Data manipulation language (DML)

54
Q

With regards to databases,___________ is used to create tables and fields of information within the fields.

A

Data definition language (DDL)

55
Q

System software, programming languages, and application software are all categories of what?

A

Computer software

56
Q

What is the ascending hierarchy of data in a system? What is the driving factor behind this ordering?
Options: Field, record, file, and character

A

Correct order: character, field, record, and file

**The order is based on pieces of data. Character has fewest, field second fewest, and so forth

57
Q

Database management software is considered both ______ and _______.

A
  1. Software

2. Middleware

58
Q

8047 is an example of what? These can be found in fields.

A

Data value or characters

59
Q

CustomerNumber is an example of what?

A

Field (or attributes)

60
Q

CustomerNumber, CustomerName, CustomerPhone, CustomerContact, CustomerCreditLimit is an example of what?

A

Record. A record is a collection of fields that describe an individual instance of an entity.

61
Q

This is a collection of records for one specific entity (invoice file, customer file, etc.)

A

File (table)

62
Q

Machine language must be designed for the specific computer and, therefore, is determined by the ______ who design the computer.

A

Engineers

63
Q

Review the benefits of a single integrated database information system.

A
  1. Increased data accessibility

2. Decreased data redundancy

64
Q

Pretty much all relational databases use what type of computer language?

A

SQL

65
Q

Capability to ____ and ____ the database is a primary function of a database management system.

A

Create and modify

66
Q

The advantages below are for what type of database?

  1. Flexible for ad hoc queries
  2. Store data in table form
  3. Maintained on direct access devices
A

Relational databases

67
Q

With regards to structuring and organizing data, how do hierarchal and relational databases differ?

A

Hierarchical - Tree structure

Relational - Tables

68
Q
  1. Report customization is a function of _____ system.
  2. Financial transaction inputs is a function of _____ software.
  3. Database access authorizations is a function of ______ system
A
  1. Report writing system
  2. Application software
  3. Access control systems
69
Q

The ____________ defines the database structure and content, especially the schema and subschema descriptions, including the names of the data elements contained in the database and their relationship to each other.

A

Data definition language

70
Q

The ________ language is a type of database language used to specify the privileges and security rules governing database users.

A

Data control language

71
Q

The _______ language provides application programs with a facility to interact with the database to facilitate adding, changing, and deleting either data or data relationships.

A

Data manipulation

72
Q

The ________ language are symbolic character strings used to control the current state of database management system operations.

A

Data command interpreter language

73
Q

The machine-language program that results when a symbolic-language program is translated is called a(n) _____

A

Object program

74
Q

This type of program refers to first-generation computers, which require manual wiring of the CPU to perform desired operations.

A

Wired program

75
Q

An _________ (e.g., Microsoft Office) is a series of applications such as a word processor, database, and spreadsheet.

A

Integrated suite

76
Q

_______ is generally considered to be software made available at a low, or no, cost to users.

A

Shareware

77
Q

An _______ system controls the execution of computer programs and may provide various services. It can be considered a software that performs a variety of general technical computer-controlling operations.

A

Operating system