Join WhatsApp ChannelDaily MCQs & Exam Updates

Computer Science MCQs

MCQs on Programming, Networking, Database and OS

62 Questions
Subject Preparation Guide

Prepare Computer Science with confidence

Strengthen your knowledge of computer fundamentals, hardware, software, programming, networks, databases and information technology.

Computer BasicsProgrammingNetworksDatabases
Recommended for academic classes, IT tests and computer portions of competitive examinations.
Computer Science preparation illustration
41
Medium css pms

Which Excel reference remains fixed when copied?

  • A Relative Reference
  • B Mixed Reference
  • C Absolute Reference
  • D Dynamic Reference
Permalink
Correct Answer: Option C — Absolute Reference
Explanation: Absolute references use dollar signs and do not change when formulas are copied to other cells.
Submitted by: PaperMCQs
42
Medium css fpsc

What does VLOOKUP do in Excel?

  • A Creates charts
  • B Searches values vertically
  • C Deletes rows
  • D Sorts data
Permalink
Correct Answer: Option B — Searches values vertically
Explanation: VLOOKUP searches for a value in the first column of a table and returns related information from another column.
Submitted by: PaperMCQs
43
Medium fpsc ppsc

Which feature in Excel is used to summarize large datasets?

  • A Spell Check
  • B Pivot Table
  • C WordArt
  • D AutoFill
Permalink
Correct Answer: Option B — Pivot Table
Explanation: Pivot Tables allow users to summarize, analyze, and organize large amounts of data efficiently.
Submitted by: PaperMCQs
44
Medium css pms

Which software development model follows a sequential approach?

  • A Agile
  • B Scrum
  • C Waterfall
  • D DevOps
Permalink
Correct Answer: Option C — Waterfall
Explanation: The Waterfall model progresses through defined phases in sequence and is suitable for stable requirements.
Submitted by: PaperMCQs
45
Medium fpsc ppsc

What is the primary purpose of RAID technology?

  • A Increase screen resolution
  • B Improve storage performance and reliability
  • C Enhance processor speed
  • D Manage network traffic
Permalink
Correct Answer: Option B — Improve storage performance and reliability
Explanation: RAID combines multiple drives to improve performance, fault tolerance, or both.
Submitted by: PaperMCQs
46
Medium css pms

What is the purpose of a foreign key?

  • A Store passwords
  • B Identify duplicate records
  • C Create relationships between tables
  • D Encrypt database contents
Permalink
Correct Answer: Option C — Create relationships between tables
Explanation: Foreign keys enforce relationships between tables and maintain referential integrity.
Submitted by: PaperMCQs
47
Medium css fpsc

Which of the following is a NoSQL database?

  • A Oracle
  • B MySQL
  • C MongoDB
  • D PostgreSQL
Permalink
Correct Answer: Option C — MongoDB
Explanation: MongoDB is a document-oriented NoSQL database designed for flexible and scalable data storage.
Submitted by: PaperMCQs
48
Medium css fpsc

What is the purpose of an index in a database?

  • A Reduce security
  • B Improve query performance
  • C Store backups
  • D Encrypt records
Permalink
Correct Answer: Option B — Improve query performance
Explanation: Indexes improve retrieval speed by allowing databases to locate records efficiently.
Submitted by: PaperMCQs
49
Medium css fpsc

Which memory is fastest among the following?

  • A Hard Disk
  • B RAM
  • C Cache Memory
  • D ROM
Permalink
Correct Answer: Option C — Cache Memory
Explanation: Cache memory stores frequently used data close to the CPU and is significantly faster than RAM.
Submitted by: PaperMCQs
50
Medium fpsc nts

Which SQL clause is used to filter rows before grouping?

  • A HAVING
  • B GROUP BY
  • C WHERE
  • D ORDER BY
Permalink
Correct Answer: Option C — WHERE
Explanation: The WHERE clause filters rows before grouping and aggregation are applied.
Submitted by: PaperMCQs
51
Medium css pms

What is polymorphism in object-oriented programming?

  • A Data hiding
  • B Ability of an object to take multiple forms
  • C Memory allocation
  • D Database indexing
