Consider supporting us on Patreon. Help us keep revisedeck free.
1. Theory Fundamentals
A section of Computer Science, 9608
Listing 10 of 304 questions
A Local Area Network is used by staff in a hospital to access data stored in a Database Management System (DBMS). Name two security measures to protect computer systems. A frequent task for staff is to key in new patient data from a paper document. The document includes the patient’s personal ID number. The Patient ID is a seven digit number. The database designer decides to use a check digit to verify each foreign key value that a user keys in for a Patient ID. When a user assigns a primary key value to a Patient ID, the DBMS adds a modulus-11 check digit as an eighth digit. The DBMS uses the weightings 6, 5, 4, 3, 2 and 1 for calculating the check digit. It uses 6 as the multiplier for the most significant digit. Show the calculation of the check digit for the Patient ID with the first six digits 786531. Complete Patient ID Name and describe two validation checks that the DBMS could carry out on each primary key value that a user keys in for a Patient ID. Validation check Description Validation check Description
9608_w17_qp_11
THEORY
2017
Paper 1, Variant 1
View
A Local Area Network is used by staff in a hospital to access data stored in a Database Management System (DBMS). Name two security measures to protect computer systems. A frequent task for staff is to key in new patient data from a paper document. The document includes the patient’s personal ID number. The Patient ID is a seven digit number. The database designer decides to use a check digit to verify each foreign key value that a user keys in for a Patient ID. When a user assigns a primary key value to a Patient ID, the DBMS adds a modulus-11 check digit as an eighth digit. The DBMS uses the weightings 6, 5, 4, 3, 2 and 1 for calculating the check digit. It uses 6 as the multiplier for the most significant digit. Show the calculation of the check digit for the Patient ID with the first six digits 786531. Complete Patient ID Name and describe two validation checks that the DBMS could carry out on each primary key value that a user keys in for a Patient ID. Validation check Description Validation check Description
9608_w17_qp_13
THEORY
2017
Paper 1, Variant 3
View
Arnold is a software developer. He has created a computer game for people to download over the Internet. Arnold is considering releasing the game as a piece of commercial software. Describe what is meant by a commercial licence. Name and describe one other type of licence that Arnold can consider using. Licence type Description Users need to enter their name and email address to create an account. The information is stored in a database on Arnold’s computer. Give three ways that Arnold can ensure users’ details are kept secure.
9608_w18_qp_13
THEORY
2018
Paper 1, Variant 3
View
The following incomplete table shows descriptions relating to the security of data transmission. Complete the table with the appropriate terms. Description Term A The original data to be transmitted as a message B An electronic document from a trusted authority that ensures authentication C An encryption method produced by a trusted authority that can be used by anyone Explain the purpose of a digital signature. Describe how a digital signature is produced for transmission with the message.
9608_w19_qp_32
THEORY
2019
Paper 3, Variant 2
View
A software developer works in a team for a large software development company. Two principles of the ACM/IEEE Software Engineering Code of Ethics are: • developers must act consistently with the public interest • developers must act in the best interest of their client and employer. Name and describe three other principles in the ACM/IEEE Software Engineering Code of Ethics. Principle 1 Description Principle 2 Description Principle 3 Description The software development company uses data backup and disk-mirroring to keep their data secure. Explain how data backup and disk-mirroring allow the company to recover from data loss. Data backup Disk-mirroring
9608_s19_qp_11
THEORY
2019
Paper 1, Variant 1
View
Sophie is about to start a new job as a junior software developer. She is worried about joining a new team of people. State one ethical action that Sophie can take to help her to feel more confident about starting work. State two ethical actions that Sophie’s manager can take to help Sophie to feel more confident about starting work. State one ethical action that Sophie’s new colleagues can take to help Sophie to feel more confident about starting work. Explain why Sophie is asked to sign a professional code of conduct before starting work.
9608_s20_qp_12
THEORY
2020
Paper 1, Variant 2
View
Raj has joined a software company as a trainee programmer. He was given the company’s Code of Conduct document during his induction training. The handbook has a section headed ‘Ethical Behaviour’. Describe what is meant by ethics. Raj is assigned to work as a new member of a development team. In his first week, Raj feels uncomfortable working with one of his colleagues. He is unfamiliar with the programming language used by the team. Next week, he will be working on the site of one of the company’s clients with a colleague. Raj is very nervous about working in an unfamiliar workplace. Raj has a review with his manager after his first three weeks. The Code of Conduct document was produced by the Human Resources section. It closely follows the ACM/IEEE Software Engineering Code of Ethics that uses these eight key principles: Public Client and Employer Product Judgement Management Profession Colleagues Self There are issues Raj will want to raise with his manager. • Describe two of these issues. • Circle the key ACM/IEEE principle this comes under. • Suggest what action should be taken to demonstrate ethical behaviour. Issue 1 Description ACM/IEEE principle (Circle one only) Public Client and Employer Product Judgement Management Profession Colleagues Self Possible action
9608_w17_qp_11
THEORY
2017
Paper 1, Variant 1
View
Raj has joined a software company as a trainee programmer. He was given the company’s Code of Conduct document during his induction training. The handbook has a section headed ‘Ethical Behaviour’. Describe what is meant by ethics. Raj is assigned to work as a new member of a development team. In his first week, Raj feels uncomfortable working with one of his colleagues. He is unfamiliar with the programming language used by the team. Next week, he will be working on the site of one of the company’s clients with a colleague. Raj is very nervous about working in an unfamiliar workplace. Raj has a review with his manager after his first three weeks. The Code of Conduct document was produced by the Human Resources section. It closely follows the ACM/IEEE Software Engineering Code of Ethics that uses these eight key principles: Public Client and Employer Product Judgement Management Profession Colleagues Self There are issues Raj will want to raise with his manager. • Describe two of these issues. • Circle the key ACM/IEEE principle this comes under. • Suggest what action should be taken to demonstrate ethical behaviour. Issue 1 Description ACM/IEEE principle (Circle one only) Public Client and Employer Product Judgement Management Profession Colleagues Self Possible action
9608_w17_qp_13
THEORY
2017
Paper 1, Variant 3
View
Questions Discovered
304