Try these Questions in preparation for our End of Year Exam
Database design
1. List the FOUR major components of a database in ascending order
a) _____________________________________________________
b) _____________________________________________________
c) _____________________________________________________
d) _____________________________________________________
2. Define the term ‘database’
3. Briefly compare a flat file database with a DBMS
4. When would the user need to sort a database?
5. Why would the FIND command be used to locate data in a database rather than using a query language search?
6. How is a relational operator different from a logical query?
7. The data in a database includes the following:
|
Dog
|
Breed
|
File _name
|
Size
|
|
Terrier
|
Tenterfield
|
Terrier1.gif
|
45kB
|
|
Beagle
|
Golden
|
Beag8.gif
|
125kB
|
|
Great Dane
|
American
|
Dane9.jpg
|
.547MB
|
Write the records that would result from the following queries:
a) Size<50kB __________________________________________
b) Breed=Terrier AND Size>40kB __________________________
c) File _Name CONTAINS .jpg OR Breed=Golden
8. What is a FILTER?
digital media
1. What is binary code?
2. How is data digitised?
3. Why is copying digitised data a major advantage?
4. Define the term ‘input hardware’
5. Hardware digitising devices include scanners. Name TWO different types of scanner.
6. Give TWO examples of pointing devices.
7. Explain the two major factors that are important to the choice of hardware for digital media.
8. Digital data can be manipulated transmitted and displayed. Briefly explain the meaning of ‘transmission’ and ‘display’.
9. Draw and label TWO examples of manipulation techniques that may be used with images.