Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Business Data Management > Quiz 1 - Part 1 > Flashcards

Quiz 1 - Part 1 Flashcards

(86 cards)

Start Studying
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
Improves data sharing, security, access, and decision making
Database management system
26
Supports one user at a time
Single-user database
27
Supports multiple users at the same time
Multiuser database
28
Supports a small number of users or a specific department
Workgroup database
29
Support many users across many departments.
Enterprise database
30
Support one or more workgroup processes. 10-100 users.
Workgroup database
31
Procedures often formalized. problem solution within group.
Workgroup database
32
Can duplicate data, somewhat difficult to change.
Workgroup database
33
Support one or more enterprise processes. 100-1000s users.
Enterprise database
34
Procedures formalized, problem solutions affect enterprise.
Enterprise database
35
Eliminate workgroup data duplication, difficult to change
Enterprise database
36
Support one or more inter-enterprise processes. 1000s users.
Inter-enterprise database
37
system procedures formalized. problem solutions affect multiple organizations.
Inter-enterprise database
38
Can resolve problems of duplicated enterprise data. very difficult to change
Inter-enterprise database
39
_____database is when data is located at a single site
Centralized databased
40
_____ database is when data is distributed across different sites
Distributed database
41
Created and maintained using cloud data services that provide defined performance measures for the database
Cloud database
42
Contains a wide variety of data used in multiple disciplines
General-purpose database
43
Contains data focused on specific subject areas
Discipline-specific databases
44
Designed to support a company’s day-to-day operations
operational database
45
Stores historical data and business metrics used exclusively for tactical or strategic decision making
Analytical database
46
Stores data in a format optimized for decision support
Data warehouse
47
Enable retrieving, processing, and modeling data from the data warehouse
Online analytical processing
48
Captures and processes business data to generate information that support decision making
Business intelligence
49
data that exists in their original state
Unstructured data
50
It results from formatting unstructured data to facilitate storage, use, and the generation of information.
Structured data
51
Processes data to some extent.
semi-structured data
52
A special language used to represent and manipulate data elements in textual format
Extensible Markup Language (XML)
53
Focuses on the design of the database structure that will be used to store and manage end-user data
Database Design
54
_____ database facilitates data management
Well-designed database
55
________ database generates accurate and valuable information
Well-designed database
56
______ database avoids redundant data
Well-designed database
57
Causes difficult-to-trace errors, leads to bad decisions, can lead to failure of organization
Poorly designed database
58
Raw facts. Have little meaning unless they have been organized in some logical manner.
Data
59
A character or group pf characters that has a specific meaning. Used to define and store data.
Field
60
A logically connected set of one or more fields.
Record
61
A collection of related records.
File
62
Lengthy development times, and difficult of getting quick answers
Problems with File System Data Processing
63
Complex system administration
Problems with File System Data Processing
64
Lack of security and limited data sharing. Extensive programming.
Problems with File System Data Processing
65
Access to a file is dependent on its own structure
Structural dependence
66
All file system programs are modified to conform to a new file structure
Structural dependence
67
File structure is changed without affecting the application’s ability to access the data
Structural independence.
68
Data access changes when data storage characteristics change
Data Dependence
69
Data storage characteristics is changed without affecting the program’s ability to access the data
Data independence
70
Unnecessarily storing same data at different places
Data redundancy
71
Scattered data locations
Islands of information
72
Increases the probability of having different versions of the same data
Data redundancy
73
Implication - Poor data security and data inconsistency
Data Redundancy Implications
74
Implication: Increased likelihood of data-entry errors when complex entries are made in different files
Data Redundancy Implications
75
Develops when not all of the required changes in the redundant data are made successfully
Data anomaly
76
Types of Data Anomay
Update anomalies, insertion anomalies, deletion anomalies
77
Stores definitions of the data elements and their relationship
Data dictionary
78
Ensures efficient performance of the database in terms of storage and access speed
Performance tuning
79
Sophisticated algorithms ensure that multiple users can access the database concurrently without compromising its integrity
Multiuser access control
80
Minimizes redundancy and maximizes consistency
Data integrity management
81
Lets the user specify what must be done without having to specify how
query language
82
A query language and data access standard supported by the majority of DBMS vendors
Structured Query Language (SQL)
83
Increased costs, management complexity
Disadvantage of Database System
84
Maintaining currency, vendor dependence
Disadvantage of Database System
85
Frequent upgrade / replacement cycles.
Disadvantage of Database System
86
To implement and manage a database, use a ____
DBMS

Business Data Management (6 decks)

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