Databases Flashcards

1
Q

What is a:

Table

A

Data structure that contains a collection of records

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

What is a:

Record

A

Information about a person or thing. It is a collection of fields

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

What is a:

Field

A

One peice of information about a record

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

What is a:

Data type

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

What is a:

Primary key

A

A unique field to differentiate different people/things

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

What are the different:

Data types

A
  • Text
  • Character
  • Boolean
  • Integer
  • Real
  • Date/time
  • Currency
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are the different types of:

Databases

A
  • Single table
  • Flat file (only one you need to know)
  • regional
How well did you know this?
1
Not at all
2
3
4
5
Perfectly