Computer Knowledge PYQs

The correct answer is .exe.

Key Points

• .exe is the file extension used for executable files on Windows operating systems, which are designed to run programs and install software.
• Executable files contain machine code that is directly executed by the computer's CPU, making them essential for software deployment.
• Windows operating systems use .exe files for a variety of tasks, including software installation, application launching, and script execution.
• Security features such as User Account Control (UAC) often prompt users before allowing .exe files to run, helping to prevent unauthorized or malicious activity.

Additional Information

• File Extensions and Their Uses
• .mp3 - A file extension for audio files that use the MPEG-1 or MPEG-2 Audio Layer III compression standard, commonly used for music and podcasts.
• .txt - Represents plain text files that contain unformatted text, used for simple documents and notes.
• .jpg - A commonly used file extension for images, employing the JPEG (Joint Photographic Experts Group) compression method, widely used for digital photos.
• Executable File Security
• Executable files can be a vector for malware and other security threats if downloaded from untrusted sources.
• Users are advised to install antivirus software and keep their systems updated to mitigate risks associated with .exe files.
• Alternative Executable Formats
• .msi - Microsoft Installer files, used for software installation, updates, and configuration.
• .bat - Batch files containing a series of commands to be executed by the Windows command interpreter.

The correct answer is Storing the BIOS or firmware.

Key Points

• ROM (Read-Only Memory) is non-volatile memory, which means it retains its data even when the power is turned off.
• It is primarily used to store the BIOS (Basic Input/Output System) or firmware of a computer, which is essential for the initial boot process.
• The BIOS or firmware contains the necessary instructions for the computer to start up and communicate with its hardware components.
• ROM is not meant for random data access or temporary data storage, as it can only be read and not easily modified.

Additional Information

• BIOS (Basic Input/Output System)
• It is the firmware used to perform hardware initialization during the booting process.
• BIOS provides runtime services for operating systems and programs.
• The BIOS firmware is built into the PC and is the first software that runs when powered on.
• Firmware
• Firmware is a specific class of computer software that provides low-level control for a device's specific hardware.
• It is embedded in the hardware and can be updated to improve functionality and security.
• EEPROM (Electrically Erasable Programmable Read-Only Memory)
• A type of ROM that can be electronically erased and reprogrammed.
• It allows for limited write cycles, making it useful for storing configuration settings.
• Volatile vs. Non-Volatile Memory
• Volatile memory requires power to maintain stored information (e.g., RAM).
• Non-volatile memory retains data even when the power is turned off (e.g., ROM, Flash Memory).

The correct answer is For providing an additional layer of security.

Key Points

• Passwords help in protecting sensitive information stored on the PC by restricting access only to authorized users.
• They act as the first line of defense against unauthorized access and potential data breaches.
• Passwords help in maintaining the privacy of personal and professional data.
• Enabling passwords can prevent unauthorized changes to system settings and software configurations.

Additional Information

• Encryption
• Encryption is the process of converting data into a code to prevent unauthorized access.
• It is used to protect sensitive data both in transit and at rest.
• Common encryption methods include AES (Advanced Encryption Standard) and RSA (Rivest-Shamir-Adleman).
• Two-Factor Authentication (2FA)
• 2FA adds an extra layer of security by requiring two forms of identification before access is granted.
• This usually includes something you know (password) and something you have (mobile device for OTP).
• 2FA is widely used in online banking, email services, and secure systems.
• Biometric Authentication
• Biometric authentication uses unique biological traits such as fingerprints, retina scans, or facial recognition for identification.
• It is considered more secure than traditional passwords as biometrics are harder to replicate.
• Commonly used in smartphones, secure facilities, and high-security areas.
• Antivirus Software
• Antivirus software is designed to detect, prevent, and remove malware, including viruses, worms, and trojans.
• Regular updates are essential for antivirus software to protect against the latest threats.
• Popular antivirus programs include Norton, McAfee, and Kaspersky.

The correct answer is Editing emails that are yet to be sent.

Key Points

