FPSC Information Technology Mcqs

SQL stands for Structured Query Language. It is a powerful and widely used domain-specific language designed for managing and manipulating data stored in relational database management systems (RDBMS). SQL provides a standardized way to interact with databases, allowing users and applications to perform various operations. These operations include creating and modifying database schemas, retrieving specific data, inserting new records, updating existing information, and deleting data. Its declarative nature means users specify what data they want, rather than how to retrieve it, leaving the optimization to the database system. SQL is essential for database administrators, developers, and data analysts, serving as the backbone for data management in countless applications, from small business systems to large enterprise solutions. Its ubiquity makes it a fundamental skill in the field of data management and software development.

The Waterfall model is a traditional, linear, and sequential approach to software development. It consists of distinct phases such as requirements gathering, design, implementation, testing, deployment, and maintenance. A fundamental characteristic of this model is that each phase must be completed and signed off before the next phase can begin.

The correct answer is B: No. In the Waterfall model, it is generally very difficult and often costly to go back to a previous phase once a current phase is completed. The model emphasizes thorough documentation and completion of each stage before progressing, making backtracking a significant challenge. This rigidity is one of its main criticisms, especially for projects with evolving requirements.

A: Yes, C: Sometimes, and D: Always are all incorrect because they contradict the core principle of the Waterfall model, which is its strict, one-directional flow. While minor adjustments might occur within a phase, a formal return to a fully completed and signed-off previous phase is not part of its design and is actively discouraged due to the potential for significant rework and delays.

The key that uniquely identifies a record in a table is the Primary Key. A primary key is a special relational database table column (or combination of columns) designated to uniquely identify each row in the table. Its fundamental characteristics are:

• Uniqueness: No two rows can have the same primary key value.
• Non-nullability: A primary key cannot contain NULL values, ensuring every record has an identifier.

Other key types serve different purposes:

• Foreign Key: Establishes a link between data in two tables, referencing the primary key of another table.
• Candidate Key: Any column or set of columns that can uniquely identify a row. A primary key is chosen from the candidate keys.
• Super Key: A set of attributes that uniquely identifies tuples in a relation. It can contain extra attributes that are not strictly necessary for unique identification.

The primary key is crucial for maintaining data integrity and establishing relationships between tables in a relational database.

Cloud Computing offers various service models that define the level of control and responsibility shared between the cloud provider and the consumer. The three main service models are Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS).

The correct answer is A: SaaS. SaaS, or Software as a Service, is a cloud computing service model where a provider hosts applications and makes them available to customers over the internet. Users typically access these applications via a web browser, without needing to install or manage any software or infrastructure themselves (e.g., Gmail, Salesforce).

B: HTTP is incorrect because HTTP (Hypertext Transfer Protocol) is a protocol used for transmitting data over the web, not a cloud service model. C: HTML is incorrect because HTML (Hypertext Markup Language) is a markup language used for creating web pages, not a cloud service model. D: LAN is incorrect because LAN (Local Area Network) refers to a computer network that interconnects computers within a limited area, such as a home or office, and is not a cloud computing service model.

Network topology refers to the physical or logical arrangement of connected devices in a network. Different topologies have distinct characteristics regarding how devices are interconnected and how data flows.

• The Star topology is the correct answer because it inherently requires a central device, such as a hub, switch, or router, to which all other network devices are individually connected. Data from one device must pass through this central controller to reach any other device on the network. This design simplifies troubleshooting and isolates network problems, as a failure in one cable only affects the connected device, not the entire network. However, the central device becomes a single point of failure.
• Mesh topology is incorrect. In a mesh topology, every device is connected directly to every other device, creating multiple redundant paths. It does not rely on a central controller.
• Bus topology is incorrect. A bus topology connects all devices to a single shared communication line (the 'bus'). It uses terminators at each end and does not require a central hub.
• Ring topology is incorrect. In a ring topology, devices are connected in a circular fashion, with data flowing in one direction around the ring. There is no central controller.

A MAC address is a unique identifier assigned to network interfaces for communications at the data link layer of a network segment. It's often referred to as a physical address.

