wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

N5 Computing SDD/DDD/CS

Total questions: 89

Worksheet time: 54mins

Name
Class
Date
1.

What is a "field" in a database?

a)

A row in a table

b)

A column in a table

c)

The entire database

d)

A relationship between tables

2.

What does the term "record" refer to in a database?

a)

A single piece of data (e.g., a name)

b)

A collection of related fields

c)

A table in the database

d)

A query result

3.

What is a "primary key" used for?

a)

To sort data alphabetically

b)

To uniquely identify each record in a table

c)

To create relationships between tables

d)

To filter data in a query

4.

What is a "relationship" in a database?

a)

A single piece of data

b)

A connection between two or more tables

c)

A type of query

d)

A database report

5.

A ​ (a)   relationship allows one record in a table to be related to many records in another table? ​

Choose from the below words
One-to-many
one-to-one
Many-to-many
zero-to-one
6.

In a database, what is a "data type"?

a)

A method of sorting data

b)

The type of data that can be stored in a field (e.g., text, number, date)

c)

A type of query

d)

A way to create relationships

7.

Which of the following best describes the purpose of a "foreign key"?

a)

To uniquely identify records within a table.

b)

To create a link between two tables.

c)

To sort data in a table.

d)

To filter data in a query.

8.

Which SQL command is used to retrieve data from a database table?

a)

INSERT

b)

UPDATE

c)

SELECT

d)

DELETE

9.

What does the * symbol represent in a SELECT statement?

a)

The primary key

b)

All columns in the table

c)

A specific column

d)

A wildcard character for filtering

10.

What is the purpose of the WHERE clause in a SELECT statement?

a)

To sort the results

b)

To filter the results based on a condition

c)

To group the results

d)

To join tables

11.

Put the following in the correct order for a valid SQL statement

a)

SELECT

b)

FROM

c)

WHERE

d)

ORDER BY

1)
2)
3)
4)
12.

You are to create a program that asks the user to enter their date of birth, the program will then tell the user how many days they have been alive for.

What is the input/process/output for this scenario

a)

Input:Date of Birth

Process: calculate number of days between DOB and today

Output: Number of days alive

b)

Input:Date of Birth

Process: Number of days alive

Output: calculate number of days between DOB and today

c)

Input:Date of Birth

Process: Subtraction

Output: Age

d)

Input:Age

Process: Subtraction

Output: Days alive

13.

Select the logical operator

a)

FOR

b)

While

c)

AND

d)

=

14.

Select the logical operator below

a)

IF

b)

WHILE

c)

OR

d)

SELECT

15.

Choose the logical operator

a)

:

b)

NULL

c)

NOT

d)

WHERE

16.

Select all the pre-defined functions

a)

Round

b)

Length

c)

Random

d)

WHILE

17.

What is the correct code to generate a random number between 1 and 10

a)
b)
c)
d)
18.

This is correct input validation

a)

TRUE

b)

FALSE

19.

Input validation requires what kind of loop

a)

WHILE

b)

FOR

c)

IF

d)

LOOP

20.

This code will calculate the length of the string stored in the variable name_length

a)

True

b)

False

21.

This transfers the memory location to be read from or written to

a)

Arithmetic and Logic Unit (ALU)

b)

Data Bus

c)

Address Bus

d)

Control Unit

22.

This transfers data between the processor and memory

a)

Arithmetic and Logic Unit (ALU)

b)

Data Bus

c)

Address Bus

d)

Registers

23.

Performs all calculations and logical operations

a)

Arithmetic and Logic Unit (ALU)

b)

Data Bus

c)

Address Bus

d)

Control Unit

24.

Temporary memory locations within the processor

a)

Arithmetic and Logic Unit (ALU)

b)

Data Bus

c)

Address Bus

d)

Registers

25.

Controls the sequencing of fetching, decoding and executing instructions

a)

Arithmetic and Logic Unit (ALU)

b)

Data Bus

c)

Address Bus

d)

Control Unit

26.

All RAM memory locations have a unique address for correct data read/write.

a)

True

b)

False

27.

Good for testing, errors are highlighted straight away. This is an advantage of

a)

Translator

b)

Compiler

28.

All lines are translated to machine code, this machine code version is then saved and can be executed. Machine code can be run again, and again without further translation. This is a definition of a

a)

Translator

b)

Compiler

29.

Translates one program line into machine code and executes immediately.

a)

Translator

b)

Compiler

30.

0.100101 x 25

What is the mantissa?

a)

100101

b)

2

c)

5

d)

0100101

31.

