Database Package
Computer Studies · 50 practice questions
Definition of a database and examples of database packages (Dbase, Foxbase, MS Access, Oracle); basic database terms (file, record, field, key, form, table); database organizations (hierarchical, network, relational); features of database format in MS Access (files as tables, rows and columns); creating a database in MS Access (defining structure, field types, entering and saving data); basic operations on an existing database (searching, modifying, sorting, reporting, selecting, inserting).
- Define a database and give examples of database packages.
- Define basic database terms.
- List and explain different types of database organization.
- Create a database using MS Access and carry out basic operations on it.
Try a few questions
- Practice question 1
A field's data type in a database, such as text, number, or date, determines
- A.what kind of value can be stored within it
- B.the exact font used to display that field
- C.the exact physical location of the database server
- D.the exact colour displayed for that field
Show the answer
A. what kind of value can be stored within it
A field's data type constrains and defines what kind of value it is able to hold.
- Practice question 2
Filtering records in a database temporarily displays only those that meet
- A.no criteria at all, showing every record blindly
- B.criteria defined exclusively by the database software vendor
- C.criteria that change randomly with each use
- D.specific, user-defined criteria
Show the answer
D. specific, user-defined criteria
Filtering shows only the records matching criteria the user has specifically defined.
- Practice question 3
Database backups are essential for protecting against data loss due to
- A.hardware failure or accidental deletion
- B.the standard operation of a database management system
- C.authorized, routine data entry
- D.the normal process of running a query
Show the answer
A. hardware failure or accidental deletion
Backups specifically guard against the kind of data loss that hardware failures and accidental deletions can cause.
More UTME Computer Studies topics
Practise with instant feedback
Answer questions one at a time and see the right answer and the reason straight away. Free to start.
Start practising