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. Which of the following correctly defines runtime polymorphism in C++ ?Asked in TPSC Senior Technical Assistant 2026
  2. In Java, what is the output of System.out.println(10/3) ;Asked in TPSC Senior Technical Assistant 2026
  3. In OSI Model, which layer is responsible for end-to-end error recovery and flow control ?Asked in TPSC Senior Technical Assistant 2026
  4. Which device connects two different networks ?Asked in TPSC Senior Technical Assistant 2026
  5. Which switching technique guarantees constant bandwidth and fixed delay but is inefficient for bursty data ?Asked in TPSC Senior Technical Assistant 2026
  6. Which layer of the OSI model handles physical transmission of bits ?Asked in TPSC Senior Technical Assistant 2026
  7. Which device operates at both Layer 2 and Layer 3 in modern networks ?Asked in TPSC Senior Technical Assistant 2026
  8. Which protocol is used to assign IP addresses automatically ?Asked in TPSC Senior Technical Assistant 2026
  9. What is the purpose of DNS ?Asked in TPSC Senior Technical Assistant 2026
  10. Which switching method stores entire frame before forwarding ?Asked in TPSC Senior Technical Assistant 2026
  11. Which network architecture separates service providers from consumers ?Asked in TPSC Senior Technical Assistant 2026
  12. Which protocol is used to send emails ?Asked in TPSC Senior Technical Assistant 2026
  13. In TCP/IP, which layer combines the Session and Presentation layers of OSI ?Asked in TPSC Senior Technical Assistant 2026
  14. A subnet mask of 255.255.255.0 provides how many host bits ?Asked in TPSC Senior Technical Assistant 2026
  15. In Relational Algebra, which operator is NOT primitive but derived ?Asked in TPSC Senior Technical Assistant 2026
  16. Which SQL command is used to retrieve data from a table ?Asked in TPSC Senior Technical Assistant 2026
  17. In Oracle Database, what is the purpose of a synonym ?Asked in TPSC Senior Technical Assistant 2026
  18. Which of the following is TRUE about mutating tables in PL/SQL triggers ?Asked in TPSC Senior Technical Assistant 2026
  19. Which SQL command is used to add new records to a table ?Asked in TPSC Senior Technical Assistant 2026
  20. What type of JOIN returns all records from both tables ?Asked in TPSC Senior Technical Assistant 2026
  21. In PL/SQL, what is the key difference between an implicit and explicit cursor ?Asked in TPSC Senior Technical Assistant 2026
  22. In SQL, what does the WITH CHECK OPTION clause do in a view ?Asked in TPSC Senior Technical Assistant 2026
  23. PL/SQL extends SQL by adding which type of features ?Asked in TPSC Senior Technical Assistant 2026
  24. Which SQL clause is used with aggregate functions to filter grouped results ?Asked in TPSC Senior Technical Assistant 2026
  25. Which normal form eliminates transitive dependencies ?Asked in TPSC Senior Technical Assistant 2026