• The Outbox is a folder where emails that are ready to be sent are temporarily stored.
• Users can edit emails in the Outbox before they are actually sent.
• This functionality allows for last-minute changes or corrections to the email content.
• Emails stay in the Outbox when there is a connectivity issue or when the user manually saves the email to be sent later.

Additional Information

• Inbox
• The Inbox is used for storing received emails.
• Users can organize, read, and respond to emails in the Inbox.
• Emails in the Inbox can be marked as read, unread, or moved to other folders.
• Sent Items
• The Sent Items folder stores copies of emails that have been successfully sent.
• Users can review their sent emails for reference and follow-up.
• Drafts
• The Drafts folder is used for storing emails that are being composed but are not yet ready to be sent.
• Users can continue editing their drafts and send them when ready.
• Trash
• The Trash folder temporarily stores deleted emails.
• Emails in the Trash can be restored or permanently deleted.

The correct answer is An antivirus program relying on system utilities to perform disk scans and remove malware..

Key Points

• Antivirus programs rely on system utilities to access and scan disk files, ensuring that the malware detection process is thorough and effective.
• System utilities, which are part of system software, provide the necessary functions and interfaces that antivirus programs use to interact with the hardware and file system.
• System software such as the operating system manages hardware resources, which antivirus applications depend on to monitor and protect the system.
• Without system utilities and the underlying operating system, antivirus programs would not be able to execute their scanning and removal processes effectively.

Additional Information

• System Software
• Includes the operating system and all utility programs that manage computer resources at a low level.
• Examples are Windows, macOS, Linux, and system utilities like disk defragmenters and file management tools.
• Application Software
• Software designed to help the user perform specific tasks such as word processing, web browsing, or managing antivirus protection.
• Examples include Microsoft Word, Google Chrome, and Norton Antivirus.
• Interdependence
• Application software relies on system software to function properly, as it provides the necessary environment and resources for applications to run.
• System software acts as a mediator between the hardware and application software, ensuring efficient resource allocation and management.
• Examples of Interdependence
• Device drivers allow the operating system to communicate with hardware peripherals, which application software then uses to perform tasks.
• Web browsers (application software) require network protocols handled by the operating system to access the internet.

The correct answer is Ctrl + M.

Key Points

• The keyboard shortcut Ctrl + M is used in MS Word to increase the indent of a paragraph.
• When you press Ctrl + M, the entire paragraph is indented to the right by one tab stop.
• This shortcut is particularly useful for formatting documents, making it easier to distinguish between different sections or points.
• Indentation is a common formatting feature in word processors and helps in improving the readability of documents.

Additional Information

• Paragraph Indentation
• Indentation refers to the space between the text and the page margin.
• In MS Word, indentation can be controlled through the ruler or by using specific shortcut keys.
• Types of Indentation
• First Line Indent: Indents the first line of a paragraph.
• Hanging Indent: Indents all lines of a paragraph except the first one.
• Left Indent: Moves the entire paragraph to the right.
• Right Indent: Moves the entire paragraph to the left.
• Customizing Indents
• Indents can be customized through the Paragraph dialog box in MS Word.
• You can set specific measurements for indents to achieve the desired formatting.
• Other Useful Shortcuts for MS Word
• Ctrl + L: Aligns text to the left.
• Ctrl + E: Aligns text to the center.
• Ctrl + R: Aligns text to the right.
• Ctrl + J: Justifies the text.

The correct answer is Press Esc.

Key Points

• Pressing the Esc key on your keyboard immediately exits the slide show and returns you to the editing mode in MS PowerPoint.
• The Esc key is used for escaping or exiting full-screen modes and other types of ongoing tasks in various software applications.
• In MS PowerPoint, Esc is the default shortcut for terminating the presentation mode.
• This action will take you back to the normal view where you can edit slides.

Additional Information

