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