wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

End of Term Mega Quiz

Total questions: 105

Worksheet time: 56mins

Name
Class
Date
1.
ROM stands for...
a)
Read Optical Memory
b)
Random Only Memory
c)
Read Only Memory
d)
Random Optical Memory
2.
RAM stands for ...
a)
Read Access Memory
b)
Random Application Memory
c)
Read Application Memory
d)
Random Access Memory
3.

A computer has 1000 megabytes of RAM. That is the same as ...

a)

1 Gb

b)

1000 Gb

c)

1 Kb

d)

1 Tb

4.
The characteristics of RAM are it is .....
a)
Permanent, non-volatile, not expandable and you can't write to it
b)
Temporary, volatile, expandable and you can write to it.
5.
This memory stores the data of the operating system and programs that are currently running, for access by the CPU.
a)
RAM
b)
ROM
c)
Cache memory
d)
Flash memory
6.
Why is ROM need in a computer system?
a)
It stores the 'bootstrap loader' which is needed to load the operating system.Without it, the computer wouldn't turn on.
b)
It stores the data of the operating system and programs that are currently running, for access by the CPU.
7.
This is a method of making a computer appear to have more primary memory than it has really has physically. For instance a PC might have 2Gb of RAM as primary memory, but ___ of 4Gb.  If a computer relies on this memory it will be slow.
a)
Virtual Memory
b)
Random Access Memory
c)
Read Only Memory
d)
Cache Memory
8.
Why is Virtual Memory needed in a computer system?
a)
It is used as a fast type of memory for programs currently in use to speed up the performance of a computer.
b)
When several programs run at the same time, the RAM can be full. Instead of closing programs the Operating system uses virtual memory to store some data.
9.
Where is data stored when it is Virtual Memory?
a)
It is stored on a area of a secondary storage device e.g. hard disk drive.
b)
It is stored in the RAM.
c)
It is stored in the ROM.
d)
It is stored in an optical drive e.g. CD.
10.
What is a disadvantage of Virtual Memory?
a)
Read/Write speed of a hard disk drive is slower than RAM. If the computer has to rely on this, the system is much slower.
b)
Read/Write speeds of a hard drive are faster than RAM, meaning the system is much faster.
11.
Optical device, fairly fragile, easy to snap or scratch.
a)
Flash memory
b)
Magnetic Tape
c)
CD
d)
Hard disk
12.
Not intended to be a portable storage device.
a)
CD
b)
Flash memory
c)
DVD
d)
Internal hard disk
13.
Very portable as it is designed to be fitted into small electronic devices.
a)
Flash memory devices
b)
Internal hard disk
c)
Magnetic tape
d)
Server
14.

The most durable storage device as it has no moving parts

a)

Solid State Storage

b)

Magnetic Storage

c)

Optical Storage

15.
Large computers used for backup storage are called
a)
Supercomputers
b)
Servers
c)
Clients
d)
Giants
16.
Which is a disadvantage of cloud storage?
a)

It's expensive

b)

It doesn't last long

c)

It could be a security risk

d)

Data can be accessed from any location

17.

Which of the following is not a type of storage

a)

Magnetic

b)

Solid State

c)

Optical

d)

Hard Drive

18.

What type of storage is a DVD?

a)

It is not a storage device

b)

Solid State

c)

Optical

d)

Magnetic

19.

What type of storage is a USB memory stick?

a)

Solid State

b)

Optical

c)

Magnetic

d)

It is not a storage device

20.

What type of storage is a SSD card?

a)

Magnetic

b)

It is not a storage device

c)

Solid State

d)

Optical

21.

What type of storage is a HDD?

a)

Solid State

b)

Optical

c)

Magnetic

d)

It is not a storage device

22.

Which of the following types of storage would likely access its data the fastest?

a)

Magnetic

b)

Solid State

c)

Optical

23.

Which of the following types of storage is the most durable?

a)

Optical

b)

Solid State

c)

Magnetic

24.

Which of the following types of storage is the most expensive per MB/GB?

a)

Solid State

b)

Magnetic

c)

Optical

25.

Why is a Hard Disk Drive (HDD) not very portable?

a)

It has moving parts

b)

It will break if you touch it

c)

It is too small

d)

It is too large

26.

Why does a laptop need secondary storage?

a)

To store data

b)

To backup files to move to another computer

c)

To store programs that are currently running

27.

Which type of storage uses lasers to write the data?

a)

Magnetic

b)

All types

c)

Solid state

d)

Optical

28.

The types of storage are listed below from least expensive per GB to the most expensive per GB.

Which order is correct?

a)

Solid State, Optical, Magnetic

b)

