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.
Form
Table
Query
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.
Which of the following terms is not a feature of distributed database?
Fragmentation
Multiple storage
Replication
Single server
Correct answer is D
No explanation has been provided for this answer.
To prevent the loss of data in the computer, it is better to implement file
Access
Maintenance
Checks
Backup
Correct answer is D
No explanation has been provided for this answer.
The following media are used for information transmission except
Diary
Magazine
Radio
Television
Correct answer is A
No explanation has been provided for this answer.
A file organization that contains a reference number is called
Direct access
Indexed access
Random access
Sequential access
Correct answer is B
No explanation has been provided for this answer.
The best arrangement that gives the correct order of magnitude of the database element is
Character, field, record, table, database, file
Character, field, record, table, file, database
Record, file, field, table, character, database
Table, file, record, field, character, database
Correct answer is B
No explanation has been provided for this answer.
The function of the SQL statement SELECT Student ID, Surname, House Name FROM Student, is that it
Retrieves the listed fields from student table
Highlight the listed fields from student table
Hides the selected fields from student table
Deletes the listed fields from students table
Correct answer is A
No explanation has been provided for this answer.
One advantage of information processing is that
Face-to-face interaction among staff may be reduced
Initial investment cost can be high
Running cost becomes lower in the long term
It encourages the training/retraining of staff
Correct answer is A
No explanation has been provided for this answer.
A system analyst is a person who
Designs flowchart
Designs and implements new solutions
Trains computer users
Writes complex computer programs
Correct answer is B
No explanation has been provided for this answer.
Store Manager at Xpedient Services
Assistant Accountant at Qatar Charity Organization
Civil Engineer at Emmaking Construction Limited
Financial Analyst at Fosad Consulting Limited
Logistics Supervisor at Médecins Sans Frontieres (MSF)
Research Program Manager at Rekrut Consulting
Graphics Designer / Digital Marketer at Meritabode Nigeria Limited
Chinese Translator at Lifemate Nigeria Limited
Social Media Specialist at Globe Medical International Limited