Programming (Paper 2)

Question 1

how to turn a string from lower case to uppercase

Answer 1

print(Variable.upper())

Question 2

how to turn a string from upper case to lower case

Answer 2

print(Variable.lower())

Question 3

how to turn a string to have title case

Answer 3

print(Variable.title())

Question 4

command to count the number of characters in a string

Answer 4

print(len(Variable))

Question 5

how to extract a substring from a large string from a sequence of characters

Answer 5

print(Variable[3:5])

Question 6

how to concatenate two or more strings

Answer 6

variable = variable1 + variable2

Question 7

how to open a file

Answer 7

file = open(“fruit.txt”,”r”)

Question 8

how to close a file

Answer 8

file.close()

Question 9

How to read a line in a file

Answer 9

file.readline()

Question 10

how to write a line in a file

Answer 10

file.write(“oranges”)

Question 11

how to create a new file

Answer 11

file = open(“shopping.txt”,”w”)

Question 12

how to append a file

Answer 12

file = open(“shopping.txt”,”a”)

Question 13

how to perform an SQL query

Answer 13

SELECT (what to return)
FROM (specifies the table name to retrieve data from)
WHERE (filters the data based on a specific condition)

Question 14

how to create a 1D array

Answer 14

scores = [0]*5
creates an array with 5 elements, each initialised to 0

Question 15

how to create a 2D array

Answer 15

players = [[None]*3 for _ in range(3)]
creates a 3x3 2D array with all values set to None

Question 16

how to assign a value to a 2D array

Answer 16

players [0][1] = “Holly”
replaces text in row 0, column 1 with “Holly”

Question 17

how to create a populated 2D array

Answer 17

players = [[“Rob”,”Paul”,”Hayley”], [10, 5, 8]]

Question 18

how to access a value in a 2D array

Answer 18

value = players[2][2]
retrieves the value at row 2, column 2

Question 19

how to create a function

Answer 19

def squared(number):
squared = number^2
return squared

Question 20

how to generate a random number

Answer 20

import random
number = random.randint(1,10)