• Slide Show Mode in PowerPoint
• Slide Show mode allows the presentation to be displayed full screen, making it suitable for viewing by an audience.
• In this mode, animations, transitions, and multimedia elements are activated.
• The presentation can be navigated using the keyboard, mouse, or a remote clicker.
• Normal View
• Normal View is the primary editing view in PowerPoint, which includes the Slide pane, Notes pane, and the Slide thumbnail pane.
• This view allows users to create and edit slides, add text, images, and other elements.
• Keyboard Shortcuts for PowerPoint
• F5: Start the slide show from the beginning.
• Shift+F5: Start the slide show from the current slide.
• Ctrl+P: Annotate the slide show with a pen.
• B: Make the screen black during the slide show.
• Exiting Other Modes
• Alt+Tab: Switch between open applications in Windows.
• Ctrl+S: Save the current document or project in most applications.
• Spacebar: Used primarily for advancing to the next slide in PowerPoint, not for exiting.

The correct answer is Hashing.

Key Points

• Hashing is a process of converting data into a fixed-size string of characters, which is typically a hash code.
• It is commonly used to verify the integrity of data by ensuring that the data has not been altered.
• Hash functions are designed to be fast and to produce unique hashes for unique inputs.
• Popular hashing algorithms include MD5, SHA-1, and SHA-256, each with varying levels of security.
• Hashing is widely used in applications such as password storage, data verification, and digital signatures.

Additional Information

• Hash Function
• A hash function takes an input and returns a fixed-size string of bytes.
• Even a small change to the input will produce a significantly different output.
• Collision
• A collision occurs when two different inputs produce the same hash output.
• Good hash functions minimize the chances of collisions.
• MD5
• MD5 (Message Digest Algorithm 5) produces a 128-bit hash value.
• It is widely used but is considered cryptographically broken and unsuitable for further use.
• SHA-256
• SHA-256 (Secure Hash Algorithm 256-bit) is part of the SHA-2 family, designed by the NSA.
• It produces a 256-bit hash value and is widely used in security applications and protocols.
• Digital Signatures
• Hashing is used in digital signatures to create a unique representation of data.
• Digital signatures ensure data authenticity and integrity.

The correct answer is File -> New -> Blank Presentation.

Key Points

• To create a blank presentation in MS PowerPoint, you start by clicking on the File tab located in the top left corner of the interface.
• Next, you select the New option from the dropdown menu.
• After selecting New, you will be given various templates and themes. To create a blank presentation, you choose Blank Presentation.
• This process ensures that you begin with a clean slate, allowing you to build your presentation from scratch without any pre-set designs or content.

Additional Information

• MS PowerPoint Interface
• The PowerPoint interface includes several key areas such as the Ribbon, Slide Pane, Notes Section, and the Slide Sorter.
• The Ribbon at the top contains tabs like Home, Insert, Design, Transitions, Animations, Slide Show, Review, and View, each offering different tools and options.
• Templates and Themes
• PowerPoint offers a range of templates and themes to provide pre-designed slides with various layouts and design elements.
• Templates can save time and ensure consistency in design throughout the presentation.
• Slide Master
• The Slide Master is a tool that allows users to make universal design changes to the entire presentation by modifying the master slide.
• Changes made in the Slide Master reflect on all slides that follow that master template.
• Shortcut Keys
• PowerPoint offers several shortcut keys for efficiency, such as Ctrl+N for creating a new presentation, Ctrl+M for inserting a new slide, and F5 to start the slideshow from the beginning.
• Utilizing shortcut keys can significantly speed up the workflow.

The correct answer is Paragraph Alignment.

Key Points

• Paragraph Alignment in MS Word allows users to align text to the left, center, right, or justify it across the page.
• This feature can be accessed via the Home tab in the Paragraph group.
• Users can apply paragraph alignment to a selected portion of text or an entire document.
• Justification ensures that text is evenly distributed across the width of the page, providing a clean and professional look.

Additional Information

• Font Style
• Changes the appearance of the text, such as bold, italic, or underline.
• Does not affect the alignment of the text.
• Line Spacing
• Adjusts the space between lines of text.
• Does not affect the alignment of the text.
• Text Direction
• Changes the orientation of the text, such as vertical or horizontal.
• Does not affect the alignment of the text.
• Paragraph Group
• Located in the Home tab of MS Word.
• Includes various options for text alignment, indentation, and spacing.

