THEORY QUESTIONS
OBJECTIVE QUESTIONS
THEORY ANSWERS
(1a)
Disk space analyzer
[PICK ANY ONE]
(i) Helps to identify files and folders that are taking up too much space on the hard drive
(ii) Provides a graphical representation of disk usage
(iii) Allows for the sorting of large files and folders by size
(iv) Facilitates the deletion of unnecessary files and folders
(v) Enables the user to free up disk space for other applications
(vi) Helps to optimize the performance of the computer by reducing unnecessary file clutter.
(1b)
Backup utility
[PICK ANY ONE]
(i) Creates backup copies of data files and settings
(ii) Provides an automated backup schedule to keep the data up-to-date
(iii) Offers different types of data backups such as full differential or incremental
(iv) Ensures data security by providing encryption and password protection
(v) Allows the user to restore data from backups in case of system failure or data loss
(vi) Helps to ensure the continuity of business operations in the event of a disaster.
(1c)
Register cleaner
[PICK ANY ONE]
(i) Scans the Windows Registry for errors and invalid entries
(ii) Cleans up obsolete redundant and unwanted registry entries
(iii) Helps to improve the overall performance of the computer by accelerating Windows boot-up times
(iv) Streamlines the registry system
(v) Makes system backups in case of accidental deletion of essential registry files
(vi) Prevents system crashes and maximizes the stability of the operating system.
(1d)
File manager
[PICK ANY ONE]
(i) Allows for the management of files and folders on the computer
(ii) Provides a user-friendly interface for navigating and opening files
(iii) Enables the creation deletion and renaming of files and folders
(iv) Helps to organize files and folders by allowing for the creation of groups
(v) Facilitates the transfer of files and folders between different locations
(vi) Provides advanced search features to locate specific files or folders on the computer.
(1e)
Uninstaller
[PICK ANY ONE]
(i) Enables the user to remove unwanted software or applications from the computer
(ii) Helps to remove traces of the uninstalled software from the system
(iii) Can remove multiple applications at once
(iv) Provides a complete list of installed programs on the computer
(v) Ensures the complete and safe removal of software including registry entries and associated files
(vi) Helps to improve system performance by freeing up disk space that had been previously occupied by the uninstalled software.
============================================
(2ai)
Malware in computing is a term used to describe any malicious software that is designed to harm or exploit a computer system or its user. Malware can be in the form of viruses worms Trojans ransomware spyware adware bots and rootkits.
(2aii)
[PICK ANY THREE]
(i) Virus
(ii) Worm
(iii) Trojan
(iv) Ransomware
(v) Spyware
(vi) Adware
(vii) Rootkit
(2b)
[PICK ANY THREE]
(i) Slow computer performance
(ii) Unexplained pop-up ads
(iii) Frequent crashes or freezes
(iv) Unusual error messages
(v) Changes to your homepage or search engine
(vi) Loss or corruption of important files
(2c)
[PICK ANY THREE]
(i) Use antivirus and anti-malware software
(ii) Keep your operating system and software up-to-date with the latest security patches
(iii) Be cautious of emails from unknown senders and avoid clicking on suspicious links or attachments
(iv) Use strong and unique passwords for all your accounts
(v) Backup your files regularly
(vi) Educate yourself on how to recognize and avoid malware attacks.
============================================
(3a)
(PICK ANY TWO )
(i) Web Designers
(ii) Graphic Designers
(iii) Artists and Illustrators
(iv) Advertising Professionals
(v) Photographers
(3bi)
(PICK ANY THREE)
(i) Pick tool
(ii) Shape tool
(iii) Crop tool
(iv) Text tool
(v) Eyedropper tool
(3bii)
(PICK ANY THREE TOOLS, MAKE SURE IT IS SAME WITH THE THREE YOU PICKED IN 3bi)
(i) Pick tool:
(PICK ANY ONE)
– To Select and move objects on the canvas.
-To Adjust the size, rotation, and position of selected objects.
(ii) Shape tool:
(PICK ANY ONE)
-To Create and modify geometric shapes such as rectangles, ellipses, polygons, and stars.
-To Edit the nodes and curves of existing shapes to create custom designs.
(iii) Crop tool:
(PICK ANY ONE)
-To Remove unwanted parts of an image or artwork by cropping it.
-To Adjust the dimensions and aspect ratio of the cropped area.
(iv) Text tool:
(PICK ANY ONE)
– Add and edit text in various fonts, sizes, and styles.
– Format text with options for alignment, spacing, and effects.
(v) Eyedropper tool:
(PICK ANY ONE)
-To Sample and select colors from existing objects or images.
-To Apply the selected color to other objects or elements in the design
(3c)
(PICK ANY TWO)
(i) CorelDRAW is popularly used for graphic design.
(ii) CorelDRAW provides powerful tools for creating digital illustrations.
(iii) CorelDRAW is also suitable for designing page layouts for print and digital media.
(iv) CorelDRAW offers features specifically tailored for web design and development.
(v) CorelDRAW is used for vector editing
============================================
(4ai)
[PICK ANY ONE]
(i) Fragmentation refers to dividing a database into smaller pieces WHILE replication involves creating multiple copies of data to be stored on different servers.
(ii) Fragmentation is done to improve performance by reducing the amount of data that needs to be accessed WHILE replication is done to improve availability and reliability of data by creating redundant copies.
(iii) Fragmentation involves storing data in different locations WHILE replication involves storing copies of data in the same or different locations.
(iv) Fragmentation can lead to inconsistent data due to the distribution of data WHILE replication ensures consistent data by keeping copies up-to-date.
(v) Fragmentation can introduce complexity in managing data WHILE replication simplifies data management by allowing for easy backups and fail over.
(vi) Fragmentation can reduce network usage by reducing the data that needs to be transferred WHILE replication can increase network usage by creating redundant copies of data.
(4aii)
[PICK ANY TWO]
(i) By replicating data across multiple servers, database replication ensures increased availability of data
(ii) Replication provides an effective means for recovery of catastrophic events such as natural disasters, hardware failures, or data center outages
(iii) Multiple replicas can handle read requests, distributing the workload and reducing the burden on a single server, thereby, improving performance and ensuring that databases accommodates increasing traffic and user demands without experiencing performance bottlenecks.
(iv) Database replication allows data to be distributed across different geographical regions.
(v) Replication enables the creation of separate database instances for specific purposes, such as offline data processing or analytics
(4bi)
(PICK ANY TWO)
(i) Horizontal fragmentation
(ii) Vertical fragmentation
(iii) Mixed or Hybrid fragmentation
(4bii)
[PICK ANY TWO]
(i) MySQL
(ii) Oracle Database
(iii) Microsoft SQL Server
(iv) IBM DB2
(v) SQLite
============================================
No5
============================================
No6
============================================
OBJECTIVE ANSWERS
DATA PROCESSING
1-10: DADBABCDCA
11-20: BDAABADCAD
21-30: CBBBDBCDDD
31-40: CCDBCDAADD