Data Processing Questions and Answers

Data Processing questions to test candidates’ acquisition of basic skills of data processing and knowledge in the application of ICT in facilitating business transactions and education.

81.

The database tool that allows the user to select and filter data from multiple tables is referred to as

A.

Form

B.

Table

C.

Query

D.

Report

Correct answer is C

A query in a database is a request for information from a database management system (DBMS), which is the software program that maintains data. Users can make a query to retrieve data or change information in a database, such as adding or removing data.

82.

Which of the following terms is not a feature of distributed database?

A.

Fragmentation

B.

Multiple storage

C.

Replication

D.

Single server

Correct answer is D

No explanation has been provided for this answer.

83.

To prevent the loss of data in the computer, it is better to implement file

A.

Access

B.

Maintenance

C.

Checks

D.

Backup

Correct answer is D

No explanation has been provided for this answer.

84.

The following media are used for information transmission except

A.

Diary

B.

Magazine

C.

Radio

D.

Television

Correct answer is A

No explanation has been provided for this answer.

85.

A file organization that contains a reference number is called

A.

Direct access

B.

Indexed access

C.

Random access

D.

Sequential access

Correct answer is B

No explanation has been provided for this answer.

86.

The best arrangement that gives the correct order of magnitude of the database element is

A.

Character, field, record, table, database, file

B.

Character, field, record, table, file, database

C.

Record, file, field, table, character, database

D.

Table, file, record, field, character, database

Correct answer is B

No explanation has been provided for this answer.

87.

The function of the SQL statement SELECT Student ID, Surname, House Name FROM Student, is that it 

A.

Retrieves the listed fields from student table

B.

Highlight the listed fields from student table

C.

Hides the selected fields from student table

D.

Deletes the listed fields from students table

Correct answer is A

No explanation has been provided for this answer.

88.

One advantage of information processing is that

A.

Face-to-face interaction among staff may be reduced

B.

Initial investment cost can be high

C.

Running cost becomes lower in the long term

D.

It encourages the training/retraining of staff

Correct answer is A

No explanation has been provided for this answer.

89.

The malware which is programmed to initiate at a specific date or when a specific event occurs is called

A.

Directory virus

B.

Logic bomb

C.

Polymorphic virus

D.

Root kit virus

Correct answer is B

No explanation has been provided for this answer.

90.

A system analyst is a person who

A.

Designs flowchart

B.

Designs and implements new solutions

C.

Trains computer users

D.

Writes complex computer programs

Correct answer is B

No explanation has been provided for this answer.