20 questions
What is a Database?
A database is a hardware like hard drive.
A database is a spreadsheet.
A database is an organized collection of data.
A database is file of data.
Select the right answer Which 2 are database software?
Microsoft Open Office & MS Powerpoint
MS Excel & MS Access
MS Access & MS Powerpoint
MS word & MS Excel
What type of data stored in the Name field?
Date and time
Numeric
text
yes/no
What type of data is stored in the shoe size field?
Numeric
yes/no
alphanumeric
text
what data type is stored in Sports field?
text
numeric
yes/no
alphanumeric
What type of data is stored in Hair Colour field?
yes/no
alphanumeric
Data / time
text
This type of data can only have two values: TRUE or FALSE and YES or NO?
Alphanumeric/text
Logical Boolean
Date/Time
Numeric
This data type refers to data made up to letters and numbers symbols and spaces?
Numeric
Date and time
Alphanumeric/text
Currency
This type of data can store two types of numbers a whole numbers and a decimal numbers?
Alphanumeric
Numeric
Currency
Logical Boolean
This data types stores data in a date or time format?
Alphanumeric
Logical Boolean
Numeric
Date/time
This type of data stores money values in the database?
Numeric
Currency
Alphanumeric
Numbers
_______ is a single description of an object or a person?
_______ contains all the data relating to a single person or object.
_______ is a piece of data that is unique to a particular record.
_______ holds a collection of records. e.g. student file holds record for all the pupils in a school.
__________ restricts the user to the data they can enter.
________ is an automatic computer check to ensure that the data entered is sensible and reasonable.
________ checks the data being entered is within a specified range.
________ is a type of validation checks that checks the data being entered is within a certain number of characters.
_______ used to checks large numbers.