लोक सेवा आयोग
नेपाल राष्ट्र बैंक, प्राविधिक, सूचना प्रविधि, सहायक द्धितिय, सहायक (सूचना प्रविधि) पदको खुल्ला प्रतियोगितात्मक लिखित परिक्षा
२०८१/०१/२०
पत्र: द्धितिय
समय: २ घण्टा ३० मिनेट पूर्णाङ्कः १००
विषय: Information Technology-II
प्रत्येक Section को उत्तर छुट्टाछुट्टै उत्तरपुस्तिकामा लेख्नुपर्नेछ । अन्यथा उत्तरपुस्तिका रद्ध हुनेछ ।
Subjective Time: 2 hours
75 Marks
Section "A" 45 Marks
1. What is Table of Content? How can you create Table of Content in MS Word? 1+4=5
2. What is page orientation? Explain different types of page orientation in detail. Also explain the use of Drop Cap. 1+3+1=5
3. Describe the process of creating a pivot table in a spreadsheet. Why are pivot table important for data analysis? Describe. 3+2=5
4. Discuss the advantages and disadvantages of using animations and transitions in a presentation. Provide example to support your answer. 5
5. Describe Database Management System. How is it different from File System? Explain the different types of JOIN in SQL. 1+1+3=5
6. What are the benefits of mail merge in MS Word? Explain the detail steps you use to create mail merge in MS Word. 2+8=10
7. What are the benefits of database normalization? Create a database in 1NF and convert it into 2NF and 3NF. Explain the ordered index and has index. 3+3+4=10
Section "B" 30 Marks
8. What is Content Management System? Write its advantages and limitation. 1+4=5
9. What are the perceived benefits and challenges of using IT in commercial banking services in Nepal? Explain with appropriate examples. 5
10. According to the Nepal Rastra Bank Act, what does the 'Negotiable Bill of Exchange' include? Explain. 5
11. Discuss the primary function of the Nepal Rastra Bank as per the Nepal Rastra Bank Act, 2058. 5
12. What are the main objectives of Electronic Transactions Act, 2063? Briefly explain offences relating to computer. 2+8=10
-The End-
