Sigma Delta: QS

Showing posts with label QS. Show all posts

Aug 23, 2017

PSC Assistant Computer Operator Exam 2074-05-07 Solved Answer Paper

लाेक सेवा अायाेग, नेपाल विविध सेवा, राजपत्र अनंकित द्वितीय श्रेणी

सहायक कम्प्युटर अपरेटर वा साे सरह (प्राविधिक) पदकाे प्रतियाेगितात्मक परीक्षा मिति २०७४-०५-०७

Key: (B) विषय सेवा सम्बन्धी ।

Jul 9, 2017

लोकसेवा आयोगबाट बिगतमा सोधिएका बिज्ञान,प्रबिधी र स्वास्थ्य सम्बन्धी १२५ वटा प्रश्नोत्तरहरु

#बिज्ञान,प्रबिधी र स्वास्थ्य सम्बन्धी १२५ वटा प्रश्नोत्तर
लोक सेवा आयोगबाट बिगतमा सोधिएका प्रश्नोत्तरहरु

१ रुख सम्बन्धी अध्यान गर्ने बिज्ञानलाइ के भनिन्छ ?
- आर्बोरिकल्चर ( नासु २०७०)
२ रक्त सञ्चार प्रक्रीया कसले पत्ता लगाएका हुन ?
- विलियम हर्बे (नासु २०६९)
३ कुकुरलाइ कति डिग्री फरेनहाइटमा ज्वरो आउछ ?
- १०२° फरेनहाइट (खरिदार २०६८)
४ डिजेल इन्जिनका आबिष्कार को हुन ?
- रोडोल्फ डिजेल (खरिदार २०६८)
५ कुनै अन्तरिक्ष यात्रीको तौल पृथ्विमा २२० पाउण्ड छ भने चन्द्रमा उसको तौल कति होला ?
- ३६•३७ पाउण्ड (खरिदार २०६८)
६ भुकम्प मापन गर्ने यन्त्रलाइ के भनिन्छ ?
- सिस्मोग्राफ (खरिदार २०६८)
७ प्राणिहरुको बिकासबादी सिद्दन्तका प्रतिपादक को हुन ?
-चार्ल्स डार्बिन ( खरिदार २०६८)
८ इन्सुलिन कुन रोगसँ सम्बन्धित छ ?
- मधुमेह (नासु २०७०)
९ शरिरमा भिटामिन सिको कारणले कुन रोग लाग्छ ?
- स्कर्भी (नासु २०७०)
१० क्षयरोगबाट बच्न कुन खोप प्रयोग गर्नु उपयुक्त्त हुन्छ ?
- बी सी जी (खरिदार २०७०)
११ बेरीबेरी रोग कुन भिटामिनको कमिले लाग्दछ ?
- भिटामिन बी र सी (खरिदार २०७०)
१२ गलगाँड के बृद्दी भएर हुने गर्दछ ?
- थाइराईड ग्रन्थी ( खरिदार २०७०)
१३ कुन प्रकारको भिटामिनको कमिले रतन्धो लाग्दछ ?
- भिटामिन ए (खरिदार २०६८)
१४ भिटामिन ए को रासयनिक नाम के हो ?
- रोटिनोल (खरिदार २०६८)
१५ १ ग्राम कार्बोहाइड्रेट्ले कति क्यालोरी शक्ती उपल्ब्ध गराउछ ?
- ४ क्यालोरी (खरिदार २०६८)
१६" प्रत्येक क्रीया जहिले पनि बराबर तर बिपरित प्रतिक्रीया हुन्छ" भन्ने न्युटनको गतिको कुन चही नियम हो ?
- तेश्रो नियम (नासु २०७१)
१७ सबैभन्दा बढी अक्सिजन उत्पादन गर्ने रुख कुन हो ?
-पिपल (नासु २०७१)
१८ मानिसको सामन्य रक्तचापको अबस्था कति हो ?
- १२०/८० MM पारो (खरिदार २०६८)
विज्ञान प्रविधी विकास
-----------------
१९ वातवरण सम्वन्धि पहिलो अन्तराष्ट्रीय सम्मेलन कहिलो भयो ?
- सन १९७२ जुन ५-१६
२० स्मृती वन के सँग सम्बन्धित छ ?
- व्यापकरुपमा वृक्षारोपण गर्न जनतालाई प्रोत्साहित गरि वातवरण प्रदुषण नियन्त्रण गर्ने
२१ वायुयानको आवगमनको पूर्वसूचना दिने यन्त्रलाई के भनिन्छ ?
- प्रीडिक्टर
२२ आफ्नो गुँड बनाउने एकमात्र सर्पको प्रजाती कुन हो ?
-गोमन
२३ डाइनामाईटको आविष्कार कसले गरेका हुन ?
- अल्फ्रेड नोबेल
२४ ओजन तह पातलिदैं गएको तथ्य सर्वप्रथम प्रकाशमा ल्याउने वैज्ञानिक को हुन ?
-सेरउड रोल्याण्ड
२५ हरित गृह प्रभावको अवधारणा ल्याउने वैज्ञानिक को हुन ?
- बेरिन जिन फेरिएर
२६ मुकेश चालिसेले कुन जिवको बारेमा गहन अध्यायन गरेका थिए ?
- बाँदर
२७ ग्याँसको दबाब नाप्ने यन्त्रलाई के भनिन्छ ?
- मानोमिटर
२८ कम्प्युटरको सूचनाहरु कुन एकाईमा नापिन्छ ?
-बिटमा, बाईटमा, गिगाबाईटमा
२९ मानिस मृत्यु भएपछी अन्त्य सम्म काम गर्ने अंग कुन हो ?
- कान
३० कति तापक्रममा पानी सबैभन्दा गर्हुंगो हुन्छ ?
-४° सेन्टिग्रेड
३१ सबैभन्दा बढी फलाम तत्व कुन खाद्य पदार्थमा पाईन्छ ?
- पालुङ्गो साग
३२ कुन बैज्ञानिकलाई Father of स्किएन्के भनिन्छ ?
-अल्बर्ट आईन्सटाइन
३३ ´Give me a firm place to stand and I will move to earth` भन्ने वैज्ञानिक को हुन?
- आर्किमिडिज
३४ लुई पाश्चरले रेबिज रोग विरुद्दको सुईको आविष्कार कहिले गरेका थिए ?
-सन १८५५
३५ प्यारासुटको आविष्कार कसले गरेका हुन ?
-जे ब्लेनचार्ड
३६ हिरामा कति प्रतिशत कार्वन रहेको हुन्छ ?
-१००%
३७ टेष्ट ट्युब प्रविधिबाट विश्वमा पहिले जन्माईएको बच्चाको नाम के हो ?
- लुइस ब्राउन (नेपालाका ओममणि तामाङ)
३८ जेनेरेटरको आविष्कार कसले गरेका हुन ?
- माइकल फराडे
३९ सर्वप्रथम क्लोनिङ प्रविधिबाट जन्माईएको भेडाको नाम के हो ?
- डलि
४० प्रयोगत्माक विज्ञानका पिता भनेर कसलाई चिनिन्छ ?
- आर्किमिडिज
४१ बलप्वाईन्ट पेनको आविस्कार कसले गरेका हुन ?
- विरो ब्रदर्स
४२ ग्यालिलियोले दुरदर्शक यन्त्रको आविष्कार कहिले गरेका थिए ?
- सन १६०९
४३ न्युटनको ब्रहमान्डशास्त्र, गुरुत्वाकर्षण, गतिका नियम आदि समेटिएका प्रशिद्द ग्रन्थ ´Principia` कहिले प्रकाशित भएको थियो ?
- सन १६८७
४४ रकेट इन्जिन तथा जेट इन्जिन न्युटनको चालसम्बन्धी कुन नियमको आधरमा निर्माण गरिएको हो ?
- तेश्रो नियम
४५ मानव जातिको पुर्खा बाँदर हो भनेर भन्ने बैज्ञानिक को हुन ?
- चार्ल्स डार्विन
४६ क्षयरोग विरुद्दको खोपको आविष्कार कसले गरेका हुन ?
- लुई पाश्चर
४७ ध्वानिको तिब्रता कुन एकाईमा नापिन्छ ?
- डेसिबल
४८ बालुवा कुन कुन तत्व मिलेर बनेको हुन्छ ?
- सिलिकन र अक्सिजन
४९ आधुनिक भौतिक शास्त्रका पिता कसलाई भनिन्छ?
- सर आईज्याक न्युटन
५० कृतिम ताप प्रदान गरि अण्डा कोरेलर चल्ला निकाल्ने यन्त्रलाई के भनिन्छ ?
- इक्युटेर
५१ परमाणुको उर्जा उत्पादन गर्ने गतिलाई तिब्र पार्ने यन्त्रलाई के भनिन्छ ?
- साईक्लोट्रोन
५२ विश्वमा पहिलो बोल्ने रोवर्ट अन्तरिक्षयात्रीलाई के भनिन्छ ?
- किरोबो
५३ विश्वमा तिब्र गतिको इन्टरनेट सेवा कुन देशमा रहेको छ ?
- दक्षिण कोरिया
५४ सर आईज्याक न्युटनको जन्म कहिले भएको थियो ?
- सन १६४२ डिसेम्बर २५
५५ ब्रेल लिपिका आविष्कार को हुन ?
- लुइस ब्रेल
५६ सवैभन्दा हल्का धातु कुन हो ?
- लिथियम
५७ टर्पिडो के हो र कहाँ प्रयोग गरिन्छ ?
- लडाँईमा प्रयोग गरिने हतियार र समुन्द्री लडाँईमा प्रयोग गरिन्छ
५८ डिजेल इन्जिनका आविष्कार को हुन ?
- रुडोल्फ डिजेल
५९ फायर एक्सटिग्विसर यन्त्र के को लागी प्रयोग गरिन्छ ?
- आगो निभाउने यन्त्र
६० ब्लायक बक्सले के पत्ता लगाउन सहयोग गर्दछ ?
- हवाईजहाज दुर्घटना बारे
६१ विकिरणबाट उद्दिप्त गरि उत्सर्जन क्रीयाद्वारा हुने प्रकाशको पर्वर्द्दन लाई LASER हो । अब भन्नुहोस यसको पुरा रुप के होला ?
-Light Amplification Stimulated Emission of Radiation
६२ हावामा अक्सिजनको मात्रा कति हुन्छ ?
-२१ %
६३ बर्षा नाप्ने कामको प्रयोग हुने यन्त्रको नाम के हो ?
- रेन गज
६४ बाघ गणनामा प्रयोग हुने आधुनिक वैज्ञानिक पद्दतिको नाम के हो ?
- Camera Trapping
६५ विश्वको पहिलो महिला अन्तरिक्ष यात्री को हुन ?
- भ्यालेन्टिना तेरेस्कोभा(रुस)
जैविक प्रविधी
------------
६६ जैविक प्रविधी शब्द सर्वप्रथम कहिले प्रयोग भयो ?
- सन १९१९ मा
६७ कुनै पनि जिवित वस्तुलाई कच्चा पदार्थको रुपमा प्रयोग गरि त्यसको जैव रासयनिक संश्लेशण र विभाजनपबाट निस्कने पदार्थलाई मानिस वा पर्यावरणको उपयोगिताको लागी प्रयोग गरिने प्रविधिलाई के भनिन्छ ?
- जैविक प्रविधी
६८ कुनै प्राणी जस्तै सतप्रतिशत जीन संरचना भएको प्राणिको उत्पादन गर्ने प्रविधिलाई के भनिन्छ ?
-क्लोनिङ
६९ जैविक प्रविधिका शाखाहरु:-
® बायो इन्फरमेटिक्स:- जैविक समस्यालाई कम्प्युटरबाट समाधान
® ब्लु जैविक प्रविधी :- सामुन्द्रीक एवं जलिय गतिविधिसँग
® ग्रीन जैविक प्रविधी :- परम्परागत औधिगिक कृषी पद्दती
® रेड जैविक प्रविधी :- जेनेटिक इञ्जिनियरिङ्को चिकित्सा
® ह्वाइट जैविक प्रविधी :- विविध औधोगिक प्रयोजनमा
७० DNA प्रविधिको सुरुवात कहिले देखी भएको हो ?
- सन १९७३
सुचना तथा सञ्चार प्रविधी
--------------------
७१ कम्प्युटर , सुक्ष्म विद्युतिय यन्त्र र दुरसञ्चारको एकिकृत प्रविधिलाई के भनिन्छ ?
- सूचना प्रविधी
७२ नेपालमा सर्वप्रथम सुचना प्रविधी निति कहिले आएको हो ?
- वि•सं• २०५७
७३ ई-मेलको सुरुवात सर्वप्रथम कहिले भएको हो ?
- सन १९७६
७४ नेपालमा सर्वप्रथम टेलिफोनको सुरुवात कहिले भएको हो ?
-वि•सं• १९७०
७५ अप्टिकल फाइवर के सँग सम्बन्धित रहेको छ ?
- दूरसञ्चार र भु-उपग्रह
७६ सूचना प्रविधी विकास परिषदको अध्यक्ष को हुने व्यवस्था रहेको छ ?
- प्रधानमन्त्री
७७ सूचना तथा सञ्चार प्रविधिको सेवा तथा साधनश्रोतमा पहुँच भएका र नभएका समुहबिचको अन्तरलाई के भनिन्छ ?
- डिजिटल विभेद
७८ नेपालमा प्रयोग भएको पहिलो कम्प्युटर कुन हो ?
- IBM-1401 (वि•सं• २०२८)
७९ सूचना तथा समाज निर्माणका लागी पहिलो विश्व सम्मेलन कहिले र कहाँ सम्पन्न भयो ?
- सन २००३ डिसेम्बर १०-१२ ( जेनेभा)
८० इन्टरनेट सम्बन्धी अपराध नियन्त्रण सम्बन्धमा कुन कानुनमा ब्यबस्थ गरिएको छ ?
- विद्युतिय कारोबात ऐन , २०६३
वैकल्पिक उर्जा
-------------
८१ विश्वमा वैकल्पिक उर्जा प्रयोगतर्फ कहिले देखी ध्यानाकर्षण भयो ?
- सन १९७०
८२ नेपालका कति जिल्लामा गोबर ग्याँस प्लान्ट सफल भएको छ ?
- ६८ जिल्ला
८३ नेपालको सोर्य उर्जा उत्पादन क्षमता कति रहेको छ ?
- २•५ करोड मेगा वाट
८४ नेपालको कुन ठाँउमा वायु उर्जाको प्रयोगबाट बिजुली निकालिएको छ ?
- कागबेनी, मुस्ताङ
८५ सूर्यमुखी फूल कुन तत्वका कारण सूर्यतिर फर्किन्छ ?
- अक्सिन
८६ कुन विरुवाको तेलबाट गाडी चलाउने इन्धन बन्छ ?
- सजिवन
८७ नेपालको जिरो इनर्जी हाउस कहाँ छ ?
- पुल्चोक
क्रम विकास र वंशाणु
--------
८८ कोषहरुको न्युक्लियसभित्र क्रोमोजममस हुने रासायनिक पदार्थ जसले बाबुआमाको गुणहरु सन्तानहरुमा प्रसारण गर्ने प्रक्रीयालाई के भनिन्छ ?
- वंशाणु
८९ पुरना जिवबाट नया जिब उत्पन्न हुने प्रक्रीयालाई के भनिन्छ ?
-क्रमविकास
९० मानब रुप लिन प्रयत्नशिल सबैभन्दा प्राचिन जिव कुन हो ?
- रामापिथेकस
९१ पहिको बंशमा देखिने गुणलाई प्रबल भनिन्छ भने पहिलो वंशमा दविएर रहने गुणलाई के भनिन्छ ?
- लुप्त गुण
९२ जेनेटिक्सका पिता भनेर कसलाई चिनिन्छ ?
- ग्रेगर जोन मेण्डल
९३ प्रबल र लुप्त गुणहरु बोक्ने जिनलाई के भनिन्छ ?
- ठिमाहा जिन
९४ आकार र उत्पत्ती एवं आन्तरिक संरचना समान तर बेग्लाबेग्लै काम गर्ने अंगलाई के भनिन्छ ?
- सजातिय अंग
९५ मानिसमा कति जोडा क्रोमोजम हुन्छ ?
-२३ जोडा
९६ पैतृक गुणको आधारमा जिवहरुमा देखापर्ने विभिन्नतालाई के भनिन्छ ?
-वंशाणुगत परिवृत्ती
स्वास्थ्य र रोग
-------------
९७ लामो समय बाँच्नुका अतिरिक्त रोगव्याधी तथा दुर्वलताबाट मुक्त भइ असल स्वास्थ्य प्राप्तिको लागी बढी जोड दिनुलाई स्वास्थ्य भनिन्छ ।
९८ नेपालको स्वास्थ्य सेवा कुन प्रकृतिको छ ?
- प्राथमिक स्वास्थ्य प्रकृतिको
९९ भिटामिन ´ए` को रासयनिक नाम के हो ?
- रेटिनोल
१०० मानिशको शरिरमा भएको कुन रक्त समुहलाई Universal Donor भनिन्छ ?
-O+ ve
१०१ ECG को पुरा रुप के हो ?
-Electro-Cardiogram
१०२ कुन भिटामिनको कमिले रगत धेरै बग्दछ ?
- भिटामिन-के
१०३ वातवरण संग मानव शरिरको असुन्तलित समायोजन लाई के भनिन्छ ?
- रोग
१०४ समुदायमा एक्कासी ठुलो संख्यमा देखापर्ने एकै प्रकारको रोगलाई के भनिन्छ ?
- महामारी
१०५ नेपाल रेडक्रस सोसाईटिको स्थापना कहिले भएको हो ?
- वि •सं• २०२० भाद्र १९
१०६ क्षयरोग कसले पत्ता लगाएका हुन ?
- रवर्ट कोचले
१०७ टाईफाईड कुन जिवाणुको कारण हुने गर्दछ ?
- साल्मोनेला टाईफी
१०८ क्यान्सरलाई नेपालिमा के भनिन्छ ?
- अर्बुद रोग
१०९ रक्तचाप माथिल्लो १६० मि•मि• भन्दा बढी हुनुलाई के भनिन्छ ?
- सिस्टोलिक
११० रक्तचाप तल्लो ९५ मि•मि• भन्दा बढी हुनुलाई के भनिन्छ ?
- डायस्टोलिक
१११ हेपाटाईटिस बि ले शरिरको कुन अङ्गलाई असर गर्दछ ?
- कलेजो
अन्य थप जानकारिहरु
---------
११२ फ्याटी एसिडबाट बनेको सोडिय्म वा पोटासियम लवणलाई के भनिन्छ ?
-साबुन
११३ लुगा धुने सोडालाई सोडियम कार्वोनेट भनिन्छ भने खाने सोडालाई के भनिन्छ ?
- सोडियम वाई कार्वोनेट
११४ सामन्यतया प्लास्टिक कति प्रकारका हुन्छन ?
-२
११५ प्रोटिन, स्टार्च, रबर के-का उदाहारणहरु हुन ?
- प्राकृतिक पोलिमर
११६ स्वास्थ्य क्षेत्रमा बहुप्रचलित शब्द MRI को पुरा रुप के हो ?
-Magnetic Resonance Imaging
११७ सबैभन्दा बढी रोग सार्ने जिव कुन हो ?
- झिंगा
११८ ई-मेल प्राप्त गर्ने र पठाउने सफ्टवेयरलाई के भनिन्छ ?
- ब्राउजर
११९ WiMax को पुरा रुप के हो ?
-Worldwide Interoperability for Microwave Access
१२० खुर्सानिमा कुन भिटामिन पाइन्छ ?
- भिटामिन-सी
१२१ क्यान्सर नलाग्ने मानव शरिरको एकमात्र अङ्ग कुन हो ?
- आँखाको नानी
१२२ विभिन्न जैविक पदार्थ कुहिएर बनेको मललाई के भनिन्छ ?
- जैविक मल
१२३ धागो , डोरि लहरा आकारको बस्तुलाई के भनिन्छ ?
-रेसा
१२४ माटोको उर्वराशक्ती बढाउन प्रयोग गरिने पदार्थलाई के भनिन्छ ?
- मल
१२५ काँच बनाउन सिलिकासँग सोडियम कार्बोनेट र क्याल्सियम कार्बोनेट मिसाईन्छ ।

कम्प्युटर सम्बन्धी केही साधारण Tips & Tricks हरु

कम्प्युटर सम्बन्धी केही साधारण Tips & Tricks हरु:-

१ माउसको काम कि बोर्डले गर्नुहोस्
यदि कुनै बेला तपाईंको माउसले काम गरेन भने के गर्नु हुन्छ ? तपाईंहरुलाई थाहा छ माउसको काम कि-बोर्डले पनि गर्न सकिन्छ ? त्यसको लागि Shift+Alt+NumLock कि थिच्नुस् र र ok गर्नुहोस् । अब तपाईंले माउसको काम Number key हरुबाट गर्न सक्नु हुन्छ ।

२ कम्प्युटरको password बिर्सनु भयो भने यदि तपाईंले आफ्नो कम्प्युटरको password बिर्सिनु भयो भने यो step प्रयोग गरेर आफ्नो कम्प्युटर खोल्न सक्नु हुन्छ कम्प्युटर on गर्नुस् password Enter गर्ने ठाउँ देख् नु हुनेछ
अब Ctrl+Alt+Delete कि थिच्नुस् । username लाई Change गरेर administrator राखिदिनुस् र ok गर्नुस् ।

३ कम्प्युटरलाई छिटो ShuttDown गर्ने तरिका
सबै भन्दा पहिला Ctrl+Alt+Delete थिच्नुस् Task Manager खुल्नेछ
ShuttDown Tab मा क्लिक गर्नुस्
Ctrl कि लाई press गरेरै Turn Off मा क्लिक गर्नुस्

४ आफ्नो कम्प्युटरको सम्पूर्ण जानकारी
यदि तपाईंलाई आफ्नो कम्प्युटर बारे सम्पूर्ण जानकारी थाहा छैन र त्यो जान्न चाहनु हुन्छ भने, Start > Run मा क्लिक गर्नुस् र त्यहा Command टाईप गर्नुस् Command पेज खुल्नेछ अब त्यहा systeminfo टाईप गरेर Enter गर्नुस् । अब तपाईंले आफ्नो कम्प्युटरको सम्पूर्ण Details हेर्न सक्नुहुनेछ ।

५ आफ्नो कम्प्युटरलाई Fast गराइराख् न चाहनु हुन्छ भने,
यदि तपाईंको कम्प्युटर Slow चल्छ र यसलाई Fast गराउन चाहनु हुन्छ भने यि कुराहरुलाई याद राख्नुस्
आफ्नो कम्प्युटरको C Drive मा धेरै फाइलहरु Save नगर्नुहोस् र सके सम्म C Drive को क्षमता 50% Free
नै होस् ।
Desktop मा धेरै फाइलहरु राख् ने नगर्नुस् यसले तपाईंको कम्प्युटरको Ram त्यसमा Use भई राखेको हुन्छ र कम्प्युटर slow चल्छ ।
कम्प्युटरमा काम सकिसकेपछि ShutDown गरेर मात्र off गर्ने गर्नुस ।

६ कम्प्युटरको Virtual Memory बढाउने तरिका
तपाईंको कम्प्युटरको Virtual Memory कम भएर पनि कम्प्युटर slow चलेको हुन सक्छ , तपाईंले Virtual
Memory लाई बढाउन सक्नु हुन्छ My computer Icon लाई Right क्लिक गर्नुस् र properties मा जानुस् Advance Tab मा क्लिक गर्नुस्
Performance को Settings मा क्लिक गर्नुस्
त्यस भित्रको Advance Tab मा क्लिक गर्नुस्
Virtual Memory को change icon मा क्लिक गर्नुस्
र Virtual Memory reset गर्नुस्
कम्प्युटरलाई restart गर्नुस्

७ Network Connection को full Detial को लागि Start > Run र त्यहा ncpa.cpl टाईप र Enter गर्नुस् तपाईंको कम्प्युटरमा भएको Network connection हरुको पेज खुल्नेछ ।

८ कम्प्युटरको System properties हेर्नको लागि
shortcut key
Windows कि + Pause/Break कि थिच्नुस्

९ MsWord को फाइललाई password ले लक गर्न
चाहनु हुन्छ भने,
यदि तपाईं MsWord मा टाईप गरेको documant लाई अरुले नहेरोस भन्ने चाहनु हुन्छ भने त्यसलाई आफ्नो password राखी लक गर्न सक्नु हुन्छ , त्यसको लागि MSWord को Tool बारको Tools मा क्लिक र Option मा क्लिक गर्नुस्
अब Security मा क्लिक गर्नुस् र Password to open भन्ने box मा आफुले चाहेको password राख्नुस् > ok > password लाई conform गर्नुस् र ok अब तपाईंले आफ्नो document लाई save गरिदिनुस् ।

सामान्य ज्ञान प्रश्नोत्तरः कम्प्यूटरः

सामान्य ज्ञान प्रश्नोत्तरः कम्प्यूटरः

१. कम्प्यूटरलाई नेपालीमा के भनिन्छ ??
— सुसांख्य
२. कम्प्यूटरको पिता कसलाई मानिन्छ ??
— चार्ल्स बेबेज
३. विश्वको प्रथम इलेक्ट्रोनिक डिजिटल कम्प्यूटर कुन हो ??
— एनीयक
४. नेपालमा पहिलो कम्प्युटर कुन र कहिले भित्रिएको हो ??
— IBM 1401 र वि.सं.२०२८
५. इन्टीग्रेटेड सर्किट (IC) को पिता को हुन् ??
— ज्याक एस. किलबी
६. कम्प्यूटरमा प्रयोग हुने ‘IC चिप्स’ केले बनेको हुन्छ ??
— सिलिकन
७. सी. पी. यू. को पूरा रुप के हो ??
— सेन्ट्रल प्रोसेसिङ् यूनिट
८. कम्प्यूटर कम्पनी IBM को पूरा रुप के हो ??
— इन्टरनेशनल बिजनेस मेशीन
९. नेपालमा सर्वप्रथम केको लागि कम्प्युटर ल्याइएको थियो ??
— जनगणना
१०. लभ बग के हो ?
— कम्प्यूटर भाइरस
११. कम्प्यूटर व्यवसायको शिखर पुरुष बिल गेट्सको नाम कुन कम्पनी सँग सम्बन्धित छ ??
— माइक्रोसफ्ट
१२. NASSCOM को फुल फर्म के हो ??
— नेशनल एसोसिएशन अफ सफ्टवेयर एण्ड सर्विसेज कम्पनीज
१३. विश्वको प्रथम भर्चुअल समाचार वाचिका को हुन् ??
— एनानोवा
१४. कमजोर मानिसहरुको लागि विशेष रूपमा बनाएको कम्प्यूटर कुन हो ??
— अल राइट
१५. विश्वको सबभन्दा कम उमेरको वेब डिजाइनर को हुन् ??
— अजयपुरी
१६. विश्वको प्रथम महिला कम्प्यूटर प्रोग्रामरको श्रेय कसलाई जान्छ ??
— एडा अगस्टा (अमेरीका)
१७. भारतमा भेटिएको पहिलो कम्प्यूटर भाइरस कुन हो ??
— सी ब्रेन
१८. वाई टू के (Y2K) को समस्याले प्रभावित विश्वको एक मात्र देश कुन हो ??
— जाम्बिया
१९. ‘Y2K’ को विस्तृत रूप के हो ??
— ईयर टू थाउजेन्ड
२०. विश्व कम्प्यूटर साक्षरता दिवस कहिले मनाइन्छ ??
— 2 डिसेम्बर
२१. भारतमा निर्मित पहिलो कम्प्यूटरको नाम के हो ??
— सिद्धार्थ
२२. परम पदम के हो ??
— सुपर कम्प्यूटर

Jul 8, 2017

PSC Exam MCQ Ms-Access question set 1 Solved

PSC MCQ Ms-Access question set 1

1. What Are The Different Views To Display A Table
A) Datasheet View
B) Design View
C) Pivote Table & Pivot Chart View
D) All Of Above
➤ Answer :

2. Which Of The Following Creates A Drop Down List Of Values To Choose From?
A) Ole Object
B) Hyperlink
C) Memo
D) Lookup Wizard
➤ Answer :

3. The Command Center Of Access File That Appears When You Create Or Open The Ms Access Database File.
A) Database Window
B) Query Window
C) Design View Window
D) Switchboard
➤ Answer :

4. The Third Stage In Designing A Database Is When We Analyze Our Tables More Closely And Create A ___________ Between Tables
A) Relationship
B) Join
C) Query
D) None Of These
➤ Answer :

5. In A Database Table, The Category Of Information Is Called __________
A) Tuple
B) Field
C) Record
D) All Of Above
➤ Answer :

6. This Key Uniquely Identifies Each Record
A) Primary Key
B) Key Record
C) Unique Key
D) Field Name
➤ Answer :

7. It Is An Association Established Between Common
A) Line
B) Relationship
C) Primary Key
D) Records
➤ Answer :

8. This Is The Stage In Database Design Where One Gathers And List All The Necessary Fields For The Database Project.
A) Data Definition
B) Data Refinement
C) Establishing Relationship
D) None Of The Above
➤ Answer :

9. A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________
A) DCL
B) DML
C) DDL
D) All Of Above
➤ Answer :

10. Which Of The Field Has Width 8 Bytes?
A) Memo
B) Number
C) Date/time
D) Hyperlink
➤ Answer :

11. Which Of The Following Statement Is True?
A) Foreign Key Fields Don\'t Allow Duplicate Values
B) In Primary Key Field You Can Enter Duplicate Value
C) In An Indexed Field You May Or May Not Enter Duplicate Value Depending Upon Setting
D) All Statements Are True
➤ Answer :

12. Following Is Not A Database Model
A) Network Database Model
B) Relational Database Model
C) Object Oriented Database Model
D) None
➤ Answer :

13. Microsoft Access Is A
A) RDBMS
B) OODBMS
C) ORDBMS
D) Network Database Model
➤ Answer :

14. DCL Provides Commands To Perform Actions Like
A) Change The Structure Of Tables
B) Insert, Update Or Delete Records And Data Values
C) Authorizing Access And Other Control Over Database
D) None Of Above
➤ Answer :

15. The Database Language That Allows You To Access Or Maintain Data In A Database
A) DCL
B) DML
C) DDL
D) None Of Above
➤ Answer :

16. What Is The Maximum Length A Text Field Can Be?
A) 120
B) 255
C) 265
D) 75
➤ Answer :

17. Which Of The Following Is Not A Database Object?
A) Tables
B) Queries
C) Relationships
D) Reports
➤ Answer :

18. A __________ Enables You To View Data From A Table Based On A Specific Criterion
A) Form
B) Query
C) Macro
D) Report
➤ Answer :

19. What Are The Columns In A Microsoft Access Table Called?
A) Rows
B) Records
C) Fields
D) Columns
➤ Answer :

20. Which Of The Following Is Not A Type Of Microsoft Access Database Object?
A) Table
B) Form
C) Worksheets
D) Modules
➤ Answer :

Jul 7, 2017

PSC Exam Questions Ms-Excel MCQ Set 1 Solved

PSC Exam Questions Ms-Excel MCQ Set 1

1. Which of the following term describes explanatory text attached to a cell?
A. Context     B. Callout     C. Comment     D. Dialog     E. None of these
➤ Answer:
2. Which of the following function displays row data in a column or column data in a row?
A. Hyperlink     B. Index C.     Transpose     D. Sum         E. None of these
➤ Answer:
3. Macros can be executed from the ____ menu.
A. Insert     B. Tools     C. Edit         D. Data         E. None of these
➤ Answer:
4. A function inside another function is called a _____ function.
A. Nested     B. Round     C. Sum         D. Text         E. None of these
➤ Answer:
5. Which of the following function is used to enter current time in a worksheet cell?
A. =today()     B. =now()     C. =time()     D. =currentTime()     E. None of these
➤ Answer:
6. Which of the following is the keyboard shortcut for creating a chart from the selected cells?
A. F3         B. F5         C. F7         D. F12         E. F11
➤ Answer:
7. Which of the following keyboard shortcut is used to edit existing Excel data?
A. F2         B. F3         C. F1         D. F4         E. F5
➤ Answer:
8. A value used in a formula that does not change is called a _______
A. Static     B. Cell         C. Variable     D. Constant     E. Dynamic
➤ Answer:
9. Which of the following is used to convert existing Excel worksheet data and charts to HTML document?
A. External Wizard
B. Intranet Wizard
C. Import Wizard
D. Export Wizard
E. Internet Assistant Wizard
➤ Answer:
10. Which of the following term refers to a set of values that Excel saves and can substitute automatically on your worksheet?
A. Range     B. Scenario     C. Nested     D. What-if analysis     E. None of these
➤ Answer:
11. In Excel, a typical worksheet has _____ number of columns.
A. 12,384     B. 15,684     C. 16,384        D. 13,484    E. None of these
➤ Answer:
12. In Excel, a typical worksheet has _____ number of rows.
A. 1,048,576    B. 1,015,684    C. 1,016,384    D. 1,013,484    E. None of these
➤ Answer:
13. Which of the following symbol is used before a number to make it a label?
A. ” (quote)     B. = (equal)     C. _ (underscore)     D. ‘ (apostrophe)     E. None of these
➤ Answer:
14. In Excel, a typical worksheet has _______ column width
A. 250 Characters
B. 512 Characters
C. 255 Characters
D. 612 Characters
E. None of these
➤ Answer:
15. Which of the following is the maximum limit of the height of a row in an Excel Sheet?
A. 209 points     B. 309 points     C. 509 points     D. 409 points     E. None of these
➤ Answer:
16. What is the maximum number of line feeds per cell in an Excel Sheet?
A. 253         B. 250         C. 257         D. 212         E. 211
➤ Answer:
17. What is the maximum limit of characters in a header or footer in an Excel Sheet?
A. 253         B. 255         C. 257         D. 212         E. 211
➤ Answer:
18. What is the minimum Zoom range in an Excel Sheet?
A. 8%         B. 10%         C. 12%         D. 20%         E. None of these
➤ Answer:
19. What is the maximum Zoom range in an Excel Sheet?
A. 100%     B. 200%     C. 300%     D. 400%     E. None of these
➤ Answer:
20. What is the maximum limit of available worksheet functions?
A. 141         B. 231         C. 341         D. 421         E. None of these
➤ Answer:

Jul 2, 2017

NOC Senior Computer Assistant Exam 2073 - Solved

Nepal Oil Corporation Limited, Technical/Miscellaneous,

Senior Computer Assistant (5th Level)

Competitive Written Examination Date: 2073-07-28
Time: 2 hr 30 mins Full Marks: 100

Section “A”: Multiple Choice 25 x 2 = 50

1. Objects on the slide that hold text are called
a) Placeholders
b) Object holders
c) Auto layout
d) Text holder
➤ Answer:
2. Which of the following should be used when you want to add a slide to an existing presentation?
a) File, add a new slide
b) Insert, New Slide
c) File Open
d) File New
➤ Answer:
3. The PowerPoint view that displays only text (title and bullets) is
a) Slide show
b) Slide sorter view
c) Notes page view
d) Outline view
➤ Answer:
4. …….. value change the color of text into red.
a) FF0000
b) 00FF00
c) 0000FF
d) None of the above
➤ Answer:
5. Which HTML tag produces the biggest heading?
a) <h7>
b) <h9>
c) <h4>
d) <h1>
➤ Answer:
6. The ALU of a computer normally contains a number of high speed storage element called
a) Semiconductor memory
b) Registers
c. Hard disks
d) Magnetic disk
➤ Answer:
7. Communication between a computer and a keyboard involves _______ transmission.
a) Automatic
b) Half-duplex
c) Full-duplex
d) Simplex
➤ Answer:
8. DNS database contains
a) name server records
b) hostname-to-address records
c. hostname aliases
d) all of the above
➤ Answer:
9. _______ command is used to create a file
a) Create
b) Create con
c) Copy
d) Copy Con
➤ Answer:
10. Which of the following class uses 8 bits for network and 24 bits for hosts of the IP address?
a) Class A
b) Class B
c) Class C
d) Class D
➤ Answer:
11. Which of the following memories need refreshing?
a) SRAM
b) DRAM
c) ROM
d) All of the above
➤ Answer:
12. Pressing the combination of _______ keys is called warm booting
a) Ctrl+Alt+Del
b) Ctrl+Shift+Del
c) Ctrl+Tab+Del
d) Ctrl+Caps+Del
➤ Answer:
13. _______ combination of keys are used for column break.
a) Ctrl+Shift+Enter
b) Ctrl+Alt+Del
c) Ctrl+Shift+Home
d) None of the above
➤ Answer:
14. Which of the following is not of the merge process?
a) Sort the data records
b) Format a main document
c. Edit a data source
d) Merge the two files to print or create new document
➤ Answer:
15. In Microsoft Word the key F12 opens a
a) Open dialog box
b) Save as dialog box
c) Save dialog box
d) Close dialog box
➤ Answer:
16. To print current page of a document only
a) Press Ctrl+P and select current page
b. Click MS Office button >> Print >> Print Preview >> Print and select current page
c. Click MS Office button >> Print >> Quick Print
d. Both A and B
➤ Answer:
17. The A4 default paper size of width/height is
a) 8.17”/11.59”
b) 8.27”/11.69”
c) 8.3”/11.79”
d) None of above
➤ Answer:
18. The formula in cell B5 is =A4+C3. This is copied to the cell D8. What will be the formula in D8?
a) A4+C3
b) C7+E6
c) C4+E3
d) E7+C5
➤ Answer:
19. Which of the following is correct syntax in Excel?
a) =IF(LogicalText, TrueResult, FalseResult)
b. =IF(LogicalTest, (TrueResult, FalseResult))
c. =IF(LogicalTest, TrueResult)(LogicalTest, FalseResult))
d. =IF(LogicalTest, TrueResult, IF(LogicalTest, FalseResult))
➤ Answer:
20. Which is an example of a function?
a) Add(A1:A2)
b) =A1+A
c) =Sum(A1:A2)
d) A1+A2

21. To start data on a new line within a cell, enter a line break by pressing
a) Alt+Enter
b) Shift+Enter
c) Ctrl+Enter
d) None of the above
➤ Answer:
22. A form can be used as a
a) Data entry
b) Switchboard
c) Custom dialog box
d) All of the above
➤ Answer:
23. _______ is the default field size of auto number
a) Short Integer
b) Long Integer
c) Float
d) Double
➤ Answer:
24. …. Uniquely identifies each record
a) Primary key
b) key record
c) Unique key
d) Field name
➤ Answer:
25. Function key …. is used to display the Slides show
a) F4
b) F5
c) F6
d) F7
➤ Answer:

PSC Assistant Computer Operator Exam 2073 - Solved

राजपत्र अनंकित द्वितीय श्रेणी विविध सेवा, सहायक कम्प्युटर अपरेटर वा साे सरह पदकाे प्रतियाेगितात्मक लिखित परीक्षा २०७३

Solved Question Paper of PSC Assistant Computer Operator Exam Date: 2073-02-32
Time: 45 minutes FM: 50 Objective Questions (50 x 1 = 50 marks)

1. Which command is used to display all the files having (.exe) extension but the different file name?
A) dir *.exe
B) dir filename.*
C) dir filename.ext
D) dir *.sys
➤ Answer:
2. CHKDSK command is used to:
A) Report the status of files on disk
B) Analyze the hard disk error
C) Diagnose the hard disk error
D) all of the above.
➤ Answer:
3. Which command is used to change the file name?
A) ren
B) rename
C) both of above
D) none of above
➤ Answer:
4. Which among the following are the best tools for fixing errors on disk?
A) Fixdsk
B) Fdisk
C) Scandisk
D) Chkdsk
➤ Answer:
5. The key F12 opens a:
A) close dialog box
B) save as dialog box
C) open dialog box
D) save dialog box
➤ Answer:
6. Which file starts MS Word?
A) word2003.exe
B) word.exe
C) winword.exe
D) msword.exe
➤ Answer:
7. To invoke help in MS window one has to use:
A) F4
B) F1
C) F2
D) F3
➤ Answer:
8. Key combination used for UNDO in MS word is:
A) Ctrl+U
B) Ctrl+Z
C) Ctrl+Y
D) Ctrl+V
➤ Answer:
9. Which of the following is not a valid view type in MS-word?
A) Print layout
B) Web layout
C) Outline layout
D) Inline layout
➤ Answer:
10. What is the short cut to justify text to center?
A) Ctrl+E
B) Ctrl+S
C) Ctrl+L
D) Ctrl+C
➤ Answer:
11. Which of the following is an example for automatic text formatting?
A) replacing two -‘s with an hyphen
B) underlining hyperlink
C) adjusting extra space
D) all of the above
➤ Answer:
12. Feature that enables several people to work to create and update a document:
A) document protection
B) document sharing
C) document locking
D) document collaboration
➤ Answer:
13. If you want to keep track of different editions of a document which features will you use?
A) Track change
B) Editions
C) Versions
D) All of above
➤ Answer:
14. To underline selected text in one can use:
A) tab+U
B) alt+U
C) ctrl+U
D) shift+U
➤ Answer:
15. What is a portion of a document in which you set certain page formatting options as default?
A) page setup
B) page
C) document
D) section
➤ Answer:
16. Which of the following is not a type of page margin?
A) top
B) left
C) right
D) center
➤ Answer:
17. You can break the column by:
A) pressing alt+enter
B) pressing ctrl+shift+enter
C) pressing ctrl+enter
D) pressing shift+enter
➤ Answer:
18. A feature of MS Word that saves the document automatically after certain interval is available on:
A) pressing ctrl+s
B) save tab on options dialog box
C) save as dialog box
D) none of above
➤ Answer:
19. Excel uniquely identifies cells within a worksheet with a cell name which is a:
A) Number
B) cell names
C) column numbers and row letters
D) Column letters and row numbers
➤ Answer:
20. Which symbol must all formula begin with?
A) @
B) =
C) +
D) (
➤ Answer:
21. Getting data from cell located in a different sheet is called
A) Functioning
B) Accessing
C) Referencing
D) Updating
➤ Answer:
22. To auto fit the width of column:
A) Double click the column header
B) Double click the right border of column
C) Double click the left border of column
D) all of above
➤ Answer:
23. A circular reference is:
A) A formula that either directly or indirectly depends on itself
B) Geometric modeling tool
C) A cell that points to a drawing object
D) Always erroneous
➤ Answer:
24. To add the number of cell A2 and A9:
A) =sum(A2,A9)
B) = add(A2:A9)
C) =sum(A2 and A9)
D) =sum(A2 to A9)
➤ Answer:
25. Absolute reference to cell A3 is expressed as:
A) @A$3
B) @A3
C) A$3
D) $A$3
➤ Answer:
26. You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
A) column chart
B) pie chart
C) row chart
D) line chart
➤ Answer:
27. MS-Excel files have a default extension of:
A) .xsl
B) .xls
C) .doc
D) .xlw
➤ Answer:
28. Which of the following formulas is not entered correctly?
A) 10+50
B) =10+50
C) =B7*B1
D) =B7+14
➤ Answer:
29. If you press………. , the cell accepts your typing as its contents.
A) insert
B) enter
C) ctrl+enter
D) tab
➤ Answer:
30. You can print:
A) a single worksheet
B) a range of cell by range name
C) an entire worksheet
D) all of the above
➤ Answer:
31. …….. is a collection of data stored in a standardized format, designed to be shared by multiple users.
A) relation
B) database
C) record
D) database management system.
➤ Answer:
32. The sql query: SELECT * FROM employee
A) displays structure of employee table
B) displays all field names from employee table
C) displays all records from employee table
D) all of the above
➤ Answer:
33. A field or group of fields that uniquely identifies every row of a table is …..
A) access key
B) primary key
C) foreign key
D) hot key
➤ Answer:
34. Which of the following should you use if you want all the slide in the presentation to have the same “look”?
A) a presentation design template
B) tie slide layout option
C) add a slide option
D) outline view
➤ Answer:
35. Which file format can be added to a Power Point show?
A) .wav
B) .jpg
C) .gif
D) all of the above
➤ Answer:
36. IBM 1401 was brought to prepare the census report of …..
A) 2048 BS
B) 2018 BS
C) 2028 BS
D) 2038 BS
➤ Answer:
37. Transistor is related to ……… generation computers.
A) fifth
B) second
C) third
D) fourth
➤ Answer:
38. Which of the following is the type of computer on the basis of size?
A) hybrid
B) analog
C) micro
D) digital
➤ Answer:
39. Component of computer system
A) Processing unit
B) input unit
C) output unit
D) all of the above
➤ Answer:
40. Which of the following storage is fastest?
A) blue-ray disc
B) RAM
C) ROM
D) Register
➤ Answer:
41. Unicode standard is
A) keyboard layout
B) software
C) font
D) character encoding system
➤ Answer:
42. If any person publishes illegal materials in electronic form, he shall be liable to the punishment with:
A) fine not exceeding two thousand rupees and with imprisonment not exceeding five years or with both
B) fine not exceeding one hundred thousand rupees or with the imprisonment not exceeding five years or with both
C) fine not exceeding two thousand rupees and with imprisonment not exceeding three years
D) fine not exceeding two thousand rupees or with imprisonment not exceeding three years or with both
➤ Answer:
43. Program developed according to the requirement specific to an office is …..
A) packaged software
B) tailored software
C) utility software
D) all of the above
➤ Answer:
44. C Language was developed by …..
A) Steve Jobs
B) Linus Torvalds
C) Bill Gates
D) Dennis Ritche
➤ Answer:
45. Cache memory …..
A) stores data permanently
B) helps to store more data in hard disk
C) placed between main memory and microprocessor,
D) holds last time visited web site only
➤ Answer:
46. GIF images can have only upto ….. colors
A) 1024
B) 128
C) 256
D) 512
➤ Answer:
47. A protocol is- – — –
A) an operating system
B) interconnection pattern of computers
C) set of rules for communication
D) a device for internet
➤ Answer:
48. A dot matrix printer:
A) input device
B) is output device
C) cannot print alphabet
D) cannot print number
➤ Answer:
49. File with which extension is not executable?
A) exe
B) com
C) sys
D) bat
➤ ➤ Answer:
50. The batch file uses the extension:
A) .DOS
B) .BAT
C) .DOC
D) .PRG
➤ Answer:

Jul 1, 2017

PSC Assistant Computer Operator Exam 2072 - Solved

राजपत्र अनंकित द्वितीय श्रेणी विविध सेवा, सहायक कम्प्युटर अपरेटर वा साे सरह पदकाे प्रतियाेगितात्मक लिखित परीक्षा २०७२

Solved Question Paper of PSC Assistant Computer Operator Exam 2072

Exam Date: 2072-03-29 Time: 45 minutes FM: 50 Objective Questions (50 x 1 = 50 marks)

1. What happens when you click on insert >> picture>> clip art?
A. It inserts a clipart picture into document
B. It lets you choose clipart to insert into document
C. It opens clip art task bar
D. None of the above
➤ Answer:
2. In word, the mailing list is known as the ____.
A. Data sheet
B. Source
C. Data source
D. Sheet
➤ Answer:
3. From which menu you can insert header and footer?
A. Insert menu
B. View menu
C. Format menu
D. Tools menu
➤ Answer:
4. Which of the following line spacing is invalid?
A. Single
B. Double
C. Triple
D. Multiple
➤ Answer:
5. Which operation you will perform if you need to move a block of text?
A. Copy and paste
B. Cut and paste
C. Paste and delete
D. Paste and cut
➤ Answer:
6. MS Office provides help in many ways, which of these is one of them?
A. What is this?
B. Office Assistant
C. Help menu
D. All of the above
➤ Answer:
7. Which of the following is NOT available in spread sheet?
A. Statistical Function
B. Mail merge facility
C. What-if analysis
D. Pivot table
➤ Answer:
8. Which of the following is NOT a logical operator?
A. >
B. =
C. +
D. <
➤ Answer:
9. Which of the following is an absolute cell reference?
A. $C$1
B. &C1$
C. ‪#‎C$1
D. ‪#‎C1#
➤ Answer:
10. Getting data from a cell located in a different sheet is called:
A. Accessing
B. Referencing
C. Updating
D. Functioning
➤ Answer:
11. Conditional count can be performed using:
A. Countiff()
B. Countif()
C. Ifcount()
D. Iffcount()
➤ Answer:
12. Multiple calculations can be made in a single formula using:
A. Standard Formula
B. Complex Formula
C. Smart Formula
D. Array Formula
➤ Answer:
13. Chart in worksheet itself is known as:
A. Embedded Chart
B. Implied Chart
C. Inserted Chart
D. Overlapping Chart
➤ Answer:
14. When a formatted number does not fit within a cell, it displays:
A. ####
B. )DIV/0
C. ‪#‎DIV@
D. None of the above
➤ Answer:
15. Red triangle at top right corner of a cell indicates:
A. There is an error in the cell
B. The font color of the text in cell is red
C. There is a comment associated with the cell
D. The cell can’t accept formula
➤ Answer:
16. To select multiple non-adjacent cells in a worksheet you will click them holding:
A. Ctrl key
B. Alt key
C. Shift key
D. Ctrl+Shift key
➤ Answer:
17. Formatting a cell in currency, you can specify:
A. Decimal places
B. Currency Symbol
C. Both of above
D. None of the above
➤ Answer:
18. To insert three columns between columns D and E you would:
A. Select Column D
B. Select Column E
C. Select columns E,F and G
D. Select columns D,E and F
➤ Answer:
19. This key uniquely identifies each record in a table of a database is a:
A. Primary key
B. Key Record
C. Unique key
D. Field name
➤ Answer:
20. What do you mean by one-to-many relationship between student and class table?
A. One student can have many classes
B. One class may have many students
C. Many classes may have many students
D. Many students may have many classes
➤ Answer:
21. Queries in Access can be used as:
A. View, change and analyze data in different ways
B. A source of records for forms and report
C. Only A
D. Both A and B
➤ Answer:
22. Good design determines:
A. Credibility
B. Readability
C. First impression
D. All of the above
➤ Answer:
23. Objects on the slide that hold text are called:
A. Placeholders
B. Object holders
C. Auto layout
D. Text holders
➤ Answer:
24. Drag and drop feature allows you to….
A. Switch from insert to over type mode
B. Move and copy text using the mouse
C. Move and copy text using the clipboard
D. Open a new document and drop it into the active document
➤ Answer:
25. When inserting page number in footer it appeared 1 but you wish to show a how can you do that?
A. From format menu choose bullets and numbering and configure necessary setting
B. From insert menu choose page number and specify necessary setting
C. Click on page number format tool and specify required setting
D. All of the above
➤ Answer:
26. Access method in Hard disk is:
A. Random
B. Serial
C. Sequential
D. All of the above
➤ Answer:
27. Back up of the data files will help to prevent:
A. Loss of confidentiality
B. Duplication of data
C. Virus infection
D. Loss of data
➤ Answer:
28. Which of the following retains the information it’s storing when the power to the system is turned off?
A. CPU
B. ROM
C. DRAM
D. DIMM
➤ Answer:
29. Which of the connector is used to plug a telephone line into a modem?
A. COM1
B. RJ-45
C. RJ-11
D. RJ-10
➤ Answer:
30. ____ has the shortest access times.
A. Cache memory
B. Virtual memory
C. Secondary memory
D. All of the above
➤ Answer:
31. What is BIOS an acronym for?
A. Bootstrap initial operation system
B. Basic input output startup
C. Boot initial operating startup
D. Basic input output system
➤ Answer:
32. What do you call a single point on a computer screen?
A. Cell
B. Element
C. Pixel
D. Bit
➤ Answer:
33. ASCII code of ‘A’ in decimal is:
A. 34
B. 98
C. 95
D. 65
➤ Answer:
34. Computers virus:
A. Can destroy files
B. Can effect installed program
C. Can destroy boot sector
D. All of the above
➤ Answer:
35. The output quality of a printer is generally measured by:
A. Dot per inch
B. Dot per meter
C. Dots printed per unit time
D. All of the above
➤ Answer:
36. Which of the following is the programming language?
A. MS-Word
B. Java
C. Ms-Access
D. VISIO
➤ Answer:
37. RJ-45 UTP cable has ____ cables.
A. 2 pair
B. 3 pair
C. 4 pair
D. 5 pair
➤ Answer:
38. Which one of the following printers is suitable for printing carbon copies?
A. Laser
B. Dot matrix Printer
C. Ink-jet
D. Drum
➤ Answer:
39. A row or number used to identify storage location is called:
A. A byte
B. A record
C. An address
D. All of the above
➤ Answer:
40. Which of the following is a file attribute?
A. Hidden
B. Archive
C. Read only
D. All of the above
➤ Answer:
41. Which of the following is not an operating system?
A. Linux
B. Windows
C. Oracle
D. Dos
➤ Answer:
42. Which of the following is not a component of control panel?
A. Keyboard
B. mouse
C. Monitor
D. Printer
➤ Answer:
43. Short-cut key combination for closing windows is______
A. Ctrl +S
B. Alt + F4
C. Ctrl +V
D. F1
➤ Answer:
44. _____tool helps to reduce file access time from disk.
A. Scandisk
B. Disk Defragmenter
C. Backup
D. Format
➤ Answer:
45. Which of the following is not type of page margin?
A. Left
B. Right
C. Center
D. Top
➤ Answer:
46. Portrait and landscape are:
A. Page Orientation
B. Paper size
C. Page layout
D. All of the above
➤ Answer:
47. Which of the following is not a font style?
A. Bold
B. Italics
C. Regular
D. Superscript
➤ Answer:
48. A bookmark is an item or location in document that you identify as a name for future reference.
A. To add anchor in web page
B. To mark the ending of a paragraph of document
C. To quickly jump to specific location in document
D. To add hyperlinks in webpage
➤ Answer:
49. Thesaurus tool in MS Word is used for:
A. Spelling suggestions
B. Grammar options
C. Synonyms and antonyms words
D. All of the above
➤ Answer:
50. What is the purpose of inserting header and footer in document?
A. To enhance the overall appearance of the document
B. To mark the starting and ending of page
C. To make large document more readable
D. To allow page headers and footers appear on document when printed
➤ Answer:

PSC Computer Operator Exam 2072

राजपत्र अनंकित प्रथम श्रेणी विविध सेवा, कम्प्युटर अपरेटर पदकाे प्रतियाेगितात्मक लिखित परीक्षा २०७२

Solved PSC Computer Operator Exam Date: 2072-03-05

Time: 45 minutes FM: 50 Objective Questions (50 x 1 = 50 marks)

1. Which function will calculate the number of workdays between 6/9/2004 and 8/12/2004 ?
A) Workday    B) Date    C) Networkdays      D) All of the above
➤ Answer:
2. Which button do you click to add up a series of numbers?
A) The autosum button
B) The formula button
C) The quicktotal button
D) The total button
➤ Answer:
3. Which command will you choose to convert a column of data into row?
A) Cut and Paste
B) Edit>Paste Special> Transpose
C) Both of above
D) None of above
➤ Answer:
4. Which of the following is an example of relative cell address?
A) B9    B) D$9    C) $F5    D) $M$2
➤ Answer:
5. …….. is a collection of data stored in a standardized format, designed to be shared bymultiple users.
A) Database
B) Record
C) Database Management System
D) Relation
➤ Answer:

6. The Column of a table is referred to as the …….
A) Tuple    B) Attribute    C) Entity       D) Degree
➤ Answer:
7. A Field or group of fields that uniquely identifies every roe of a table is…….
A) Primary Key       B) Foreign Key       C) Hot Key    D) Access key
➤ Answer:
8. Which is the best file organization when data is frequently added or deleted from a file?
A) Sequential
B) Direct
C) Index sequential
D) None of Above
➤ Answer:
9. …….. operator is used to compare a value to a list of literals values that have been specified.
A) Like       B) Compare       C) Between    D) In
➤ Answer:
10. What is the default extension of PowerPoint Presentation?
A) prn       B) doc       C) docx    D) ppt
➤ Answer:
11. Which key is used to view slide show?
A) F1    B) F2    C) F5       D) F1
➤ Answer:
12. Which file format can be added to a powerpoint show?
A) .jpg    B) .gif    C) .wav    D) All of the above
➤ Answer:
13. Full form of HTML is …..
A) Hypertext Markup Language
B) HoTMail
C) Hyoertext Mail Language
D) All of the Above
➤ Answer:
14. ….. is a standalone tag (i.e. does not have closing tag) .
A) <font>       B) <hr>       C) <b>       D) <table>
➤ Answer:
15. To set the background color we use:
A) <Body text=”Color”>
B) <Body=”color”>
C) <Body bgcolor=”color”>
D) All of the above
➤ Answer:
16. Numbers are stored and transmitted inside a computer in …..
A) Binary form
B) ASCII Code form
C) Decimal form
D) Alphanumeric form
➤ Answer:
17. Each IP packet must contain
A) Only source address
B) Only destination address
C) Source and destination address
D) Source or destination address
➤ Answer:
18. How many bits are there in the Ethernet address?
A) 64 bits    B) 48 bits       C) 32 bits       D) 16 bits
➤ Answer:
19. A central computer surrounded by one of more satellite computers is called a
A) bus network.
B) ring network
C) star network
D) All of the above
➤ Answer:
20. The two types of record access methods are:
A) Sequential and random
B) Sequential and indexed
C) Direct and immediate
D) Online and real time
➤ Answer:
21. The least significant bit of the binary number, which is equivalent to any odd decimal number is:
A) 0    B) 1       C) 1 or 0       D) 3
➤ Answer:
22. Laptop computers use:
A) CRT Display
B) LCD display
C) SSGA displays
D) None of the previous
➤ Answer:
23. A hard copy would be prepared on a
A) Line printer
B) dot matrix printer
C) Typewriter terminal
D) All of the above
➤ Answer:
24. Fifth generation computer is also known as
A) Knowledge information processing system
B) Very large scale integration (VLSI)
C) Both of above
D) None of above
➤ Answer:
25. Reading data is performed in magnetic disk by
A) Read/write heads
B) Sectors
C) Track
D) Lower surface
➤ Answer:
26. Which of the following is not a type of software?
A) System software
B) Application Software
C) Utility Software
D) Entertainment software
➤ Answer:
27. An approach that permits the computer to work on several programs instead of one is
A) On-line thesaurus
B) Multiprogramming
C) Overlapped processing
D) Outline processor
➤ Answer:
28. A Hybrid computer
A) Resembles digital computer
B) Resembles analog computer
C) Resembles both a digital and analog computer
D) None of the above
➤ Answer:
29. The personal computer industry was started by
A) IBM       B) Apple    C) Compaq    D) HCL
➤ Answer:
30. Which is the operating system program?
A) Windows B) Ms-word C) MS-excel D) Ms-PowerPoint
➤ Answer:
31. Format command is used to
A) Prepare a blank disk
B) Create a new blank disk from a used one
C) Both of above
D) None of the above.
➤ Answer:
32. Function of operating system
A) Memory Management
B) Document preparation
C) web page designing
D) All of above
➤ Answer:
33. Full form of MS-DOS is
A) Micro System disk Operating System
B) Micro Simple Disk Operating System
C) Microsoft Disk Operating System
D) Micro Sort Disk Operating System
➤ Answer:
34. In Windows system, if the displayed system time and date system is wrong you can Reset it using
A) Write
B) Calendar
C) Card file
D) Control Panel
➤ Answer:
35. Page formatting which is used frequently in future is saved as ….
A) Master document
B) Theme
C) Cross-reference
D) Template
➤ Answer:
36. Shortcut key for manual column break in ms word .
A) Ctrl + Enter B) Shift + spacebar C) Ctrl + Shift+ Enter D) Alt + Enter
➤ Answer:
37. Ctrl + Shift + D
A) Double Paragraph Spacing
B) Delete Current word
C) Dotted Underline
D) Double Underline
➤ Answer:
38. Which of the following is feature of MS-word?
A) Drag and Drop    B) Text Wrap    C) Find and replace    D) All of the above.
➤ Answer:
39. ….. increases the readability of text
A) Save    B) Bullet and numbering    C) Thesaurus    D) Help
➤ Answer:
40. Which is not the type of indent available in ms-word?
A) Right Indent    B) Left Indent    C) Center Indent       D) Hanging indent
➤ Answer:
41. Page numbering is inserted as……
A) Footnote       B) Endnote    C) Footer    D) none of above
➤ Answer:
42. Leader character is associated with
A) Bullet & numbering    B) Gutter       C) Indent    D) Tab
➤ Answer:
43. Pressing F8 key for three times selects
A) A word    B) A sentence    C) A Paragraph    D) Entire document.
➤ Answer:
44. Which of the following is graphics solution for word processors?
A) Clipart    B) WordArt    C) Drop Cap    D) All of the above
➤ Answer:
45. Which of the following options is not available to remove arrows of formula Auditing?
A) Remove precedent arrows
B) Remove dependent arrows
C) Remove all Arrows
D) Remove all arrows for this cell
➤ Answer:
46. The minimum and maximum value you can set for save Auto Recovery Info in electronic spreadsheet are
A) 1 and 120 minutes
B) 0 and 120 minutes
C) 2 and 60 minutes
D) 1 and 10 minutes
➤ Answer:
47. Formatting a cell in Currency, you can specify
A) Decimal places
B) Currency Symbol
C) Both of above
D) None of above
➤ Answer:
48. What term refers to a specific set of values saved with the workbook?
A) Range    B) Scenario       C) Trend line       D) What-if-analysis
➤ Answer:
49. To insert three columns between columns D and E you would
A) Select column D
B) select column E
C) Select Columns E,F and G.
D) Select columns D, E and F
➤ Answer:
50. You can add an image to a template by clicking the insert picture from file button on the…….. toolbar
A) Standard    B) Formatting       C) Drawing    D) Picture
➤ Answer:

PSC Computer Operator Question 2073 - Solved

लाेक सेवा अायाेग

राजपत्र अनंकित प्रथम श्रेणी कम्प्युटर अपरेटर पदकाे प्रतियाेगितात्मक लिखित परीक्षा २०७३

Solved Question Paper of PSC Computer Operator
Exam Date: 2073-01-29

Time: 45 minutes FM: 50 Objective Questions (50 x 1 = 50 marks)

1) IBM 1401 was brought to prepare the census report of …

a) 2018 BS

b) 2028 BS

c) 2038 BS

d) 2048 BS

Answer :

2) Transistor is related to ….. generation computers

a) Second

b) Third

c) Fourth

d) Fifth
Answer:

3) The ability to recover and read deleted or damaged files from a criminal’s computer is an example of an enforcement specially called

a) Robotics

b) Simulation

c) Computer forensics

d) Animation
Answer:

4) An area of a computer that temporarily holds data waiting to be processed is

a) CPU

b) Memory

c) Storage

d) File
Answer:

5) For reproducing sound, a CD (compact disk) audio player uses a …..

a) Quartz crystal

b) Titanium needle

c) Laser beam

d) Barium Titanium Ceramic
Answer:

6) Unicode Standard is ….

a) Software

b) Font

c) Character encoding system

d) Keyboard layout
Answer:

7) A fault in a computer program which prevents it from working correctly is known as

a) Boot

b) Bug

c) Biff

d) Strap
Answer:

8) Program developed according to the requirement specific to an office is …

a) Tailored software

b) Utility software

c) Packaged software

d) All of above
Answer:

9) The difference between people with access to computers and the internet and those without these access is known as the

a) Digital divide

b) Internet divide

c) Web divide

d) E-Illiteracy
Answer:

10) Cache memory …..

a) Helps to store more data in hard disk

b) Placed between main memory and microprocessor

c) Stores data permanently

d) Holds last time visited data only
Answer:

11) Which one of the following printers is suitable for printing sprocket fed carbon copies?

a) Laser

b) Dot matrix

c) Ink jet

d) Drum
Answer:

12) …… are set of rules and procedures to control the data transmission over the internet

a) IP address

b) Domains

c) Protocol

d) Gateway
Answer:

13) Which of the following is a file attribute?

a) Hidden

b) Achieve

c) Read only

d) All of above
Answer:

14) …… are used to identify a user who returns to a website?

a) Cookies

b) Plug-ins

c) Scripts

d) Session
Answer:

15) Windows 7 supports which of the following file system?

a) NTFS

b) FAT

c) EXIT

d) UNIX
Answer:

16) Which among the following are the best tools for fixing errors in disk

a) Fdisk

b) Scandisk

c) Chkdsk

d) Fixdisk
Answer:

17) …… runs on computer hardware and serve as platform for other software to run on

a) Operating system

b) Application software

c) System software

d) All of above
Answer:

18) The operating system creates ….. from the physical computer

a) Virtual space

b) Virtual computers

c) Virtual device

d) None of above
Answer:

19) The primary function of an operating system is

a) To make the most efficient use of the computer hardware

b) To allow people to use the computer

c) To keep system programs employed

d) To make computers easier to use
Answer:

20) Thesaurus tool in MS Word is used for

a) Spelling suggestions

b) Grammar options

c) Synonyms and antonyms word

d) All of above
Answer:

21) Which tab in Font dialog box contains options to apply font effects?

a) Font tab

b) Character spacing

c) Text effects

d) Standard toolbar
Answer:

22) Which of the following is not of the merge process?

a) Sort the data source records

b) Format the main document

c) Edit the data source

d) Merge the two files to print or create a new document
Answer:

23) A screen element of MS Word that is usually located below the title bar that provides categorized options is

a) Menu bar

b) Tool bar

c) Status bar

d) All of above
Answer:

24) A word processor would most likely be used to do

a) Keep an account of money spent

b) Do a computer search in media center

c) Maintain an inventory

d) Type a biography
Answer:

25) If you need to change the typeface of a document, which menu will you choose?

a) Edit

b) View

c) Format

d) Tools
Answer:

26) ….. is a tool in Word which apply same format to different character/paragraphs?

a) Format repeater

b) Format applier

c) Format painter

d) Format generator
Answer:

27) …. Switch the page between portrait and landscape layout

a) Margins

b) Size

c) Columns

d) Orientation
Answer:

28) …. enables several people to work to create and update a document

a) Document sharing

b) Document locking

c) Document collaboration

d) Document protection
Answer:

29) When a hyperlink is created, Word formats the web address as …..

a) Italicized and colored red

b) Italicized and colored blue

c) Underlined and colored red

d) Underlined and colored blue
Answer:

30) Workbook is collection of

a) Cells

b) Worksheets

c) Workspaces

d) Projects
Answer:

31) Shortcut key to bring format cells dialog box is:

a) Ctrl+F

b) Ctrl+E

c) Ctrl+1

d) Ctrl+D
Answer:

32) The cell reference $A$5 is a …..

a) Relative cell reference

b) Absolute cell reference

c) Mixed cell reference

d) None of above
Answer:

33) Function to get sum of the contents of the cells A1, A2, B1, B2 is ….

a) =sum(A1+A2+B1+B2)

b) =sum(A1:B2)

c) =total(A1..B2)

d) =sum(A1,B2)
Answer:

34) To edit the contents of cell

a) Press F2

b) Double click on cell

c) Click on Formula bar

d) All of above
Answer:

35) Graphical representation of worksheet data

a) Pivote table

b) Goal seek

c) Graph

d) Scenario
Answer:

36) Filter option is used to ….

a) Arrange data in alphabetical order

b) Arrange data in numeric order

c) Arrange data in chronological order

d) Extract the records that meet given criteria
Answer:

37) The formula =if(A1>B1, A1-B1, B1-A1) gives

a) Larger one from cell A1 & B1

b) Positive difference of A1 & B1

c) Contents of A1

d) Contents of B1
Answer:

38) How do you display updatable current date in MS Excel?

a) DATE()

b) TODAY()

c) NOW()

d) Ctrl+;
Answer:

39) A function inside another function is called

a) Nested function

b) Round function

c) Sum function

d) Text function
Answer:

40) What are the different views to display a table?

a) Datasheet view

b) Design view

c) Pivot table and pivot chart view

d) All of above
Answer:

41) In a database table, the category of information is called

a) Tuple

b) Field

c) Record

d) All of above
Answer:

42) This key uniquely identify each record

a) Primary key

b) Key record

c) Unique key

d) Field name
Answer:

43) ….. enables you to view data from a table based on a specific criterion

a) Form

b) Query

c) Macro

d) Report
Answer:

44) A database language concerned with the definition of the whole database structure and schema is

a) DCL

b) DML

c) DDL

d) All of above
Answer:

45) In Microsoft PowerPoint in order to see all the slides on one screen you use

a) View, slide sorter

b) View, slide

c) View, master

d) View, slide show
Answer:

46) What are the three options available in Insert >> Picture menu

a) Clipart, Pictures, Shapes

b) Clipart, From file, Shapes

c) Clipart, From file, Autoshapes

d) Clipart, Pictures, Autoshapes
Answer:

47) Which of the following font effect is not available in PowerPoint font dialog box?

a) Underline

b) Shadow

c) Emboss

d) Strikethrough
Answer:

48) Full form of HTML is

a) Hypertext Markup Language

b) Hotmail

c) Hypertext Mail Language

d) All of above
Answer:

49) In HTML ….. tag is used for linking an external document

a) <src>

b) <anchor>

c) <a>

d) <include>

Answer:

50) To set the background color we use

a) <body text=“color”>

b) <body=“color”>

c) <body bgcolor=“color”>

d) All of above

Answer:

Sigma Delta

ads

Aug 23, 2017

PSC Assistant Computer Operator Exam 2074-05-07 Solved Answer Paper

Jul 9, 2017

लोकसेवा आयोगबाट बिगतमा सोधिएका बिज्ञान,प्रबिधी र स्वास्थ्य सम्बन्धी १२५ वटा प्रश्नोत्तरहरु

कम्प्युटर सम्बन्धी केही साधारण Tips & Tricks हरु

सामान्य ज्ञान प्रश्नोत्तरः कम्प्यूटरः

Jul 8, 2017

PSC Exam MCQ Ms-Access question set 1 Solved

Jul 7, 2017

PSC Exam Questions Ms-Excel MCQ Set 1 Solved

Jul 2, 2017

NOC Senior Computer Assistant Exam 2073 - Solved

PSC Assistant Computer Operator Exam 2073 - Solved

Jul 1, 2017

PSC Assistant Computer Operator Exam 2072 - Solved

PSC Computer Operator Exam 2072

PSC Computer Operator Question 2073 - Solved

Facebook Insta down right now फेसबुकमा समस्या

पुराना पाेष्टहरू

Labels