The correct answer is Fiber Optic Cable.

Key Points

• Fiber optic cables use light to transmit data, allowing for high-speed data transfer over long distances.
• They are less susceptible to electromagnetic interference, making them ideal for WAN communication where signal integrity is crucial.
• Fiber optic cables can carry significantly more data compared to traditional copper cables, supporting higher bandwidths.
• Due to their efficiency and reliability, fiber optic cables are widely used in modern WANs, including internet backbones and global telecommunications networks.
• They are essential for applications requiring high data transmission rates, such as video conferencing, online gaming, and cloud computing.

Additional Information

• HDMI Cable
• HDMI (High-Definition Multimedia Interface) cables are used primarily for transmitting audio and video signals between devices like TVs, monitors, and gaming consoles.
• They are not suitable for WAN communication due to their limited range and use case.
• Twisted Pair Cable
• Twisted pair cables are commonly used for LAN (Local Area Network) connections, such as in Ethernet networks.
• While they can be used for shorter WAN links, they are not ideal for long-distance WAN communication.
• Coaxial Cable
• Coaxial cables are used for cable television and internet services but are less common for modern WANs due to their lower bandwidth capacity compared to fiber optics.
• They are more susceptible to signal degradation over long distances.
• Advantages of Fiber Optic Cables
• Fiber optic cables offer higher bandwidth, allowing for faster internet speeds and larger data transfers.
• They have a lower signal attenuation rate, meaning signals can travel longer distances without losing strength.
• They provide better security as they are harder to tap into without being detected.
• Fiber optics are lightweight and thinner compared to copper cables, making them easier to install and manage.

The correct answer is The existing rows are shifted down..

Key Points

• When a new row is inserted in MS Excel, the existing rows are shifted down to accommodate the new entry.
• This operation does not overwrite any existing data; instead, it pushes all the data in the rows below the insertion point down by one row.
• Inserting a new row can be done by right-clicking on a row number and selecting "Insert," or by using the keyboard shortcut Ctrl + Shift + "+".
• This feature helps in maintaining the integrity of data while making space for new entries without losing existing information.

Additional Information

• MS Excel Data Management
• MS Excel allows users to manage large datasets efficiently, including sorting, filtering, and organizing data into rows and columns.
• Features like "Insert" and "Delete" rows/columns provide flexibility in structuring the data dynamically as per user requirements.
• Excel's built-in functions and formulas facilitate complex calculations and data analysis.
• Excel's ability to create charts and graphs from data helps in visual representation and better understanding of information.
• Excel Shortcuts
• Keyboard shortcuts in MS Excel enhance productivity by allowing quick execution of commands without navigating menus.
• Common shortcuts include Ctrl + C (Copy), Ctrl + V (Paste), Ctrl + Z (Undo), and Ctrl + S (Save).
• Knowing and utilizing Excel shortcuts can significantly speed up data entry and management tasks.
• Excel Data Integrity
• Maintaining data integrity involves ensuring the accuracy and consistency of data throughout its lifecycle.
• Excel provides features like Data Validation to control the type of data or the values that users enter into a cell.
• Proper use of formulas and functions can prevent errors and ensure reliable data analysis.

The correct answer is They utilise more hardware resources and need dynamic memory allocation..

Key Points

• Desktop and laptop operating systems handle a wide range of applications simultaneously, necessitating advanced memory management techniques.
• They require dynamic memory allocation to efficiently manage varying memory needs of different applications.
• These systems need to optimize the use of RAM and virtual memory to ensure smooth multitasking and application performance.
• Advanced memory management helps in preventing memory leaks and ensuring efficient memory utilization, which is crucial for the performance of these systems.

Additional Information

• Dynamic Memory Allocation:
• It involves allocating memory storage as needed at runtime, allowing efficient use of resources.
• It is essential for applications that require varying memory sizes during execution.
• Virtual Memory:
• It is a memory management capability that provides an "idealized abstraction of the storage resources" that are actually available on a given machine.
• It helps in running large applications that exceed the physical memory by using disk space as an extension of RAM.
• Memory Leaks:
• Memory leaks occur when a program does not release the memory it has allocated, leading to reduced performance or system crashes.
• Advanced memory management techniques help in detecting and preventing such leaks.
• Multitasking:
• Multitasking refers to the ability of an operating system to execute multiple tasks simultaneously.
• Efficient memory management is crucial for ensuring that all running tasks have the required memory resources.

