State three reasons why it is important to define datatypes of fields in a database correctly.8/1/2021 State three reasons why it is important to define datatypes of fields in a database correctly.
Reasons for defining datatypes in databases
0 Comments
State two advantages of making payments through a mobile phone.
Advantages of mobile phone in payments
A computer technician found it necessary to disable a firewall when working on a computer system. State two reasons that may have necessitated disabling of the firewall.
When firewall is disabled
State three circumstances under which voice input would be preferred over other methods of data capture.
Circumstance for voice input
List four factors to be considered when acquiring a printer.
Factors to consider when acquiring a printer
State three benefits of using optical magnetic reader to register candidates for an examination.8/1/2021 State three benefits of using optical magnetic reader to register candidates for an examination.
Benefits of using OMR
State three possible causes of fire outbreak in a computer laboratory.
Sources of fire in a computer laboratory
Distinguish between an assembler and an interpreter as used in programming.
Write the acronym MODEM in full.
Explain the purpose of a modem when connecting to the internet.
State two advantages of using portable computers.
Advantages of portable computers
Figure 1 shows relationships between tables in a database.
Identify two primary and two foreign keys used in the relationship.
Primary keys
List six file manipulation activities that may be carried out using an operating system.
File manipulation activities- creation of files/folders
State two circumstances under which warm booting of a computer may be necessary.
Reasons for warm booting a computer
Describe the octal number system.(a) Describe the octal number system. (b) Convert each of the following to the number system indicated: (i) 111.1012 to decimal;(ii) 14.687510 to binary.(c) Convert the number -17 10 into 8-bit: (i) signed magnitude representation;(ii) two’s complement.(d) Perform the arithmetic operation 110.112 + 11.0112
RESPONSES
(a) Characteristics of octal number system.
The following is an extract from a document created using a wordprocessor.
Identify six formats that have been applied on the extract.
(b) State three tools in a wordprocessor that would help a user to minimize spelling mistakes when creating a document. (c) The following is an extract of a spreadsheet created to manage sales. Use it to answer the questions that follow.
(i)Write a formula that will compute the number of items whose unit price is more than 10,000.
(ii) If the formula = $R2 * C$2 was placed in cell D2, state the output if it was copied to D3. (d) A school administers examinations to all students in sciences, humanities and languages. Use the entities; EXAMINATIONS, STUDENTS, SCIENCES,HUMANITIES and LANGUAGES to illustrate a network database model.
RESPONSES
(a) Formats applied
State the role of each of the following data communication devices:repeater and router
(b) Figure 3 shows a network based on the bus topology.
(i) Identify the component labelled P. (ii) State the function of the component labelled P. (c) Students of Neema Secondary School formed an environmental club with a goal of taking part in environmental conservation activities. Outline three ways in which they can use the internet to achieve this goal. (d) (i) A company has three branches A, B and C where A is the headquarter. The local area network (LAN) at A is directly connected to the LAN at B and directly to the LAN at C. Explain two benefits of having the LAN at B also directly connected to the LAN at C. (4 marks) (ii) State three ways in which a company can protect its computer network from hackers.
(a) (i) Repeater
(ii) Terminator in a backbone is used to prevent data signal from bouncing back/absorb signals. (c) Use of internet in environmental conservation club
With the aid of a diagram. describe time sharing mode as used in computer data processing.
(b) A company’s management has opted to use computers to process data. State four factors that the management needs to consider when selecting the company data processing mode.
(c) Explain the purpose of each of the following in system documentation: (î) user manual; (ii) sample data: (iii) table descriptions.
RESPONSES
(a) Time-sharing mode
This is a processing mode in which a central processor serves two or more users with different requirements. The processor time is divided equally among the tasks in the queue. A user whose task requirements are more than is apportioned is send back to the queue. For example, four jobs requiring times t1, t2, t3 and t4 to complete is apportioned equal time in each round until when they are done.
(b) Factors to consider when selecting data processing mode
State two advantages of using low level programming languages.(b) Other than flowcharts, state three tools that can be used to present an algorithm.
|
Categories
All
Archives
January 2025
|