Paper 2 keywords Flashcards

1
Q

what is the DIV operator

A

outputs the answer without the fraction part

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

what does = mean

A

equal to

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

what does >

A

greater than operator

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

what does <

A

less than operator

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

what does >=

A

Greater than or equal to

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

what does <=

A

less than or equal to

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

what does <>

A

not equal to

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

what is a sequence

A

statements or actions performed in a specific order

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

what is selection

A

a way of making decisions in a program by choosing different paths based on a condition

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

what is an example of a count-controlled loop

A

For loop - repeats a loop a set number of times

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

what is an example of a pre-condition loop

A

while loop - repeats a loop while condition is true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

what is an example of a post-condition loop

A

repeat until loop = repeats a loop until a condition is true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

what is the difference between a function and a procedure

A

a function produces a result

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

what data type is an int

A

it is any whole number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

what data type is a real

A

all numbers with a decimal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

what data type is char

A

just one character from

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

what data type is a str

A

a group of characters consisting of letters, numbers and special characters

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

what data type is a boolean

A

has only 2 values, true or false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

what is linear search

A

starts with first value in a dataset and checks every value one at a time until all values have been checked.

20
Q

what is bubble search

A

starts at the beginning of a data set and checks values in ‘pairs’ and swaps them if they’re not in the correct order.

21
Q

validation

A

process carried out by a computer to check if the data input is reasonable.

22
Q

range check

A

checks the numerical value is at a certain range.

23
Q

type check

A

makes sure the type of data is input correctly.

24
Q

length check

A

checks if the data has a certain number of characters

25
presence check
makes sure data has been entered
26
check digit
extra digit is appended to a barcode
27
verification
checks whether data has been correctly copied from one source to another
28
double entry
data is entered twice
29
visual check
when someone checks the data
30
what is normal data
data that falls within the range
31
normal data between 1-20
2,3,4
32
extreme data
upper and lower limits of the accepted range
33
extreme data between 1-20
2,19
34
abnormal data
values outside of the range
35
abnormal data between 1-20
0,25,30
36
what are SQL Scripts
list of commands that perform a given task
37
SQL: SELECT
fetches specific fields from a table
38
SQL: FROM
identifies which table to fetch data from
39
SQL: ORDER BY
sorts the results from a query by a given column
40
SQL: WHERE
includes only specific data
41
SQL: SUM
returns the sum of all the values in a field
42
SQL: COUNT
counts the number of records
43
primary key
a field that uniquely identifies each record
44
record
a row of data
45
field
a column title