FPSC Information Technology Mcqs

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.

The SQL command used to delete all records from a table without deleting the table structure is TRUNCATE. While DELETE can also remove all rows, TRUNCATE TABLE is generally faster and more resource-efficient for this specific task, especially on large tables.

Here's a breakdown of why:

• TRUNCATE: This command deallocates the data pages used by the table and logs only the deallocation of these pages. It's a DDL (Data Definition Language) command, meaning it's non-transactional and cannot be rolled back in most database systems. It effectively resets the table to its initial empty state, often resetting identity columns as well.
• DELETE: This is a DML (Data Manipulation Language) command. When used without a WHERE clause, it removes all rows one by one, logging each deletion. This makes it slower but allows for rollback.
• DROP: This command completely removes the table definition and all its data from the database.
• REMOVE: This is not a standard SQL command for deleting records.

Therefore, for a quick and efficient removal of all data while preserving the table's schema, TRUNCATE TABLE is the preferred choice.

The question asks to identify the component known as the "Brain" of the computer. This analogy refers to the part responsible for executing instructions, performing calculations, and managing the overall flow of data.

The CPU (Central Processing Unit) is correctly identified as the "Brain" of the computer. It is the primary component that performs all arithmetic, logical, and input/output operations, executing instructions from programs. Without the CPU, a computer cannot function or process any information, making its role central to all computing tasks.

• RAM (Random Access Memory) is incorrect because it serves as temporary, volatile storage for data and programs currently in use, allowing the CPU quick access to information. It doesn't process data itself.
• The Motherboard is incorrect as it is the main circuit board that connects all the computer's components, allowing them to communicate. It's the backbone, not the processing unit.
• BIOS (Basic Input/Output System) is incorrect. It is firmware stored on a chip, responsible for initializing hardware components during the boot process and loading the operating system. It's a set of instructions, not the processing engine.

The ACID properties are fundamental principles in database management systems (DBMS) that guarantee reliable transaction processing. They ensure data integrity even in the event of errors, power failures, or other issues. Let's break down what each letter stands for:

• Atomicity: Ensures that a transaction is treated as a single, indivisible unit of operations. Either all operations within the transaction are completed successfully, or none of them are. There are no partial transactions.
• Consistency: Guarantees that a transaction brings the database from one valid state to another, maintaining all defined rules, constraints, and triggers.
• Isolation: Ensures that concurrent transactions do not interfere with each other. Each transaction appears to execute in isolation, as if it were the only transaction running.
• Durability: This is the correct answer. It guarantees that once a transaction has been committed, its changes are permanent and will survive any subsequent system failures, such as crashes or power outages. The committed data is stored persistently and will not be lost.

These properties collectively ensure the reliability and integrity of data in transactional systems.

This question tests knowledge of standard computer storage unit conversions. In computing, storage units are typically based on powers of 2, specifically 1024, rather than 1000, due to the binary nature of computers.

The correct answer is 1024 GB. This is because computer memory and storage capacities are measured using binary prefixes, where each successive unit is 1024 (which is 2¹⁰) times larger than the previous one. The hierarchy is as follows: 1 Kilobyte (KB) = 1024 Bytes, 1 Megabyte (MB) = 1024 KB, 1 Gigabyte (GB) = 1024 MB, and therefore, 1 Terabyte (TB) = 1024 GB. This standard ensures precise measurement in a binary system.

• 1024 MB is incorrect because 1024 MB is equivalent to 1 GB, not 1 TB.
• 1000 GB is incorrect. While 1000 GB is often used in marketing for hard drive capacities (decimal prefixes), the precise binary standard in computing for a Terabyte is 1024 GB.
• 1024 KB is incorrect because 1024 KB is equivalent to 1 MB, which is significantly smaller than a Terabyte.

The correct answer is MongoDB. MongoDB is a popular example of a NoSQL database, specifically a document-oriented database. NoSQL databases, which stands for "Not only SQL," are a class of non-relational database management systems that provide a mechanism for storage and retrieval of data other than the tabular relations used in relational databases.

