Join WhatsApp ChannelDaily MCQs & Exam Updates

FPSC MCQs

Federal Public Service Commission — Complete MCQ Bank

66 Questions
Exam Preparation Guide

How to prepare for FPSC

FPSC recruitment tests assess subject knowledge, general ability and job-related competence for federal government positions across Pakistan.

General KnowledgeCurrent AffairsEnglishJob-related Subjects
Read the official syllabus first, then combine subject-specific revision with timed mixed-question practice.
FPSC preparation illustration
41

What does VLOOKUP do in Excel?

  • ACreates charts
  • BSearches values vertically
  • CDeletes rows
  • DSorts 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
42

Which feature in Excel is used to summarize large datasets?

  • ASpell Check
  • BPivot Table
  • CWordArt
  • DAutoFill
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
43

What is the role of DNS in networking?

  • AAssign IP addresses
  • BTranslate domain names to IP addresses
  • CTransfer files
  • DEncrypt network traffic
Permalink
Correct Answer: Option B — Translate domain names to IP addresses
Explanation: DNS converts domain names into IP addresses, allowing systems to locate internet resources.
Submitted by: PaperMCQs
44

What is the primary purpose of RAID technology?

  • AIncrease screen resolution
  • BImprove storage performance and reliability
  • CEnhance processor speed
  • DManage 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
45

Which of the following is a NoSQL database?

  • AOracle
  • BMySQL
  • CMongoDB
  • DPostgreSQL
Permalink
Correct Answer: Option C — MongoDB
Explanation: MongoDB is a document-oriented NoSQL database designed for flexible and scalable data storage.
Submitted by: PaperMCQs
46

What is a deadlock in an operating system?

  • AA memory leak
  • BA security attack
  • CA situation where processes wait indefinitely for resources
  • DA file corruption error
Permalink
Correct Answer: Option C — A situation where processes wait indefinitely for resources
Explanation: Deadlock occurs when processes are permanently blocked waiting for resources held by one another.
Submitted by: PaperMCQs
47

What is the purpose of an index in a database?

  • AReduce security
  • BImprove query performance
  • CStore backups
  • DEncrypt records
Permalink
Correct Answer: Option B — Improve query performance
Explanation: Indexes improve retrieval speed by allowing databases to locate records efficiently.
Submitted by: PaperMCQs
48

Which memory is fastest among the following?

  • AHard Disk
  • BRAM
  • CCache Memory
  • DROM
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
49

Which SQL clause is used to filter rows before grouping?

  • AHAVING
  • BGROUP BY
  • CWHERE
  • DORDER BY
Permalink
Correct Answer: Option C — WHERE
Explanation: The WHERE clause filters rows before grouping and aggregation are applied.
Submitted by: PaperMCQs
50

Which algorithm is commonly used to find the shortest path in a weighted graph?

  • ABubble Sort
  • BDijkstra's Algorithm
  • CBinary Search
  • DDepth First Search
Permalink
Correct Answer: Option B — Dijkstra's Algorithm
Explanation: Dijkstra's Algorithm finds shortest paths in weighted graphs with non-negative edge weights and is widely used in navigation systems.
Submitted by: PaperMCQs