Lok Sewa Aayog Question Papers 2073 with Answers
Computer Technician
Exam Date: 2073-02-06
Time: 45 minutes FM: 50
| Download | File Size – 2.74 mb |
Solved Question Paper of PSC Computer Technician Exam 2073
Also Read: Solved Question Paper of Exam 2073 | PSC Computer Operator
Objective Questions (50 x 1 = 50 marks)
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
Ans: c) Document collaboration
2. You can break column by pressing
a) Ctrl+Shift+Enter
b) Ctrl+Enter
c) Alt+Enter
d) Alt+Shift
Ans: a) Ctrl+Shift+Enter
3. The shortcut key to copy format is:
a) Ctrl+Shift+C
b) Alt+Ctrl+Shift
c) Alt+Shift+C
d) None of the above
Ans: a) Ctrl+Shift+C
4. Which of the following is NOT a valid page margin
a) Mirrored
b) Narrow
c) English
d) Wide
Ans: c) English
5. What function displays row data in a column or column data in row?
a) Hyperlink
b) Index
c) Transpose
d) Rows
Ans: c) Transpose
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 chat sheets
d) you have to work hard to create it
Ans: c) it can contain many sheets including worksheets and chat sheets
7. A typical spreadsheet software allows at least
a) 64 columns
b) 128 columns
c) 256 columns
d) 52 columns
Ans: c) 256 columns
8. Which of the following methods cannot be used to edit the contain of cell?
a) Pressing the Alt Key
b) Clicking the formula bar
c) Pressing F2
d) Double clicking the cell
Ans: a) Pressing the Alt Key
9. How should you print a selected area of a worksheet, if you will want to print a different area next time?
a) On the file menu, Point 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
Ans: 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
Ans: b) Template
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
Ans: a) Notes Page view
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
Ans: a) Request Line
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.
Ans: a) Sent from a website and stored in user’s web browser while a user is browsing a website.
14. How can you make a bulleted list ?
a) <list>
b) <NL>
c) <ul>
d) <ol>
Ans: c) <ul>
15. Text within <EM> ?.. <EM> tag displays text in ….. Format.
a) Bold
b) Italic
c) List
d) Indented
Ans: b) Italic
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
Ans: b) Database Management System (DBMS)
17. When building database, the data dealing with an entity is modeled as a:
a) Attribute
b) Class
c) Object
d) Table
Ans: c) Object
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
Ans: a) One-to-one 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
Ans: Your Turn !
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
Ans: b) Evaluating deliverable to find errors
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.)
Ans: 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
Ans: a) Data Design
23. ?Digital Signature? issued by
a) Controller
b) Certifying Authority
c) Subscriber
d) Department of Information Technology
Ans: b) Certifying Authority
24. For Digital signature key pair is generated by
a) Asymmetric crypto system
b) Symmetric crypto system
c) RSA
d) None of the above
Ans: a) Asymmetric crypto system
25. License of certifying authority is issued by
a) Nepal Government
b) Controller
c) Department of IT
d) Ministry of Science and Technology
Ans: b) Controller
26. An area of a computer that temporarily holds data waiting to be processed is ??
a) CPU
b) Memory
c) Storage
d) File
Ans: b) Memory
27. Hard disk can be used as ??
a) Input Device
b) Output device
c) Storage Device
d) All of the above
Ans: c) Storage Device
28. Unicode standard is ??
a) Software
b) Font
c) Character Encoding System
d) Keyboard Layout
Ans: c) Character Encoding System
29. A fault in a computer program which prevents it from working correctly is known as
a) Boot
b) Bug
c) Biff
d) Strap
Ans: b) Bug
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
Ans: a) Digital Divide
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
Ans: b) Place between main memory and microprocessor
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
Ans: b) Dot Matrix
33. HDMI Stands for
a) High Definition Machine Interface
b) High Definition Machine Interconnection
c) High Definition Multimedia Interface
d) High Definition Manual Interface
Ans: c) High Definition Multimedia 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
Ans: b) 1,2 3,6
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
Ans: 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
Ans: a) tracert
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
Ans: a) BAD RAM
38. Bridge works in which layer of OSI model?
a) Application Layer
b) Transport layer
c) Network Layer
d) Datalink layer
Ans: d) Datalink layer
39. Unix Operating System is an
a) Multi User Operating system
b) Time Sharing operating system
c) Multitasking operating system
d) All of the above
Ans: d) All of the above
40. In which type of Operating system, the response time is very crucial?
a) Network operation system
b) Real time operating system
c) Batch operating system
d) Unix operating system
Ans: b) Real time operating system
41. Multimedia system require hard real time scheduling
a) to ensure critical tasks will be serviced within timing deadlines
b) To deliver the media file to client
c) To minimize the delay
d) for security
Ans: a) to ensure critical tasks will be serviced within timing deadlines
42. Process is
a) Program in high level language kept on disk
b) Contents of main memory
c) Program in execution
d) A job in secondary memory
Ans: b) Contents of main memory
43. Virtual memory is normally implemented by
a) Demand paging
b) Buses
c) Virtualization
d) All of these
Ans: a) Demand paging
44. DHCP stands for
a) Dynamic Host Control Protocol
b) Dynamic Host Configuration Protocol
c) Different Host Control Protocol
d) Dynamic Host Configuration Procedure
Ans: b) Dynamic Host Configuration Protocol
45. A ??.. is a device that forwards packets between networks by processing the routing information included in a packet.
a) Bridge
b) Firewall
c) Router
d) Switch
Ans: c) Router
46. ?? is the physical path over which a massage travels
a) Path
b) Medium
c) Protocol
d) Router
Ans: b) Medium (Message travel from sender to receiver via a medium using a protocol.)
47. ?.. is executed to request a new IP address
a) ipconfig /renew
b) ipconfig /release
c) ipconfig /revive
d) ipconfig /request
Ans: a) ipconfig /renew
48. Communication channel is shared by all the machines on the network in
a) Broadcast network
b) Unicast network
c) Multicast network
d) None of the above
Ans: a) Broadcast network
49. Protocol Data Unit (PDU) of TCP is known as
a) Message
b) Segment
c) Datagram
d) Frame
Ans: b) Segment
50. What function key is used hyperlink facility?
a) Ctrl+C
b) Ctrl+K
c) Ctrl+L
d) Ctrl+J
Ans: b) Ctrl+K
Good Luck !