The correct answer is Counts the number of cells.

Key Points

• The COUNT() function in MS Excel is used to count the number of cells that contain numbers.
• It helps in quickly determining the number of numeric entries in a selected range of cells.
• The function ignores empty cells and cells containing text or logical values.
• Basic syntax: =COUNT(value1, [value2], ...), where value1, value2, etc., can be cell references or ranges.

Additional Information

• COUNTA()
• Similar to COUNT(), but counts all cells that are not empty, including text and logical values.
• Syntax: =COUNTA(value1, [value2], ...)
• COUNTIF()
• Counts the number of cells that meet a specified condition.
• Syntax: =COUNTIF(range, criteria)
• COUNTBLANK()
• Counts the number of empty cells in a specified range.
• Syntax: =COUNTBLANK(range)
• COUNTIFS()
• Counts cells based on multiple criteria.
• Syntax: =COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)

The correct answer is Layer 3 Switch.

Key Points

• A Layer 3 Switch is designed to function both as a switch and a router, which allows it to efficiently forward data packets to the correct device within a LAN.
• These switches use MAC addresses to switch data and IP addresses to route data, making them highly efficient in data forwarding.
• Layer 3 switches are commonly used in enterprise networks to ensure high performance and low latency in data communication.
• They are capable of performing routing functions while maintaining the speed and performance of switching.

Additional Information

• MAC Address (Media Access Control Address)
• A unique identifier assigned to network interfaces for communications at the data link layer of a network segment.
• Used in networking technologies such as Ethernet and Wi-Fi.
• Router
• A networking device that forwards data packets between computer networks.
• Routers perform traffic directing functions on the Internet.
• Hub
• A basic networking device that connects multiple computers in a LAN.
• Hubs broadcast data to all devices on a network, which can lead to inefficiencies.
• Bridge
• A device that connects and filters traffic between two or more network segments.
• Operates at the data link layer and helps to reduce network traffic by dividing it into segments.

The correct answer is option 3.

Key Points

• The Central Processing Unit (CPU) is frequently referred to as the 'brain' of the computer.
• The CPU is responsible for executing instructions from computer programs by performing basic arithmetic, logical, control, and input/output operations.
• The CPU typically consists of the Control Unit (CU), the Arithmetic Logic Unit (ALU), and various registers.
• The Control Unit directs the operation of the processor by fetching and interpreting instructions from memory.

Additional Information

• Arithmetic Logic Unit (ALU)
• The ALU is a fundamental part of the CPU that performs arithmetic and logical operations.
• It operates on binary data inputs and produces binary results, which are stored in registers.
• Control Unit (CU)
• The CU directs the operation of the processor by fetching instructions from memory and decoding them.
• It coordinates the activities of the ALU, registers, and other components.
• Registers
• Registers are small, fast storage locations within the CPU used to hold data temporarily.
• They include the instruction register, program counter, and accumulator, among others.
• Cache Memory
• Although not considered one of the three main units of the CPU, cache memory is crucial for improving processing speed.
• It stores frequently accessed data and instructions to reduce the time taken to fetch them from main memory.

The correct answer is 8 bits.

Key Points

• Each ASCII character is represented using 8 bits (1 byte).
• ASCII stands for American Standard Code for Information Interchange.
• ASCII codes are used to represent text in computers and other devices that use text.
• The standard ASCII character set includes 128 characters (0 to 127).
• Extended ASCII sets use the full 8 bits, allowing for 256 characters (0 to 255).

Additional Information

