A complete guide for computer operator Preparation

Friday, May 20, 2016

Solved Question Paper of Computer Technician Exam 2016

Public Service Commission
Computer Technician Exam  2073
Competitive Written Exam Held on 2073-02-06
Time: 45 minutes
FM: 50
Key: C
Objective Questions (50 x 1 = 50 marks)
Correct Answers are Marked as Bold

  1. Feature that enables several people to work to create and update a document
    A) Document sharing     B) Document locking     C) Document collaboration    D) Document protection
  2. You can Break column by pressing
    A) Ctrl+Shift+Enter     B) Ctrl+Enter    C)Alt+enter    D) Alt+ Enter
  3. The shortcut key to copy format is:
    A) Ctrl+Shift+C     B) Alt+Ctrl+C    C)Alt+Shift+C    D) None of above
  4. Which of the following is NOT valid page margin
    A) Mirrored     B) Narrow   C)English    D) wide
  5. What function displays row data in a column or column data in row?
    A) Hyperlink     B) Index    C)Transpose    D) Rows
  6. Each excel file is called a workbook because
    A) It can contain text and data     B) It can be modified    C)It can contain many sheets including worksheets and chart sheets    D) You have to work hard to create it
  7. A Typical spreadsheet software allows at least
    A) 64 Columns     B) 128 columns    C) 256 columns    D) 52 columns
  8. Which of the following methods cannot be used to edit the content of cell?
    A) Pressing the Alt Key     B) Clicking the formula bar    C) Pressing F2     D) Double clicking the cell
  9. How should you print a selected area of a worksheet, if you'll want to print a different area next time?
    A) On the file menu, Pint to print area, and then click set Print area.
    B) On the file menu, Click print and then click selection under print area.
    C) On the view menu, Click custom views, then click add
    D) All of the above
  10. In MS Power Point,....... is readymade styles that can be used for a presentation
    A) Auto Style    B) Template    C) Wizard    D) Preformatting
  11. Which view in Power Point can be used to enter Speaker Comment?
    A) Notes Page view   B) Slide sorter    C) Normal   D) Slide Show
  12. The values GET, POST,HEAD etc are specified in ....... of HTTP message.
    A) Request Line    B) Header Line    C) Status Line    D) Entity Body
  13. A Web Cookie is a small piece of data
    A) Sent from a website and stored in user's web browser while a user is browsing a website
    B) Sent from user and stored in a server while a user is browsing a website
    C) Sent from root server to all servers
    D) None of the mentioned
  14. How can you make a bulleted list ?
    A) <list>    B) <NL>    C) <ul>    D) <ol>
  15. Text within <EM>…..</EM> tag displays text in ……. Format.
    A) Bold    B) Italic    C) List    D) indented
  16. Software that defines a database, stores the data, supports a query language produces reports and creates data entry screens is a
    A) Data Dictionary    B) Database Management System (DBMS)   C) Decision Support System    D) Relational Database
  17. When building database, the data dealing with an entity is modeled as a:
    A) Attribute    B) Class   C) Object    D) Table
  18. Student and course enrolled is an example of
    A) One-to-one relationship    B) One-to-many Relationship   C) Many-to-one  Relationship    D) Many-to-many Relationship
  19. Given the following relation
    Student(roll no, name, course no, course max. marks, year of study, address)
    The corresponding 3 NF relations are
    A) Student(roll no, name, year of study, address) Course (Course no, course Max marks
    B) Student( roll no, name year of study, address) Student( roll no, course no)Course( Course no, course max. marks)
    C) Student(roll no, name, address) Year(roll no, year of study) Course(Course no, course max. marks)
    D) None of the above
  20. Which of the following term describes testing?
    A) Finding Broken code    B) Evaluating deliverable to find errors   C) Stage of all projects    D) None of above
  21. Which of the following manuals is not a user documentation?
    A) Beginner’s guide    B) Installation guide   C) Reference guide    D) SRS
    (SRS provides information on exact requirements of system as agreed between user and developers.)
  22. Data flow diagram is related to
    A) Data Design    B) Process Design   C) UI design    D) Database Schema
  23. “Digital Signature” issued by
    A) Controller    B) Certifying Authority   C) Subscriber    D) Department of Information Technology
  24. For Digital signature key pair is generated by
    A) Asymmetric crypto system    B) Symmetric crypto system   C) RSA    D) None of the above
  25. License of certifying authority is issued by
    A) Nepal Government    B) Controller   C) Department of IT    D) Ministry of Science and Technology
  26. An area of a computer that temporarily holds data waiting to be processed is ……
    A) CPU    B) Memory   C) Storage    D) File
  27. Hard disk can be used as……
    A) Input Device    B) Output device   C) Storage Device    D) All of the above
  28. Unicode standard is ……..
    A) Software    B) Font   C) Character Encoding System    D) Keyboard Layout
  29. A fault in a computer program which prevents it from working correctly is known as
    A) Boot   B) Bug   C) Biff    D) Strap
  30. The difference between people with access to computers and the internet and those without this access is known as the:
    A) Digital Divide    B) Internet divide   C) web divide    D) E-illiteracy
  31. Cache Memory…….
    A) Helps to store more data in hard disk    B) Place between main memory and microprocessor   C) stores data permanently    D) Holds late time visited web site only
  32. Which one of the following printers is suitable for printing sprocket fed carbon copies?
    A) Laser    B) Dot Matrix   C) Ink-jet    D) Drum
  33. HDMI Stands for
    A) High Definition Machine Interface    B) High Definition Machine Interconnection    C) High Definition Multimedia Interface    D) High Definition  Manual Interface
  34. When RJ 45 jack is clamped with UTP-4 pair cable, it is understood that following PIN are responsible for reception and transmission
    A) 1,2 3,4    B) 1,2 3,6   C) 1,2 7,8    D) 5,6 7,8
  35. If a computer presentation is required to be displayed in local monitor and LCD projector simultaneously, the setup chosen in windows display setting is
    A) Split Screen    B) Projector only   C) LCD mode   D) Duplicate Screen
  36. What command can be used to find out network route/path for internet connection
    A) tracert    B) ping   C) nslookup   D) net use
  37. Computer not booting at all, beeping endlessly is symptom of
    A) BAD RAM    B) BAD Network Card   C) Network Cable Fault   D) HDD bad sector
  38. Bridge works in which layer of OSI model?
    A) Application Layer    B) Transport layer   C) Network Layer    D) Datalink layer