• Media Access Control is the correct answer. MAC stands for Media Access Control. The MAC address is part of the Media Access Control sublayer of the Data Link Layer (Layer 2) in the OSI model. This sublayer is responsible for controlling how devices on the network gain access to the medium and permission to transmit data. It ensures that data is correctly addressed to the intended recipient on a local network segment.
• Memory Access Control is incorrect. This term relates to how a CPU accesses memory, not network addressing.
• Master Access Code is incorrect. This term is not standard in networking and typically refers to a security code or password.
• Main Access Cell is incorrect. This term does not have a recognized meaning in the context of network addressing or MAC addresses.

IP addresses are categorized into public and private addresses. Private IP addresses are reserved for use within private networks (like homes or offices) and are not routable on the public internet. This allows multiple private networks to use the same IP ranges without conflict, as long as they are not directly connected to the internet.

• 192.168.1.1 is the correct answer. It falls within the Class C private IP address range, which is 192.168.0.0 to 192.168.255.255. This range is commonly used in small to medium-sized private networks.
• 12.0.0.1 is incorrect. This is a public IP address. It does not fall into any of the designated private IP address ranges.
• 172.33.0.1 is incorrect. While 172.x.x.x can be a private range, the specific private range for Class B is 172.16.0.0 to 172.31.255.255. Since 172.33.0.1 is outside this specific range, it is considered a public IP address.
• 200.1.1.1 is incorrect. This is a public IP address. It does not fall into any of the designated private IP address ranges.

Data security is paramount in modern computing, and various techniques are employed to protect information from unauthorized access or alteration. One fundamental method involves transforming data into an unreadable state.

• Encryption is the correct answer. Encryption is the process of converting information or data into a code, called ciphertext, to prevent unauthorized access. The original data, known as plaintext, is transformed using an algorithm and an encryption key, making it unreadable to anyone without the correct decryption key. Its primary purpose is to ensure the confidentiality and integrity of data, whether it's stored or transmitted.
• Decryption is incorrect. Decryption is the reverse process of encryption, where the encrypted data (ciphertext) is converted back into its original, readable format (plaintext) using a decryption key.
• Compression is incorrect. Compression is the process of reducing the size of data to save storage space or reduce transmission time. While it can be used in conjunction with encryption, its primary goal is not security.
• Transmission is incorrect. Transmission refers to the act of sending data from one point to another, such as over a network. It describes the movement of data, not its transformation for security purposes.

This question pertains to the fundamental structure of a hard disk and the boot process. When a computer starts, it needs a specific location on the hard disk to find the initial instructions to load the operating system.

The correct answer is Master Boot Record (MBR). The MBR is a special type of boot sector located at the very beginning of a partitioned computer mass storage device, such as a hard disk. It contains the primary boot loader code, a disk's partition table, and a unique disk signature. The BIOS reads the MBR to initiate the boot process by finding the active partition and loading its boot sector.

• Boot Sector is a more general term for any sector on a hard disk or floppy disk that contains machine code to be loaded into RAM by a computer's built-in firmware. The MBR is a specific type of boot sector.
• FAT (File Allocation Table) is a type of file system used to manage how files are stored and retrieved on a disk, not a specific sector.
• Kernel is the core component of an operating system, responsible for managing system resources. It is loaded into memory by the boot loader, but it is not the first sector of the hard disk itself.

This question asks about the central component of the Linux operating system. Understanding the core elements of an OS is crucial for comprehending its functionality.

The correct answer is Kernel. The kernel is the fundamental part of an operating system. It is the bridge between the applications and the actual hardware, managing the system's resources, including the CPU, memory, and peripheral devices. It handles tasks like process management, memory management, device drivers, and system calls, providing essential services for all other parts of the OS and applications to function.

• The Shell is a command-line interpreter or a graphical interface that provides a user interface for accessing the operating system's services. It's an interface, not the core.
• A Terminal is an application that provides a text-based interface to the operating system, often used to interact with the shell. It's a tool for user interaction, not the OS core.
• A GUI (Graphical User Interface) is a visual way for users to interact with electronic devices through graphical icons and visual indicators. It's a user interface layer built on top of the kernel and other OS components, not the core itself.

This question describes a classic problem in concurrent programming and operating systems related to resource management. When multiple processes share resources, conflicts can arise.

