NEW
Font size
WorksheetsDatabase Management Quiz
Total questions: 15
Worksheet time: 14mins
A Primary Key is a code that uniquely identifies a _____________ in a Database.
Record
Field
Text
Number
In a database table, each rows are called __________
Fields
Records
Primary Keys
Foreign Keys
Each item of information within a record is called a ...
form
field
record
report
What is a suitable data type for Age?
Text
Number
Currency
Yes/No
The term DBMS stands for
Database Microsoft
Database Micro System
Database Management System
Database Building Management System
Which of the following application software can be used to create our databases?
Ms Excel
Ms Word
Notepad
Ms Access
A field such as Item Price is considered to have this data type
Text
Currency
Date/Time
Number
All of the following are disadvantages of manual database EXCEPT:
Folders are easily misplaced.
Large amounts of storage space are required to store files.
Cross-referencing information from different files is difficult.
Retrieval of simple information is relatively fast and easy
Which of the following is not an example of a data type?
Number
Yes/No
Entity
Date/ Time
An organized collection of related records is a
Table
Cell
Report
Field
How many records are in the table?
2
5
1
4
How many fields are in the record?
2
5
1
4
Which of the following fields can be used as a primary key?
Firstname
Age
Address
ID number