See Full Question Here


Monday, May 16, 2016

Solved Question Paper of Computer Operator Exam 2073

Public Service Commission
Computer Operator Exam  2073
Competitive Written Exam Held on 2073-01-29
Time: 45 minutes
FM: 50
Key: A
Objective Questions (50 x 1 = 50 marks)
Correct Answers are Marked as Bold
  1. IBM 1401 was brought to prepare the census report of ...
    A) 2018 BS        B) 2028 BS        c)2038 BS           D) 2048 BS
  2. Transistor is related to ….. generation computers
    A)  Second       B) Third        C) Fourth          D) Fifth
  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
  4. An area of a computer that temporarily holds data waiting to be processed is
    A) CPU        B) Memory       C) Storage       D) File
  1. For reproducing sound, a CD (compact disk) audio player uses a …..
    A) Quartz crystal   B) Titanium needle  C) Laser beam  D)Barium Titanium Ceramic
  1. Unicode Standard is ….
    A) Software      B) Font  C) Character encoding system     D)Keyboard layout
  2. A fault in a computer program which prevents it from working correctly is known as
    A) Boot      B) Bug     C) Biff      D) Strap
  1. Program developed according to the requirement specific to an office is …
    A) Tailored software    B) Utility software  C) Packaged software    D) All of above
  2. 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
  3. 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
  1. Which one of the following printers is suitable for printing sprocket fed carbon copies?
    A) Laser    B) Dot matrix     C) Ink jet       D) Drum
  2. …… are set of rules and procedures to control the data transmission over the internet
    A) IP address     B) Domains    C) Protocol    D) Gateway
  1. Which of the following is a file attribute?
    A) Hidden     B) Achieve     C) Read only    D) All of above
  2. …… are used to identify a user who returns to a website?
    A) Cookies     B) Plug-ins    C) Scripts   D) Session
  3. Windows 7 supports which of the following file system?
    A) NTFS     B) FAT  C) EXIT   D) UNIX
  4. Which among the following are the best tools for fixing errors in disk
    A) Fdisk      B) Scandisk     C) Chkdisk  D) Fixdisk
  5. …… 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
  6. The operating system creates ….. from the physical computer
    A) Virtual space     B) Virtual computers    C) Virtual device    D) None of above
  1. 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
  2. Thesaurus tool in MS Word is used for
    A) Spelling suggestions      B) Grammar options
    C) Synonyms and antonyms word     D) All of above
  3. Which tab in Font dialog box contains options to apply font effects?
    A) Font tab     B) Character spacing    C) Text effects    D) Standard toolbar
  4. 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
  5. 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
  6. 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
  7. If you need to change the typeface of a document, which menu will you choose?
    A) Edit    B) View   C) Format    D) Tools
  8. ….. 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
  9. …. Switch the page between portrait and landscape layout
    A) Margins    B) Size     C) Columns   D) Orientation
  10. …. Enables several people to work to create and update a document
    A) Document sharing     B) Document locking     C) Document collaboration    D) Document protection
  11. 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
  1. Workbook is collection of
    A) Cells    B) Worksheets   C) Workspaces    D) Projects
  2. Shortcut key to bring format cells dialog box is:
    A) Ctrl+F    B) Ctrl+E     C) Ctrl+1    D) Ctrl+D
  1. The cell reference $A$5 is a …..
    A) Relative cell reference       B) Absolute cell reference    
    C) Mixed cell reference          D) None of above
  2. Function to get some 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)
  3. To edit the contents of cell
    A) Press F2           B) Double click on cell
    C) Click on Formula bar      D) All of above
  4. Graphical representation of worksheet data
    A) Pivote table        B) Goal seek         C) Graph      D) Scenario
  5. 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
  1. 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
  2. How do you display updatable current date in MS Excel?
    A) DATE()     B) TODAY()    C) NOW()   D) Ctrl+;
  3. A function inside another function is called
    A) Nested function      B) Round function
    C) Sum function           D) Text function
  4. 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
  5. In a database table, the category of information is called
    A) Tuple     B) Field    C) Record      D) All of above
  6. This key uniquely identify each record
    A) Primary key   B) Key record    C) Unique key   D) Field name
  7. ….. enables you to view data from a table based on a specific criterion
    A) Form   B) Query    C) Macro    D)  Report
  8. 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
  9. 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
  1. 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
  2. Which of the following font effect is not available in PowerPoint font dialog box?
    A) Underline    B) Shadow    C) Emboss    D) Strikethrough
    Note:-  Strickethrough is not available in 2003 version But Emboss is available and  Emboss is  not available but strickethrough is available in 2007 or above version.

  3. Full form of HTML is
    A) Hypertext Markup Language      B)  Hotmail
    C) Hypertext Mail Language          D) All of above
  1. In HTML ….. tag is used for linking an external document
    A) <src>     B) <anchor>    C) <a>   D) <include>
  2. To set the background color we use
    A) <body text=“color”>      B) <body=“color”>   C) <body bgcolor=“color”>    D) All of above

