1. How can a database be defined?
|
a) A
set of information available on a computer via a purpose
built database program
b) A
paper document
c) A store of
data on any medium, e.g. a word document, spreadsheet
|
|
|
2. Which computing 'guru' developed the concept of Normalisation?
|
a) E.F.
GODD
b) E.F.
TODD
c) E.F. CODD
d) E.F. BODD
|
|
|
3. What does Normalisation involve?
|
a) Dividing
databases into two or more tables
b) Defining relationships
between tables
c) Both of the
above
|
|
|
4. What is an 'entity'??
|
a) The
key that is used to create the link between other tables
within the relational database.
b) A person, place, thing or event ; about which
we want to share data in the database
c) Part of the program that enables you to share information
d) A way of identifying a set of transactions belonging to a single group
|
|
|
5. What does the acronym 'DBMS' mean?
|
a) Database
Master Source
b) Data Build Management System
c) Database Management Source
d) Database Management System
|
|
|
6. If one rental car has had many customers, would this relationship
be described as?
|
a) One to Many
b) Many to One
c) Many to Many
d) None of the above
|
|
|
7. "Returning the database to its original, pre-change state" is
a statement to describe which function?
|
a) Rollback
b) Commit
c) Cascade
Update
d) Functional
Dependency
|
|
|
|
Database
Types exercise next >>>>
|
