PSC Computer Technician 2073/02/06

 

Computer Technician Exam 2073
Competitive Written Exam Held On 2073-02-06

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 the 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 contain text and data

b. It can be modified

c. It 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 key

d. Double clicking the cell

 

9. How should you print a selected are of a worksheet, if you'll want to print a different area next time?

a. On the file menu, print 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 customer views, then click add

d. All of the above

 

10. In MS Power Point____is readymade style 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 server

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 screen is a

a. Data Dictionary

b. Data 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. Give the following relation student(roll no, course no, course max.marks, year of study,address). The corresponding 3NF relation 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 the above

 

21. Which of the following manuals is not a user documentation?

a. Beginner's guide

b. Installation guide

c. Reference guide

d. SRS

 

22. Data flow diagram is related to

a. Data design

b. Process design

c. UI design

d. Database schema

 

23. "Digital Signature" is used 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. Placed 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, keeping endless is symptoms 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

 

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

 

40. In which type of operating system, the response time is very crucial?

a. Network operating system

b. Real time operating system

c. Batch operating system

d. Unix 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

 

42. Process is

a. Program to high level language kept on disk

b. Content of main memory

c. Program in execution

d. A job in secondary memory

 

43. Virtual memory is normally implemented by

a. Demand paging

b. Buses

c. Virtualization

d. All of these

 

44. DHCP stands for

a. Dynamic Host Control Protocol

b. Dynamic Host Configuration Protocol

c. Different Host Control Protocol

d. Dynamic Host Configuration Procedural

 

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

 

46. ___is the physical path over which a message travels.

a. Path

b. Medium

c. Protocol

d. Router

 

47. __is executed to request to a new IP address.

a. ipconfig/renew

b. ipconfig/release

c. ipconfig/revive

d. ipconfig/request

 

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

 

49. Protocol Data Unit (PDU) of TCP is known as

a. Message

b. Segment

c. Datagram

d. Frame

 

50. What function key is used hyperlink facility?

a. Ctrl + C

b. Ctrl + K

c. Ctrl + L

d. Ctrl + J

-The End- 

Also Read

Post a Comment (0)
Previous Post Next Post