Note:- Answers are Based on different websites.

The End

Solved Question Paper of Karmachari Sanchaye Kosh 2072

Karmachari Sanchaya Kosh
Computer Operator
Open Competition Written Examination

Time: 45 Minutes                                        Level: 5                                                                FM: 50
Select the correct answer and write in answer sheet. (50 x 1 = 50)
Correct Answers are marked as BOLD text.
  1. Sped of Printer is measured in
    a. FPM
    b. PPM
    c. CPI
    d. MPI
  2. Joystick is …. Kind of device
    a. input
    b. output
    c. processing
    d. storage
  3. Abbreviation CAD stands for
    a. Computer Aided Definition
    b. Calculator Aided Design
    c. Computerized At Destruction
    d. Computer Aided Design
  4. In display unit the ratio 1024 x 800 is known as
    a. Aspect Ratio
    b. PPM
    c. DPI
    d. BIT
  5. ASCI value of character ‘a’ is
    a. 95
    b. 96
    c. 97
    d. 98
  6. Which of the following is not the part of the CPU?
    a. Arithmetic Logical Unit
    b. Control Unit
    c. Hard Disk
    d. Cache Memory
  7. Which of the following is fastest memory?
    a. DVD
    b. Hard Disk
    c. RAM
    d. Cache
  8. 10 Seconds is equal to
    a. 100 milli-sec
    b. 0.001 milli-sec
    c. 1000 milli-sec
    d. 10000 milli-sec
  9. POST stands for
    a. Public Outlay Software Test
    b. Power Outage Survival tool
    c. Peripheral Output Standard Terminal
    d. Power on Self Test
  10. Highest Speed Network Media is?
    a. Satellite
    b. Microwave
    c. Optical Fiber
    d. CAT6e
  11. An IP address in IP v4 is of
    a. 2 bytes
    b. 3 bytes
    c. 4 bytes
    d. 6 bytes
  12. Which of the following statement regarding the optical fiber is false
    a. It is less prone to interference than copper wires
    b. It can transmit data to a longer distance than copper wires
    c. It is cheaper than copper wire
    d. It can support more band-width than copper wire
  13. The default subnet mask for the Class 3 networks
  14. Which command is used to copy files?
    a. copy
    b. type
    c. ren
    d. diskcopy
  15. To copy the hidden system files of DOS to another disk, you can use the command
    a. Copy
    b. Sys
    c. Ren
    d. Diskcopy
  16. Which command is used to confirm before deleting the directory?
    a. Deltree
    b. Del *.*/p
    c. Deltree/f
    d. Erase *.*
  17. Which is the best tool for fixing errors on disk?
    a. fdisk
    b. chkdsk
    c. scandisk
    d. fixdisk
  18. What is the name of the batch file that automatically runs when MSDOS is booted?
    a. run.bat
    b. config.bat
    c. config.sys
    d. autoexec.bat
  19. Which command is used to display a list of deleted files that DOS can undelete
    a. Undelete *.*
    b. Undelete/list
    c. Undelete/all
    d. None of the above
  20. Which feature of MS Word enables to send the same letter to different persons?
    a. macros
    b. mail merge
    c. template
    d. none
  21. Which of the following is not a font style?
    a. bold
    b. regular
    c. italics
    d. superscript
  22. Which of the following is used to change margins?
    a. Formatting toolbar
    b. standard toolbar
    c. page setup dialog box
    d. paragraph dialog box
  23. What is the shortcut key to display field codes?
    a. Alt+F9
    b. Shift+F9
    c. Ctrl+F9
    d. Space+F9
  24. What is placed to the left of horizontal scroll bar
    a. Tab stop buttons
    b. Split buttons
    c. View buttons
    d. indicators
  25. What is the maximum number of lines set for “lines to drop box”?
    a. 3
    b. 10
    c. 5
    d. 15
  26. What is the shortcut key for “Find and Replace” dialog box?
    a. Ctrl + F
    b. Ctrl + R
    c. Ctrl + H
    d. Ctrl+Shift+F
  27. What is the shortcut key to “Superscript” the selected text?
    a. Ctrl + =
    b. Ctrl + Shift + =
    c. Ctrl + –
    d. Ctrl + shift + –
  28. By default, document in MS Word prints with
    a. 1 inch top margin
    b. 1. Inch bottom margins
    c. A portrait orientation
    d. All of above
  29. What is the shortcut key for spelling check in documents?
    a. F7
    b. Ctrl+F7
    c. Shift+F7
    d. Alt+F7
  30. What is gutter margin?
    a. Margin that is added to the left margin when printing
    b. Margin that is added to the binding side of page when printing
    c. Margin that is added to the right margin when printing
    d. Margin that is added to the outside of the page when printing
  31. Which of the following is not available in Font spacing?
    a. Normal
    b. Condensed
    c. Loosely
    d. Expanded
  32. Which feature is used to create a newspaper like document?
    a. Bullets & Numbering
    b. Columns
    c. Tables
    d. Tap Stops
  33. Which of the following is an absolute cell reference?
    a. $A$1
    b. #A$1
    c. &A1$
    d. #A1#
  34. Getting data from a cell located in a different sheet is called
    a. Accessing
    b. referencing
    c. Updating
    d. Functioning
  35. The number of rows in a worksheet of Excel 2003 is
    a. 36500
    b. 65536
    c. 64536
    d. None of above
  36. Multiple Calculations can be made in a single formula using:
    a. Standard Formula
    b. Complex Formula
    c. Array Formula
    d. Smart Formula
  37. …. is used to select multiple non-adjacent cell in a worksheet
    a. CTRL key
    b. Shift key
    c. Alt key
    d. Tab key
  38. Conditional count can be performed using
    a. countif
    b. ifcount
    c. countiff
    d. iffcount
  39. Charts in worksheet itself is known as
    a. Embedded chart
    b. Inserted chart
    c. Implied chart
    d. Overlapping chart
  40. Invalid Formula category in EXCEL is
    a. Conditional
    b. Statistical
    c. Graphical
    d. Financial
  41. What is the output of the text function =MID(“regression”, 3,2)?
    a. gre
    b. egr
    c. re
    d. gr
  42. The technique which defines a set of values acceptable for the field is known as
    a. verification
    b. acceptance
    c. validation
    d. setting
  43. Which of the following is the property of Primary key?
    a. Duplicate
    b. Unique
    c. Pictorial
    d. Limited
  44. Technique of displaying only those records that meet the defined criteria is known as
    a. Selecting
    b. Filtering
    c. Separating
    d. Differentiating
  45. Data Definition Language (DDL) includes
    a. Creating Table
    b. Select Query
    c. Data Insert
    d. All of above
  46. A data manipulation command that combines the records from one or more table is called
    a. SELECT
    b. PRODUCT
    c. JOIN
    d. PROJECT
  47. What is the maximum number of slides that can be printed in a handouts
    a. 4
    b. 6
    c. 9
    d. 12
  48. What is the shortcut key to add a new slide in a presentation
    a. Crl+N
    b. Ctrl + P
    c. Ctrl + M
    d. Ctrl + O
  49. The arrangement of elements such as Title and subtitle Text, pictures, tables etc. is called
    a. layout
    b. Presentation
    c. Design
    d. Scheme
  50. What function key is used for slide show
    a. F3
    b. F6
    c. F4
    d. F5