• Character Encoding
• Character encoding is a system of converting characters into bytes for storage and transmission.
• Other popular encoding standards include Unicode, UTF-8, and ISO-8859-1.
• ASCII History
• ASCII was developed in the early 1960s by the American National Standards Institute (ANSI).
• It was designed to standardize character representation across various devices and platforms.
• ASCII Applications
• ASCII is widely used in programming, data processing, and communications.
• It is the basis for text representation in most modern computer systems.
• Limitations of ASCII
• Standard ASCII can only represent English characters and a limited set of symbols.
• Extended ASCII and other encoding schemes were developed to support additional characters and languages.

The correct answer is Unusual system slowdowns and unexpected errors.

Key Points

• One of the common symptoms of a computer virus infection is unusual system slowdowns that occur without any apparent reason.
• Unexpected errors and crashes are also indicative of a potential virus infection, disrupting normal operations.
• Infected systems may display frequent and unwanted pop-up ads, even when not browsing the internet.
• Another sign is the presence of unknown programs or processes running in the background, which were not installed by the user.
• Changes in system settings and the appearance of unfamiliar toolbars in the browser can also indicate a virus infection.

Additional Information

• Virus Definition
• A computer virus is a type of malicious software program designed to replicate itself by modifying other programs and inserting its own code.
• Viruses typically require a host program to function and spread from one computer to another.
• Common Types of Viruses
• File Infector Virus: Attaches itself to executable files and spreads when the infected file is run.
• Macro Virus: Embeds itself into documents and spreadsheets that contain macros.
• Boot Sector Virus: Infects the master boot record and is activated when the computer is started.
• Prevention Measures
• Install and regularly update antivirus software to detect and remove viruses.
• Avoid downloading and opening email attachments from unknown or untrusted sources.
• Keep your operating system and all software up to date with the latest security patches.
• Impact of Viruses
• Viruses can lead to data loss, system corruption, and unauthorized access to sensitive information.
• They can also cause significant downtime and financial losses for both individuals and organizations.

The correct answer is It marks the start and end of each part in a multipart message..

Key Points

• The boundary parameter in the Content-Type header is crucial for distinguishing different parts of a multipart email message.
• It is an identifier that marks the beginning and ending of each part within the message.
• Each boundary is a unique string that should not appear in the content of the message parts.
• The boundary string allows email clients to correctly parse and separate the individual parts of the email, such as text, images, and attachments.

Additional Information

• Multipart Email:
• A multipart email contains multiple parts, such as plain text, HTML, and attachments.
• These parts are separated by boundary strings defined in the Content-Type header.
• Content-Type Header:
• It specifies the media type of the resource, for example, text/html for HTML files.
• In emails, it indicates the type of content, such as multipart/mixed for emails with attachments.
• MIME (Multipurpose Internet Mail Extensions):
• MIME is an Internet standard that extends the format of email to support text in character sets other than ASCII, as well as attachments.
• It is used to encode the body of the email in a way that can be interpreted by different email clients.
• Boundary String:
• A boundary string is a sequence of characters that indicate where parts of the multipart message begin and end.
• It is defined in the Content-Type header and used by email clients to split the email into its constituent parts.

The correct answer is To prompt for permission before making system-wide changes.

Key Points

• User Account Control (UAC) is a security feature in Windows operating systems.
• Its primary role is to prevent unauthorized changes to the operating system.
• UAC prompts users for permission or an administrator password before allowing changes that could affect the system's operation.
• It helps in preventing malware and unauthorized applications from making system-wide changes without user consent.
• UAC adds an additional layer of security by ensuring that all changes to the system settings are intentional.

Additional Information

• Operating System Security:
• Operating system security includes measures to protect the OS from threats, including malware and unauthorized access.
• Common security features include firewalls, antivirus programs, and user account management.
• Administrator Account:
• An administrator account has full access to the system and can make system-wide changes.
• It is recommended to use a standard user account for daily activities and an administrator account only when necessary.
• Standard User Account:
• A standard user account has limited access and cannot make system-wide changes without permission.
• This account is suitable for most daily tasks and helps in maintaining system security.
• Security Tokens:
• In UAC, security tokens are used to determine the level of access a user has.
• When a user logs in, Windows assigns a security token that includes their user rights and privileges.