Optical, Magnetic, Solid State

c)

Magnetic, Solid State, Optical

d)

Optical, Solid State, Magnetic

e)

Magnetic, Optical, Solid State

29.

The types of storage are listed below from fastest to slowest. Which order is correct?

a)

Magnetic, Optical, Solid State

b)

Solid State, Optical, Magnetic

c)

Optical, Magnetic, Solid State

d)

Solid State, Magnetic, Optical

30.

Computers use binary to store data.

a)

True

b)

False

31.

Which number base is Binary?

a)

10

b)

2

c)

16

32.

Which of the following units is the smallest in terms of size?

a)

Kilobyte

b)

Megabyte

c)

Nibble

33.

How many bits are in a byte?

a)

2

b)

4

c)

6

d)

8

34.

How many bits are in a nibble?

a)

2

b)

4

c)

6

d)

8

35.

Smallest to largest, which of the below answers is correct?

a)

bit, nibble,byte,megabyte,kilobyte,terabyte,petabyte

b)

nibble, bit,byte,kilobyte,megabyte,terabyte,petabyte

c)

bit,byte,nibble,kilobyte,megabyte,petabyte,terabyte

d)

bit, nibble,byte,kilobyte,megabyte,terabyte,petabyte

36.

Convert the following denary number into binary(11).

a)

0011

b)

1011

c)

1100

d)

1010

37.

Convert the following denary number to binary (9).

a)

1010

b)

1011

c)

1001

d)

0111

38.

Convert the following denary into binary (21)

a)

0001 0101

b)

0011 0101

c)

0111 0111

d)

0100 0101

39.

Convert the following denary into binary (100).

a)

0111 0100

b)

0110 0100

c)

0101 100

d)

0110 1100

40.

Convert the following binary number to denary (0000 1111).

a)

15

b)

12

c)

10

d)

8

41.

Convert the following binary number to denary ( 0001 1001).

a)

21

b)

23

c)

25

d)

27

42.

Convert the following binary into denary (0011 1111).

a)

59

b)

61

c)

63

d)

65

43.

What is the hexadecimal value for the denary number (12).

a)

A

b)

B

c)

C

d)

D

44.

What is the hexadecimal value for the binary number (0000 1111).

a)

0d

b)

0e

c)

ff

d)

0f

45.

Convert the following binary number to hexadecimal (1001 1111)

a)

8d

b)

8e

c)

9e

d)

9f

46.

Convert the following binary number to hexadecimal( 1100 0111).

a)

c7

b)

a6

c)

b7

d)

d7

47.

Add the following nibbles together and select the correct answer from the list below. (1110 + 0010). Answer will be expressed in 4 bits.

a)

0001

b)

0000

c)

10000

d)

1001

48.

What it is known as when a calculation has been run but there is not enough space to store the answer?

a)

Syntax Error

b)

Overflow Error

c)

Indentation Error

49.

Convert the hex value A5 to binary

a)

10101010

b)

00011111

c)

01011010

d)

10100101

50.

You work out the approximate file size of an image using:

(bpp is bits per pixel - the colour depth)

a)

height × width × 8bpp\frac{height\ \times\ width\ \times\ 8}{bpp}  

b)

height × width × bpp8\frac{height\ \times\ width\ \times\ bpp}{8}  

c)

height × width × bpp × 8height\ \times\ width\ \times\ bpp\ \times\ 8  

d)

height × width8 ×bpp\frac{height\ \times\ width}{8\ \times bpp}  

51.

What is sample resolution in a sound file?

a)

The number of different values used to represent a sample in the file

b)

The number of bits used per second in the file

c)

The number of bits used to store each sample in the file

d)

The ratio of the compressed file size to the uncompressed size

52.

A sound file's size is increased by

a)

A greater bit depth

b)

Lossy Compression

c)

Higher sample frequency

d)

The volume of the sound

53.

Analogue sound waves are digitised in a process known as (a)  

54.

What is the decimal equivalent of hexadecimal value 'D'?

a)

11

b)

10

c)

13

d)

14

55.

Convert Binary into Hexadecimal:

1011 1110 0001

a)

CE2

b)

6ED

c)

BE1

d)

9G2

56.

What is meant by sampling resolution (bit depth)?

a)

The number of bits per sample.

b)

The number of bytes per sample.

c)

The number of pixels per sample.

d)

The number of data per sample.

57.

Bitmap images are made up of (a)  

58.

Main drawback of high resolution images?

a)

Increase in file size

b)

Increase in pixels

c)

The quality of Image.

d)

No drawbacks.

59.

What is an Image Resolution?

a)

Number of pixels in an image.

b)

