NEW
Font size
WorksheetsREVISION YEAR 9
Total questions: 69
Worksheet time: 40mins
The number or word we store in a variable.
Value
Bug
Information
Text
name = 'Dave'
print (name)
What button do you press to compile (run) your program so that it runs in the shell (Interactive mode)?
F3
F5
F7
F9
Which is the Python logo?
What is a input?
A function that allows us to ask the user to enter some data.
To plug in something.
Data displayed on a screen.
A function
What function is used to output a message in python?
print("")
input=name
name=input
x = 5
y = 6
print(x*y)
The code above displays the following:
11
x*y
Syntax Error
30
Operators used in python:
divide, multiply, add, subtract
/, *, +, -
div, mul, +, -
\, x, +, -
~, *, +, -
Which is the smallest form of data?
Bit
Byte
Nibble
8 Binary Digits
Which answer is correct from smallest to largest?
Kilobyte, Gigabyte, Megabyte
Gigabyte, Megabyte, Terabyte
Megabyte, Terabyte, Kilobyte
Byte, Kilobyte, Megabyte
Which one of the 2 units of storage is larger ?
Megabyte
Gigabyte
How many Bits are in a Byte
2
4
10
8
Which is larger?
Bit
Byte
How many bits are in a nibble?
16
8
4
32
A kilobyte is...
1024 Bits
1024 Bytes
1024 Megabytes
1024 Gigabytes
A megabyte is...
1024 Bits
1024 Bytes
1024 Kilobytes
1024 Gigabytes
Which of these is the smallest?
Megabyte
Kilobyte
Gigabyte
Terabyte
A typical mp3 track is around 50 megabytes in size.
No - they are more like 3 megabytes
Yes - that's about right
No - they're more like 200 megabytes
No - they're more like 1 gigabyte
The following is a correct order of units of storage from lowest to highest:
Bit, Nibble, Byte, Kilobyte, Megabyte, Gigabyte, Terabyte
Bit, Byte, Kilobyte, Nibble, Megabyte, Gigabyte, Terabyte
Terabyte, Gigabyte, Megabyte, Kilobyte, Byte, Nibble, Bit
Megabyte, Byte, Kilobyte, Nibble, Gigabyte, Bit, Terabyte
Convert Decimal to Binary: 56
11110010101
00111000
100010101
1111110000
Convert Decimal to Hexadecimal: 36
AD
80
1A
24
Convert Hexadecimal to Decimal: 7A
123
111
122
10110110
Convert Hexadecimal to Decimal: 6F
01101111
111
65
155
Convert Binary to Hexadecimal: 1111010
7A
2952
F55
556
Convert Decimal to Hexadecimal: 986
10101010111
2BA
3FB
3DA
Convert Hexadecimal to Decimal: FD
11111101
253
785
510
Convert Binary to Decimal: 1111010101000
FDB
8475
7848
6415
Convert Decimal to Binary: 55
11011101
110111
10110111
1101001
Convert Hexadecimal to Binary: 9A
2547
4F111
101011010101011
10011010
What is encryption?
Building tombs
Protecting data by scrambling it
Unscrambling data to read it
Exploring church basements
What do you call the algorithm used to encrypt data?
Flux capacitor
Oscillation overthruster
Cipher
Transmogrifier
What do we call scrambled, encrypted data?
Garbage
Ciphertext
Plaintext
Gibberish
What do we call unscrambled, readable data?
ASCII
Ciphertext
Plaintext
Purple prose
Who invented the Caesar Cipher?
Augustus Caesar
Hadrian Caesar
Julius Caesar
Palpatine Caesar
Who worked out how to break the German Enigma code?
Alan Titchmarsh
Alan Shearer
Alan Turing
Alan Partridge
What do you need to encrypt and decrypt a plaintext and cipher text?
Wi fi network
A key
Binary code
Hexadecimal code
Which two protocols are used in encryption scenarios and algorithms?
SSL and TLS
HTP and FTP
HTTP only
HTTPs
Which protocol should you use if shopping online?
FTP
SMTP
HTTP
HTTPS
Which of these do you need to keep secret?
The cipher algorithm
Your public encryption key
Your private decryption key
Your MAC address
The Primary Key is a unique value for that column and hence, it cannot be the same for two ________________.
Fields
records
Data
None of these
Each table must have only one column set as __________
Foregin Key
Primary Key
Design Key
To create a table, click on Create and then
Forms
reports
queries
Table
The Primary Key is a __________ identifier for a record
Distinct
unique
None of these
Which field has primary key in the given table
Address 1
CustomerName
Customer ID
_______ is used to store alphanumeric data
Text
Number
Date time
Curency
_______ is used to store numeric data
Text
Number
Date time
Curency
If you want to enter the birth date of the student which data type will you use?
Text
Number
Date time
Curency
Mr. Faris wants to save the price of the product he selling in the market so he used number datatype. Is he correct? Why?
Yes, correct price is a number,
No, not correct because price is a currency
None of these
The field name should not have______
alphabets
space
number
all other 3 options
__________can attach files such as pictures, documents, spreadsheets or charts
Date/ Time
Attachment
Short Text
Number
The primary key field can never be blank or cannot contain a null value
True
false
The patient_id, doctor_id, student_id can be primary keys because in each table, these fields will have a unique number
True
False
The Primary Key is a unique identifier for a record
True
false
•Click the field that you want to make a Primary Key
•On ________ tab, in Tool
group click Primary Key
Home
Insert
Design
Arrange the following steps in correct sequence to create the Primary Key
1. On Design tab, in Tool group click Primary Key
2. Save the Table
3. Click the field that you want to make a Primary Key
1,2,3
3,2,1
3,1,2
To add records to a table, open
the tables in _____________ View
Datasheet view
Design View
To design a table, open
the tables in _____________ View
Datasheet view
Design View
§To Save a Database,
•Click the File tab and select the
Save Database As option,
the Save As dialog box appears,
then in the File Name text box
type the name of the database
•Click save
•The file will be saved with
the extension .accdb
True
false
This field can never be left ________.
Blank
stack
Array
A database helps you to organise the collected data in a _____format in a systematic manner
Tabular
Linear
What are the steps to create a blank database?
Start ----------> Access ---------> Blank database
New ----> Blank database ----> Filename ----> Create
Design tab---- blank---- start button