Permalink
Correct Answer: Option B — Ability of an object to take multiple forms
Explanation: Polymorphism allows objects to be treated through a common interface while exhibiting different behaviors depending on their actual type.
Submitted by: PaperMCQs
52
Medium css fpsc

Which OSI layer is responsible for end-to-end communication?

  • A Network Layer
  • B Data Link Layer
  • C Transport Layer
  • D Session Layer
Permalink
Correct Answer: Option C — Transport Layer
Explanation: The Transport Layer provides end-to-end communication, reliability, flow control, and error handling using protocols such as TCP and UDP.
Submitted by: PaperMCQs
53
Medium fpsc nts

Which sorting algorithm repeatedly selects the smallest element and places it in the correct position?

  • A Merge Sort
  • B Quick Sort
  • C Selection Sort
  • D Heap Sort
Permalink
Correct Answer: Option C — Selection Sort
Explanation: Selection Sort repeatedly finds the minimum element from the unsorted portion and places it at the beginning. It is simple but inefficient for large datasets.
Submitted by: PaperMCQs
54
Medium css fpsc

What is the primary purpose of normalization in relational databases?

  • A Increase redundancy
  • B Reduce redundancy
  • C Increase storage space
  • D Improve graphics rendering
Permalink
Correct Answer: Option B — Reduce redundancy
Explanation: Normalization organizes data into structured tables to minimize redundancy and dependency issues. It improves data integrity, reduces update anomalies, and makes databases easier to maintain and scale in real-world applications.
Submitted by: PaperMCQs
55
Medium fpsc ppsc

Which scheduling algorithm gives each process a fixed time slice?

  • A FCFS
  • B Round Robin
  • C Shortest Job First
  • D Priority Scheduling
Permalink
Correct Answer: Option B — Round Robin
Explanation: Round Robin scheduling assigns a fixed time quantum to each process. If a process does not complete within its allotted time, it is moved to the end of the queue. This approach improves fairness and responsiveness in time-sharing systems.
Submitted by: PaperMCQs
56
Medium css pms

Which data structure is most suitable for implementing recursion?

  • A Queue
  • B Array
  • C Stack
  • D Heap
Permalink
Correct Answer: Option C — Stack
Explanation: Recursion relies on the call stack to store function calls, local variables, and return addresses. Every recursive call creates a new stack frame, which is removed when the function returns. This makes the stack the fundamental data structure behind recursion.
Submitted by: PaperMCQs
57
Medium css fpsc

What is the purpose of a firewall?

  • A Increase processor speed
  • B Protect networks from unauthorized access
  • C Store files permanently
  • D Compress data
Permalink
Correct Answer: Option B — Protect networks from unauthorized access
Explanation: A firewall monitors and filters network traffic according to predefined security rules. It acts as a barrier between trusted and untrusted networks, helping prevent unauthorized access and cyberattacks.
Submitted by: PaperMCQs
58
Medium css pms

What is encapsulation in object-oriented programming?

  • A Combining data and methods into a single unit
  • B Creating multiple classes
  • C Executing parallel processes
  • D Allocating memory dynamically
Permalink
Correct Answer: Option A — Combining data and methods into a single unit
Explanation: Encapsulation is the process of bundling data and methods within a class while restricting direct access to internal details. It improves modularity, maintainability, and security by controlling how data is accessed and modified.
Submitted by: PaperMCQs
59
Medium css fpsc

What is the time complexity of Binary Search in the worst case?

  • A O(n)
  • B O(log n)
  • C O(n²)
  • D O(1)
Permalink
Correct Answer: Option B — O(log n)
Explanation: Binary Search repeatedly divides a sorted dataset into halves until the target value is found or determined absent. Because the search space is halved each step, the worst-case time complexity is logarithmic, O(log n).
Submitted by: PaperMCQs
60
Medium css fpsc

Which layer of the OSI model is responsible for routing packets?

  • A Transport Layer
  • B Network Layer
  • C Session Layer
  • D Presentation Layer
Permalink
Correct Answer: Option B — Network Layer
Explanation: The Network Layer is responsible for logical addressing and routing of packets between networks. Protocols such as IP operate at this layer, enabling data to travel across interconnected networks efficiently.
Submitted by: PaperMCQs