PSC Computer Operator Practical Question Set 11

ATTEMPT ALL THE QUESTIONS
1.      You have a sample document provided. Type the Nepali Document as Provided.               [15]

पश्चिम नेपालको कञ्चनपुर जिल्लामा एक बालिकालाई बलात्कारपछि गरिएको हत्याका मुख्य दोषीलाई पक्राउ नगरिएको र त्यसको विरोध गर्ने स्थानीयवासीलाई सरकारले दमन गरेको भन्दै शनिबार राजधानी काठमाण्डूमा समेत विरोध प्रदर्शन भएको छ। जनताको भेला' भनिएको उक्त प्रदर्शनमा 'निर्मलाका लागि न्याय' भन्ने लेखिएका प्लेकार्ड र ब्यानर बोकेर नागरिकहरू सहभागी भएका थिए। कुनै पनि राजनीतिक दल वा सामाजिक संघसंस्थाको आयोजनामा नभई स्वतस्फूर्त रूपमा विरोध प्रदर्शन गरिएको सहभागीहरूले बताए। काठमाण्डूको माइतीघरबाट सु्रु भएको विरोध प्रदर्शन बानेश्वर पुगेर सकिएको थियो।

मौन रूपमा निकालिएको उक्त जुलुसमा केही नाट्यकर्मीहरूले बलात्कारप्रति सरकारी बेवास्तामाथि व्यंग्य गर्दै सडक नाटक समेत देखाएका थिए। केही दिनदेखि सामाजिक सञ्जालमा चलाइएको 'निर्मलाका लागि न्याय' भन्ने ह्यासट्याग अभियानबाटै मानिसहरू उक्त विरोधमा सहभागी हुन आएको अभियान सु्रु गर्ने मध्येकी एक अमृता लम्सालले बताइन्। उनले भनिन्, "यहाँ सबैजना स्वतस्फूर्त रूपमा आउनु भएको छ, हामीले रातरातभर नसुती सामाजिक सञ्जालमा चलाएको अभियानमा पु्रुषहरूको समेत ठूलो सहभागीता हुनु खुशीको कुरा हो।" विरोधमा सहभागी नाट्यकर्मीहरूले भने एकोहोरो शंख फुकेर विरोध जनाएका थिए। सरकारले दण्डहीनता नदेखेको र पीडितको आवाज नसुनेकाले शंख फुकेर यस्तो विरोध जनाउनु परेको उनीहरूले बताए। शनिबारै बिहान बसेको सत्ताधारी दल नेपाल कम्युनिस्ट पार्टीको आकस्मिक सचिवालय बैठकले पनि बलात्कार र हत्यामा संलग्नलाई पक्राउ गरि कारबाही गर्न सरकारलाई आग्रह गरेको थियो। उक्त निर्णय लगत्तै गृह मन्त्रालयले घटनाको अनुसन्धानमा संलग्न कञ्चनपुरका प्रहरी उपरिक्षकलाई निलम्बन गरेको जनाएको छ। महेन्द्रनगरमा बसेका सर्वपक्षिय बैठकहरूले भने दोषीलाई खोजी गरि पक्राउ गरेर कारबाही गर्ने माग गरेपछि दुईदिनदेखि तनावग्रस्त रहेको उक्त स्थान शान्त हुने अपेक्षा गरिएको छ।

