Solved Question Paper of Chief Teacher (Computer)

Following is the solved question paper of Gharelu Tatha Sana Udyog Bikas Samiti, Chief Teacher (Computer) exam conducted on 9 July 2014. Thanks to Muga Ram Rai who mailed me the scanned copy of question paper. At the same time, a huge thanks to Bina Wasti to convert the scanned question paper into a Word file.

Please find the answers at the end of this post.

Download » Question Paper of Chief Teacher Computer

Question Paper

1. Trojan horse programs
a. Are legitimate program that allow unauthorized access
b. Do not actually work
c. are hidden programs that do not show up.
d. usually are immediately discovered on the system.

2. Microsoft Query uses the following to connect to external
a. Data source
b. Database
c. Data record
d. Query wizard

3. Forcing users to enter values in a specific way. The validation rulses are teremed as

a. Input masking
b. I/O masking
c. Output masking
d. None

4. The button command used for sending data to server
a. type = reset
b. type = button
c. Type = submit
d. type = send

5. Which of the following is not a programming language?
a. Pascal
b. C++
b. BASIC
d. Word

6. USB stands for
a. Ultra silent Bus
b. Uni Service Bus
c. Universal Serial Bus
d. Upper side Bus

7. The command to recover deleted file in MSDOS is
a. Universal
b. Undelete
c. Recover
d. Restore

8. Utility to minimize the number of fragmented files is
a. Defragment
b. Unfragment
c. Fragment me
d. Nofragment

9. Which of the following is NOT available in spreadsheet?
a. Statistical functions
b. Mail merge facility
c. What-if analysis
d. Pivot table

10. Data definition language (DDL) includes
a. Creating table
b. select query
c. Data insert
d. All of the above

11. Modern days network card has the following interface
a. RJ 11
b. RJ12
c. RJ40
d. RJ 45

12. It is possible to ………a data source before performing a merge.
a. Create
b. Modify
c. Sort
d. All of the above

13. 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

14. Scatter chart are
a. Line charts
b. XY charts
c. Mostly used for non-numeric values
d. All of the above

15. MODEM stands for
a. Modulator/ Demodulator
b. Multiplexer/ Demodulation
c. Modulator/ Dispatch
d. Magnify /Diminish

16. What is the short-cut key you can press to create a copyright symbol?
a. Alt + Ctrl+C
b. Alt+C
c. Ctrl +C
d. Ctrl +Shift+C

17. The query ” Select*form table_name* returns
a. All row from table with column name*
b. All rows first column only
c. All rows and columns
d. First row only

18. IBM 1401 was brought to prepare the census of ……..
a. 2018 BS
b. 2028 BS
c. 2038 BS
d. 2048 BS

19. Hard Disk can be used as ……….
a. Input device
b. Output device
c. Storage device
d. All of the above

20. Cache Memory ……
a. Helps to store more data in hard disk
b. places between main memory and microprocessor
c. Stores data permanently
d. holds last time visited web site only

21. Which of the following printers is suitable for printing sprocket fed carbon copies?
a. Laser
b. Dot matrix
c. Ink jet
d. Drum

22. ………are used to identify a user who returns to a website?
a. Cookies
b. plug-ins
c. Scripts
d. Sessions

23. Which of the following is not an operating system?
a. Linux
b. Windows
c. Oracle
d. DOS

24. Shortcut key combination for closing window is ………
a. Ctrl +S
b. Alt+ F4
c. Ctrk + S
d. F1

25. Page formatting which is uded frequently in future is saved as ….
a. Master document
b. Theme
c. Cross reference
d. Template

26. Ctrl+Shift +D
a. Double paragraph spacing
b. Delete current word
c. Dotted underline
d. Double underline

27. …..increases the readability of text.
a. save
b. bullet and numbering
c. Thesaurus
d. help

28. Page numbering is inserted as …..
a. Footnote
b. Endnote
c. Footer
d. None of the above

29. which key should be pressed to start a new paragraph in Ms word?
a. Down cursor key
b. Enter key
c. Shift+Enter key
d. Ctrl+Enter key

30. Shortcut key to bring format cells dialogue box is
a. ctrl+F
b. Ctrl+E
c. Ctrl+1
d. ctrl +D

31. 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)

32. 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

33. How do yo display updatable current date in MS Excel?
a. Date ()
b. Today ()
c. Now ()
d. Ctrl+;

34. 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 the above

35. Which type of field is incremented automatically?
a. Auto Elevate
b. Auto Number
c. Auto Increment
d. Auto Value

36. The rule that a value of a foreign key must appear as a value of some specific table is called a
A. Referential integrity
b. Index
c. Integrity constraint
d. Functional dependency

37. what is the name given to the process of initializing a microprocessor with its operation system?
a. Warm Booting
b. Hot Booting
c. Cold Booting
d. Booting

38. The IT Policy of Nepal, 2006 has been formulated to achieve the following objectives.
a. To development knowldege-based society
b. To reestablish knowledge basded-industries
c. To increase IT professionals
d. Both A and B

39. The access query can be created form neither design view or wizard view or SQL view. Select the correct query statement for all the records from table 1 in SQL view.
a. Select*form table1
b. Select*form table table1

c. Select all form table1
d. None of the above

40. <img src= “Myfoto.jpg” width=100%/> The output of the tag is
a. The file Myfoto.jpg
b. The file Myfoto.jpeg
c. The picture myfoto
d. None

41. What is the command to display or change the file attributes in DOS?
a. FAT
b. FILTER
c. ATTRIB
d. ATTRIBUTE

42. Following MSDOS command displays all files with extension.com
a. Dir *.*
b. Dir *.com
b. Display *.*
d. Disp *.com

43. To run calculator , one has to enter …….in run command.
a. Calc
b. Calculator
c. Calcu
d. Initiate calculator

44. Which of the following is NOT a logical operator?
a. +
b. =
c. >
d. <

45. What do you call a single point on a computer screen?
a. Cell
b. Element
c. Pixel
d. Bit

46. Wild Card ‘?’ means
a. Any character in any number
b. any one character
c. any two characters
d. any digits

47. Default text editor in window is
a. Notepad
b. Wordpad
c. Wonpad
d. Winword

48. Which of the following should you use if you want all the slide in the presentation to have the same ‘look’?
a. Slide layout option
b. Add a slide option
c. Outline view
d. A presentation design template

49.The device used in a data communication network to perform the converstion between analogue and digital signials, is called a…..
a. Front end processor
b. Modem
c. Decoder
d. Multiplexer

50. Pressing F8 key for three times selects
a. Word
b. A sentence
c. A paragraph
d. Entire document
Computer Teacher Question Paper web 1 Computer Teacher Question Paper web 2 Computer Teacher Question Paper web 3 Computer Teacher Question Paper web 4

 

Correct Answers

Gharelu Answers

 

Comments

    • says

      For question #19, I selected option D because all storage devices are also input/output devices (though not directly).

      Input is the operation to provide data to the CPU and output is the one that receives data from CPU and provides it to the users.

      You may have seen ‘Print to File’. In this situation, you are outputting the result to a file in disk.

      In case of #47, Notepad is the default text editor. It is the program in Windows that opens .txt files.

      WordPad is a mini WordProcessor Windows provides.

      Muga Ram, please use http://icttrends.com/discussion to join the community and discuss to clarify your confusion.

Leave a Reply