Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Business Data Management > Quiz 1 - Part 1 > Flashcards

Quiz 1 - Part 1 Flashcards

1
Q

Raw Facts, Building blocks of information

A

Data

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

_________ is the generation, storage, and retrieval of data

A

Data Management

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

Not yet been processed to reveal the meaning

A

Raw Data

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

Produced by processing data, and reveals the meaning of data.

A

Information

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

Enables knowledge creation, and should be accurate, relevant, and timely to enable good decision making

A

Information

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

T or F - Information is always subjective

A

True

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

________is in one person’s context is just a data point in another person’s context.

A

Information

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

Data Characteristics of Good Information

A

Accurate, timely, relevant, just sufficient, worth its cost

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

Knowledge derived from data

A

Information

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

Recorded facts or figures

A

Data

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

Shared, integrated computer structure that stores a collection of end-user data and metadata

A

Database

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

Raw facts of interest to end user

A

End-user data

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

Data about data, which the end-user data are integrated and managed

A

Metadata

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

Describe data characteristics and relationships

A

Metadata

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

Collection of programs, manages the database structure.

A

Database management system

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

Controls access to data stored in the database

A

Database management system

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

Intermediary between the user and the database and enables data to be shared

A

Database management system

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

Presents the end user with an integrated view of the data.

A

Database management system

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

Receives and translates application requests into operations required to fulfill the requests

A

Database management system

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

Hides database’s internal complexity from the application programs and users

A

Database management system

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

Different versions of the same data appear in different places

A

Data Inconsistency

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

Better data integration and less data inconsistency

A

Advantage of DBMS

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

Increased end-user productivity

A

Advantage of DBMS

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

Promoting accuracy, validity, and timeliness of data

A

Data Quality

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

Improves data sharing, security, access, and decision making

A

Database management system

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

Supports one user at a time

A

Single-user database

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

Supports multiple users at the same time

A

Multiuser database

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

Supports a small number of users or a specific department

A

Workgroup database

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

Support many users across many departments.

A

Enterprise database

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

Support one or more workgroup processes. 10-100 users.

A

Workgroup database

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

Procedures often formalized. problem solution within group.

A

Workgroup database

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

Can duplicate data, somewhat difficult to change.

A

Workgroup database

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

Support one or more enterprise processes. 100-1000s users.

A

Enterprise database

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

Procedures formalized, problem solutions affect enterprise.

A

Enterprise database

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

Eliminate workgroup data duplication, difficult to change

A

Enterprise database

36
Q

Support one or more inter-enterprise processes. 1000s users.

A

Inter-enterprise database

37
Q

system procedures formalized. problem solutions affect multiple organizations.

A

Inter-enterprise database

38
Q

Can resolve problems of duplicated enterprise data. very difficult to change

A

Inter-enterprise database

39
Q

_____database is when data is located at a single site

A

Centralized databased

40
Q

_____ database is when data is distributed across different sites

A

Distributed database

41
Q

Created and maintained using cloud data services that provide defined performance measures for the database

A

Cloud database

42
Q

Contains a wide variety of data used in multiple disciplines

A

General-purpose database

43
Q

Contains data focused on specific subject areas

A

Discipline-specific databases

44
Q

Designed to support a company’s day-to-day operations

A

operational database

45
Q

Stores historical data and business metrics used exclusively for tactical or strategic decision making

A

Analytical database

46
Q

Stores data in a format optimized for decision support

A

Data warehouse

47
Q

Enable retrieving, processing, and modeling data from the data warehouse

A

Online analytical processing

48
Q

Captures and processes business data to generate information that support decision making

A

Business intelligence

49
Q

data that exists in their original state

A

Unstructured data

50
Q

It results from formatting unstructured data to facilitate storage, use, and the generation of information.

A

Structured data

51
Q

Processes data to some extent.

A

semi-structured data

52
Q

A special language used to represent and manipulate data elements in textual format

A

Extensible Markup Language (XML)

53
Q

Focuses on the design of the database structure that will be used to store and manage end-user data

A

Database Design

54
Q

_____ database facilitates data management

A

Well-designed database

55
Q

________ database generates accurate and valuable information

A

Well-designed database

56
Q

______ database avoids redundant data

A

Well-designed database

57
Q

Causes difficult-to-trace errors, leads to bad decisions, can lead to failure of organization

A

Poorly designed database

58
Q

Raw facts. Have little meaning unless they have been organized in some logical manner.

A

Data

59
Q

A character or group pf characters that has a specific meaning. Used to define and store data.

A

Field

60
Q

A logically connected set of one or more fields.

A

Record

61
Q

A collection of related records.

A

File

62
Q

Lengthy development times, and difficult of getting quick answers

A

Problems with File System Data Processing

63
Q

Complex system administration

A

Problems with File System Data Processing

64
Q

Lack of security and limited data sharing. Extensive programming.

A

Problems with File System Data Processing

65
Q

Access to a file is dependent on its own structure

A

Structural dependence

66
Q

All file system programs are modified to conform to a new file structure

A

Structural dependence

67
Q

File structure is changed without affecting the application’s ability to access the data

A

Structural independence.

68
Q

Data access changes when data storage characteristics change

A

Data Dependence

69
Q

Data storage characteristics is changed without affecting the program’s ability to access the data

A

Data independence

70
Q

Unnecessarily storing same data at different places

A

Data redundancy

71
Q

Scattered data locations

A

Islands of information

72
Q

Increases the probability of having different versions of the same data

A

Data redundancy

73
Q

Implication - Poor data security and data inconsistency

A

Data Redundancy Implications

74
Q

Implication: Increased likelihood of data-entry errors when complex entries are made in different files

A

Data Redundancy Implications

75
Q

Develops when not all of the required changes in the redundant data are made successfully

A

Data anomaly

76
Q

Types of Data Anomay

A

Update anomalies, insertion anomalies, deletion anomalies

77
Q

Stores definitions of the data elements and their relationship

A

Data dictionary

78
Q

Ensures efficient performance of the database in terms of storage and access speed

A

Performance tuning

79
Q

Sophisticated algorithms ensure that multiple users can access the database concurrently without compromising its integrity

A

Multiuser access control

80
Q

Minimizes redundancy and maximizes consistency

A

Data integrity management

81
Q

Lets the user specify what must be done without having to specify how

A

query language

82
Q

A query language and data access standard supported by the majority of DBMS vendors

A

Structured Query Language (SQL)

83
Q

Increased costs, management complexity

A

Disadvantage of Database System

84
Q

Maintaining currency, vendor dependence

A

Disadvantage of Database System

85
Q

Frequent upgrade / replacement cycles.

A

Disadvantage of Database System

86
Q

To implement and manage a database, use a ____

A

DBMS

Business Data Management (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions