Databases Flashcards

1
Q

What is a database?

A

a persistent organised store of data

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

What is the use of data handling software to create, maintain and interrogate a database?

A

q

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

How does a DBMS allow separation of data from applications and why this is desirable?

A

q

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

What are the principal features of DBMS and how can they be used to create customised data handling applications?

A

q

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

What is the relationship between entities and tables?

A

q

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

What are the components of a relational database?

A

q

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

How are logical operators used in framing database queries?

A

q

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

How are key fields used to connect tables and avoid data redundancy?

A

q

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

What are methods of validating data as it is input?

A

q

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