Key characteristics of NoSQL databases like MongoDB include:

• Flexible Schema: They often allow for dynamic schemas, meaning the structure of data can vary from document to document.
• High Scalability: Designed for horizontal scaling, making them suitable for handling large volumes of data and high traffic.
• Variety of Data Models: They can store data in various formats such as key-value, document, column-family, or graph.

In contrast, MySQL, Oracle, and PostgreSQL are all examples of traditional Relational Database Management Systems (RDBMS) that use SQL (Structured Query Language) for defining and manipulating data, adhering to a rigid, predefined schema.

The question asks to identify which type of memory is non-volatile. Memory can be broadly categorized into volatile and non-volatile. Volatile memory requires power to maintain the stored information, losing its contents when power is removed. Non-volatile memory, conversely, retains its stored information even when not powered.

The correct answer is ROM (Read-Only Memory). ROM is a type of non-volatile memory used in computers and other electronic devices. It stores firmware, such as the BIOS (Basic Input/Output System), which is essential for booting up the computer and performing basic hardware initialization. The data stored in ROM is permanent and does not disappear when the power is turned off.

• RAM (Random Access Memory) is incorrect because it is volatile memory. It serves as the computer's main working memory, holding data and programs currently in use, but all its contents are lost when the computer is powered down.
• Cache memory is incorrect. It is a small, very fast, volatile memory that stores frequently accessed data for the CPU, improving performance. Its contents are lost without power.
• Registers are incorrect. These are tiny, extremely fast storage locations directly within the CPU, used to hold data that the CPU is actively processing. They are volatile and lose their data when power is removed.

The correct answer is Rows from two or more tables. In SQL (Structured Query Language), a JOIN operation is used to combine rows from two or more tables based on a related column between them. This is a fundamental operation in relational databases, allowing you to retrieve data that is logically connected but stored across different tables.

For instance, if you have one table for 'Customers' and another for 'Orders', you might join them on a common column like 'CustomerID' to see which customers placed which orders. The result of a JOIN operation is a new result set that contains columns from both (or more) tables, with rows matched according to the specified join condition.

There are several types of JOINs, including:

• INNER JOIN: Returns rows when there is a match in both tables.
• LEFT (OUTER) JOIN: Returns all rows from the left table, and the matched rows from the right table.
• RIGHT (OUTER) JOIN: Returns all rows from the right table, and the matched rows from the left table.
• FULL (OUTER) JOIN: Returns all rows when there is a match in one of the tables.

JOINs are crucial for querying normalized databases efficiently.

This question asks for the full form of the acronym ASCII. ASCII is a fundamental concept in computer science and telecommunications, representing how characters are encoded and exchanged.

The correct answer is American Standard Code for Information Interchange. ASCII is a character encoding standard for electronic communication. It was developed in the 1960s and assigns unique numerical values to 128 characters, including uppercase and lowercase English letters, numbers (0-9), punctuation marks, and control characters. This standardization allows different computer systems and devices to understand and exchange text data consistently, forming the basis for much of modern digital text representation.

• Asian Standard Code for Information Interchange is incorrect. The "A" in ASCII stands for "American,&quot reflecting its origin.
• American Scientific Code for Interchange is incorrect. The term "Standard" is crucial in the acronym, indicating its role as a widely adopted convention, not specifically a "Scientific" code.
• All Standard Code for Information is incorrect. The first word "All" does not match the "American" origin of the standard.

The correct answer is Reduce Data Redundancy. Database normalization is a systematic process used in relational database design to organize columns and tables to minimize data redundancy and improve data integrity. The primary goal is to eliminate redundant data (duplicate data) and ensure that data dependencies make sense, meaning that data is stored only once and in the most appropriate table.

By reducing redundancy, normalization offers several significant benefits:

• Improved Data Integrity: Less chance of inconsistencies when data is updated, as changes only need to be made in one place.
• Reduced Storage Space: Storing data only once saves disk space.
• Easier Maintenance: Databases become easier to manage and update.
• Enhanced Query Performance: While not its primary goal, a well-normalized database can sometimes lead to more efficient queries due to smaller, more focused tables.

