WAEC Data Processing 2023 past questions and answers

Artificial intelligence is a feature of

1. A.second generation computers.
2. B.third generation computers.
3. C.fourth generation computers.
4. D.fifth generation computers.

The Difference Engine and the Analytical Engine were invented by

1. A.Ada Lovelace and Charles Babbage.
2. B.Blaise Pascal.
3. C.Charles Babbage.
4. D.Blaise Pascal and Ada Lovelace.

Which of the following data elements ranks highest in size?

1. A.Bit.
2. B.Byte
3. C.Field
4. D.Record

The aim of administering questionnaire is to collect

1. A.data.
2. B.information.
3. C.statistics.
4. D.specimen.

Which of the following computer types represents data as variable and continuous values?

1. A.Analogue computer
2. B.Digital computer
3. C.Mainframe computer
4. D.Microcomputer.

A digital platform for the delivery of public sector information and seminar to citizens is called

1. A.e-library.
2. B.e-government.
3. C.e-commerce.
4. D.e-learning.

One application of ICT in medicine is

1. A.global positioning system.
2. B.seismic software.
3. C.computerized axial tomography.
4. D.optical character recognition.

A pointing device that controls cursor movement on the screen is

1. A.keyboard
2. B.monitor.
3. C.plotter.
4. D.trackball

The process of drawing inference from a piece of information is called

1. A.analysis
2. B.collation.
3. C.interpretation.
4. D.organization.

The volume of data that can be sent from one point to another in a given time period is called

1. A.baud
2. B.bandwidth
3. C.byte.
4. D.broadband.

The equipment shown in Figure 1 is used for

1. A.audio transmission
2. B.ethernet connection
3. C.infrared transmission.
4. D.radio transmission.

A student in the school hostel was able to upload some personal details on the school portal via the school's WiFi. The ISP and the hostel are both domiciled in the school premises.
What type of network is illustrated above?

1. A.LAN
2. B.MAN
3. C.PAN
4. D.WAN

A student in the school hostel was able to upload some personal details on the school portal via the school's WiFi. The ISP and the hostel are both domiciled in the school premises.
The physical infrastructure through which internet traffic are exchanged between the ISP in the school illustrated above and other ISPs is called

1. A.internet exchange point.
2. B.server farms.
3. C.subscriber end points.
4. D.switch racks.

Figure 2 is an e-mail application interface. Use it to answer questions 15 and 16.
New messages received are saved in the part labelled

1. A.I.
2. B.II.
3. C.III.
4. D.IV.

Figure 2 is an e-mail application interface.
To send an e-mail, the user must click on the part labelled

1. A.I
2. B.II.
3. C.III.
4. D.IV.

The allocation and de-allocation of computing resources in a computer is the function of

1. A.application software.
2. B.browsers.
3. C.memory unit.
4. D.operating system.

The ruler feature in MS Word that is used to indent the second and subsequent lines of a paragraph is

1. A.hanging indent.
2. B.left indent.
3. C.left margin.
4. D.right indent.

Figure 3 is a Microsoft Excel Worksheet. Use it to answer questions 20 and 21.
What formula will correctly display the total number of individuals involved in the computation as shown in Figure 3?

1. A.= COUNT(A2:A5)
2. B.= COUNTA(A2:A5)
3. C.= COUNTIF(A2:A5)
4. D.= SUM (A2:A5)

Figure 4 is an entity relationship diagram in MS Access. Use it to answer questions 22 and 23.
How many entities are listed in Figure 4?

1. A.3
2. B.5
3. C.25
4. D.30

Figure 4 is an entity relationship diagram in MS Access.
What kind of relationship exists between users and products as shown in Figure 4?

1. A.One-to-many
2. B.One-to-one
3. C.Many-to-many
4. D.Many-to-one

Figure 5 is an MS PowerPoint application interface. The part used to apply motion effect to different objects of a slide is labelled

1. A.I.
2. B.II.
3. C.III.
4. D.IV.

Macromedia Dreamweaver application is used for

1. A.graphic designs.
2. B.intranet communication.
3. C.surfing the internet.
4. D.web design.

The following features are found in the toolbox of CorelDraw application except

1. A.ellipse tool.
2. B.marque tool.
3. C.rectangle tool.
4. D.text tool.

When performing computer recovery operations after a system crash, the startup disk is used to

1. A.backup deleted users file.
2. B.recover the system disk from an image file.
3. C.restore the system to an earlier time.
4. D.update the application packages.

A computer system under use was found to unusually slow, freezes often and very dusty. What is needed to correct this problem?

