Danho
ZIMSEC O Level · 4021/2 · N2020

Computer Science Paper 2 November 2020

Questions
28
Total marks
100
Time allowed
150 min
Syllabus code
4021/2

Sit this paper online

Questions
28
Pass mark
17
Sit this paper

Answer every question in the printed order, get marked at the end, then see the answers.

The questions

Question 101

[1 marks]Computer system architecture
In the standard block diagram of a computer system, name the component of the Central Processing Unit (CPU) that performs arithmetic and logical operations on data.

Answer this when you sit the paper.

Question 102

[1 marks]Computer system architecture
Which of the following is NOT one of the five basic hardware components of a computer system?
  1. AInput devices, such as a keyboard, mouse or scanner used to enter data
  2. BOutput devices, such as a monitor or printer used to present processed results
  3. CBacking storage
  4. DCompiler software

Question 201

[1 marks]Real time stock control and point of sale
A real time stock control system in a supermarket scans an item's barcode at the point of sale. What happens immediately after the barcode is scanned?
  1. AThe stock file is searched for a product matching the scanned code
  2. BMore stock is automatically re-ordered
  3. CThe new stock figure is written back to the file
  4. DAn itemised receipt is printed for the customer to take to the till operator

Question 202

[1 marks]Real time stock control and point of sale
Which of the following is an advantage of using point of sale (POS) terminals for supermarket transactions?
  1. AThey increase the number of staff needed at checkouts
  2. BThey allow shopping trends to be identified from sales data
  3. CThey make automatic re-ordering of stock impossible, so staff must reorder by hand
  4. DThey require more stationery than manual tills

Question 301

[1 marks]Protocols and network models
State the term for a set of rules that determines how devices within a network communicate and interact with each other.

Answer this when you sit the paper.

Question 302

[1 marks]Protocols and network models
Which of the following is one of the layers of the Open Systems Interconnection (OSI) model?
  1. AEncryption Layer, where messages are scrambled before being sent across the network
  2. BDatabase Layer
  3. CApplication Layer
  4. DCompiler Layer

Question 303

[1 marks]Protocols and network models
Which of the following statements correctly describes a simplex data transmission mode?
  1. AData cannot be transferred at all.
  2. BData is transferred in only one direction.
  3. CData travels in both directions simultaneously.
  4. DData travels in both directions, but not at the same time.

Question 401

[1 marks]Data protection legislation
State the term for the set of legal guidelines governing how personal data about individuals should be obtained, processed, stored and maintained.

Answer this when you sit the paper.

Question 402

[1 marks]Data protection legislation
Which of the following is NOT a requirement of the Data Protection Act?
  1. APersonal data may be sold to any third party without the owner's permission
  2. BPersonal data must be processed fairly and lawfully
  3. CPersonal data must be protected from accidental damage
  4. DPersonal data must be kept accurate and up to date

Question 403

[1 marks]Data protection legislation
State one natural or environmental event, other than deliberate human action, that can cause data held on a computer system to be accidentally lost.

Answer this when you sit the paper.

Question 501

[1 marks]Algorithms and the systems development life cycle
State the term for a sequence of steps designed to perform a particular task, specifying the actions to be executed and the order in which they are executed.

Answer this when you sit the paper.

Question 502

[1 marks]Algorithms and the systems development life cycle
Which of the following is a tool commonly used in the design stage of the systems development life cycle?
  1. AMicrosoft Excel
  2. BMicrosoft Visio
  3. CMicrosoft Access
  4. DAdobe Photoshop

Question 601

[1 marks]Algorithms
An algorithm inputs the numbers 5, -3, 0, 8, -2 one at a time and counts how many of the numbers input are positive (greater than 0). How many positive numbers are counted?

Answer this when you sit the paper.

Question 602

[1 marks]Algorithms
An algorithm inputs the numbers 4, -7, 0, -1, 6, 9 one at a time and counts how many of the numbers input are negative (less than 0). How many negative numbers are counted?
  1. A1
  2. B2
  3. C3
  4. D4

Question 701

[1 marks]Programming constructs
Which of the following is NOT one of the three basic programming constructs?
  1. ASequence, executing statements one after another
  2. BSelection, branching between alternatives with a condition
  3. CRepetition
  4. DCompilation

Question 702

[1 marks]Programming constructs
State the term for the programming construct in which instructions are executed one after another, in the order they are written, with no branching or repetition.

Answer this when you sit the paper.

Question 801

[1 marks]Web authoring
State the HTML tag used to define the title that appears in a web page's browser tab, for example inside the head section of the page.

Answer this when you sit the paper.

Question 802

[1 marks]Web authoring
State the term for a keyword that defines how a web browser will format and display web content, such as <title> or <body>.

Answer this when you sit the paper.

Question 803

[1 marks]Web authoring
State the term for an individual component of an HTML document, for example the part of the document that represents its title.

Answer this when you sit the paper.

Question 901

[1 marks]Number bases
Convert the binary number 1010010 to octal.

Answer this when you sit the paper.

Question 902

[1 marks]Number bases
Convert the binary number 111011001 to octal.
  1. A371
  2. B713
  3. C730
  4. D731

Question 903

[1 marks]Number bases
Convert the hexadecimal number AF5 to denary.
  1. A2085
  2. B2508
  3. C2805
  4. D2850

Question 1001

[1 marks]SQL
State the SQL keyword used to retrieve (select) data from a database table.

Answer this when you sit the paper.

Question 1002

[1 marks]SQL
State the SQL command used to remove a row from a database table.

Answer this when you sit the paper.

Question 1003

[1 marks]SQL
Which of the following SQL statements correctly deletes the row where StudentID = 5 from a table named students?
  1. ADROP FROM students WHERE StudentID = 5;
  2. BDELETE students SET StudentID = 5;
  3. CDELETE FROM students WHERE StudentID = 5;
  4. DREMOVE FROM students WHERE StudentID = 5;

Question 1101

[1 marks]Database management systems
State the term for a software system that allows users to define, create and maintain a database, and that provides controlled access to the data.

Answer this when you sit the paper.

Question 1102

[1 marks]Database management systems
Which of the following is a function of a Database Management System (DBMS)?
  1. AEnforcing security so that only authorised users can access the database
  2. BCompiling source code into machine code before the program can run
  3. CRendering web pages in a browser
  4. DRouting data packets between network devices

Question 1201

[1 marks]Marketing and intellectual property
Which of the following is a factor that affects a company's marketing strategy?
  1. AThe physical fitness of the sales manager
  2. BThe colour of the company's office furniture
  3. CEconomic factors such as income levels and inflation
  4. DThe programming language used to build the company's payroll system

More sittings of this paper

The answers, and why they are the answers

Sit the paper here to see which ones you got right. Danho explains every question, keeps your score, and works without a connection.

Get it on Google PlayDownload on the App Store