Number of bits in an image.

c)

Number of bytes in an image.

d)

Number of data in an image.

60.

A (a)   is the basic unit of all computing memory storage terms.

61.
A kilobyte is usually rounded to 1000 bytes. But actually it is _____ bytes:
a)
1024
b)
512
c)
1048
d)
9600
62.
A gigabyte consists of 1024:
a)
megabytes
b)
terabytes
c)
kilobytes
d)
nibbles
63.

Which of these is the smallest?

a)

Megabyte

b)

Kilobyte

c)

Gigabyte

d)

Terabyte

64.
ASCII is:
a)
a numerical system that has 2 rather than 10 as a base.
b)
the most common format for text files in computers and on the Internet
65.
True or False: In an ASCII file, each alphabetic, numeric, or special character is represented with a 7-bit binary number (a string of seven 0s or 1s).
a)
True
b)
False
66.

A bitmap image is made up of

a)

Pixels

b)

Colours

c)

Sounds

d)

Samples

67.
Increasing the colour depth means…
a)
A bigger range of colours can be used for each pixel
b)
More pixels are in the image.
c)
More colours are in the image.
d)
Darker colours
68.
Reducing the amount of colours in the image will
a)
Reduce the quality of the image.
b)
Reduce the amount of binary needed for each pixel.
c)
Make the file size larger
d)
Remove pixels from the image.
69.
Additional Information about the image file is stored as
a)
Metadata
b)
Properties
c)
File summary
d)
Pixels
70.
Increasing the resolution of an image means that
a)
More pixels will be used to make up the image
b)
More colours will be used to make up the image
c)
The image size will be bigger
71.
How could you reduce the file size of an image?
a)
Reduce the numbr of colours used per pixel (colour depth)
b)
Reduce the dimensions of the image.
c)
Compress the file using a lossy compression file type.
d)
All of these
72.
What is real life sound known as?
a)
Analogue Sound
b)
Digital Sound
73.
What is the process called for  converting analogue sound into binary (digital format)?
a)
Conversions
b)
Sampling
c)
Bit Rate
d)
Converting
74.
The height of a sound wave graph is related to what?
a)
Amplitude (loudness)
b)
Pace (speed)
c)
Key
d)
Tone
75.
The amplitude of sound is measured in normal denary numbers and converted into binary?
a)
True
b)
False
76.
What is bit depth?
a)
Number of bits assigned to each sample
b)
Rate at which the binary is calculated
c)
How deep the sound can go
d)
The speed of the sound wave
77.

is how many samples you take in a second.

a)

Sample Rate

b)

Sample Resolution

c)

Binary

d)

File Size

78.

5 Seconds of audio, sample resolution of 2 bits and a sample rate of 2. What is the correct file size?

a)

10

b)

20

c)

15

d)

32

79.

Increasing the sample rate means the analogue recording is sampled more often?

a)

True

b)

False

80.

Increasing either the sample rate or sample resolution will increase the file size?

a)

True

b)

False

81.

What does "SQL" stand for?

a)

Structured Question Language

b)

Structured Query Language

c)

Simple Query Language

d)

Simple Question Language

82.

Which statement is used to extract data from a database?

a)

Extract

b)

Get

c)

Open

d)

Select

83.

If you were wanting to filter data, which clause would you use?

a)

Where

b)

Order by

c)

From

d)

Select

84.

Using which word allows you to specify that more than one condition must be met in a query?

a)

Also

b)

And

c)

Or

d)

Where

85.

Using which word allows you to specify that only one of a series of conditions needs to be met in a query filter?

a)

And

b)

Maybe

c)

If

d)

Or

86.

Less than or equal to?

a)

>=

b)

=>

c)

=<

d)

<=

87.

Which character returns all the data found in a table?

a)

%

b)

#

c)

*

d)

/

88.

Which word is missing from the following SQL statement?


Select * table_name

a)

With

b)

Where

c)

From

d)

And

89.

What is the correct order of clauses in a SQL statement?

a)

SELECT, FROM, ORDER BY, WHERE

b)

SELECT, FROM, WHERE, ORDER BY

c)

SELECT, WHERE, FROM, ORDER BY

d)

WHERE, FROM, SELECT, ORDER BY

90.

How do we select all rows for the "Designer" table?

a)

SELECT * FROM Designer

b)

SELECT [All] FROM Designer

c)

SELECT Designer.*

d)

SELECT FROM Designer

91.

How would we script a SQL query to select "Description" from the Item table?

a)

SELECT Item.Description

b)

EXTRACT Description FROM Item

c)

SELECT Item FROM Description

d)

SELECT Description FROM Item

92.

