TPSC Prelims previous year questions
Guiding State PSC aspirants since 2016 50,000+ students · 1,000+ final selections Exam Calendar Results Call 9116926003
pscnotes
Pick your state

TPSC Prelims previous year questions questions with answers

772 multiple-choice questions. Open any question for its answer and explanation.

  1. In the sliding window protocol with window size W, bandwidth-delay product B, and a = propagation delay / transmission time. What is the maximum channel utilization achievable ?Asked in TPSC Junior System Engineer 2026
  2. Banker’s algorithm is used to avoidAsked in TPSC Junior System Engineer 2026
  3. Which CPU scheduling algorithm can cause the ‘convoy effect’, where short processes wait behind a long process ?Asked in TPSC Junior System Engineer 2026
  4. In virtual memory, the concept of ‘thrashing’ occurs whenAsked in TPSC Junior System Engineer 2026
  5. A semaphore S is initialized to 1. Process P1 executes wait(S) and then signal(S). Process P2 also executes wait(S) then signal(S). This semaphore implements:Asked in TPSC Junior System Engineer 2026
  6. Which page replacement algorithm suffers from Belady’s anomaly (increasing frames can increase page faults) ?Asked in TPSC Junior System Engineer 2026
  7. Copy-on-Write (CoW) in fork() is an optimization thatAsked in TPSC Junior System Engineer 2026
  8. Which file allocation method provides the best sequential and random access but suffers from external fragmentation ?Asked in TPSC Junior System Engineer 2026
  9. In a multi-threaded process, which of the following is shared among all threads of the same process ?Asked in TPSC Junior System Engineer 2026
  10. The Shortest Remaining Time First (SRTF) scheduling algorithm is the preemptive version of SJF. Its main drawback is:Asked in TPSC Junior System Engineer 2026
  11. In journaling file systems, the journal recordsAsked in TPSC Junior System Engineer 2026
  12. In a multi-level feedback queue (MLFQ) scheduler, a CPU-bound process will tend to:Asked in TPSC Junior System Engineer 2026
  13. Which normal form eliminates transitive dependencies ?Asked in TPSC Junior System Engineer 2026
  14. In a B+ tree index, all data records are stored atAsked in TPSC Junior System Engineer 2026
  15. The ACID property that ensures a transaction’s effects survive system failures isAsked in TPSC Junior System Engineer 2026
  16. Which SQL command is used to change the structure of an existing table ?Asked in TPSC Junior System Engineer 2026
  17. In relational algebra, which operation returns tuples present in one relation but not another ?Asked in TPSC Junior System Engineer 2026
  18. The Two-Phase Locking (2PL) protocol guarantees :Asked in TPSC Junior System Engineer 2026
  19. Boyce-Codd Normal Form (BCNF) is stricter than 3NF becauseAsked in TPSC Junior System Engineer 2026
  20. Which query optimization technique rewrites a query using relational algebra equivalences before execution ?Asked in TPSC Junior System Engineer 2026
  21. In the ER model, a weak entity is one thatAsked in TPSC Junior System Engineer 2026
  22. The MVCC (Multi-Version Concurrency Control) technique avoids read locks byAsked in TPSC Junior System Engineer 2026
  23. In agile development, a ‘Sprint’ isAsked in TPSC Junior System Engineer 2026
  24. Which software testing technique tests internal structure/code paths ?Asked in TPSC Junior System Engineer 2026
  25. Cyclomatic complexity of a program is defined as M = E − N + 2P. For a program with 15 edges, 12 nodes, and 1 connected component, M =Asked in TPSC Junior System Engineer 2026