Test Flashcards

1
Q

Advantages of a computerised database over a paper based database?

A

Easier to search and find what you’re looking for
Can’t lose it as you can make a back-up
Can make changes to it very easily

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

What are ‘Name, Address, Phone number, Card details’ an example of?

A

FIELDs

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

What are FIELDS?

A

One piece of information about the customer

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

What is a record?

A

All the information (fields) that is about ONE CUSTOMER

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

How many characters can you have in a short text?

A

You have a limit of 255 characters

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

How many characters can you have in a long text?

A

More than 255 characters

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

What is a query?

A

A Query is a way of asking a question, in order to find information from a Database.

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

What is a flat file?

A

A flat file consists of a single table of data

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