PRELIM CHAPTER 1 Flashcards
1
Q
Good decisions require good information
derived from ___________
social media
internet
raw facts
ideas
A
raw facts
2
Q
Data is managed most efficiently when
stored in a __________
A
database
3
Q
(T or F) Databases evolved from computer file
systems
A
T
4
Q
Databases are used in almost all modern settings
involving data management (3):
A
- Business
- Research
- Administration
5
Q
( T or F) Databases solve many of the problems
encountered in data management
A
T
6
Q
__________ solve many of the problems
encountered in data management
A
databases
7
Q
(T or F) Information is raw, unorganized facts that need to be processed
A
F
Data
8
Q
___________ is the data processed, organized, structured, or presented in a given context so as to make it useful.
A
Information
9
Q
A _________ is a shared, integrated computer structure that stores a collection of end-user data and metadata
A
database
10
Q
Databases store a collection of ___________ and ____________
Metadata
Information
programs
end-user data
A
End-user data
Metadata
11
Q
__________ - raw facts of interest to end
user
A
end- user data
12
Q
- data about data
- Provides description of data characteristics and relationships in data
- Complements and expands value of data
A
Metadata
13
Q
DBMS means?
A
Database management systems
14
Q
__________ manages structure and controls access to
data
A
DBMS
15
Q
(T or F) DBMS prevents data to be shared
A
F
it enables data to be shared
16
Q
(T or F) DBMS is the intermediary between the user and
the database
A
T
17
Q
Advantages of a DBMS (7):
A
*Improved data sharing
*Improved data security
*Better data integration
*Minimized data inconsistency
*Improved data access
*Improved decision making
*Increased end-user productivity
18
Q
Databases can be classified according to (3):
A
- Number of users
- Database location(s)
- Expected type and extent of use
19
Q
Types of databases(10):
A
- single- user databases
- multi-user databases
- centralized databases
- distributed databases
- operational databases
- data warehouse
- unstructured data
- structured data
- semistructured data
- extensible markup language XML
20
Q
(T or F) XML database supports unstructured XML
data
A
F
semistructured
21
Q
_______________ supports only one user at a time
- single- user databases
- multi-user databases
- centralized databases
- distributed databases
A
single- user databases
22
Q
_______________ supports multiple users at the same time
- single- user databases
- multi-user databases
- semistructured data
- extensible markup language XML
A
multi-user databases
23
Q
_______________ data located at a single site
- distributed databases
- data warehouse
- unstructured data
- centralized databases
A
centralized databases
24
Q
_______________ data distributed across
several different sites
- distributed databases
- data warehouse
- multi-user databases
- semistructured data
A
distributed databases
25
_______________ supports a company’s day-to-day operations
* distributed databases
* operational databases
* data warehouse
* unstructured data
operational databases
26
_______________ stores data used for tactical or strategic decisions
* distributed databases
* operational databases
* data warehouse
* unstructured data
data warehouse
27
_______________ stores data used for tactical or strategic decisions
* unstructured data
* structured data
* semistructured data
* extensible markup language XML
unstructured databases
28
_______________ have been processed to some extent
* unstructured data
* structured data
* semistructured data
* extensible markup language XML
semistructured data
29
_______________ result from formatting, applied based on the type of processing to be performed
* unstructured data
* structured data
* semistructured data
* extensible markup language XML
structured data
30
is data about data
Metadata
31
define the data characteristics
such as the data type (such as character or numeric) and the relationships that link the data.
metadata
32
are an important component of database design
Relationships
33
Reasons for studying file systems:
* ___________ of database design is easier to
understand
* Understanding ___________ system problems helps to
avoid problems with DBMS systems
* Knowledge of file system is useful for ___________
file system to database system
- Complexity
- file
- converting
34
typically composed of a collection of file folders, each tagged and kept in cabinet
- database systems
- file systems
- information
- manual systems
file systems
35
(T or F) Contents of each file folder are logically related
T
36
Served as a data repository for small data collections
- database systems
- file systems
- Computerized file systems
- Manual file systems
Manual file systems
37
Manual file systems are convenient for large collections
F
It is cumbersome for large collections
38
Data processing (DP) specialist converted computer file structure from manual system
Computerized file systems
39
organizes and stores your business's files on a hard drive or network space
- database systems
- file systems
- Computerized file systems
- Manual file systems
Computerized file systems
40
(T or F) Initially, computer file systems resembled manual systems
T
41
(T or F) As the number of files increased, file systems evolved
T
42
Each file used its own ___________ program to store, retrieve, and modify data
-
application
43
Each file was owned by an individual or department that commissioned its __________
- data
- creation
- information
- system
creation
44
_______ have little meaning unless they have been organized in some logical manner
- data
- field
- record
- file
data
45
These are raw facts such as name, phone number, birth date etc.
- data
- field
- record
- file
data
46
A character or group of characters that has a specific meaning.
- data
- field
- record
- file
field
47
used to define and store data
- data
- field
- record
- file
field
48
a logically connected set of one or more fields
- data
- field
- record
- file
record
49
a collection of related records
- data
- field
- record
- file
file
50
is Widely used by business users
Microsoft Excel
51
Summary of file system limitations:
* Requires _______ programming
* Cannot perform _______ queries
* System administration is _______ and
difficult
* Difficult to make _______ to existing
structures
* _______ features are likely to be
inadequate
extensive
ad hoc
complex
changes
Security
51
Summary of file system limitations:
* Requires extensive __________
* Cannot __________ ad hoc queries
* System __________ is complex and
difficult
* Difficult to make changes to existing
__________
* Security features are likely to be
__________
programming
perform
administration
structures
inadequate
52
Access to a file is dependent on its own structure
- Structural dependence
- Structural independence
- Data dependence
- Data independence
Structural dependence
53
(T or F) All file system programs doesn't have to be modified to conform to a new file structure
F
All file system programs must be modified to
conform to a new file structure
54
change file structure without affecting data access
- Structural dependence
- Structural independence
- Data dependence
- Data independence
Structural independence
55
data access changes when data storage characteristics change
- Structural dependence
- Structural independence
- Data dependence
- Data independence
Data dependence
56
data storage characteristics do not affect data access
- Structural dependence
- Structural independence
- Data dependence
- Data independence
Data independence
57
(T or F) File system is vulnerable to security breaches
T
58
promotes storage of same data in different locations
Organizational structure
59
(T or F) Data stored in different locations is likely to be updated consistently
F
Data stored in different locations is unlikely to be updated consistently
60
Same data stored unnecessarily in different places is an example of data ____________
- redundancy
- inconsistency
- anomalies
redundancy
61
data _________ means different and conflicting versions of same data occur at different places
- redundancy
- inconsistency
- anomalies
inconsistency
62
Data anomalies (3):
* Update anomalies
* Insertion anomalies
* Deletion anomalies
63
data _________ are abnormalities when all changes in redundant data are not made correctly
- redundancy
- inconsistency
- anomalies
anomalies
64
consists of logically related data stored in a single logical data repository
Database system
65
(T or F) Database system May be physically distributed among multiple storage facilities
T
66
eliminates most of file system’s problems
- file system
- manual file system
- DBMS
DBMS
67
defines and regulates the collection, storage, management, use of data
Database system
68
Five major parts of a database system:
* Hardware
* Software
* People
* Procedures
* Data
69
provides a framework in which strict procedures and standards enforced
- database system
- file systems
- Computerized file systems
- Manual file systems
database system
70
Data ______ created within the database and their relationships determine effectiveness
- system
- structures
- files
- records
structures
71
Disadvantages of database
systems:
* Increased _______
* Management _______
* Maintaining _______
* _______ dependence
* Frequent upgrade/replacement cycles
costs
complexity
currency
Vendor
72
Disadvantages of database
systems:
* Increased _________
* Management _________
* Maintaining _________
* _________ dependence
* Frequent upgrade/replacement cycles
costs
complexity
currency
Vendor
73
Creates and maintains database-based applications
- database developer
- database designer
- database analyst
- database architect
- database consultant
- database security officer
database developer
74
designs and maintains databases
- database developer
- database designer
- database analyst
- database architect
- database consultant
- database security officer
database designer
75
Manages and maintains DBMS and databases
- database developer
- database designer
- database administrator
- database analyst
- database architect
- database consultant
- database security officer
database administrator
76
Develops databases for decision support reporting
- database developer
- database designer
- database analyst
- database architect
- database consultant
- database security officer
database analyst
77
Designs and implements database environments
- database developer
- database designer
- database analyst
- database architect
- database consultant
- database security officer
database architect
78
Helps companies leverage databases technologies to improve business processes and achieve specific goals
- database developer
- database designer
- database analyst
- database architect
- database consultant
- database security officer
database consultant
79
Implements security policies for data administration
- database developer
- database designer
- database analyst
- database architect
- database consultant
- database security officer
database security officer