Normalization involves breaking down large tables into smaller, related tables and defining relationships between them. This process typically follows a series of guidelines known as normal forms (e.g., First Normal Form (1NF), Second Normal Form (2NF), Third Normal Form (3NF)).

The question asks to identify the fastest memory in a computer. Computer memory operates on a hierarchy, with speed generally decreasing as capacity increases and as the memory is located further from the CPU.

The correct answer is Registers. Registers are the smallest and fastest memory components within a computer. They are tiny storage locations built directly into the CPU itself, designed to hold data that the CPU is actively processing or about to process. Their direct integration with the CPU allows for immediate access, minimizing delays and maximizing processing speed, making them significantly faster than any other memory type.

• RAM (Random Access Memory) is incorrect. While fast, RAM is much slower than registers. It serves as the main working memory, holding data for active programs, but it requires more time for the CPU to access compared to its internal registers.
• Hard Disk is incorrect. Hard Disk Drives (HDDs) are a type of secondary storage, known for their large capacity but are significantly slower than primary memory like RAM or registers due to their mechanical nature.
• SSD (Solid State Drive) is incorrect. SSDs are much faster than traditional HDDs, offering significant performance improvements for secondary storage. However, they are still considerably slower than RAM, cache memory, and especially registers, which are directly integrated into the CPU for immediate data access.

The correct answer is the Physical Level. Database abstraction is a way to hide the complexities of how data is actually stored and managed, presenting users with a simpler, more conceptual view. There are typically three levels of abstraction in a database system:

• Physical Level: This is the lowest level of abstraction. It describes how the data is actually stored on the physical storage media (e.g., hard drives, SSDs). It details the complex low-level data structures, file organization, indexing techniques, and storage allocation strategies. Database administrators and system designers typically work at this level.
• Logical Level (or Conceptual Level): This level describes what data is stored in the database and the relationships among that data. It represents the entire database in terms of a schema, without detailing the physical storage structures. Programmers and database designers often work at this level.
• View Level (or External Level): This is the highest level of abstraction. It describes only part of the database, tailored to the needs of specific user groups. Users at this level only see the data relevant to them, simplifying interaction and enhancing security by hiding irrelevant or sensitive information.

The physical level is crucial for efficient data retrieval and storage management.

The acronym URL stands for Uniform Resource Locator. A URL is essentially the address of a given unique resource on the World Wide Web, such as a webpage, image, or video, providing a mechanism to retrieve that resource. The term "Uniform" signifies that there is a standardized format for constructing these addresses, ensuring consistency and interoperability across the internet. "Resource" refers to anything that can be identified and processed by a computer, while "Locator" indicates that the URL specifies the exact location of that resource and how to access it. Therefore, option A accurately defines the acronym, representing a foundational concept in web navigation.

Options B, C, and D are incorrect because they use terms that do not align with the established standard and meaning of a URL. "Universal Resource Link," "Uniform Radio Link," and "Unified Resource Line" are misinterpretations of the components. While they might sound plausible, they do not reflect the precise technical definition or the fundamental purpose of a URL in identifying and locating web-based content. Understanding the precise meaning of each part of the acronym is crucial for comprehending how web resources are identified and accessed.

A deadlock in a Database Management System (DBMS) is a critical situation where two or more transactions are perpetually waiting for each other to release resources, leading to a standstill. Each transaction holds a resource that the other needs, and neither can proceed. This perfectly aligns with Processes blocking each other, as transactions are essentially processes competing for shared resources like locks on data items. This scenario prevents any of the involved transactions from completing their operations, causing system inefficiency and potential timeouts.

• Data corruption is incorrect because a deadlock primarily prevents progress; it doesn't inherently corrupt data, although unhandled deadlocks can lead to data inconsistency if transactions are forcibly terminated.
• Server crash is also incorrect. While deadlocks can degrade performance and lead to application unresponsiveness, they typically do not cause the entire database server to crash.
• Network lag refers to delays in data transmission over a network and is unrelated to resource contention within the DBMS itself.