Note: Answer are based on source of different web site.
The End

HTML Basic Note Book


for documents on the World Wide Web since 1989. HTML documents are text HTML files that contain two parts: content that can be seen on a computer screen and markup or tags  (encoded information) that is generally hidden from the user.
HTML defines the structure and layout of a Web document by  using a variety of tags and attributes.
The correct structure for an HTML document starts with
<HEAD> (enter here what document is about & scripting language)</HEAD>
<BODY> and ends with </BODY>
All the information you'd like to include in your Web page fits in between the <BODY> and </BODY>   tags. There are hundreds of other tags used to format and layout the information in a Web page. Tags are also used to specify hypertext links. These allow Web developers to direct users to other Web pages with only a click of the mouse on either an image or word(s).

HTML (Hyper Text Markup Language):-
Before Starting HTML we should know Hypertext Markup Language (HTML), in computer science, the standard text formatting language

The internet is a new communication technology that influences us on large scale. The internet also called the Net, is the world’s largest network. It is not a single network but global interconnected network of networks providing free exchange of information. We can share data, ideas, files, without any discretion of age and country. Internet is also a source of software. We can download software within a few minutes.
Advanced Research Project Administration Net (ARPA Net) is the ancestor of the internet. The project was an experience in reliable networking and to link defense and military research contractors in Later when Tim Bereners Lee has developed www in 1990, then everyone can be able to use internet since 1992. From 1994, Nepal is also connected within a internet.
World Wild Web (WWW):-
World Wide Web, which is a part of the net, is a collection of web pages. It contains information that can be a combination of text, pictures and hyperlinks. In another it is a web server.
Web page is a resource of information that suitable for World Wide Web and can be accessed through a web browser. This information is usually in HTML or XHTML format and may provide navigation to other through/ via hyperlink. It is a document, connected to the World Wide Web and view able by anyone  connected to the internet who has a web browser is known as web page.
Web Site:-
Web site is a very common terminology in WWW. A site refers to a particular location on the web and the collection of web is known as web site.
URL (Uniform Resource Locator):-
In short URL is a address of website. In another word URL is a global address of document and other  resources on the World Wide Web. The first part of the address is called a protocol identifier and it indicates what protocol to use. The second part is called a resources name and it specifies the IP address or domain name where the resources are located. The protocol identifier and resource name are separated by colon and two backward slashes.
For example:-
http://www.yahoo.com                            ftp://kaspersky.com/vob3.dat
Web Browser:-
The software that allows user to navigate the web and view HTML encoded document is known as web  browser. For example Internet Explorer, Opera, Firefox, Google Chrome etc.

A set of rules and convention (principle) for sending information over a network is called protocol.

HTTP (Hyper Text Transfer Protocol):-
Http is a standard set of rules for processing hypertext links, exchanging files (like text, graphic, images, sound, video and multimedia) on the World Wide Web. It is used to transfer hypertext request and  information between server and clients through web browser.
Work of HTTP
  • To create connection between server and client
  • To send request To receive request/Reply
  • To terminate/ close connection
How to create HTML Files:-
  • Click on Start Menu and click on “Run” Option.
  • Type “Notepad” in the text box of the run dialog box and click on ok
  • Then save the file with extension “.html”(extension must be defined)
  • At last click on “save” button.
How to open HTML Files:-
  • Just double Click on the html file
How to Edit HTML Files:-
  • Open html file.
  • Then click on “View” menu, click on “Source” option.
  • Edit your document in notepad application.

How to define HTML tags in notepad:-
----------   Write title of the webpage here.
-----------    Enter here what document is about & scripting language.
----------   All the information you'd like to include in your Web write here.
For more detail Please Download HTML Basic Note Book        Download
Powered by Blogger.

Subscribe Computer Preparation Help

Get all article, Blog Post to your email. Just subscribe from here.

Enter your email address:

Like Me on Facebook