GCSE COMPUTER SCIENCE OCR 2026 REVIEW TEST
QUESTIONS AND ANSWERS SURE A+
✔✔sequences - ✔✔only one way from start to finish
✔✔selections - ✔✔multiple ways to get from start to finish
✔✔iterations - ✔✔loops that allows to repeat a task
✔✔exponentiation - ✔✔raise a number to a power
✔✔DIV operator - ✔✔returns whole number part of division
✔✔MOD operator - ✔✔returns remainder part of division
✔✔== - ✔✔is equal to
✔✔<> or != - ✔✔is not equal to
✔✔< - ✔✔is less than
✔✔> - ✔✔is greater than
✔✔<= - ✔✔is less than or equal to
✔✔>= - ✔✔is greater than or equal to
✔✔comparison values - ✔✔produce boolean value
✔✔x.upper - ✔✔changes all characters in string x to upper case
✔✔x.lower - ✔✔changes all characters in string x to lower case
✔✔x.length - ✔✔returns number of character in string x
✔✔x[i] - ✔✔extracts the character in position i from string x
✔✔x.subString(a,b) - ✔✔extracts string starting at portion a with length b from string x
✔✔switch-case statements - ✔✔check value of a variable
✔✔for loops - ✔✔example of a count-controlled loop
, ✔✔AND - ✔✔&&
✔✔OR - ✔✔| |
✔✔NOT - ✔✔!
✔✔element - ✔✔each piece of data inside array
✔✔records - ✔✔rows of tables in databases - store a category
✔✔fields - ✔✔columns of tables in databases - story details about specific item
✔✔primary key - ✔✔uniquely identifies record in table (database)
✔✔data values in same record - ✔✔have different data types
✔✔data values in same field - ✔✔have same data types
✔✔flat file database - ✔✔only one table, viewed by opening one data file
✔✔relational database - ✔✔combine flat-file databases, linked together by key fields
✔✔SQL definition - ✔✔structured query language
✔✔SQL function - ✔✔create, update, query databases, consists of standard commands
called statements
✔✔Text - SQL data types - ✔✔stores strings
✔✔Date - SQL data types - ✔✔stores date in the form DD MM YYYY
✔✔Boolean - SQL data types - ✔✔stores TRUE or FALSE
✔✔CREATE TABLE - SQL command - ✔✔creates table with required number of fields
✔✔INSERT INTO - SQL command - ✔✔adds records to table (complete records no
specific field vs specific record assign field)
✔✔UPDATE-SET-WHERE - SQL command - ✔✔updates record in database
✔✔SELECT - SQL command - ✔✔tells database what information you want to achieve
✔✔FROM - SQL command - ✔✔tells database which tables to look in
QUESTIONS AND ANSWERS SURE A+
✔✔sequences - ✔✔only one way from start to finish
✔✔selections - ✔✔multiple ways to get from start to finish
✔✔iterations - ✔✔loops that allows to repeat a task
✔✔exponentiation - ✔✔raise a number to a power
✔✔DIV operator - ✔✔returns whole number part of division
✔✔MOD operator - ✔✔returns remainder part of division
✔✔== - ✔✔is equal to
✔✔<> or != - ✔✔is not equal to
✔✔< - ✔✔is less than
✔✔> - ✔✔is greater than
✔✔<= - ✔✔is less than or equal to
✔✔>= - ✔✔is greater than or equal to
✔✔comparison values - ✔✔produce boolean value
✔✔x.upper - ✔✔changes all characters in string x to upper case
✔✔x.lower - ✔✔changes all characters in string x to lower case
✔✔x.length - ✔✔returns number of character in string x
✔✔x[i] - ✔✔extracts the character in position i from string x
✔✔x.subString(a,b) - ✔✔extracts string starting at portion a with length b from string x
✔✔switch-case statements - ✔✔check value of a variable
✔✔for loops - ✔✔example of a count-controlled loop
, ✔✔AND - ✔✔&&
✔✔OR - ✔✔| |
✔✔NOT - ✔✔!
✔✔element - ✔✔each piece of data inside array
✔✔records - ✔✔rows of tables in databases - store a category
✔✔fields - ✔✔columns of tables in databases - story details about specific item
✔✔primary key - ✔✔uniquely identifies record in table (database)
✔✔data values in same record - ✔✔have different data types
✔✔data values in same field - ✔✔have same data types
✔✔flat file database - ✔✔only one table, viewed by opening one data file
✔✔relational database - ✔✔combine flat-file databases, linked together by key fields
✔✔SQL definition - ✔✔structured query language
✔✔SQL function - ✔✔create, update, query databases, consists of standard commands
called statements
✔✔Text - SQL data types - ✔✔stores strings
✔✔Date - SQL data types - ✔✔stores date in the form DD MM YYYY
✔✔Boolean - SQL data types - ✔✔stores TRUE or FALSE
✔✔CREATE TABLE - SQL command - ✔✔creates table with required number of fields
✔✔INSERT INTO - SQL command - ✔✔adds records to table (complete records no
specific field vs specific record assign field)
✔✔UPDATE-SET-WHERE - SQL command - ✔✔updates record in database
✔✔SELECT - SQL command - ✔✔tells database what information you want to achieve
✔✔FROM - SQL command - ✔✔tells database which tables to look in