The correct answer is Deadlock. Deadlock occurs when two or more processes are permanently blocked because each is waiting for a resource that is held by another process in the same set. This creates a circular waiting condition where no process can proceed, leading to a system standstill. For example, Process A holds Resource X and waits for Resource Y, while Process B holds Resource Y and waits for Resource X.

• Starvation is a situation where a process is repeatedly denied access to a resource it needs, even though the resource becomes available. Unlike deadlock, the resource eventually becomes free, but the process never gets it due to unfair scheduling or priority issues.
• Paging is a memory management scheme that allows an operating system to retrieve data from secondary storage and use it in main memory. It's related to virtual memory, not resource contention between processes.
• Spooling (Simultaneous Peripheral Operations Online) is a process of placing data in a temporary working area (the spool) for another program to process. It's commonly used for managing print jobs or other I/O operations, not a state of blocked processes waiting for each other.

This question asks about the default file system used by modern Windows operating systems. File systems are crucial for organizing and managing how data is stored and retrieved on storage devices.

The correct answer is NTFS (New Technology File System). NTFS is the primary file system used by Microsoft's Windows NT family of operating systems, including Windows 10 and 11. It was introduced with Windows NT and offers significant improvements over older file systems like FAT32, including enhanced security features (permissions), journaling for data recovery, support for larger files and volumes, and disk quotas.

• FAT32 (File Allocation Table 32) is an older file system that is widely compatible across different operating systems but has limitations on individual file size (4GB) and partition size (2TB). While Windows can read and write FAT32, it's not the native or recommended file system for modern Windows installations.
• HFS (Hierarchical File System) and its successor HFS+ are file systems primarily used by Apple's macOS (and its predecessors).
• EXT4 (Fourth Extended File System) is the default file system for many Linux distributions.

The process of loading the Operating System (OS) into a computer's main memory (RAM) is fundamentally known as booting. This crucial initial sequence begins when the computer is powered on, involving the firmware (like BIOS or UEFI) performing a Power-On Self-Test (POST) and then locating and executing the bootloader. The bootloader's primary role is to load the OS kernel into RAM, allowing the system to initialize and become fully operational for user interaction. Without successful booting, the computer cannot function.

• Starting is a generic term and lacks the specific technical meaning associated with the OS loading process.
• Formatting refers to preparing a storage device (like a hard drive or USB) for data storage by creating a file system, which is entirely unrelated to loading the OS.
• Processing describes the CPU's continuous execution of instructions and data manipulation, a general computing activity rather than the specific initial OS load.

Therefore, 'booting' precisely defines this essential startup procedure.

The correct shortcut key combination to directly open the Task Manager in Windows is Ctrl+Shift+Esc. This command provides immediate access to the Task Manager, a utility that allows users to monitor running applications, processes, and services, view system performance, and manage startup programs. It's an essential tool for troubleshooting unresponsive applications or checking system resource usage.

• Ctrl+Alt+Del opens the Windows Security screen, which then offers an option to launch Task Manager, but it's not a direct shortcut.
• Alt+F4 is used to close the currently active window or, if no window is active, to open the shutdown dialog.
• Win+R opens the 'Run' dialog box, which is used to execute commands or open applications by typing their names.

Thus, Ctrl+Shift+Esc is the most efficient way to access the Task Manager.

The IPv4 address is a fundamental component of network communication, uniquely identifying devices on the internet. It is composed of 32 bits. These 32 bits are typically divided into four 8-bit segments (octets), represented in dotted-decimal notation, such as 192.168.1.1. This 32-bit structure allows for approximately 4.3 billion unique addresses, which was sufficient for the early internet but is now largely exhausted, leading to the development of IPv6.

• 16 bits (A) is incorrect; this would only allow for 65,536 unique addresses, which is far too few for modern networking needs.
• 64 bits (C) is incorrect; while some systems use 64-bit architecture, IPv4 specifically uses 32 bits.
• 128 bits (D) is incorrect; this is the length of an IPv6 address, the successor to IPv4, designed to provide a vastly larger address space.

Therefore, 32 bits is the correct answer for an IPv4 address.

