Chapter 3 Flashcards

1
Q

What are concurrency control strategies?

A

Features of a database that allow several users access to the same data item at the same time.

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

What is a data type?

A

Determines the sort of data permitted in a field, for example numbers only.

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

What is data uniqueness?

A

Ensures that no duplicates are entered.

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

What is a database constraint?

A

A restriction that determines what is allowed to be entered or edited in a table.

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

What is metadata?

A

Defines and describes the data and relationships between tables in the database.

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

What are read and write privileges?

A

The ability to both read and modify a file.

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

What is read-only access?

A

The ability to read a file but not make changes.

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

What does self-describing mean in a database system?

A

A database system is referred to as self-describing because it not only contains the database itself, but also metadata which defines and describes the data and relationships between tables in the database.

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

What is a view in a database?

A

A subset of the database.

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