NEW
Font size
WorksheetsDatabase Knowledge Quiz
Total questions: 58
Worksheet time: 29mins
What is a database?
A computer virus
A collection of related data organized for easy access
A type of computer hardware
A software used only for typing
A database is mainly created in order to ______.
Play games
Store and retrieve data later
Print documents
Browse the internet
Which of the following is an example of a database?
A television programme
A list of students in JSS3
A keyboard
A mouse
What type of IP address is highlighted in the image ?
IPV1
IPV6
IPV4
IPV2
A manual database is stored using ______.
Cloud servers
Filing cabinets
Hard disks
Flash drives
One advantage of a manual database is that it ______.
Is fast to search
Uses electricity
Cannot be infected by computer viruses
Is easy to share
Which of the following is a disadvantage of a manual database?
Cheap to operate
Does not require electricity
Time-consuming to retrieve records
Cannot be stolen
Manual databases are vulnerable to ______.
Computer hacking
Power failure
Fire and theft
Software errors
A computerized database uses ______ to store data.
Humans only
Computers
Filing cabinets
Paper files
Which of the following is an advantage of a computerized database?
Difficult data editing
Slower data retrieval
Easier data updating
High paper usage
Which is NOT an advantage of a computerized database?
Faster data retrieval
Data security
Reduced paper use
Easy data loss
A Database Management System (DBMS) is ______.
A computer hardware
A software for creating and managing databases
A virus scanner
A word processor
Which of the following is a DBMS?
Microsoft Word
MySQL
Paint
PowerPoint
SQLite is an example of ______.
Operating system
Programming language
Database management system
Spreadsheet
Which DBMS is commonly used in schools?
Microsoft Access
Adobe Photoshop
CorelDraw
Notepad
Which sector uses databases for account details and transactions?
Airlines
Banking
Schools
Hospitals
Airline databases are mainly used for ______.
Medical records
Examination results
Reservations and schedules
Employee salaries
Universities use databases mainly for ______.
Sports activities
Student information and grades
Cooking records
Security patrols
Raw facts like numbers and names are called ______.
Information
Data
Records
Fields
Which of the following is an example of data?
A report card
Examination result analysis
89
A student profile
A database field is best described as ______.
A table row
A set of related tables
A column in a table
A whole database
Fields in a table make up the ______.
Rows
Columns
Records
Queries
A record is a collection of ______ about the same subject..
Tables
Databases
Fields
Queries
Records are stored as ______ in a table
Columns
Rows
Fields
Queries
Which of the following best defines a record?
Raw data
A collection of fields about one person or item
A database software
A query result
A key in a database is used to ______.
Delete records
Print tables
Uniquely identify records
Create forms
Which of the following is a type of key?
Table key
Primary key
Data key
Record key
A primary key must be ______.
Repeated
Empty
Unique
Optional
Which of the following can serve as a primary key?
Student name
Phone number
Student registration number
Age
Which of the following is a database model?
Foreign key
Relation
Heirarchical
Hierarchical
A table is made up of ______.
Files and folders
Records and fields
Software and hardware
Queries and reports
Columns in a table represent ______.
Records
Fields
Queries
Reports
A database form is mainly used to ______.
Store tables
Enter and edit data
Delete databases
Create keys
Which database object helps users input data easily?
Table
Query
Form
Report
A query is a request for ______.
Hardware
Data from a database
Software installation
Virus scanning
Queries are used mainly to ______.
Store data
Search and retrieve data
Print forms
Design tables
A database report is ______.
Raw data
A formatted output of data
A table column
A database field
Reports are mainly used for ______.
Data entry
Decision making
Programming
Virus protection
A database model describes how data is ______.
Deleted
Printed
Structured and stored
Lost
Which is NOT a type of database model?
Hierarchical
Network
Relational
Circular
The hierarchical database model looks like a ______.
Circle
Table
Tree
Grid
In the hierarchical model, each child has ______ parent.
No
Multiple
One
Unlimited
The main disadvantage of the hierarchical model is that ______.
It is fast
Data is duplicated
Whole tree must be searched
It uses tables
The network database model allows a child to have ______.
One parent only
No parent
Multiple parents
No relationship
The network model was developed to overcome the drawbacks of the ______ model.
Relational
Flat file
Hierarchical
Manual
The relational database model organizes data in the form of ______.
Trees
Networks
Tables
Graphs
Which database model is most commonly used today?
Hierarchical
Network
Relational
Manual
Rows in a relational table represent ______.
Fields
Records
Queries
Keys
Columns in a relational table represent ______.
Records
Tables
Fields
Databases
Which of these is NOT a database object?
Table
Form
Report
Keyboard
Data security is an advantage of ______ databases.
Manual
Paper
Computerized
Physical
Which database system reduces calculation errors?
Manual database
Filing system
Computerized database
Notebook
Which of the following best describes data?
Processed facts
Raw facts
Printed results
Reports
Which item is best stored in a hospital database?
Flight schedules
Student grades
Patient records
Examination timetable
Which key uniquely identifies a record?
Candidate key
Foreign key
Primary key
Secondary key
Easy data sharing is an advantage of ______.
Manual databases
Computerized databases
Paper files
Filing cabinets
Which database object produces printed output?
Query
Table
Form
Report
A table in a database contains ______.
Only one record
Only one field
Related records and fields
Only raw data
