cameroon gce june 2015 ICT Paper 2

cameroon gce  june  2015 ICT Paper 2

TO DOWNLOAD ICT  JUNE  2015 Paper 2 CLICK BELOW

1.

(i)

(a) Explain two reasons why robots are useful to industries.  ( 2marks )
(b) Describe two measures that can be taken to secure a banking system ( 4marks)

(ii)

(a) Describe a DBMS.  ( 2marks )
(b) What is relational database? –   ( 2marks )
(c) Give two disadvantages ofa flat file in databases.   ( 2marks )

(iii)
(a) Explain the term “Programming paradigm”.  (1 mark)

(b)  Define   the following programming  paradigms
(i)  Procedural programming
(ii) Declarative programming.;  (4 marks)

2.

(i)

(a)What is network topology? ( 2 marks)

(b)Explain two considerations in selecting a tooology for a school network.(4 marks)

3.

(ii)

(a) What is prototyping?
(b)Give two reasons for prototyping

(iii)
(a) What is a program control structure? –
(b) Using either Pascal or C programming language write out the general form for the following control structures.
Sequence  ( 1 marks)
FOR statement and  ( 1marks)
WHILE statement ( 1 marks)
(c)Draw the flowchart symbol for the choice/selection structure. ( 2 marks)

3.

(i)

(a) Write out the steps involved in SDLC in an annotated diagram.  ( 2marks)

(b)  Distinguish   between piecemeal and direct system implementation methods. ( 2marks)

(c) Describe one other alternative method of building a system. ( 2marks)

(ii)

(a) State two functions of a project manager in project management.  ( 2marks)

(b) With respect to project management, describe a PERT chat, stating all the elements involved. ( 2marks)
(c)What is the importance of identifying the critical path of a project?

( 1 marks)

(iii) Discuss TWO possible effects on people who live in some developing countries of having
no access or very limited access to ICT. ( 6 marks)

4.

(a) What is a file format? Give one type of file format.   (2 marks)
(b) Explain one importance of file format ·   (1 marks)
(c) State two reasons why file formats vary.     (2 marks)

(ii)

(a) Systems need protection from hazards e.g, natural hazards such as flood and fire.
Describe two other hazards that may impede a computer system.
(4 marks)

(b) Explain three reasons why wireless communication is not preferred by some organizations. (3 marks)
(a) HTTP.

(b) FTP.

(c)TCP/IP.
Explain the consequence of network communication without each of the following protocols (relate your
answer to the purpose of each protocol).

(3 marks)

(iv) State two wireless standards and give an estimation of their area of coverage. ( 3marks)

5.

With regards to the relational database, discuss with the aid of diagrams, the meaning of the
following:

(a)One-to-one  relationship.  (2 marks)
(b) One-to-many relationship. (2 marks)

(c)Many-to-many relationship. (2 marks)

(ii)

With the help of well labeled diagrams, discribe three commonly used standard network topologies, giving one advantage and one disadvantage for each case.
(6 marks)

.(iii)

Briefly describe each of the following.
(a) E-commerce.
(b)Browser.
(c) E-mails

(d)Search engine.

6.

(i)List and explain TWO main threats to the safety of data.

(ii) How does the Data Protection Act define the following terms? irea following terrse.

(a)Personal data.
(b)Data.
(c) DataSubject.
( 3marks)

(ii) Differentiate between “synchronous” and “asynchronous” data transmission. ( 2marks)

(iii)Explain each of the following project management terminologies.
(a) Project.
(b) Critical path.
( c)Gantt chart.                                                                          ( 5 marks)
(iv) Name three important factors to consider when designing a new Computer User Interface  ( 3 marks)

7.

(i) Briefly describe the following system software stating the category of each.

(a)Compiler.
(b) Defragmenter.
( c) File compression.      ( 4 marks )

(d) Interpreter.
(ii)State FOUR functions of an operating system when managing a computer’s resources.

( 4 marks)
(iii)Define the term interrupt. State one scenario in which an interrupt is used in the

management of an operating system.     ( 2 marks)

(iv)

(a) What is a pseudo-code?  ( 1mark )

(b) Write a pseudo-code that request marks for 5 subjects and calculates the average assuming
all subjects have equal coefficient. ( 6 marks)

Note that average is given by (total marks)/5 in this case.

8.

(i) Briefly describe the following systems as used in ICT, giving an example of each.

(a)Monitoring system
(b) Control system   ( 6 marks)

(ii)With respect to computer usage, what is ergonomics?
(1 mark)

(iii)
Describe two ways that can be taken to prevent:
(a)Carpal tunnel syndrome (CTS).
(b) Eye strain.

( 4 marks)

(iv) Distinguish between protection and security, giving an example of each. ( 2marks)

(v)Describe how transfare of funds is accomplished in E-commerce. ( 4marks)

8.

Define the following terms:
(a) Process
(b) Interrupt
(c) Deadlock                   (6 marks)

(ii) List two major activities of an operating system with respect to:

(a)Memory management
(b) Secondary storage management
(4 marks)

(iii) Differentiate between multiprocessing and multiprogramming.     (4 marks)
(iv)

(a) What is telemedicine?(1 mark)
(b) Name TWO benefits oftelemedicine to remote communities in Cameroon.
(2 marks)