PRELIM Quiz 1 Lec Flashcards

1
Q

It is the foundation of information, which is the bedrock of knowledge.

A

Data

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

Data is _ , unorganized facts that need to be processed.

A

raw

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

It 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
4
Q

_ is a collection of programs that manages structure and controls access to data. (Acronym is not allowed)

A

database management systems

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

The following are the roles and advantages of DBMS:

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
6
Q

The following are the roles and advantages of DBMS:
*Improved _________ sharing
*Improved data _________
*Better data _________
*Minimized data _________
*Improved _________ access
*Improved decision _________
*Increased _________ productivity

A
  • data
  • security
  • integration
  • inconsistency
  • data
  • making
  • end-user
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Workgroup and enterprise database are examples of this type of database:

A

Multi-user Database

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

This type of database stores data used for tactical or strategic decisions.

Data Warehouse
Operational
Distributed
Centralized

A

Data Warehouse

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

(T or F) File systems typically composed of collection of file folders, each tagged and kept in cabinet

A

T

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

(T or F) Knowledge of file system is useful when converting file system to database system

A

T

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

(T or F) In DBMS each file used its own application program to store, retrieve and modify data.

A

F

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

It is a character or group of characters that has a specific meaning. It is used to define and store data.
- record
- data
- file
- field

A

field

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

A logically connected set of one or more fields that describes a person, place or thing.

data
field
record
file

A

record

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

(T or F) If the same data is stored unnecessarily in different places, then data redundancy is present.

A

T

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

Data _ : different and conflicting versions of same data occur at different places

A

inconsistency

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

Five major parts of a database system are:

Hardware
Software
People
_
Data

A

procedure

17
Q

Disadvantages of database systems:
* Increased _________
* Management _________
* Maintaining currency
* Vendor _________
* Frequent upgrade/replacement _________

A
  • cost
  • complexity
  • dependence
  • cycles