Join WhatsApp ChannelDaily MCQs & Exam Updates

Computer Science MCQs

MCQs on Programming, Networking, Database and OS

47 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
21
Medium css fpsc

What is artificial intelligence?

  • A Computer hardware
  • B Simulation of human intelligence by machines
  • C Network design
  • D Database storage
Permalink
Correct Answer: Option B — Simulation of human intelligence by machines
Explanation: Artificial Intelligence enables machines to perform tasks requiring human-like reasoning and learning.
Submitted by: PaperMCQs
22
Medium css fpsc

Which database operation removes a table completely?

  • A DELETE
  • B REMOVE
  • C DROP
  • D CLEAR
Permalink
Correct Answer: Option C — DROP
Explanation: DROP permanently removes an entire database object including structure and data.
Submitted by: PaperMCQs
23
Medium css fpsc

Which cyberattack encrypts files and demands payment?

  • A Spyware
  • B Ransomware
  • C Adware
  • D Trojan
Permalink
Correct Answer: Option B — Ransomware
Explanation: Ransomware locks or encrypts data and demands a ransom for restoration.
Submitted by: PaperMCQs
24
Medium css pms

What is multitasking in an operating system?

  • A Using multiple monitors
  • B Running multiple processes concurrently
  • C Installing multiple OS
  • D Using many files
Permalink
Correct Answer: Option B — Running multiple processes concurrently
Explanation: Multitasking enables an operating system to execute multiple programs seemingly at the same time.
Submitted by: PaperMCQs
25
Medium css fpsc

What is a database schema?

  • A Backup file
  • B Structure of a database
  • C Network device
  • D Programming language
Permalink
Correct Answer: Option B — Structure of a database
Explanation: A database schema defines tables, fields, relationships, and constraints.
Submitted by: PaperMCQs
26
Medium css fpsc

Which layer of OSI handles physical transmission of bits?

  • A Network
  • B Transport
  • C Physical
  • D Session
Permalink
Correct Answer: Option C — Physical
Explanation: The Physical Layer is responsible for transmitting raw bits over communication channels.
Submitted by: PaperMCQs
27
Medium css fpsc

Which programming language is primarily used for Android development?

  • A Swift
  • B Kotlin
  • C Ruby
  • D PHP
Permalink
Correct Answer: Option B — Kotlin
Explanation: Kotlin is Google's preferred language for Android app development because of its modern syntax and safety features.
Submitted by: PaperMCQs
28
Medium css fpsc

Which protocol is used to securely transfer files over SSH?

  • A FTP
  • B TFTP
  • C SFTP
  • D SMTP
Permalink
Correct Answer: Option C — SFTP
Explanation: SFTP operates over SSH and provides encrypted file transfer capabilities, making it more secure than traditional FTP for transmitting sensitive data.
Submitted by: PaperMCQs
29
Medium css fpsc

Which Excel chart is best for showing trends over time?

  • A Pie Chart
  • B Line Chart
  • C Scatter Plot
  • D Radar Chart
Permalink
Correct Answer: Option B — Line Chart
Explanation: Line charts effectively display trends and changes across time periods, making them useful for analysis.
Submitted by: PaperMCQs
30
Medium css pms

What is a macro in MS Office?

  • A Database
  • B Automated task sequence
  • C Chart type
  • D Network protocol
Permalink
Correct Answer: Option B — Automated task sequence
Explanation: A macro automates repetitive tasks by storing commands and actions that can be replayed later.
Submitted by: PaperMCQs
31
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
32
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
33
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
34
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
35
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
36
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
37
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
38
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
39
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
40
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