Explain the difference between functions and procedures in structured programming. Include an example of when you might use each in a program.
Understanding Functions and Procedures (4 marks) Read More »
Consider the following two-dimensional array representing scores for students in different subjects, where each row represents a student and each column represents a subject (Math, Science, English): [[65, 70, 75], [80, 85, 90], [55, 60, 65]] Write lines of code to output the Science score for the second student and the English score for the
2D Array Index (2 marks) Read More »
Given a one-dimensional array of student names: [“Alex”, “Brian”, “Charlie”, “Diana”, “Elena”] Write lines of code that demonstrate outputting the name of the first and last student in the array.
1D Array Index (2 marks) Read More »
Describe how a two-dimensional array can be used to manage a simple database of student records. Assume each record has fields for student ID, name, and grade.
Two-dimensional Arrays and Databases. (3 marks) Read More »
Explain why arrays are used in programming. Give one reason why one-dimensional arrays are used and one reason why two-dimensional arrays are used.
Why Arrays are used in Programming (2 marks) Read More »
A table named Orders contains the columns OrderID, CustomerID, OrderDate, and Amount. Describe how you would write an SQL query to display the OrderID and Amount for all orders placed in the month of December, 2021, where the order amount was over £500. Include an explanation of your SQL command.
SQL Query 3. (5 marks) Read More »
Consider a database with a table named Customers that includes the columns CustomerID, FirstName, LastName, and City. Write an SQL query to find the full names of all customers who live in ‘London’.
SQL Query 2. (3 marks) Read More »
A database named LibraryBooks contains a table Books that has the following columns: BookID, Title, Author, and YearPublished. Write an SQL query to retrieve the titles of all books that were published after the year 2000.
SQL Query 1. (3 marks) Read More »
Consider the following code used to read a file until the end: myFileHandler = open(“myFile.txt”) while NOT myFileHandler.endOfFile() print(myFileHandler.readLine()) endwhile myFileHandler.close() (a) Explain what the endOfFile() method does in this context. (1 mark) (b) What does readLine() do in this loop? (1 mark) (c) Why is it important to close the file after all operations
End of File Handling (3 marks) Read More »
Given the following code snippet: myFileHandler = open(“myFile.txt”) myFileHandler.writeLine(“Hello, world!”) (a) What is the purpose of the writeLine(“Hello, world!”) method? (1 mark) (b) How can you modify the code to ensure that the data is safely saved and the file is closed properly after writing? (2 marks)
Writing and Reading Files (3 marks) Read More »
en Notifications
Arabic
Chinese (Simplified)
Dutch
French
German
Italian
Portuguese
Russian
Spanish
Ukrainian
Welsh