The malware that locks your files and demands payment is known as Ransomware. This malicious software encrypts a user's files, making them inaccessible, and then demands a ransom, typically in cryptocurrency, for the decryption key. Its primary goal is financial extortion, leveraging the victim's need to recover their data. Ransomware attacks can be devastating for individuals and organizations, often leading to significant data loss or costly payments.

Let's examine why the other options are incorrect:

• Spyware (A) is designed to secretly gather information about a user's activities without their knowledge or consent, but it does not typically lock files or demand payment.
• Trojan (C) refers to malware that disguises itself as legitimate software to trick users into installing it. While a Trojan can deliver ransomware, its defining characteristic is deception, not the act of locking files for ransom itself.
• Worm (D) is a self-replicating malware that spreads across networks and computers without human interaction. While worms can carry various payloads, their primary function is propagation, not specifically file encryption and ransom demands.

HTML stands for HyperText Markup Language, and its primary function is to structure content on the web. It uses a system of 'tags' to define elements such as headings, paragraphs, images, and links, indicating how content should be organized and displayed by a web browser. Therefore, HTML is correctly identified as a Markup Language.

• A Programming Language, like Java or C++, involves logic, algorithms, variables, and control flow (e.g., loops, conditionals) to perform computations, which HTML does not.
• A Scripting Language, such as JavaScript, adds dynamic and interactive behavior to web pages, executing commands within a host environment. HTML provides the static structure, not the dynamic behavior.
• A Query Language, like SQL (Structured Query Language), is specifically designed for retrieving and managing data in databases. HTML has no capabilities for querying databases.

The Python programming language was developed by an individual, Guido van Rossum, not a company. Van Rossum began working on Python in the late 1980s at Centrum Wiskunde & Informatica (CWI) in the Netherlands, releasing its first version in 1991. He served as Python\'s \"Benevolent Dictator For Life\" (BDFL) until 2018, overseeing its development and direction. Python is an open-source language, meaning its development is community-driven, with contributions from countless developers worldwide, rather than being owned or exclusively developed by a single corporation.

The other options are major technology companies, but none of them developed Python:

• Microsoft (A) is known for Windows, Office, and C#.
• Apple (C) is famous for macOS, iOS, and Swift.
• Google (D) has developed languages like Go and Dart, and heavily utilizes Python, but did not create it.

These companies are significant users and contributors to the Python ecosystem, but the foundational creation belongs to Guido van Rossum.

The Software Development Life Cycle (SDLC) is a structured process that outlines the stages involved in developing and maintaining software. The phase that specifically addresses fixing bugs and making enhancements after the software has been released to users is Maintenance. This phase is crucial for ensuring the long-term viability and functionality of the software, responding to user feedback, adapting to new environments, and correcting any defects discovered post-deployment.

• Testing is a phase that occurs *before* release, where the software is rigorously checked for defects to ensure it meets requirements. While bugs are found and fixed during testing, fixing them *after* release falls under maintenance.
• Design is an earlier phase where the architecture and components of the software are planned and specified.
• Analysis is typically the initial phase, focusing on gathering and documenting user requirements and system specifications.

HTTP (Hypertext Transfer Protocol) operates at the Application layer (Layer 7) of the OSI (Open Systems Interconnection) model. The Application layer is the topmost layer and provides network services directly to end-user applications, such as web browsers and email clients. HTTP is the fundamental protocol used for fetching resources like HTML documents, images, and other web content from web servers, enabling communication between web clients and servers.

Let's understand why the other options are incorrect:

• The Transport layer (A, Layer 4) is responsible for end-to-end communication and data segmentation, using protocols like TCP and UDP.
• The Network layer (B, Layer 3) handles logical addressing and routing of data packets across different networks, primarily using IP.
• The Session layer (D, Layer 5) establishes, manages, and terminates communication sessions between applications.

HTTP's role in directly facilitating user-facing application functions, like web browsing, firmly places it within the Application layer, as it interacts directly with the software applications that users employ.