Multitasking is an extension of time-sharing. Time-sharing is a technique that allows multiple users or multiple programs to share a single CPU by rapidly switching between them. Each user or program gets a small slice of CPU time, creating the illusion that all tasks are running simultaneously. Multitasking applies this concept to a single user running multiple applications concurrently on their system, where the operating system manages the CPU's allocation to each program.

• Multiprogramming is an earlier concept where multiple programs reside in memory, but only one runs at a time until it performs an I/O operation, then another runs. It lacks the rapid CPU switching for interactive use.
• Batch processing executes jobs sequentially without user interaction, typically for large, non-interactive tasks.
• Serial processing means tasks are executed strictly one after another, which is the opposite of concurrent execution.

Therefore, time-sharing is the foundational concept enabling modern multitasking.

The OSI (Open Systems Interconnection) model is a conceptual framework that standardizes the functions of a telecommunication or computing system into seven distinct layers. Each layer has specific responsibilities. Routing, the process of selecting a path for data packets across different networks, is the primary responsibility of the Network Layer (Layer 3).

• The Physical Layer (A) (Layer 1) deals with the physical transmission of raw bit streams over a physical medium, such as cables or wireless signals. It is concerned with hardware specifications and electrical signals, not routing decisions.
• The Data Link Layer (B) (Layer 2) handles frame transmission between adjacent network nodes and error detection/correction within a single network segment. Devices like switches operate at this layer.
• The Transport Layer (D) (Layer 4) provides end-to-end communication between applications, managing segmentation, reassembly, and flow control (e.g., TCP, UDP). It ensures reliable data delivery but does not handle inter-network routing.

Thus, the Network Layer is correctly identified as responsible for routing.

Virtual memory is a memory management technique that allows a computer to compensate for physical memory (RAM) shortages by temporarily transferring data from RAM to disk storage. Therefore, virtual memory is typically located on the Hard Disk (or Solid State Drive). When the system runs low on physical RAM, it moves less frequently used pages of memory from RAM to a dedicated area on the hard disk, known as a swap file or paging file, freeing up RAM for active processes. This creates the illusion of more available RAM than physically present.

• RAM (Random Access Memory) is the physical, volatile memory that virtual memory extends, not where virtual memory itself resides.
• CPU Cache is a very small, extremely fast memory used by the CPU to store frequently accessed data for quick retrieval, unrelated to virtual memory's function.
• ROM (Read-Only Memory) stores firmware like the BIOS and is non-volatile, not used for dynamic memory management.

The hard disk serves as the overflow for RAM in a virtual memory system.

Port numbers are crucial for network communication, identifying specific processes or services on a network device. HTTPS (Hypertext Transfer Protocol Secure) is the secure version of HTTP, which uses SSL/TLS encryption to protect data exchanged between a web browser and a server. The default port number for HTTPS is 443.

• 80 (A) is incorrect; this is the default port for standard, unencrypted HTTP traffic.
• 21 (B) is incorrect; this is the default port for FTP (File Transfer Protocol), used for transferring files between a client and server.
• 25 (D) is incorrect; this is the default port for SMTP (Simple Mail Transfer Protocol), which is used for sending email.

Using port 443 for HTTPS ensures that web traffic is encrypted, providing confidentiality and integrity for sensitive information like login credentials and financial transactions.

In Linux and other Unix-like operating systems, the command used to list files and directories within a specified directory is ls. This command is fundamental for navigating and understanding the file system structure. By default, `ls` lists the contents of the current directory. It also supports various options, such as `ls -l` for a detailed (long) listing, `ls -a` to show all files including hidden ones, and `ls -h` for human-readable file sizes.

• dir is the command used in Windows (DOS/CMD) to list directory contents, not in Linux.
• list is not a standard or recognized command for listing directory contents in Linux.
• cd stands for 'change directory' and is used to navigate between different directories in the file system, not to display their contents.

Thus, `ls` is the correct and universally recognized command for listing files in Linux.

In network environments, devices require unique IP addresses to communicate. Manually configuring these addresses can be cumbersome and prone to errors, especially in large networks. The protocol designed to automate this process is DHCP.

