9618 Computer Science June 2025 Question Paper 13

The student takes a photograph of the picture using a digital camera. The digital camera creates an image with a resolution of 2 million pixels and uses a bit depth of 16 bits.

A teacher records an audio file of the student playing the piano during a music lesson.

Complete the table by giving the term for each description about sound representation on a computer.

\begin{tabular}{|p{7cm}|p{7cm}|} \hline \textbf{Description} & \textbf{Term} \ \hline the number of times the amplitude is measured per time interval & \ \hline the number of bits used to store each amplitude measurement & \ \hline the type of sound wave before it is recorded by a computer & \ \hline \end{tabular}

The student types a report on a computer in a history lesson.

The processor has a Control Unit (CU) and system clock.

The computer has cache memory.

Describe one benefit of the computer using cache memory.

The computer connects to a monitor using a High Definition Multimedia Interface (HDMI) cable that connects into an HDMI port.

Explain how HDMI provides connection to peripheral devices.

Complete the description of compilers and interpreters by writing the missing words.

A compiler checks all the code before attempting to translate the program. If any errors are found, they are all reported at the same time and the program does not translate or run. If there are no errors found, the compiler produces \underline{\hspace{1.5em}} which can run without access to the \underline{\hspace{1.5em}}.

An interpreter translates one line of code and then runs it, before moving to the next line of code. If the line of code has an error, the interpreter \underline{\hspace{1.5em}} and displays the error. The programmer can correct the error \underline{\hspace{1.5em}} and then the interpreter continues translating from that point.

The programmer needs to keep the program files secure on their computer and during electronic data transmission over the internet. The files are protected by a password.

Complete the table by identifying \textbf{one} other method of keeping the files secure during electronic data transmission \textbf{and} \textbf{one} other method of keeping the files secure on the computer.

State how each method protects the data.

The methods must be different.

\begin{tabular}{|l|p{4cm}|p{6cm}|} \hline & \textbf{Method} & \textbf{How the method protects the data} \ \hline \textbf{during transmission} & & \ & & \ \hline \textbf{on the computer} & & \ & & \ \hline \end{tabular}

The computer program allows users to play a game in a virtual world. Users can play the game from any computer with internet access using a web browser. The game allows users to interact with other users.

Explain the reasons why the statement 'This computer game uses a client-server model' is correct.

Describe the possible consequences of the programmer \textbf{not} joining a professional ethical body.

X = \hrulefill

Y = \hrulefill

Complete the truth table for the logic expression:

\begin{tabular}{|c|c|c|c|c|} \hline \textbf{A} & \textbf{B} & \textbf{C} & \textbf{Working space} & \textbf{X} \ \hline 0 & 0 & 0 & & \ \hline 0 & 0 & 1 & & \ \hline 0 & 1 & 0 & & \ \hline 0 & 1 & 1 & & \ \hline 1 & 0 & 0 & & \ \hline 1 & 0 & 1 & & \ \hline 1 & 1 & 0 & & \ \hline 1 & 1 & 1 & & \ \hline \end{tabular}

The current contents of memory are:

\begin{tabular}{r|l|} \cline{2-2} \textbf{Address} & \textbf{Instruction} \ \cline{2-2} \textbf{50} & 47 \ \cline{2-2} \textbf{51} & 48 \ \cline{2-2} \textbf{52} & 49 \ \cline{2-2} \textbf{53} & 50 \ \cline{2-2} ... & \ \cline{2-2} \textbf{500} & LDM #50 \ \cline{2-2} \textbf{501} & DEC ACC \ \cline{2-2} \textbf{502} & CMP 51 \ \cline{2-2} \textbf{503} & JPE 505 \ \cline{2-2} \textbf{504} & JMP 501 \ \cline{2-2} \textbf{505} & STO 50 \ \cline{2-2} \textbf{506} & SUB #10 \ \cline{2-2} \textbf{507} & STO 51 \ \cline{2-2} \textbf{508} & END \ \cline{2-2} \end{tabular}

The table shows part of the instruction set for a processor. The processor has one register: the Accumulator (ACC).

\begin{tabular}{|l|l|l|} \hline \textbf{Opcode} & \textbf{Operand} & \textbf{Explanation} \ \hline AND & \texttt{#n/Bn/&n} & Bitwise AND operation of the contents of ACC with the operand \ \hline AND & \texttt{

Complete the entity-relationship (E-R) diagram for the database.

\begin{tabular}{ccc} \framebox{\quad \texttt{CUSTOMER} \quad} & \qquad\qquad & \framebox{\quad \texttt{ORDER} \quad} \ & & \ & & \ \framebox{\quad \texttt{SUPPLIER} \quad} & & \framebox{\quad \texttt{ORDER_PRODUCT} \quad} \ & & \ & & \ & \framebox{\quad \texttt{PRODUCT} \quad} & \ \end{tabular}

A new product needs to be entered into the database. The product has the ID 002323, the product name ‘Blue ball point 2mm’, there are 50 in a box, the product costs $5.00 and the supplier has the ID SFX223.

Write a Structured Query Language (SQL) script to enter the new product into the table \texttt{PRODUCT}.

The attribute \texttt{Collected} in the table \texttt{ORDER} stores the Boolean value \texttt{TRUE} if the order has been collected and \texttt{FALSE} if the order has not been collected.

Write an SQL script to return the customer name for each customer that has orders they have not collected. Include the number of orders each customer has not collected with an appropriate title.

An example output might be:

\begin{tabular}{|c|c|} \hline \textbf{CustomerName} & \textbf{NotCollected} \ \hline Jack Wright & 2 \ \hline Lin Cho & 1 \ \hline Santaya Yui & 1 \ \hline \end{tabular}

The shop uses a Database Management System (DBMS).

A computer can perform logical and arithmetic shifts.

Complete the following binary addition. Show your working. Include any overflow bit(s).

Subtract the binary number 00011110 from the binary number 01100100 using binary subtraction. Show your working.