0417.1.2.06 — Characteristics of backing storage: past paper questions
Real questions on 0417.1.2.06 — characteristics of backing storage
The newest 20 of 20 written questions. Open one to see it on the real paper.
- 0417/13 · May/June 2025 · Q9b[4]
The database needs to be evaluated. Part of the evaluation is to Identify any limitations. Describe four other tasks carried out during the evaluation.
See it on the paper → - 0417/11 · October/November 2024 · Q3b(ii)[1]
Cloud storage is an example of backing storage. State one other example of backing storage.
See it on the paper → - 0417/11 · October/November 2024 · Q3c[6]
The student is considering using cloud storage. Evaluate this type of storage.
See it on the paper → - 0417/12 · May/June 2023 · Q13a[4]
Weather forecasters use computer modelling. Explain why computer modelling is used to forecast the weather.
See it on the paper → - 0417/12 · May/June 2023 · Q13b[2]
Data is collected by different types of sensor and then input to the computer model to be processed. Identify twosensors that could be used to collect weather data.
See it on the paper → - 0417/12 · February/March 2023 · Q7a[2]
Primary key
See it on the paper → - 0417/12 · February/March 2023 · Q7b[2]
Foreign key
See it on the paper → - 0417/11 · October/November 2022 · Q4b[4]
Write down the field name which is the most appropriate for the data type, based on the data shown in the table.
See it on the paper → - 0417/12 · October/November 2022 · Q5a[4]
Describe the steps involved in setting up and testing the database structure before it can be used in the new system.
See it on the paper → - 0417/12 · October/November 2022 · Q7a[6]
Describe the benefits and drawbacks of storing membership details on a computer database.
See it on the paper → - 0417/12 · October/November 2022 · Q7b[5]
Describe five features of a well-designed paper-based data capture form.
See it on the paper → - 0417/13 · October/November 2022 · Q7a[4]
The librarian is planning to set up a number of different types of validation rule for the fields to check data entry. Write down the most appropriate field name from the table that could be used with each of the validation rules. Your answers must be different in each case. Name_of_book Department ISBN Book_type Cost...
See it on the paper → - 0417/13 · October/November 2022 · Q7b[1]
Write down the most appropriate field name from the table that could be used as a primary key field. Most of the revision books are available in electronic book type as digital versions of the printed books. These are stored as interactive PDF files.
See it on the paper → - 0417/13 · May/June 2021 · Q1[4]
Tick (✓) whether the following statements refer to Backing storage, RAM or ROM. Backing storage (✓) RAM (✓) ROM (✓) This is temporary storage used for the application being executed. This is volatile memory. An example of this storage is an SSD. This stores the start-up instructions for the computer.
See it on the paper → - 0417/13 · May/June 2021 · Q10c[6]
Aimi created a relational database but could have created a flat file database. Discuss the advantages and disadvantages of using a relational database rather than a flat file database.
See it on the paper → - 0417/12 · February/March 2021 · Q11[4]
The owner of a bookshop has a database of all the books she has in stock. As some of the data is being entered into the database it is checked using validation checks. An example of some of the records in the database is shown. Field name Example data Name of book Brotherhood of Wisdom Name of author Colin Turner ISBN...
See it on the paper → - 0417/11 · October/November 2020 · Q10a[5]
Write the search criteria to find all the earthquakes of a magnitude greater than or equal to 6.5, with a depth less than 15 km.
See it on the paper → - 0417/11 · October/November 2020 · Q10b[1]
Give the name of the country that satisfies the search criteria in part (a).
See it on the paper → - 0417/12 · February/March 2020 · Q8a[2]
Explain the differences between a flat file database and a relational database.
See it on the paper → - 0417/12 · February/March 2020 · Q8b[4]
The school keeps details of the teachers in one file and the subjects they teach in another file. A teacher teaches more than one subject. Describe the steps the headteacher would need to take to create a relational database from this data.
See it on the paper →
What examiners said
This was a very challenging question on evaluation. The question gave an example of a task and asked for other tasks carried out during evaluation of a system. Candidates were able to state the tasks but expanding on these were more difficult.
— Examiner report, May/June 2025, 0417/13 Q9(b) (Cambridge)
Modelling had been set previously in the examination series but not related to weather. This had an impact on the candidates ability to answer the question. There were some good responses but many lacked detail. Many candidates did not understand the question thinking that the model was created using sensors and was operational 24/7.
— Examiner report, May/June 2023, 0417/12 Q13(a) (Cambridge)
This was well answered by many of the candidates who were able to give two good answers.
— Examiner report, May/June 2023, 0417/12 Q13(b) (Cambridge)
Past papers, syllabus and examiner reports © UCLES (Cambridge University Press & Assessment). Questions are matched to topics from the official syllabus. AssessPro is independent and not endorsed by Cambridge.