1. A.Change the location of the computer
2. B.Delete some files
3. C.Hit the system unit with a blower
4. D.Perform maintenance procedure.

Computer ethical practices include the following except

1. A.exposure of vulnerability in websites.
2. B.respect for intellectual property.
3. C.use of polite words on other users.
4. D.use of other people's computer without due permission.

Which of the following devices is needed by a technician for protection against electrostatic discharge?

1. A.Magnet
2. B.Screw driver
3. C.Surge protector
4. D.Wrist strap

People who use Cathode Ray Tube monitor without antiglare screen are susceptible to

1. A.back ache
2. B.repetitive strain injury.
3. C.blurred vision.
4. D.stiffness of the wrist.

Database Administrator is a professional who

1. A.tests and detects vulnerabilities on hardware devices and software.
2. B.handles packet sniffing in a network.
3. C.designs, implements and maintains a database.
4. D.performs data entry in a database.

The following precautionary measures are taken against virus infection except

1. A.regular updating of antivirus.
2. B.downloading e-mail attachment before scanning it.
3. C.avoiding the installation of pirated software.
4. D.avoiding booting the computer with disks in it.

Computer malware is detected by

1. A.adware.
2. B.antivirus.
3. C.antiglare.
4. D.logic bomb.

Use Table 1 to answer questions 35 and 36.
Columns 2 and 3 in Table 1 cannot be used as primary key because both fields contain

1. A.the same datatype.
2. B.only strings and numbers respectively.
3. C.duplicate values.
4. D.different datatypes.

The attributes in Table 1 are

1. A.18/001, 18/002, 18/003.
2. B.Yellow, Blue, Yellow.
3. C.14, 15, 15.
4. D.Reg. No, House, Age.

The speed of access to files in a random access file compared to other file organization methods is

1. A.relatively fast.
2. B.slow.
3. C.the same.
4. D.very slow.

A type of file organization that stores data in the order of their arrival is called

1. A.sequential file organization.
2. B.random file organization.
3. C.indexed-sequential file organization.
4. D.hashed file organization.

The following terms describe the importance of data security except data

1. A.availability.
2. B.consistency.
3. C.integrity.
4. D.normalization.

Advantages of parallel database include the following except

1. A.greater flexibility.
2. B.high availability.
3. C.high performance.
4. D.huge resources.

Paper 2, Essay questions
State one function for each of the following utility programs. (a) disk space analyser; (b) backup utility; (c) registry cleaner; (d) file manager; (e) uninstaller.

Paper 2, Essay questions
(a) (i) What is malware in computing? (ii) List three types of malware. (b) State three symptoms of malware infection. (c) Give two ways of preventing malware infection.

Paper 2, Essay questions
(a) Name two computer professionals that use CorelDraw in the performance of their duties. (b) (i) List three tools in the CorelDraw tool box. (ii) Give one function of each tool listed in 3(b)(i). (c) State two uses of CorelDraw as an application software.

Paper 2, Essay questions
(a) With reference to database management system, state: (i) one difference between fragmentation and replication. (ii) two advantages of replication. (b) List two: (i) types of fragmentation. (ii) examples of relational database management system.

Paper 2, Essay questions
Table 1 shows the specification of two laptop computers. Use the table to answer questions 5(a) to 5(e).
(a) Which laptop will likely boot faster? (b) Calculate the maximum number of bytes of data that can be stored in the hard disk of: (i) Laptop A; (ii) Laptop B; (c) State the type of operating system installed in both laptop A and Laptop B. (d) State one function of the Bluetooth in Laptop A. (e) A certain salesperson makes a long trip by road as part of his job and also uses the computer for live communication with his customers. (i) Which of the laptops is more suitable for the salesperson? (ii) Name three features of the laptop chosen in 5(e)(i) that makes it more suitable than the other. (iii) Give one reason for choosing each of the features in 5(e)(ii).

Paper 2, Essay questions
(a) A class teacher uses a database to keep students' records. Table 2 shows part of the information in the database. (i) Identify the primary key; (ii) give one reason for the answer in 6(a)(i); (iii) explain three methods the teacher could employ in order to secure the students' data.
(b) Outline the steps to create a drop-down list in an MS Excel worksheet.
(c) The image in Figure 1 is captured from a product in a supermarket. Use the image to answer questions 6(c)(i) to 6(c)(iii). (i) identify the image in Figure 1. (ii) give two other application areas of the image in Figure 1. (iii) state three benefits of using the image in Figure 1.