बालिका बलात्कारपछि हत्या गरिएको घटनाका वास्तविक दोषीलाई पक्राउ नगरिएको भन्दै सुरु भएको आन्दोलनका क्रममा कञ्चनपुरमा एक जनाको ज्यान जानुका साथै तीन जना गम्भीर घाइते भएका थिए। बैठकले शु्क्रबार प्रहरीको गोली लागि मारिएका शनि खुनालाई सहिद घोषणा गर्न र परिवारलाई उचित क्षतिपूर्ति दिन सिफारिस गर्ने निर्णय गरेकाले कञ्चनपुरको अवस्था सहज हुने एकजना महिला अधिकारकर्मी शारदा चन्दले बताइन्। उनले भनिन्, "अन्य सहमतिसँगै एउटा सद्भाव र्‍याली समेत निकाल्ने निर्णय भएको छ। यसले अब शान्तिपूर्ण रूपमा समस्या समाधान होला भन्ने आशा छ।" बैठकले आन्दोलनका क्रममा क्षति पुर्‍याइएकाहरूलाई उचित क्षतिपूर्ति दिने र अंगभंग भएकाहरूलाई राहत उपलब्ध गराउने निर्णय गरेको बताइएको छ।

बैठकको निर्णयलाई सकारात्मक रूपमा लिएको आन्दोलनरत संघर्ष समितिकी संयोजक मीना भण्डारीले बताइन्। उनले भनिन्, "निर्णयको अक्षरश: पालना भए कञ्चनपुरमा शान्ति र सद्भाव कामय हुनेछ। छानबिन समितिले पनि सत्यतथ्य बाहिर ल्याए निर्मलाको आत्माले शान्ति पाउनेछ।" सरकारी अधिकारीहरूले सर्वदलिय र सर्वपक्षिय बैठकपछि स्थिति सामान्य हुने र शान्ति सुरक्षाको अवस्था हेरी कर्फ्यु हटाइने जनाएका छन्। कञ्चनपुर घटनाबारे छानबिन गर्न सरकारले गठन गरेको उच्चस्तरिय समितिले पनि आफ्नो काम थालिसकेको संयोजक हरीप्रसाद मैनालीले बताए।

2.      You have a sample document provided. Type the English Document as Provided.               [5]

The company had started the road expansion project back in June 2014, and was supposed to complete the project by mid-July 2016. Owing to the 2015 earthquakes and the India-imposed trade embargo, the project’s deadline was extended to July 15 this year. But the company has completed only 47 percent of the work so far.
“Due to the bad condition of the road, the number of tourists who visit Nagarkot have gone down sharply, by almost 50 percent,” said Dhana Bahadur Lama, secretary of Nagarkot Nuldhm Tourist Development Committee.

“When the road was in a good condition, we used to get around 1,000 tourists in a single day,” he said. Nagarkot is one of the most popular tourist spots on the outskirts of Kathmandu Valley, with more than 100 hotels and restaurants. But the sorry state of the road means it takes more than two hours now to cover the distance which typically took not more than 45 minutes. Consequently, people are now opting to visit other tourist spots instead. Tourism entrepreneurs place the blame directly on Shailung Construction’s Chairman Sharada Prasad Adhikari for being neglectful and idle. if this condition prolongs, we will not be in a condition to run our businesses. Everyone is suffering, but the contractor is indifferent,” said Gokul Lamichhane, managing director of Hotel Marigold in Nagarkot.

Chief District Officer of Bhaktapur Narayan Prasad Bhattarai said that his office had written several letters to Adhikari, but to no avail. “I have tried to meet him in person as well, but he is not available,” said Bhatta. Two months ago, Mayor of Changunarayan Municipality Shom Mishra had also sent a letter to the Home Ministry regarding the issue. “Recently, I went to the minister’s residence to meet him, and requested him to give top priority to the construction of the road section. He has agreed to do so,” said Mishra.     

Hopes were high among the locals when the Home Ministry had launched an offensive against the non-performing and underperforming construction companies two months ago. But it soon fizzled out as the government did not take any action.  


3. Perform the following in Microsoft Word                                                                               [10]
copy question no. 2
Provide 2.5 line spacing
Add table of  3×2 at the bottom of document
 Provide 1" left and right indent for second paragraph
Create 2 line in margin drop cap for 1st paragraph
Create two columns for third paragraph
Insert header as "SK Technical Institute" at Left position and footer as page number at center position
Insert a horizontal watermark as SK Technical Institute
Insert  a following equation 


