TPSC Prelims previous year questions questions with answers
772 multiple-choice questions. Open any question for its answer and explanation.
- 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
- Banker’s algorithm is used to avoidAsked in TPSC Junior System Engineer 2026
- Which CPU scheduling algorithm can cause the ‘convoy effect’, where short processes wait behind a long process ?Asked in TPSC Junior System Engineer 2026
- In virtual memory, the concept of ‘thrashing’ occurs whenAsked in TPSC Junior System Engineer 2026
- 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
- Which page replacement algorithm suffers from Belady’s anomaly (increasing frames can increase page faults) ?Asked in TPSC Junior System Engineer 2026
- Copy-on-Write (CoW) in fork() is an optimization thatAsked in TPSC Junior System Engineer 2026
- Which file allocation method provides the best sequential and random access but suffers from external fragmentation ?Asked in TPSC Junior System Engineer 2026
- 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
- 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
- In journaling file systems, the journal recordsAsked in TPSC Junior System Engineer 2026
- In a multi-level feedback queue (MLFQ) scheduler, a CPU-bound process will tend to:Asked in TPSC Junior System Engineer 2026
- Which normal form eliminates transitive dependencies ?Asked in TPSC Junior System Engineer 2026
- In a B+ tree index, all data records are stored atAsked in TPSC Junior System Engineer 2026
- The ACID property that ensures a transaction’s effects survive system failures isAsked in TPSC Junior System Engineer 2026
- Which SQL command is used to change the structure of an existing table ?Asked in TPSC Junior System Engineer 2026
- In relational algebra, which operation returns tuples present in one relation but not another ?Asked in TPSC Junior System Engineer 2026
- The Two-Phase Locking (2PL) protocol guarantees :Asked in TPSC Junior System Engineer 2026
- Boyce-Codd Normal Form (BCNF) is stricter than 3NF becauseAsked in TPSC Junior System Engineer 2026
- Which query optimization technique rewrites a query using relational algebra equivalences before execution ?Asked in TPSC Junior System Engineer 2026
- In the ER model, a weak entity is one thatAsked in TPSC Junior System Engineer 2026
- The MVCC (Multi-Version Concurrency Control) technique avoids read locks byAsked in TPSC Junior System Engineer 2026
- In agile development, a ‘Sprint’ isAsked in TPSC Junior System Engineer 2026
- Which software testing technique tests internal structure/code paths ?Asked in TPSC Junior System Engineer 2026
- 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