Additional programming techniques

Question 1

Array

Answer 1

Data structure that can hold a fixed number of data elements. Each data element must be of the same data type

The elements in an array are identified by their position in the array. This is known as the index. The first element in an array always has an index of 0

Question 2

Traversing an array

Answer 2

To traverse (move through) an array a for loop can be used to display each data element in order

e.g. ArrayName = [“Dog”, “Cat”, “Snake”]
for name in ArrayName:
print(name)

Question 3

‘Inserting’ a value in an array

Answer 3

In an array, the size is fixed so you cannot insert new values, but you can change the value of elements that already exist

e.g. ArrayName[3] = “Dog”

Question 4

‘Deleting’ a value in an array

Answer 4

In an array the size is fixed so you cannot delete values, but you can overwrite them as blank

e.g. ArrayName[2] = “”

Question 5

Searching an array

Answer 5

For large arrays, a for loop is needed to search through each element for a specific value

e.g. for name in ArrayName:
if name == “Dog”:
print(name)

Question 6

SQL

Answer 6

Searches for data in a database

SELECT (from top layer of table)
FROM (table name)
WHERE