4. Prepare the following operation in spreadsheet program.                                                       [10]
S.N.
Name
Post
Salary
PF
Total
Grand Total
1.
Arjun
Manager
35000



2.
Rohan
Accountant
28000



3.
Sohan
Admin
32000



4.
Pawan
Salesman
20000



5.
Shyam
helper
15000




  •              Calculate the PF(Provident Fund)  12%  if salary is less than 20000, 15% if salary is less than 30000 otherwise 18%.
  •       Create the bar chart shows the Salary and Total salary.
5. Create the table structure for the following datasheet by using the design view.                     [4]
Empcode                     Number           integer (2 byte)
            EmpName                   Text                 30
            Salary                          Number           integer (2 byte)
            Dept                            Text                 10
            Attendance                 text                  1
6. Prepare a presentation with six slides from the text of question no.2                                        [3]
7. Prepare webpage of a school by using HTML Code with the following instructions.             [3]
Instructions:
a.       Create a Home page with introduction of the School
b.      Insert a picture on the home page
c.       Create next two pages with teachers and student data
d.      Link the pages by each other.



-Best of Luck-


Click Here to Download.......... Download PDF 


Most Important Question Set-2 for Competitive Exams


1. What is the file extension of ms access database?
a. .mad                                b. .adb                          c. .dbm                                    d. .mdb
2. The latest version of ms access is
a. 2000                                b. 8.0                            c. Xp                                       d. 2006
3. Which of the following statement is not correct?
a. Save the database file before working on it        b. Macro is not an object
c. Query works on sql standard                           d. Form is the front-end object
4. Which of the following statement is correct?
a. Table can be created in two ways                       b. Query stores the data like table
c. From can be created in two ways                       d. Reports can be generated without any table
5. Data can be defined as
a. Piece of information       b. Raw facts                 c. Recessed information          d. none
6. Collection of data is known as
a. Database                         b. Dbms                     c. Rdbms                              d. Information
7. When data is processed, it obtains
a. Database                         b. dbms                     c. rdbms                              d. Information
8. DBMS stands for
a. database managerial system                                b. database management system
c. database basic managerial system                       d. database basic management system
9. The key difference between dbms and rdbms is termed in
a. 12 Codd's rules               b. 6 Codd's rules          c. relationship                          d. None of above
10. Fields are also termed as
a. column                            b. record                       c. entity                                   d. row
11. Association among entities is expressed in the term of
a. attributes                         b. Relationship             c. query                                   d. properties
12. When primary key is applied to the field, the field
a. will not accept null values                                   b. Will not accept duplicates
c. both a& b                                                             d. none of above        
13. When indexing is done in the particular field, the field
a. Will not accept null valued                                 b. May or May not accept duplicates
c. both a &b                                                           d. none of above
14. Which of the following option is best suit for ms access definition?
a. dbms                            b. rdbms                   c. back end                              d. Microsoft database
15. Tables, forms, queries, reports all are the
a. objects                            b. field                         c. database                              d. Options
16. You have to apply the constraint of 'not null' values, than which property you will apply?
a. primary key                     b. index                        c. required                               d. a & c
17. ole stands for
a. Object link & Engaging                                       b. object linking & Embedding 
c. object like & energy                                            d. Online linking & embedding
18. Table can be created by...in ms access
a. 2 ways                            b. 3 ways                      c. 4 ways                                 d. 5 ways
19. From which data type drop down menu can be created in access
a. ole object                     b. drop down               c. hyperlink                             d. Look up wizard
20. Which data types support large number of text (characters)?
a. Memo                             b. text                           c. ole object                          d. Look up wizard
21. Which of the following data type is used for Boolean Value?
a. Currency                         b. Hyperlink                 c. Yes/No                                d. Look up wizard
22. Maximum Length of field name
a.50                                     b. 64                             c. 255                                      d.256
23. Which field property allows you to set date in "mm/dd/yy"?
a. date                                 b. format                      c. field size                              d. caption
24. Which is not part of report?
a. Title                                b. Report footer            c. Detail                                  d. Page footer
25. User cannot left the field blank or field cannot contain the null value because of the Following property
a. indexed                           b. required                    c. validation                            d. default value
26. User cannot make duplicate entry because of the following property
a. indexed                           b. required                    c. validation rule                     d. default value
27. You have to set the validation rule for 'date should be earlier than today' which of the following is correct
a.<=date()                           b.<=date                      c.<date()                                  d.<date
28.  you have to set   the validation rule for salary should not be less than 2500 and should not exceed 15000, which of the following is correct
a. <=2500 or >=15000         b.>= 2500 and<=15000         c.<2500 or>15000       d.<2500 and >15000
29. To create the input mask for letter (a to z), entry required, which of the following character is used
a. l                                       b.?                                c. &                                         d. C
30. The special form that links different objects for integration is called...
a. Package form                  b. Entry form               c. Switchboard                        d. Auto form
31. Primary key is essential for
a. not to allow duplicate entry                                b. not to allow null values
c. to create relationship                                           d. all of above
32. To create the relationship, which of the following is essential?
a. primary                           b. foreign  key              c. both of above                      d. none of above
33. While creating the relationship, the "enforce referential integrity" means
a. Value cannot be entered into second table other than specified in the first table's field
b. Value can be entered into the second table other than specified in the first's table's field
c. Can not make null entries
d. Can not make entries
34. SQL stands for
a. Structured query line                                           b. structured question line 
c. Structured query language                                  d. Structured question language
35. DCL is a part of DBMS and it stands for
a. Data count language                                            b. Data control language 
c. Data computer language                                     d. Data command language
36. In ms-access, SQL statement can be written by choosing
a. Design view                    b. Datasheet view        c. Query view                         d. sql view
37. How many types of action queries are in ms-access?
a. 4                                      b. 5                               c. 6                                          d. 7
38. To add or deduct the values on the table, which of the following query, you will use.
a. Append query                 b. update query            c. select query                         d. none of the above
39. Ms-access form is also termed as ----in database terminology
a. back end                         b. front end                  c. middle edge                        d. application.
40. To modify a form, you will go from
a. design view                    b. datasheet view         c. form view                            d. run view
41. Form can be based on -----
a. table                                b. query                        c. table & query                       d. table, query & form
42. ---------------is the output of database
a. Report                             b. form                         c. macro                                   d. query
43. Report can be based on -------------
a. report                              b. query                        c. table & query                       d. table, query & form
44. The text that is written inside 'Report footer' on three page long report, how many times will repeat the footer?
a. 2 times                            b. 3 times                     c. 4 times repeat                      d. will not repeat
45. The grand total is the part of report....
a. Report footer                  b. page footer               c. details                                  d. report header
46. Set of actions contained in one object is known as
a. Form                               b. report                       c. macro                                   d. Query
47. What is the difference between form and report?
a. Form is an object and report is not.                     b. Form relies on report
c. Report relies on form                  d. form is the front-end part and report is the final output of database
48. Data can be entered into the table by using
a. Form                               b. report                       c. A and B                               d. none on above
49. Report can be created with -----------------table(s) at a time
a. Just one                           b. two tables                c. three tables                          d. many
50. Macro can be used with
a. Form                               b. report                       c. Query                                  d. all of the above


Answer Sheet

1
d
2
c
3
b
4
b
5
b
6
a
7
d
8
b
9
a
10
a
11
b
12
c
13
c
14
b
15
a
16
D
17
b
18
b
19
d
20
a
21
c
22
c
23
b
24
d
25
b
26
a
27
c
28
b
29
b
30
c
31
d
32
c
33
a
34
c
35
b
36
d
37
a
38
a
39
b
40
a
41
c
42
a
43
c
44
d
45
a
46
c
47
d
48
a
49
d
50
d


Click Here to download..........  Download PDF