Which query would return only the fields DesignerID and Designer?

a)

SELECT * FROM Designers

b)

SELECT DesignerID, Name FROM Designers

c)

SELECT DesignerID AND Designer FROM Designers

d)

SELECT DesignerID, Designer FROM Designers

93.

How would you display Chairs in the Items table that have a Price greater than £50.

a)

SELECT * FROM Items WHERE Type = 'Chair' AND Price > 50

b)

SELECT * FROM Items WHERE Type = 'Chair' OR Price < 100

c)

SELECT * FROM Iterms WHERE Type = 'Chair' AND Price >= 50

d)

SELECT * FROM Items WHERE Price > 50

94.

Match the following SQL term with a description - FROM

a)

The criteria which must be met

b)

The fields to display

c)

The field and order used to sort the results

d)

The table used in the query

95.

Match the following SQL term with a description - SELECT

a)

The fields to display

b)

The table used in the query

c)

The criteria which must be met

d)

The field and order used to sort the results

96.

Match the following SQL term with a description - WHERE

a)

The table used in the query

b)

The fields to display

c)

The field and order used to sort the results

d)

The criteria which must be set

97.

What is a field?

a)

A collection of information

b)

A single item of information

c)

A list of information

d)

A group of records

98.

The SQL statement being run is:


SELECT player_name, score FROM leaderboard;


What is the name of the table in this query?

a)

SELECT

b)

player_name

c)

score

d)

leaderboard

99.

Which statement will show all fields and records from the table called "celebs"?

a)

SELECT * FROM celebs;

b)

SELECT FROM celebs;

c)

SELECT forename, surname FROM celebs;

d)

SELECT celebs;

100.

The SQL statement being run is:


SELECT player_name, score FROM leaderboard;


How many columns of results will be shown when this query is run?

a)

0

b)

1

c)

2

d)

3

101.

Which SQL statement will show the names and heights of all basketball players taller than 200?

a)

SELECT name FROM Player WHERE height >200;

b)

SELECT name FROM Player WHERE height >=200;

c)

SELECT name, height FROM Player WHERE height >200;

d)

SELECT name, height FROM Player WHERE height <200;

102.

Which SQL statement will show the names and weights of all wrestlers lighter than 170?

a)

SELECT name, weight FROM Wrestler WHERE weight >170;

b)

SELECT name, weight FROM Wrestler WHERE weight <= 170;

c)

SELECT name, weight FROM Wrestler WHERE weight <170;

d)

SELECT name, weight FROM Wrestler WHERE weight >=170;

103.

The SQL statement that was run was:


SELECT username, score FROM Player WHERE score>900;


The results were:


andy_pandy_12 911

aleeyah_nasoor_09 920

new_slang 907

utter_mess 901


How many records were returned in the query results?

a)

2

b)

3

c)

4

d)

8

104.

Which SQL query would display all pupils details who have the surname Smith?

a)

SELECT surname FROM Pupils WHERE Smith

b)

SELECT * FROM Pupils WHERE surname = Smith

c)

SELECT * FROM Pupils WHERE surname = "Smith"

d)

SELECT * FROM Pupils

105.

Which SQL query would display all pupils who 12 years old or order and have the surname Smith?

a)

SELECT * FROM Pupils WHERE Age >= 12 AND Surname = "Smith"

b)

SELECT * FROM Pupils WHERE Age >= 12 AND Surname = Smith

c)

SELECT * FROM Pupils WHERE Age > 12 AND Surname = "Smith"

d)

SELECT * FROM Pupils

Similar Resources on Wayground

Google Basics, Classroom, Drive, Docs & Sheets Review

100 questions

Google Basics, Classroom, Drive, Docs & Sheets Review

quiz

Worksheet

•

9th - 12th Grade

PENGINGAT EXCEL KELAS 9

102 questions

PENGINGAT EXCEL KELAS 9

quiz

Worksheet

•

9th - 12th Grade

POWER AV.5

100 questions

POWER AV.5

quiz

Worksheet

•

1st - 12th Grade

javascript

100 questions

javascript

quiz

Worksheet

•

KG - University

Ôn tập tin học 11 HK 1

100 questions

Ôn tập tin học 11 HK 1

quiz

Worksheet

•

11th Grade

Engineering and Technology FINAL

100 questions

Engineering and Technology FINAL

quiz

Worksheet

•

11th Grade

GDI - Shutter Stock - 2/23/24

110 questions

GDI - Shutter Stock - 2/23/24

quiz

Worksheet

•

9th - 12th Grade

Python Certification Preparation

100 questions

Python Certification Preparation

quiz

Worksheet

•

11th - 12th Grade