Brainscape's Knowledge GenomeTM

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


See full index

Information Management > PRELIM CHAPTER 1 > Flashcards

PRELIM CHAPTER 1 Flashcards

1
Q

Good decisions require good information
derived from ___________

social media
internet
raw facts
ideas

A

raw facts

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

Data is managed most efficiently when
stored in a __________

A

database

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

(T or F) Databases evolved from computer file
systems

A

T

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

Databases are used in almost all modern settings
involving data management (3):

A
  • Business
  • Research
  • Administration
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

( T or F) Databases solve many of the problems
encountered in data management

A

T

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

__________ solve many of the problems
encountered in data management

A

databases

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

(T or F) Information is raw, unorganized facts that need to be processed

A

F

Data

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

___________ is the data processed, organized, structured, or presented in a given context so as to make it useful.

A

Information

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

A _________ is a 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
10
Q

Databases store a collection of ___________ and ____________

Metadata
Information
programs
end-user data

A

End-user data
Metadata

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
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
12
Q
  • data about data
  • Provides description of data characteristics and relationships in data
  • Complements and expands value of data
A

Metadata

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

DBMS means?

A

Database management systems

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

__________ manages structure and controls access to
data

A

DBMS

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

(T or F) DBMS prevents data to be shared

A

F

it enables data to be shared

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

(T or F) DBMS is the intermediary between the user and
the database

A

T

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

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

Databases can be classified according to (3):

A
  • Number of users
  • Database location(s)
  • Expected type and extent of use
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

(T or F) XML database supports unstructured XML
data

A

F

semistructured

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

_______________ supports only one user at a time

  • single- user databases
  • multi-user databases
  • centralized databases
  • distributed databases
A

single- user databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
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

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

_______________ data located at a single site

  • distributed databases
  • data warehouse
  • unstructured data
  • centralized databases
A

centralized databases

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

_______________ data distributed across
several different sites

  • distributed databases
  • data warehouse
  • multi-user databases
  • semistructured data
A

distributed databases

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

_______________ supports a company’s day-to-day operations

  • distributed databases
  • operational databases
  • data warehouse
  • unstructured data
A

operational databases

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

_______________ stores data used for tactical or strategic decisions

  • distributed databases
  • operational databases
  • data warehouse
  • unstructured data
A

data warehouse

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

_______________ stores data used for tactical or strategic decisions

  • unstructured data
  • structured data
  • semistructured data
  • extensible markup language XML
A

unstructured databases

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

_______________ have been processed to some extent

  • unstructured data
  • structured data
  • semistructured data
  • extensible markup language XML
A

semistructured data

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

_______________ result from formatting, applied based on the type of processing to be performed

  • unstructured data
  • structured data
  • semistructured data
  • extensible markup language XML
A

structured data

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

is data about data

A

Metadata

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

define the data characteristics
such as the data type (such as character or numeric) and the relationships that link the data.

A

metadata

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

are an important component of database design

A

Relationships

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

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

A
  • Complexity
  • file
  • converting
34
Q

typically composed of a collection of file folders, each tagged and kept in cabinet

  • database systems
  • file systems
  • information
  • manual systems
A

file systems

35
Q

(T or F) Contents of each file folder are logically related

A

T

36
Q

Served as a data repository for small data collections

  • database systems
  • file systems
  • Computerized file systems
  • Manual file systems
A

Manual file systems

37
Q

Manual file systems are convenient for large collections

A

F

It is cumbersome for large collections

38
Q

Data processing (DP) specialist converted computer file structure from manual system

A

Computerized file systems

39
Q

organizes and stores your business’s files on a hard drive or network space

  • database systems
  • file systems
  • Computerized file systems
  • Manual file systems
A

Computerized file systems

40
Q

(T or F) Initially, computer file systems resembled manual systems

A

T

41
Q

(T or F) As the number of files increased, file systems evolved

A

T

42
Q

Each file used its own ___________ program to store, retrieve, and modify data

-

A

application

43
Q

Each file was owned by an individual or department that commissioned its __________

  • data
  • creation
  • information
  • system
A

creation

44
Q

_______ have little meaning unless they have been organized in some logical manner

  • data
  • field
  • record
  • file
A

data

45
Q

These are raw facts such as name, phone number, birth date etc.

  • data
  • field
  • record
  • file