0.100101 x 25

What is the exponent?

a)

100101

b)

2

c)

5

d)

10

32.

0.100101 x 25

Can also be written as?

a)

0.100101 x 2101

b)

0.100101 x 2111

c)

0.100101 x 2011

d)

0.100101 x 2100

33.

0.100101 x 25

Can also be written as?

a)

18.5

b)

1.85

c)

185

d)

0.185

34.

What is the binary representation of the decimal number 13?

a)

00001101

b)

00001011

c)

00001110

d)

00001001

35.

What is the binary representation of the decimal number 24?

a)

0001 1000

b)

0001 0110

c)

0101 1011

d)

0100 1100

36.

What is the binary representation of the decimal number 255?

a)

1111 1111

b)

1101 1011

c)

1110 1101

d)

1001 1001

37.

What is the binary representation of the decimal number 63?

a)

1111 1111

b)

1101 1011

c)

0011 1111

d)

1001 1001

38.

What is the primary function of the Control Unit in a CPU?

a)

Perform arithmetic operations

b)

Store data

c)

Control the execution of instructions

d)

Transfer data between memory and processor

39.

How many bits are needed to store This World in Extended ASCII?

a)

88

b)

10

c)

80

d)

72

40.

How many bytes are needed to store the phrase Hello World in Extended ASCII?

a)

88

b)

11

c)

80

d)

10

41.

How many bytes are needed to store the phrase Computer Science in Extended ASCII?

a)

16

b)

15

c)

8

d)

112

42.

Reorder the following, smallest first

a)

bit

b)

byte

c)

kilobyte

d)

megabyte

e)

gigabyte

1)
2)
3)
4)
5)
43.

There are ​ (a)   bits in a byte

Choose from the below words
8
2
7
10
1
44.

What does ASCII stand for?

a)

American Standard Code for Information Interchange

b)

American Standard Code for Internet Interchange

c)

American Standard Code for International Interchange

d)

American Standard Code for Internal Interchange

45.

What is a bitmap graphic?

a)

A graphic composed of bits of pixels in a grid

b)

A graphic composed of mathematical equations

c)

A graphic that uses vector paths

d)

A graphic that uses 3D models

46.

Which file format is used for bitmap graphics?

a)

SVG

b)

JPEG

c)

EPS

d)

PDF

47.

What is a disadvantage of bitmap graphics?

a)

They are resolution-independent

b)

They can be easily scaled without loss of quality

c)

They can become pixelated when enlarged

d)

They use less memory compared to vector graphics

48.

What is a vector graphic?

a)

A graphic composed of pixels in a grid

b)

A graphic composed of mathematical equations

c)

A graphic that uses bitmap images

d)

A graphic that uses 3D models

49.

Which file format is used for vector graphics?

a)

JPEG

b)

PNG

c)

SVG

d)

GIF

50.

What is an advantage of vector graphics over bitmap graphics?

a)

They are resolution-independent

b)

They can become pixelated when enlarged

c)

They use more memory compared to bitmap graphics

d)

They are composed of pixels

51.

Unicode's advantage over ASCII is

a)

It can store more characters

b)

It takes less bits to store a character

c)

It only has 1 alphabet

d)

It was the first standard

52.

You can save energy use of a computer by

a)

Turning down the brightness of the monitor

b)

Turning up the brightness of the monitor

c)

Keeping your laptop always charging

d)

Switching off when not in use

53.

The part of the processor that performs all calculations and logical operations is the

(a)  

54.

Which file format is used for vector graphics?

(a)  

55.

How many characters can standard ASCII represent?

(a)  

56.

How many bits are needed for 1 character in extended ASCII?

(a)  

57.

Extended ASCII uses (a)   ​ original ASCII uses ​ (b)   per character

Choose from the below words
8 bits
7 bits
1 bit
16 bits
58.

Bitmap file formats include

a)

SVG

b)

GIF

c)

JPEG

d)

PNG

59.

An entity is database terminology for a ?

a)

Table

b)

Record

c)

Field

d)

Attribute

60.

An entity relationship (ER) diagram shows how two or more tables are linked together

a)

True

b)

False

61.

The attributes of an entity are the ...?

a)

Fields

b)

Records

c)

Tables

d)

Relationship

62.

The Primary Key (PK) in an ER diagram is shown using ...?

a)

Asterix

b)

Underline

c)

Brackets

d)

Colour

63.

The Foreign Key (FK) in an ER diagram is shown using ...?

a)

Asterix

b)

Underline

c)

Brackets

d)

Colour

64.

