IT Officer Loksewa Past Question | PSC 2083 | Gorkhapatra Pratisthan

Loksewa Aayog · 2083

PSC IT Officer Written Exam

Gorkhapatra Sansthan — Paper I (Subjective)  |  50 Marks  |  1 hr 30 min

1 Explain query optimization with any three types of optimization techniques. 5 marks ›

💡 Hint / Answer Query optimization reduces DB query execution time.
1. Index-based: Use indexes to avoid full table scans.
2. Query rewriting: Restructure SQL (e.g., avoid SELECT *, use WHERE early).
3. Join optimization: Choose best join strategy — nested loop, hash join, or merge join.

2 What is normalization? Explain the BCNF normalization with example. 2+3 marks ›

💡 Hint / Answer Normalization organizes DB tables to reduce redundancy and improve integrity.
BCNF: For every functional dependency X→Y, X must be a superkey.
Example: If Teacher→Course and Course→Teacher exist together, decompose into separate tables so each determinant is a superkey.

3 What is DNS? Explain how DNS resolves a domain name to an IP address. 2+3 marks ›

💡 Hint / Answer DNS (Domain Name System) translates domain names (e.g. google.com) into IP addresses.
Resolution steps: Browser cache → Recursive Resolver → Root Server → TLD Server (.com) → Authoritative Name Server → IP returned to browser.

4 What is routing? Explain the difference between static and dynamic routing. 1+4 marks ›

💡 Hint / Answer Routing: Process of forwarding data packets between networks.
Static: Manually configured routes, no auto-update, good for small networks.
Dynamic: Routers exchange info via protocols (RIP, OSPF, BGP), adapts automatically, scalable for large networks.

5 During SLC results, millions of users access the Gorkhapatra website at the same time. Explain how distributed systems handle high traffic. 5 marks ›

💡 Hint / Answer 1. Load balancing — distribute requests across multiple servers.
2. Horizontal scaling — add more servers on demand.
3. Caching — CDN / Redis stores frequent responses.
4. DB read replicas — reduce database pressure.
5. Message queues — buffer requests to prevent overload.

6 What is mutual exclusion? Depict a scenario where mutual exclusion is required. 2+3 marks ›

💡 Hint / Answer Mutual exclusion ensures only one process accesses a critical section at a time.
Scenario: Two ATM transactions deducting from the same account simultaneously — without mutex, both read $500, both deduct $300, leaving a wrong final balance. A mutex lock prevents this race condition.

7 Why are CISC processors still widely used despite RISC being faster? Explain any three addressing modes used in CISC. 3+3+4 marks ›

💡 Hint / Answer Why CISC: Backward compatibility with legacy software, complex instructions reduce code size, simpler compiler design.
Addressing modes:
1. Immediate — operand inside instruction: MOV AX, 5
2. Register — operand from register: MOV AX, BX
3. Indirect — address stored in register: MOV AX, [BX]

8 As IT Officer of Gorkhapatra Sansthan, explain requirement analysis and SCM for a new sales application. Discuss the software process and AI tools you might use. 4+6 marks ›

💡 Hint / Answer Requirement analysis: Gather functional/non-functional requirements via stakeholder interviews, use cases, feasibility study, and SRS document.
SCM: Version control (Git), change management, release management, CI/CD pipelines.
Process: Agile/Scrum for iterative delivery and stakeholder feedback.
AI tools: GitHub Copilot (code generation), ChatGPT (documentation), Testim (AI testing), NLP tools for requirements analysis.

PSC IT Officer 2083 · Gorkhapatra Sansthan · Paper I