A

data

46
Q

A character or group of characters that has a specific meaning.

  • data
  • field
  • record
  • file
A

field

47
Q

used to define and store data

  • data
  • field
  • record
  • file
A

field

48
Q

a logically connected set of one or more fields

  • data
  • field
  • record
  • file
A

record

49
Q

a collection of related records

  • data
  • field
  • record
  • file
A

file

50
Q

is Widely used by business users

A

Microsoft Excel

51
Q

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

A

extensive
ad hoc
complex
changes
Security

51
Q

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
__________

A

programming
perform
administration
structures
inadequate

52
Q

Access to a file is dependent on its own structure

  • Structural dependence
  • Structural independence
  • Data dependence
  • Data independence
A

Structural dependence

53
Q

(T or F) All file system programs doesn’t have to be modified to conform to a new file structure

A

F

All file system programs must be modified to
conform to a new file structure

54
Q

change file structure without affecting data access

  • Structural dependence
  • Structural independence
  • Data dependence
  • Data independence
A

Structural independence

55
Q

data access changes when data storage characteristics change

  • Structural dependence
  • Structural independence
  • Data dependence
  • Data independence
A

Data dependence

56
Q

data storage characteristics do not affect data access

  • Structural dependence
  • Structural independence
  • Data dependence
  • Data independence
A

Data independence

57
Q

(T or F) File system is vulnerable to security breaches

A

T

58
Q

promotes storage of same data in different locations

A

Organizational structure

59
Q

(T or F) Data stored in different locations is likely to be updated consistently

A

F

Data stored in different locations is unlikely to be updated consistently

60
Q

Same data stored unnecessarily in different places is an example of data ____________

  • redundancy
  • inconsistency
  • anomalies
A

redundancy

61
Q

data _________ means different and conflicting versions of same data occur at different places

  • redundancy
  • inconsistency
  • anomalies
A

inconsistency

62
Q

Data anomalies (3):

A
  • Update anomalies
  • Insertion anomalies
  • Deletion anomalies
63
Q

data _________ are abnormalities when all changes in redundant data are not made correctly

  • redundancy
  • inconsistency
  • anomalies
A

anomalies

64
Q

consists of logically related data stored in a single logical data repository

A

Database system

65
Q

(T or F) Database system May be physically distributed among multiple storage facilities

A

T

66
Q

eliminates most of file system’s problems

  • file system
  • manual file system
  • DBMS
A

DBMS

67
Q

defines and regulates the collection, storage, management, use of data

A

Database system

68
Q

Five major parts of a database system:

A
  • Hardware
  • Software
  • People
  • Procedures
  • Data
69
Q

provides a framework in which strict procedures and standards enforced

  • database system
  • file systems
  • Computerized file systems
  • Manual file systems
A

database system

70
Q

Data ______ created within the database and their relationships determine effectiveness

  • system
  • structures
  • files
  • records
A

structures

71
Q

Disadvantages of database
systems:
* Increased _______
* Management _______
* Maintaining _______
* _______ dependence
* Frequent upgrade/replacement cycles

A

costs
complexity
currency
Vendor

72
Q

Disadvantages of database
systems:
* Increased _________
* Management _________
* Maintaining _________
* _________ dependence
* Frequent upgrade/replacement cycles

A

costs
complexity
currency
Vendor

73
Q

Creates and maintains database-based applications

  • database developer
  • database designer
  • database analyst
  • database architect
  • database consultant
  • database security officer
A

database developer

74
Q

designs and maintains databases

  • database developer
  • database designer
  • database analyst
  • database architect
  • database consultant
  • database security officer
A

database designer

75
Q

Manages and maintains DBMS and databases

  • database developer
  • database designer
  • database administrator
  • database analyst
  • database architect
  • database consultant
  • database security officer
A

database administrator

76
Q

Develops databases for decision support reporting

  • database developer
  • database designer
  • database analyst
  • database architect
  • database consultant
  • database security officer
A

database analyst

77
Q

Designs and implements database environments

  • database developer
  • database designer
  • database analyst
  • database architect
  • database consultant
  • database security officer
A

database architect

78
Q

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
A

database consultant

79
Q

Implements security policies for data administration
- database developer
- database designer
- database analyst
- database architect
- database consultant
- database security officer

A

database security officer

Information Management (4 decks)

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