• DHCP (Dynamic Host Configuration Protocol) (B) is the correct answer. It automatically assigns IP addresses, subnet masks, default gateways, DNS server information, and other network configuration parameters to devices. This simplifies network administration and prevents IP address conflicts.
• DNS (Domain Name System) (A) is incorrect; DNS translates human-readable domain names (e.g., example.com) into IP addresses, but it does not assign IP addresses to devices.
• HTTP (Hypertext Transfer Protocol) (C) is incorrect; HTTP is the foundation of data communication for the World Wide Web, used for transmitting web pages, not for IP address assignment.
• FTP (File Transfer Protocol) (D) is incorrect; FTP is used for transferring files between computers on a network and has no role in assigning IP addresses.

Therefore, DHCP is essential for efficient network management.

Connecting networks with different underlying technologies, protocols, or architectures requires a specialized device capable of translating between these disparate systems. This device is known as a Gateway.

• A Gateway (C) is the correct answer. It acts as a protocol converter, translating data from one protocol to another, enabling communication between otherwise incompatible networks. For instance, a router connecting a local area network (LAN) to the internet often functions as a gateway, translating between the LAN's internal protocols and the internet's protocols.
• A Bridge (A) is incorrect; it connects two LAN segments that use the same protocol, operating at the Data Link Layer (Layer 2) and forwarding frames based on MAC addresses.
• A Hub (B) is incorrect; it is a basic networking device operating at the Physical Layer (Layer 1) that simply broadcasts all incoming data to all other ports within the same network segment.
• A Switch (D) is incorrect; it is a more intelligent device than a hub, operating at the Data Link Layer (Layer 2) to forward frames only to the intended destination port within the same network.

Gateways are critical for inter-network communication across diverse environments.

The Ping command is a fundamental network utility used to test the reachability of a host on an Internet Protocol (IP) network and to measure the round-trip time for messages sent from the originating host to a destination computer. It operates by sending Internet Control Message Protocol (ICMP) echo request packets to the target host and listening for ICMP echo reply packets.

• ICMP (Internet Control Message Protocol) is the correct answer because Ping exclusively uses ICMP messages (specifically Echo Request and Echo Reply) to perform its diagnostic function. ICMP is a network layer protocol used for error reporting and diagnostic purposes.
• TCP (Transmission Control Protocol) is incorrect. TCP is a connection-oriented protocol that provides reliable, ordered, and error-checked delivery of a stream of octets between applications running on hosts. It's used for web browsing, email, etc., not for Ping.
• UDP (User Datagram Protocol) is incorrect. UDP is a connectionless protocol that provides a simple, unreliable datagram service. While faster, it lacks the error checking and reliability of TCP and is not used by Ping.
• SMTP (Simple Mail Transfer Protocol) is incorrect. SMTP is an application layer protocol used for sending and receiving email messages. It has no role in network reachability testing like Ping.

The Internet is a vast and complex system that has revolutionized communication and information access worldwide. Understanding its fundamental nature is key to comprehending its impact.

• A: Single network is incorrect because the Internet is not one monolithic network; rather, it's a 'network of networks,' connecting countless smaller networks.
• C: Local network (LAN - Local Area Network) refers to a network confined to a small geographical area, like a home or office, which is a tiny component compared to the Internet's scale.
• D: Private network refers to networks restricted to authorized users, such as intranets or VPNs, whereas the Internet is largely public and globally accessible.

The correct answer is B: Global network. The Internet connects millions of private, public, academic, business, and government networks across the entire planet, enabling worldwide data exchange and communication, making it truly global in scope.

The acronym CPU is universally recognized in computing and stands for Central Processing Unit. This component is often referred to as the "brain" of a computer because it is responsible for executing most of the instructions of a computer program. The CPU performs basic arithmetic, logical, control, and input/output operations, which are essential for the computer to function and process data effectively. Without a CPU, a computer cannot perform its core tasks.

• A: Central Process Unit is incorrect because it omits the "ing" from "Processing," which is crucial for the correct and widely accepted term.
• C: Computer Personal Unit is incorrect; the CPU is a vital internal component, not the entire computer, and "Personal" is not part of its official name.
• D: Central Program Unit is also incorrect. While the CPU executes programs, "Processing" accurately describes its broader function of handling all data and instructions.