A Primary Key (PK) must be ...?

a)

Unique

b)

Number

c)

Text

d)

Short

65.

A Foreign Key (FK) must be a Primary Key (PK) in another table

a)

True

b)

False

66.

For the following two ENTITIES, which is the appropriate relationship:

RULER / COUNTRY

a)

One to One

b)

One to Many

c)

Many to Many

67.

For the following two ENTITIES, which is the appropriate relationship:

ZOO / ANIMAL

a)

One to One

b)

One to Many

c)

Many to Many

68.

For the following two ENTITIES, which is the appropriate relationship:

RECIPE / INGREDIENT

a)

One to One

b)

One to Many

c)

Many to Many

69.

For the following two ENTITIES, which is the appropriate relationship:

DOCTOR / PATIENT

a)

One to One

b)

One to Many

c)

Many to Many

70.

For the following two ENTITIES, which is the appropriate relationship:

SIM CARD / PHONE NUMBER

a)

One to One

b)

One to Many

c)

Many to Many

71.

For the following two ENTITIES, which is the appropriate relationship:

ACTOR / MOVIE

a)

One to One

b)

One to Many

c)

Many to Many

72.

Select the correct code for a running total in a loop

a)

b)

c)

d)

73.

Reorder the following pseudocode for a running total in a loop

a)

set initial total to 0

b)

start loop

c)

get number from user

d)

add number from user to running total

1)
2)
3)
4)
74.

Reorder the following pseudocode for input validation

a)

Ask user for initial input

b)

Loop while input does not match criteria

c)

Display error message

d)

Ask user for input again

1)
2)
3)
4)
75.

Select the correct code for input validation

a)

b)

c)

d)

76.

Select the correct code to choose a random number between 1 and 10

a)

b)

c)

d)

77.

Select the correct code to round to 2 decimal places

a)

b)

c)

78.

Is python an interpreter or compiler programming language?

a)

Compiler

b)

Interpreter

79.

What output will the console show, if 15 and 30 are entered by the user?

a)

Syntax error

b)

The sum of the two numbers - 45

c)

The concatenation of the two strings - 1530

d)

Compiler error

80.

What result will display in the shell if 15 and 20 is entered by the user?

a)

"num1 + num2"

b)

1520

c)

35

81.

What datatype will the answer be if the user enters 15 and 30?

a)

Integer

b)

String

c)

Boolean

d)

Float

82.
What is a variable?
a)

A named memory location where you store values

b)
a type of graphics
c)
Data type
d)
a type of memory
83.
What symbol is used in python to assign values to a variable?
a)
equals =
b)
plus + 
c)
forward slash /
d)
asterisk *
84.
When you have an error in your code what is the term to summarise finding and fixing that error?
a)
Error checking
b)
Debugging
c)
Syntax finder
d)
Error finder
85.
A syntax error means your code has a 'grammar' mistake or you used symbols/operations incorrectly
a)
True
b)
False
86.
Which statement correctly assigns the string "Tanner" to the variable name?
a)
name  = print( "Tanner")
b)
input("Tanner")
c)
name = "Tanner"
d)
name = input("Tanner")
87.
What letter will be printed on the screen after running this code:
a)
e
b)
x
c)
t
d)
Nothing prints
88.

What is the position of the name "Robert" in the following list (array):

a)

0

b)

1

c)

2

d)

3

89.

Each item in a list (array) has an index. What is the first index in a Python list (array)?

a)

0

b)

1

c)

a

d)

A

Similar Resources on Wayground

Code.org Final Vocabulary

90 questions

Code.org Final Vocabulary

quiz

Worksheet

•

9th - 12th Grade

INFORMATIKA KLS X

92 questions

INFORMATIKA KLS X

quiz

Worksheet

•

10th Grade

HTML Revision 2023

85 questions

HTML Revision 2023

quiz

Worksheet

•

9th - 12th Grade

AP Computer Science Principles (All Terms)

90 questions

AP Computer Science Principles (All Terms)

quiz

Worksheet

•

10th Grade

ruston_pennington_79402

86 questions

ruston_pennington_79402

quiz

Worksheet

•

9th - 12th Grade

Pengenalan Mapel Informatika

94 questions

Pengenalan Mapel Informatika

quiz

Worksheet

•

10th Grade

Cau_hoi_On_tap_GK_Python

84 questions

Cau_hoi_On_tap_GK_Python

quiz

Worksheet

•

10th Grade

Online alapismeretek

85 questions

Online alapismeretek

quiz

Worksheet

•

5th - 12th Grade