9618_s22_qp_11
A paper of Computer Science, 9618
Questions:
6
Year:
2022
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
1
Computers store data in binary form. State the difference between a tebibyte and a terabyte. Convert the signed denary value –100 into an 8-bit two’s complement binary integer. Working Answer Convert the denary number 251 into hexadecimal. Show your working. Working Answer Add the following unsigned binary integers. 0 1 0 1 0 0 0 0 + 0 0 1 1 1 1 1 0
1. Information representation  →  1.1. Data Representation
13. Data Representation  →  13.3. Floating-point numbers, representation and manipulation
Open
2
A computer has hardware and software. The hardware includes different types of memory. Complete the description of computer memory. Random Access Memory (RAM) and Read Only Memory (ROM) are both examples of memory. One item that is stored in RAM is . One item that is stored in ROM is . RAM can be either Static RAM (SRAM) or Dynamic RAM (DRAM). SRAM uses transistors arranged as . DRAM uses transistors and . Explain the difference between Programmable ROM (PROM), Erasable Programmable ROM (EPROM) and Electrically Erasable Programmable ROM (EEPROM). A magnetic hard disk is used to store data on the computer. Describe the principal operations of a magnetic hard disk. Computers consist of logic gates. Complete the table by writing one set of values (input 1 and input 2) for each gate that will give the output 1. Gate Input 1 Input 2 Output AND NAND XOR NOR Write the logic expression for the given logic circuit. A B C X
3. Hardware  →  3.1. Computers and their components
Open
3
A teacher is writing examination papers on a laptop computer. The computer is connected to the internet. The teacher is concerned about the security and privacy of the papers. State the difference between the security of data and the privacy of data. Identify and describe two threats to the data. Identify one security measure to protect against each threat. Each security measure must be different. Threat 1 Description Security measure Threat 2 Description Security measure
6. Security, privacy and data integrity  →  6.1. Data Security
Open
4
A teacher uses a relational database, MARKS, to store data about students and their test marks. The database has the following structure: STUDENT(StudentID, FirstName, LastName) TEST(TestID, Description, TotalMarks) STUDENT_TEST(StudentID, TestID, Mark) Describe the advantages of using a relational database compared to a file-based approach. Give the highest level of Normal Form (NF) the database MARKS is in and justify your choice. Normal Form Justification Sample data to be stored in the table STUDENT_TEST is shown. StudentID TestID Mark A1 P10 A1 P10 Write a Structured Query Language (SQL) script to create the table STUDENT_TEST. Write a Structured Query Language (SQL) script to find the average mark of students in test A7. The mark a student is awarded in a test will be entered into the database. This mark needs to be a whole number between 0 and the maximum number of marks for that test . Explain how data validation and data verification can be used when a mark is entered.
8. Databases  →  8.3. Data Definition Language (DDL) and Data Manipulation Language (DML)
8. Databases  →  8.1. Database Concepts
Open
5
A programmer uses an Integrated Development Environment (IDE) to develop a program. Draw one line from each IDE feature to its correct description. IDE feature Description Context-sensitive prompt Executes one line of the program and then stops Dynamic syntax check Underlines or highlights statements that do not meet the rules of the language Breakpoint Outputs the contents of variables and data structures Single stepping Stops the code executing at a set line Report window Displays predictions of the code being entered The programmer wants to allow users to edit, improve and redistribute the program. Identify two different types of software licence that the programmer could use. Explain the benefits to the programmer of using program libraries.
5. System Software  →  5.1. Operating Systems
12. Software Development  →  12.1. Program Development Life cycle
Open
6
A computer system is designed using the basic Von Neumann model. Describe the role of the registers in the Fetch-Execute (F-E) cycle. Describe when interrupts are detected in the F-E cycle and how the interrupts are handled. Detected Handled Identify one factor that can affect the performance of the computer system and state how it impacts the performance. Factor Impact Question 6 continues on the next page. The table shows part of the instruction set for a processor. The processor has one general purpose register, the Accumulator (ACC). Instruction Explanation Opcode Operand AND #n Bitwise AND operation of the contents of ACC with the operand XOR #n Bitwise XOR operation of the contents of ACC with the operand OR #n Bitwise OR operation of the contents of ACC with the operand LSL #n Bits in ACC are shifted logically n places to the left. Zeros are introduced on the right hand end LSR #n Bits in ACC are shifted logically n places to the right. Zeros are introduced on the left hand end # denotes a denary number, e.g. #123 Complete the register to show the result after the instruction AND #2 is executed. Register before: Register after: Complete the register to show the result after the instruction OR #8 is executed. Register before: Register after: Complete the register to show the result after the operation LSL #4 is executed. Register before: Register after:
4. Processor Fundamentals  →  4.1. Central Processing Unit (CPU) Architecture
Open