Save
...
Component Two
Programming Fundamentals
Additional Programming Techniques
Save
Share
Learn
Content
Leaderboard
Share
Learn
Created by
shyra
Visit profile
Cards (23)
What is an array in programming?
An array is a static data
structure
that can hold a fixed number of
data elements.
View source
What must each data element in an array be?
Each data element must be of the same data type.
View source
How are elements in an array
identified
?
The
elements
in an
array
are identified by an index number.
View source
What is the index of the first element in an array?
The first element in an array always has an index of
0.
View source
What are the basic operations you should know how to perform on arrays in pseudo code?
Traverse
Add
Remove
Search
View source
How can you traverse an array in Python?
You can use a
for loop
to display
each data element
in order.
View source
Can you insert new values into an array?
No
, you cannot insert new values into an array since its
size
is fixed.
View source
What happens when you overwrite the fourth element in an array?
It
changes
the value of that element to the
new
value provided.
View source
How can you delete a value in an array?
You can
overwrite
it with a blank space to make it appear
deleted.
View source
How do you search for a specific value in a large array?
You need a
for loop
to check each
element
for the specific value.
View source
What is a two-dimensional array?
A data
structure
that can hold data in
multiple
rows and columns.
All data must still be of the
same
data type.
View source
How is the index represented in a two-dimensional array?
The index has two values, representing
row
and
column.
View source
How do you print a specific data element from a two-dimensional array?
You can use the
index number
to access the
element
directly.
View source
How do you search for a specific value in a two-dimensional array?
You will need two for loops, one for the
row
and another for the values of each
row.
View source
What is a record in programming?
A
data structure
that can store data of
different
data types.
Each record contains information about one person or thing.
Each piece of information is called a
field.
View source
What is a key field in a record?
A
key field
is
unique data
that identifies each record.
View source
What is SQL?
SQL (
Structured Query Language
) is a
language
used to search for data in a database.
View source
What is the format of an SQL statement?
The format is:
SELECT
field1, field2, field3… FROM
table
WHERE criteria.
View source
Write an example of an SQL statement using the Cars table.
SELECT Make, Colour FROM Cars WHERE Miles >
1000
AND
Age
> 8.
View source
What are wildcards in SQL?
Wildcards are symbols used to substitute characters in SQL
queries.
View source
What does the * symbol represent in an SQL statement?
The * symbol represents
ALL
fields in a
table.
View source
Write an example of an SQL statement using a wildcard.
SELECT * FROM
Cars
WHERE Colour = "
blue
".
View source
What are the questions related to Additional Programming Techniques in the exam?
Describe the
differences
between a
1D
array, 2D array, and record.
Write code for various
operations
on a
one-dimensional
array.
Write SQL statements based on the
Cars
table.
View source
See similar decks
AQA GCSE Computer Science
2308 cards
OCR GCSE Computer Science
1937 cards
Edexcel GCSE Computer Science
2949 cards
AP Computer Science Principles
1196 cards
AP Computer Science A
1898 cards
2.2.3 Additional Programming Techniques
OCR GCSE Computer Science > 2.2 Programming Fundamentals
106 cards
OCR A-Level Computer Science
2091 cards
2.2.1 Programming Concepts
OCR GCSE Computer Science > 2.2 Programming Fundamentals
117 cards
2.2 Programming Fundamentals
OCR GCSE Computer Science
249 cards
2.2.1 Programming techniques
OCR A-Level Computer Science > 2.2 Problem-solving and programming
91 cards
Understanding the use of basic file handling operations
OCR GCSE Computer Science > 2.2 Programming Fundamentals > 2.2.3 Additional Programming Techniques
106 cards
1.1 Programming concepts
AQA A-Level Computer Science > 1.0 Fundamentals of programming
374 cards
3.2.6 Structured programming
AQA GCSE Computer Science > 3.2 Programming
55 cards
3.2.2 Programming concepts
AQA GCSE Computer Science > 3.2 Programming
76 cards
1.0 Fundamentals of programming
AQA A-Level Computer Science
374 cards
12.0 Fundamentals of functional programming
AQA A-Level Computer Science
430 cards
12.3 Functional programming languages
AQA A-Level Computer Science > 12.0 Fundamentals of functional programming
111 cards
1.1.6 Error handling
AQA A-Level Computer Science > 1.0 Fundamentals of programming > 1.1 Programming concepts
127 cards
3.2.7 Robust and secure programming
AQA GCSE Computer Science > 3.2 Programming
63 cards
2.2.2 Data Types
OCR GCSE Computer Science > 2.2 Programming Fundamentals
26 cards
3.2.8 Classification of programming languages
AQA GCSE Computer Science > 3.2 Programming
91 cards