Public Service Commission Nepal Transport and Warehousing Company Limited, Open Competitive Written Examination for the post of Technician, Fifth, Computer Assistant2081/09/22
Paper: Second
Time: 3 Hours Full Marks: 100
Subject: Service related
The answer of each section should be written in a separate answer book. Otherwise the answer sheet will be cancelled.
Subjective
Section "A" 50 Marks
1. Define input, output and storage devices in the computer system. Explain in detail about different types of primary and secondary memories used in the computing devices. (3+7=10)
2. Explain the key functions of an Operating System (OS) and their significance in managing computer resources. Clarify how an OS manages process and memory. (7+3=10)
3. Define the term Data Source, Main Document, Merge Field in Mail Merge. Explain steps involved in performing a Mail Merge to send personalized letters to a list of clients using an Excel file as the data source. (3+7=10)
4. What is meant by relative, absolute and mixed cell references in MS-Excel sheet? How do you use AND function with IF clause in the Excel sheet? Explain with a suitable example. (6+4=10)
5. Describe the concept of functionality of the Master Slide in PowerPoint presentations, highlighting its role in maintaining design consistency across slides. Elaborate the use of slide templates and animations to create visually appealing and high-quality presentation, emphasizing their impact on audience engagement and the overall professionalism of the content. (5+5=10)
Section "B" 50 Marks
6. What are the different types of relationships between tables in database? Explain with suitable examples. Describe the importance of indexing in database. Also, differentiate between form and report. (5+2+3=10)
7. What is Content Management System (CMS) in webpage? Describe the primary purpose of CMS in website development. Write a code in HTML to create a webpage containing at least: header text, body background color, a table, an image and a text with hyperlink. (2+3+5=10)
8. Explain the different types of computer networks and network topologies. Mention the factor to consider when choosing a network topology for LAN. (8+2=10)
9. Describe the impact of common security threats such as Phising, Malware and DOS/DDOS attacks on an organization's cyber security posture. How can organizations mitigate these threats effectively? Write. (6+4=10)
10. Write down any five offences relating to computer mentioned in the Electronic Transaction Act, 2063. Briefly explain the primary roles and responsibilities of Government Integrated Data Center (GIDC). (5+5=10)
-The End-
Also Read
Post a Comment