Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Database Practice Questions

VIEWS: 105 PAGES: 3

									                 Name___________________


                Databases Practice Task

1. (a) Give 2 advantages of storing records electronically than
in filing cabinets?                                         (2)




(b) Give 3 examples of database being used in real life?    (3)




(c) Which GPP package do we use for creating databases?     (1)




2. A part of the DVLA database can be seen below.




(a) Give 1 example of a Record                              (1)
(b) Give 1 example of a Field                               (1)




(c) What is a Data File?                                    (1)




(d) Give 2 field types that could be used in the database   (2)




(e) Another driver is added to the database. List the correct
order of the steps. Enter steps 1 – 4 in the correct boxes

     Close the DVLA Database File

     Open the DVLA Database File

     Enter the new Data

     Print the Database



(f) The manager wants a printout of all the drivers who have 6
months left on their Road Tax. How could this be done?
(explain the search)                                       (3)
(f) The manager wants a printout of all the drivers who have
had their license for more than 5 years and more than 6
penalty points on their license. How could this be done?
(explain the search)                                 (6)

(c) What would be the best “Field Type” for each of the fields
                                                           (2)
          Field Name           Field Type
          Forename
          Surname
          Date of Birth
          Bank Balance
          Sort Code


(d) It would be beneficial if the bank could organise the
records in alphabetical order of surname. How could this be
done?                                                    (3)

								
To top