1
Q
What is the smallest unit of computer memory?
A
Bit
2
Q
How many bits are in a byte?
A
8 Bits
3
Q
How many bytes are in a kilobyte?
A
1,024 Bytes
4
Q
How many kilobytes are in a megabyte?
A
1,024 KB
5
Q
How many megabytes are in a gigabyte?
A
1,024 MB
6
Q
How many gigabytes are in a terabyte?
A
1,024 GB
7
Q
Fill in the blank: 1 _______ is equal to 1,024 Bytes.
A
Kilobyte
8
Q
Fill in the blank: 1 _______ is equal to 1,024 KB.
A
Megabyte
9
Q
Fill in the blank: 1 _______ is equal to 1,024 MB.
A
Gigabyte
10
Q
Fill in the blank: 1 _______ is equal to 1,024 GB.
A
Terabyte
11
Q
What must we tell the computer before entering data into a system?
A
What type of data it is
12
Q
Why do we need to specify the type of data to the computer?
A
Because the computer stores and processes different types of data in different ways
13
Q
Fill in the blank: The computer stores and processes different types of data in _______.
A
different ways
14
Q
What are real numbers?
A
Any number that you can place on a number line
Real numbers include whole numbers (integers) and numbers with decimal/fractional parts. They can be positive or negative.
15
Q
What types of numbers are included in real numbers?
A
- Whole numbers (integers)
- Numbers with decimal/fractional parts
Real numbers can be both positive and negative.
16
Q
True or False: Real numbers can only be positive.
A
False
Real numbers can be positive or negative.
17
Q
Fill in the blank: Real numbers can be referred to as ______.
A
single, double, or float
This terminology is often used in computer software for real data types.
18
Q
What does currency refer to?
A
Real numbers that are formatted in a specific way
19
Q
How is currency usually displayed?
A
With a currency symbol and usually two decimal places
20
Q
Fill in the blank: Currency is shown with a _______ and usually two decimal places.
A
[currency symbol]
21
Q
True or False: Currency can be represented without decimal places.
A
False
22
Q
What does percentage refer to?
A
Fractional real numbers formatted out of 100 with a percent symbol.
23
Q
How is the real value 0.5 represented as a percentage?
A
50%.
24
Q
What percentage corresponds to the real value 0.01?
A
1%.
25
How is the number 1.25 expressed in percentage form?
125%.
26
How is 50% stored inside a computer?
As a real number: 0.5.
27
What happens to the value when it is displayed as a percentage?
It is shown formatted as a percentage.
28
What does ALPHANUMERIC (TEXT) DATA refer to?
Data made up of letters (alphabet) and numbers (numeric)
## Footnote
It usually includes symbols and spaces.
29
What symbols are typically allowed in ALPHANUMERIC (TEXT) DATA?
Symbols such as:
* $#%@
* Spaces
30
How is text data usually indicated when input into a computer?
With speech marks (" ") around it
## Footnote
Example: "MONKEY"
31
True or False: ALPHANUMERIC data can only include letters and numbers.
False
## Footnote
It can also include symbols and spaces.
32
Fill in the blank: ALPHANUMERIC (TEXT) DATA is often simply called _______.
TEXT
33
What does the format of date and time data depend on?
The format depends upon the setup of the computer, the software in use, and the user's preferences.
34
What is the international date format for 06/09/08?
6th September 2008.
35
What date does 06/09/08 represent in American style?
9th June 2008.
36
What should be checked when inputting dates?
Check your computer's settings.
37
Fill in the blank: The date format can vary between _______ and _______.
American style; international style.
38
True or False: The date 23/09/78 is formatted according to American style.
False.
39
What time is indicated in the example provided?
8:49am.
40
What is a potential issue when inputting dates?
Particular care has to be taken if the data contains American style dates and the computer is set up to expect international style dates.
41
What is BOOLEAN data sometimes referred to as?
BOOLEAN data is sometimes called 'logical' data
## Footnote
BOOLEAN data can also be referred to as 'YES/NO' data in some software.
42
How many values can BOOLEAN data have?
BOOLEAN data can only have two values: TRUE or FALSE.
43
What are alternative representations for TRUE and FALSE in BOOLEAN data?
TRUE and FALSE can also be shown as:
* YES / NO
* ON / OFF
* Ticked / Unticked
44
In what software is BOOLEAN data frequently used?
BOOLEAN data is frequently used in Microsoft Word.
45
What must we do when presented with data to be input into a computer system?
We must analyse it and select appropriate data types for each value.
46
What is the data type for the data name 'Name'?
Text
47
What is the data type for the data name 'Height'?
Real
48
What is the data type for the data name 'Date of Birth'?
Date
49
What is the data type for the data name 'Phone No.'?
Alphanumeric
50
What is the data type for the data name 'Pay Rate'?
Currency
51
What is the data type for the data name 'Tax Rate'?
Percentage
52
Fill in the blank: The data type for 'Phone No.' is _______.
Alphanumeric
53
True or False: Phone numbers should be classified as numeric data types.
False
54
Why are phone numbers classified as alphanumeric data types?
Because they often have spaces, dashes, etc., which numeric data cannot have.
55
What is the term for an organised set of data?
Database
56
What types of databases can be found in computer systems?
* Databases of users
* Databases of ties
* Databases of webpages
* Databases of blog entries
* Databases of photos
* Databases of products
57
True or False: Databases are not commonly found in computer systems.
False
58
What is a record in the context of a database?
The set of data associated with a single object or person
59
Fill in the blank: The data associated with each student in a student database is called a _______.
Record
60
What information is included in Jess's record?
* ID No.: 356
* Name: Jess
* D.o.B.: 3 Mar 1995
* Phone: 7564356
* Class: 5B
* Tutor: Mr Noggin
* Room: 56
61
What is the D.o.B. of the student named Sita?
9 Jan 1994
62
What class is Hamad from ID No. 412 in?
5B
63
What is the purpose of storing data in an organised way?
To easily access it in the future
64
True or False: A student database should contain unorganised data.
False
65
What does D.o.B. stand for?
Date of Birth
66
What is the phone number associated with Hamad from ID No. 459?
8565634
67
Which tutor is associated with Jess's record?
Mr Noggin
68
Fill in the blank: A database can be found at the _______ of almost every computer system.
heart
69
What is the room number for the tutor of students in class 5B?
56
70
What is a database?
A collection of records.
71
What does a single record in a database represent?
A card with details of one person/object.
72
What is the structure of each record in a database?
Each record has the same structure with fields like name, date of birth, phone, etc.
73
What do we call the items contained in each record?
Fields.
74
What is a field name?
The label for each field, such as 'Date of Birth'.
75
Fill in the blank: Each field will contain different _______ in each of the records.
data values.
76
How many fields are typically contained in each student record?
Seven fields.
77
List the seven fields contained in each student record.
* ID Number
* Name
* Date of Birth
* Phone Number
* Class
* Tutor
* Room
78
True or False: Each record in a database can have different structures.
False.
79
What example is given for a manual database system?
Index cards in a public library.
80
What does the Phone field contain in Jess's record?
7564356.
81
What does the Phone field contain in Sita's record?
8565634.
82
In the context of records, what is the difference between a field and a field name?
A field is the data category, while a field name is the label for that category.
83
What does D.o.B. stand for?
Date of Birth
84
What is 'The field' in a database context?
The box that you would write in
85
What is 'The field name'?
The label next to the box
86
What is the definition of a Key Field / Primary Key?
A field that uniquely identifies each record in a database
87
Why is it important for every record in a database to be individually identified?
To ensure that we access the correct record
88
Why can't the Name field be used as a Key Field?
Because two or more students may have the same name
89
Why can't the Date of Birth field be used as a Key Field?
Because two students may share the same birthday
90
What is a better alternative to identify each student uniquely?
An ID number
91
What is the ideal field to use as a Key Field?
The ID number
92
What can happen if a name is used as a Key Field?
It may not identify each student uniquely
93
Fill in the blank: The Key Field is also known as the _______.
Primary Key
94
What is the example ID number given for the student Jess?
356
95
What class is student Jess in?
5B
96
Who is the tutor for class 5B?
Mr Noggin
97
What room is class 5B located in?
Room 56
98
True or False: A phone number can be used as a Key Field.
False
99
What is the common way to view the contents of a database?
As a table
100
What is the advantage of a tabular view in databases?
It is compact and allows seeing many records at once
101
What type of software typically provides a tabular view of databases?
Database software (e.g. Microsoft Access)
102
In a database table, what does each row correspond to?
A database record
103
What do the column headings in a database table represent?
Database field names
104
What does each cell in a database table contain?
An item of data
105
Fill in the blank: Each _______ of the table corresponds to a database record.
row
106
Fill in the blank: The column headings correspond to the _______ names.
field
107
True or False: Each cell in a database table can contain multiple items of data.
False
108
Fill in the blank: Each _______ of the table corresponds to a field.
cell