JavaScript is primarily a Client-side scripting language. This means that the JavaScript code is executed directly within the user's web browser, rather than on a server. It is extensively used to create interactive and dynamic web pages, handling tasks like form validation, animated graphics, and responding to user actions without requiring a round trip to the server. Its original design and most widespread application are for enhancing the user experience directly in the browser.

• While JavaScript can be used on the Server side with environments like Node.js, its *primary* and foundational role, especially in the context of web development, is client-side.
• JavaScript is not a Database language; it interacts with databases typically through server-side APIs or specific client-side libraries, but it doesn't directly query or manage database content itself.
• It is not a Network language in the sense of defining network protocols or managing network infrastructure. Its operations are at the application layer, facilitating user interaction within a web environment.

While the title "father of computing" can be attributed to different individuals for various contributions, Alan Turing is widely regarded as the father of Modern Computing. His groundbreaking theoretical work in the 1930s, particularly the concept of the "Turing machine," provided the abstract model for all modern computers and the fundamental principles of computation. He also made significant contributions to artificial intelligence with the Turing Test and played a crucial role in code-breaking during World War II, demonstrating the practical application of his theoretical ideas.

Let's consider why the other options are less accurate for "Modern Computing":

• Charles Babbage (A) is often called the "father of the computer" for his conceptual designs of mechanical general-purpose computers (Analytical Engine) in the 19th century, predating electronic computing.
• Bill Gates (C) co-founded Microsoft and was instrumental in the software revolution and personal computing, but not the theoretical foundations.
• Steve Jobs (D) co-founded Apple and revolutionized personal computing and user interfaces, but his contributions were in product development and user experience, not the underlying theoretical framework.

Turing's work laid the essential theoretical groundwork that underpins every digital computer today.

A high-level language is a programming language that is designed to be more human-readable and abstract, meaning it is closer to human language and further from machine code. These languages abstract away the complexities of computer hardware, allowing programmers to write code using more familiar syntax and concepts. Among the given options, Python is a quintessential example of a high-level language, known for its readability, extensive libraries, and ease of use across various domains.

• Assembly language is a low-level programming language that uses symbolic representations (mnemonics) for machine code instructions. It is specific to a particular computer architecture and requires a deep understanding of the hardware.
• Machine language is the lowest-level programming language, consisting of binary code (0s and 1s) that a computer's central processing unit (CPU) can directly execute.
• Binary refers to the base-2 numeral system, which is the fundamental language of computers. In this context, it is synonymous with machine language, representing instructions and data at the most basic hardware level.

An error in a computer program is universally known as a bug. This term originated in the early days of computing, famously attributed to Grace Hopper, who discovered a moth (a literal 'bug') causing a malfunction in the Mark II computer. In software development, a bug refers to a flaw, error, or fault in a computer program or system that causes it to produce an incorrect or unexpected result, or to behave in unintended ways.

The correct answer is B: Bug. A bug is the precise technical term for a defect in code.

A: Crash is incorrect because a crash is often the *result* of a severe bug, where the program stops functioning unexpectedly, rather than the error itself. C: Virus is incorrect as a virus is a type of malicious software designed to infect and damage computer systems, not a general programming error. D: Glitch is incorrect; while colloquially used for minor malfunctions, 'glitch' is a more general term that can refer to temporary hardware or software issues, but 'bug' is the specific and formal term for an error within the program's code.

CSS stands for Cascading Style Sheets, and its primary purpose is to define the visual presentation and layout of web pages. It works in conjunction with HTML, which structures the content, by providing rules for how that content should be displayed. This includes aspects like colors, fonts, spacing, positioning, and responsiveness across different devices.

The correct answer is B: Styling/Presentation. CSS is specifically designed to separate the content of a web page from its visual design, making websites easier to maintain, more consistent, and adaptable.

A: Logic is incorrect because program logic and interactivity are typically handled by scripting languages such as JavaScript. C: Database Storage is incorrect as databases (e.g., SQL, NoSQL) are used for storing and managing data, not for styling web pages. D: Server Management is incorrect; server management involves configuring and maintaining web servers and their operating systems, which is a backend task unrelated to CSS.