Computer Hardware, Networking & SQL Fundamentals

The command "sfc /scannow" is used in Windows to scan for and restore corrupted system files. When executed, it checks the integrity of all protected system files and replaces incorrect versions with the correct Microsoft versions. This is essential for maintaining system stability and resolving issues caused by damaged files. In contrast, "chkdsk" checks disk integrity, "ipconfig" displays network configuration, and "format" prepares a storage device for use, making them unsuitable for repairing system files.

TCP (Transmission Control Protocol) is a connection-oriented protocol, meaning it establishes a reliable connection between two endpoints before data transmission begins. It ensures that data packets are delivered in order, without errors, and allows for retransmission if packets are lost. This is achieved through a three-way handshake process that sets up the connection, making it suitable for applications requiring reliable communication, such as web browsing and file transfers. In contrast, connectionless protocols, like UDP, do not establish a connection and do not guarantee delivery or order.

A router is a networking device that connects different networks and directs data packets between them. It operates at the network layer of the OSI model and uses IP addresses to determine the best path for data transmission. Unlike switches and hubs, which operate within a single network, routers facilitate communication between multiple networks, such as connecting a home network to the internet. This capability makes routers essential for enabling devices on different networks to communicate effectively.

DNS, or Domain Name System, functions as the phonebook of the internet. It translates human-readable domain names, such as www.example.com, into machine-readable IP addresses, like 192.0.2.1. This conversion is essential for web browsers to locate and connect to servers hosting websites. Without DNS, users would need to remember complex numerical IP addresses instead of simple domain names, making internet navigation cumbersome and less user-friendly.

A MAC address (Media Access Control address) is a unique identifier assigned to a network interface card (NIC) for communication on a network. It is hardcoded into the hardware and serves as a distinct address for each device, ensuring that data packets are sent to the correct recipient within a local network. Unlike IP addresses, which can change based on network configurations, the MAC address remains constant, providing a reliable means of identifying devices at the data link layer of the OSI model.

The CPU, or Central Processing Unit, is often referred to as the brain of the computer because it performs the majority of the processing tasks. It executes instructions from programs, performs calculations, and manages data flow within the system. The CPU interprets and processes commands, making it essential for the functioning of all other components. While RAM, SSD, and the motherboard play important roles in a computer's operation, it is the CPU that drives the overall performance and capabilities of the system.

The `systeminfo` command in Windows provides comprehensive details about the system's configuration, including the operating system version, hardware specifications, network adapter details, and installed updates. It is a useful tool for troubleshooting and system management, allowing users to quickly access essential information about their computer's setup. In contrast, commands like `dir`, `ping`, and `copy` serve different purposes, such as listing directory contents, testing network connectivity, and copying files, respectively, and do not provide detailed system information.

The Administrator account type in Windows has full administrative control over the system, allowing users to install software, change system settings, and manage other user accounts. This level of access is essential for performing tasks that require elevated permissions, such as configuring system security and managing hardware devices. Unlike Guest or Standard User accounts, which have limited capabilities, the Administrator account can make significant changes to the operating system and its configurations, making it crucial for system maintenance and troubleshooting.

services.msc is a Windows utility specifically designed to manage background services running on the system. It allows users to view, start, stop, and configure the properties of these services, which are crucial for the operation of various applications and system functions. In contrast, devmgmt.msc is for device management, diskmgmt.msc handles disk partitions, and regedit is the registry editor, making services.msc the appropriate choice for managing services.

Disk Management is a Windows utility that provides a graphical interface for creating, deleting, resizing, and managing disk partitions. It allows users to view the status of their drives, format partitions, assign drive letters, and perform other disk-related tasks. Unlike CMD, which requires command-line knowledge, Disk Management offers a more user-friendly approach for managing storage devices, making it the preferred choice for users needing to organize their disk space.

Device Manager is a Windows tool specifically designed for managing hardware drivers and devices. It allows users to view and control the hardware attached to their computer, including updating, disabling, or uninstalling drivers for various components. This tool provides a centralized interface for troubleshooting and configuring device settings, making it essential for maintaining optimal hardware performance and resolving driver-related issues.

Clock speed, which indicates how fast a CPU can execute instructions, is measured in gigahertz (GHz). One gigahertz equals one billion cycles per second, reflecting the number of operations a processor can perform in that time. Higher GHz values generally imply better performance, as the processor can handle more tasks or execute more instructions per second. In contrast, MB (megabytes), GB (gigabytes), and TB (terabytes) are units of measurement for data storage capacity, not processing speed.

Cache memory is a small, high-speed storage area located within or very close to the CPU. It is designed to temporarily hold frequently accessed data and instructions, allowing the CPU to retrieve them much faster than from main memory (RAM) or secondary storage (HDD). This speed enhances overall system performance by minimizing latency and improving processing efficiency, making cache memory the fastest type of memory built into the CPU.

The Arithmetic Logic Unit (ALU) is a fundamental component of the CPU responsible for performing all arithmetic operations, such as addition and subtraction, as well as logical operations like comparisons. It processes data and executes instructions by manipulating binary numbers, making it essential for executing the computational tasks of the CPU. The ALU works in conjunction with other components, but it is specifically designed to handle the calculations needed for program execution.

UEFI, or Unified Extensible Firmware Interface, replaced the traditional BIOS (Basic Input/Output System) as the firmware interface between a computer's operating system and its hardware. UEFI offers several advantages over BIOS, including faster boot times, support for larger hard drives, enhanced security features, and a more user-friendly graphical interface. Unlike BIOS, which operates in 16-bit mode, UEFI runs in 32-bit or 64-bit mode, allowing for more advanced functionalities and improved performance in modern computing environments.

BIOS, or Basic Input Output System, is firmware embedded on a computer's motherboard that initializes hardware during the booting process before handing control to the operating system. It serves as a bridge between the operating system and the hardware, facilitating communication and ensuring that essential components, such as the keyboard, display, and storage devices, are operational. The term emphasizes its fundamental role in managing input and output operations, making it crucial for system functionality.

PSU commonly refers to Power Supply Unit, which is a crucial component in electronic devices and computers. It converts electrical power from an outlet into usable power for the internal components of the device, ensuring they operate correctly. A PSU provides the necessary voltage and current levels required by various hardware components, such as the motherboard, CPU, and graphics card, making it essential for the overall functionality and stability of the system.

The motherboard serves as the main circuit board in a computer, connecting all hardware components, including the CPU, RAM, GPU, and storage devices. It facilitates communication between these parts through various buses and interfaces, ensuring they work together seamlessly. Additionally, the motherboard provides power connections and ports for peripherals, making it essential for the overall functionality of the computer system.

SSD (Solid State Drive) is faster than HDD (Hard Disk Drive), DVD, and CD because it uses flash memory to store data, allowing for quicker read and write speeds. Unlike HDDs, which rely on spinning disks and mechanical arms to access data, SSDs have no moving parts, enabling instant data access and improved performance. This speed advantage significantly enhances boot times, file transfers, and overall system responsiveness, making SSDs the preferred choice for high-performance computing tasks.

RAM (Random Access Memory) is classified as volatile memory because it requires power to maintain the stored information. When the power is turned off, all data in RAM is lost, making it unsuitable for long-term storage. In contrast, HDD (Hard Disk Drive) and SSD (Solid State Drive) are non-volatile, retaining data even when powered down. ROM (Read-Only Memory) is also non-volatile, as it permanently stores data that is not meant to be modified frequently. Thus, RAM's dependency on power distinguishes it as the only volatile memory among the options provided.