Exam Details

Subject
Paper
Exam / Course
Department
Organization Uttarakhand Public Service Commission
Position programming assistant/console operator
Exam Date 2014
City, State uttarakhand,


Question Paper

1. Any computer is controlled by

Hardware

Information

Instructions

Memory

2. Storage mapping is done by

Operating System

Compiler

Linker

Loader

3. The input and output device in a computer system is

Printer

Touch Screen

Keyboard

Mouse

4. Computer memory consists of

RAM

ROM

PROM

All of the above

5. The BIOS is the abbreviation of

Best Input Output System

Basic Input Output Symbol

Base Input Output System

Basic Input Output System

6. Which of the memory has the shortest access time

Cache Memory

Virtual Memory

Secondary Memory

All of the above

7. What do you call a single point on a computer screen

Bit

Element

Pixel

Cell

8. Through which of the device, the main components of Computer communicate with each other

System Bus

Monitor

Memory

Keyboard

9. The main electronic components used in fourth generation computers were

Integrated circuits

VLSI

Vacuum tubes and valves

None of the above

10. The abbreviation bps stands for

Bytes per second

Bandwidth per second

Bits per second

Baud rate per second

11. The silicon chips used for data processing are called

ROM chips

RAM chips

PROM chips

Microprocessor

12. IBM PC and clones belong to the

Second generation

Third generation

Fourth generation

Fifth generation

13. When a PC is started, which of the following program is executed

DOS

BIOS

Start up

None of the above

14. Working area of CPU is

Program Counter

Instruction Register

Information Decoder

Accumulator

15. Which of the following layer is not in OSI model

Physical layer

Internet layer

Network layer

Transport layer

16. IPv4 address is

8 bits

16 bits

32 bits

48 bits

17. What is the Port number for HTTP

80

99

82

23

18. Which layer of OSI model is responsible for dialog control and token management

Physical layer

Data-link layer

Network layer

Session layer

19. DHCP stands for

Dynamic Host Control Protocol

Dynamic Host Configuration Protocol

Dynamic Host Connection Protocol

None of the above

20. A computer network uses a star topology if

Computers are arranged in closed loop.

All computers attach to a central point.

All computers attach to a single long cable.

None of the above.

21. Fiber Distributed Data Interface (FDDI) is an example of

Token ring

Token bus

Star topology

Multipoint network

22. Error detection at the data-link layer is achieved by

Bit stuffing

Cyclic Redundancy check

Hamming codes

Equalization

23. NIC stands for

New Internet Connection

Network Interface Card

Network Interface Connection

Net Interface Card

24. Switch is related to

Network layer

Application layer

Session layer

Data-link layer

25. File virus attaches itself to

Backup file

Source file

Object file

Executable file

26. In asymmetric key cryptography, the private key is kept by

Sender

Receiver

Sender Receiver both

All connected devices to the network

27. URL stands for

Unique Reference Label

Uniform Reference Label

Uniform Resource Locator

Unique Resource Locator

28. Digital signature is a

Scanned signature

Signature in binary form

Encrypting

Information

29. All of the following are top level domains, except

.com

.edu

.org

.army

30. The first page of a website is called as

Main page

Home page

First page

Design page

31. Which of the following protocol is used for transferring e-mail message from one machine to another

FTP

SNMP

SMTP

RPC

32. A computer which stores the different webpages is called as

Service provider

Web server

Web browser

None of these

33. In the e-mail address abc@gmail.com what is

Client computer

Server Name

Domain Name

User Name

34. Google is a

LAN Navigator

Search Engine

Hardware Part

None of the above

35. The main function of a browser is to

Compile HTML

Interpret HTML

Interpret CGI program

None of the above

36. Error reporting protocol is

ARP

TCP

UDP

ICMP

37. HTTP is a protocol to

Copy files between computers.

Transfer web pages to a browser.

Limit access to company data.

None of the above

38. Telnet is a

Network of Telephones

Television Network

Remote login

None of the above

39. Which protocol is used for browsing websites

HTTP

FTP

SMTP

TELNET

40. Virtual memory is

An extremely large main memory.

An extremely large secondary memory.

An illusion of an extremely large memory.

A type of memory used in super-computers.

41. The delay between job submission and job completion is called

Turn around time

In-process time

Response time

Waiting time

42. The module that gives the control of CPU to the process selected by short-term scheduler is

Dispatcher

Scheduler

Context switcher

All of the above

43. The substitution made by the Operating System between processes to allocate space is

Swapping

Deadlock

Fragmentation

Paging

44. Which of the following system software resides in main memory always

Text editor

Assembler

Linker

Loader

45. A program which merges many object modules is called

Linker

Loader

Interpreter

Compiler

46. MS-DOS is a

Multi User Operating System

Time Sharing Operating System

Single User Operating System

None of the above

47. The time during which a job is processed by the computer is

Delay time

Real time

Execution time

Down time

48. A translator which reads an entire program written in a high level language and converts it into machine language code is

Assembler

Compiler

Translator

System Software

49. In computer which language is used to write source program

English

Hindi

Symbolic

High level

50. When a computer is first turned on or restarted, a specific type of absolute loader is executed, called a

Boot loader

Compile and Go loader

Bootstrap loader

Start loader

51. Dijkstra's banking algorithm in an operating system solves the problem of

Deadlock Avoidance

Deadlock Recovery

Mutual Exclusion

Context Switching

52. Which command of MS-DOS is used to search for a specific string of text in one or more files

SEARCH

SORT

FIND

MORE

53. Which command is used to delete the directory and all its contents in one step

DEL

RD

DELTREE

DELDIR

54. JPEG stands for

Joint Photo Experiment Group

Joint Photographic Experts Group

Joint Photographic Enlarge Group

Joint Photogenic Experts Group

55. MIDI stands for

Multimedia Instrument Digital Interface

Musical Instrument Design Interface

Musical Instrument Digital Instruction

Musical Instrument Digital Interface

56. Which of the following program is not popular desktop publishing program

Adobe PageMaker

Microsoft Publisher

Lotus AmiPro

Quark Xpress

57. Program used to create or modify bitmap images is called

Illustration program

Paint program

Graphical modifier

Bit publishing package

58. Raster images are also known as

Bitmap images

Vector images

Clip-art images

Multimedia images

59. Corel Draw is an example of a

Group ware Application

Bit Publishing Package

Paint Program

Graphics Suite

60. Microsoft front page is an example of

Authorizing Streaming Program

Graphical map editor

Web page Editor

Robotics authoring program

61. Data is filled up into a MS-ACCESS database using

Data sheet view

Advance filter view

Design view

Relationship view

62. The default value for text field size in MS -Access is

50 characters

55 characters

60 characters

80 characters

63. In a relational schema, each tuple is divided into fields called

Relations

Domains

Queries

None of these

64. Arranging data in a specific order is called

Merging

Sorting

Classification

Verification

65. Relational calculus is a

Procedural language

Non-procedural language

Data definition language

High level language

66. In E-R diagram, attributes are represented by

Rectangle

Square

Ellipse

Triangle

67. In the architecture of database system external level is

Physical level

Logical level

Conceptual level

View level

68. E-R modelling technique is

Top-down approach

Bottom-up approach

Left-right approach

None of the above

69. Data integrity refers to

Non-duplication of data

Accuracy of data

Security of data

Centralised data

70. Which is not a component of relational database

Entity

Attribute

Table

Hierarchy

71. Name the extension of an access database file.

.dat

.mdb

.txt

.exe

72. Which SQL Query is used to remove a table and all its data from the database

Create table

Drop table

Alter table

None of these

73. Which of the following is not an aggregate function

MIN

MAX

SELECT

AVG

74. Which of the following is not used for modification in the database

DELETION

SORTING

INSERTION

UPDATING

75. What is Unicode

Standard Font

Software

Character Encoding System

Keyboard Layout

76. Which attribute is used to specify the link URL in HTML

src

href

rel

link

77. What is the correct syntax in HTML for creating a link on a webpage

A HREF "abc.html"

LINK SRC "abc.html"

HYPER SRC "abc.html"

BODY SRC "abc.html">

78. Tags that are not directly displayed on the page are written in which of the following section

<html>

<head>

<title>

<body>

79. What is the correct HTML tag for inserting a line break



<break>

<newline>



80. How can you make an e-mail link in HTML

mail href "yyy@xxx"

mail yyy@xxx</mail

a href "mail to xxx@yyy"

a href "xxx@yyy"

81. Which of the following converts ordinary text into hypertext

XML

HTML

JavaScriptü

HTTP

82. What is the correct syntax for inserting image in HTML

background img "background.gif "

body background "background.gif "

img src "background.gif "

None of these

83. Which is not a markup language, but a language for defining markup language

HTML

DHTML

SGML

None of these

84. Which attribute is used to specify the relationship between current document and the linked document

rel

target

href

relation

85. HTML stands for

Hyper Text Make up Language

Hyper Technical Mark up Language

Hyper Text Mark up Language

None of the above

86. Choose the correct HTML tag to make the text bold.









87. Architecture of the database can be viewed as

two levels

three levels

four levels

one level

88. In relational model, cardinality is termed as

Number of tuples

Number of attributes

Number of tables

Number of constraints

89. Raster is a synonym for the term

Matrix

Array

Model

All of the above

90. Graphics that contain movement are often referred as

Motion

Premier Adobe

Flash

Animation

91. Trojan Horse is

A code segment that misuses its file

Good for file accessing

Name of special file directory

None of these

92. To switch to the next task, press the following keys in windows

Alt Ctrl

Alt Esc

Alt Del

Alt Tab

93. Which is not the filename extension of an image

.gif

.jpg

.png

.ppt

94. Which of the following extension suggests that the file is a backup copy

.bak

.bas

.srt

.img

95. Date and time are available on the desktop at

My Computer

Task bar

Recycle bin

None of the above

96. In MS-DOS how a floppy or hard disk can be formatted

Clean

Spooling

Format

None of the above

97. What is the name of the application used to manage files and folders in windows

Internet Explorer

Document Explorer

Analytical Explorer

Windows Explorer

98. Which of the following shows the file, which is deleted recently

Desktop

My Document

Recycle Bin

All of these

99. Which of the following attribute prevents changes to files and folders

Hidden

Read only

System

None of the above

100. "Phone and Modem" option comes under

Control Panel

My Computer

Recycle Bin

None of the above

101. Pointing device is used as

Input device

Input and Output device

Both

None of the above

102. For accessing the network, the most appropriate icon to use is

Recycle Bin

Network Neighborhood

My Computer

None of the above

103. Which of the following is not a multimedia input device

Digital Camera

Video Camera

Music input system

Keyboard

104. To install any software in Windows, use

Add/Remove Hardware of Control Panel

Add/Remove Programs of Control Panel

Administrative Tools of Control Panel

None of the above

105. Which of the following option is clicked to display the RAM size and CPU details of computer

My Computer . System

My Document . System

Control Panel . System

None of the above

106. Data can be imported into MS-Access database from

Excel file

Word file

PowerPoint file

HTML file

107. The MPEG stands for

Movie Picture Experts Group

Moving Platform Experts Group

Multiple Platform Experts Group

Moving Picture Experts Group

108. Which of the following is not a database key

Index key

Candidate key

Unique key

Primary key

109. Graphics for word processor

Peripheral

Clip Art

Highlight

Execute

110. Special effects used to introduce slides in a presentation are called

Effects

Custom Animations

Transitions

Present Animations

111. means changing font size.

Leading

Tracking

Editing

Scaling

112. Which shortcut keys insert a new slide in current presentation

Ctrl M

Ctrl S

Ctrl A

All of these

113. If you select Insert Picture From file, then you

Insert clip arts only

Insert picture only

both

None of these

114. To add a slide in PowerPoint presentation, which option is to be selected

File add new slide

File open

File new

Insert new slide

115. Which of the following is not an option when printing handouts per page

Two slides

Three slides

Five slides

Six slides

116. Keys you press when some text is to be copied are

Ctrl+A

Ctrl+C

Alt+C

Alt+D

117. Thesaurus tool in MS-Word is used for

Spelling suggestions

Grammar options

Synonyms and Antonyms word

All of the above

118. To send email to a large group at one time, we use

List serv

Group

Alias

Mail Sever

119. In MS-Word which key underline the selected text

Ctrl+W

Ctrl+Z

Ctrl U

None of the above

120. Advance filter is present in which menu in MS-Excel

Tools

View

Data

File

121. Which of the following command of MS-Excel converts a column of data into row

Orientation

Cut and Paste

Paste Special . Transpose

All of these

122. The database schema is written in

DDL

HLL

DML

DCL

123. Which of the following is the default extension of an Excel Worksheet

.exw

.xls

.wks

None of these

124. Which of the following function of Excel get the column and row total automatically

Cell()

AutoSum()

Auto SumX(

None of these

125. A formula entered into a cell in MS-Excel must begin with the sign









126. To open the format cell dialog Box in MS-Excel, press the keys

Alt 1

Ctrl 1

Ctrl+Shift+1

F1

127. Report generator is used to

update files

data entry

print files on paper

delete files

128. Portrait and Landscape are

Paper size

Paper layout

Style

Paper orientation

129. Which of the following function of MS-Excel is used to get the absolute value of a number

UPPER()

CELL()





130. How to specify cell range from A9 to A99 in MS-Excel

A99)

(A9 to A99)

(A9 A99)

(A9 A99)

131. Which of the following is an absolute cell reference in MS-Excel







A1

132. is a table consisting of rows and columns.

Worksheet

Cell

Workbook

Range

133. Which of the following Operating System does not implement multi-tasking truly

Windows 98

Windows NT

Windows XP

MS-DOS

134. In MS-Word the option "Mail Merge" comes under

Insert Menu

Format Menu

Tools Menu

None of the above

135. In MS-Word paragraph comes under the

Insert Menu

Format Menu

View Menu

None of the above

136. Microsoft Office is a

Desktop Application

Operating System

Command Window

None of the above

137. A popular presentation program for Windows in MS-Office is

MS-Word

MS-PowerPoint

MS-Access

None of the above

138. In MS-Word, what is the smallest and largest font size available in font size tool on formatting tool bar

8and68

6and72

6and68

8and72

139. In MS-Word, on which page the header or the footer is printed by default

On first page

On last page

On alternate page

On every page

140. In MS-Word, the command comes under

Format Menu

File Menu

Edit Menu

None of the above

141. In MS-Word, which key is used to select all the text in the document

Ctrl+T

Ctrl+A

Ctrl+F

Ctrl+N

142. The default font size in MS-Word-2007 page is

8

9

10

11

143. In MS-Word the default values for the top and left margin respectively are

0.5.,1.

1., 1.25.

1.25., 1.25.

1., 1.5.

144. When the pointer is positioned on a Word, it is shaped like a hand, which shows

Grammar error

Hyperlinking

Screen tip

Formatting error

145. What is the default font type used in MS-Word-2007 document

Calibri (Body)

Arial

Algerian

Bold

146. What is the extension of MS-PowerPoint files

.fil

.dot

.txt

.ppt

147. In MS-Word, which of the following option is not available in Insert

Chart

Clip Art

Graph

Word Art

148. Which of the following line spacing is invalid in MS-Word Series-A 20 DPP

Single

Double

Triple

Multiple

149. Print option is in

File tab Insert tab Page layout tab View tab Font

150. In MS-Word cut, copy an Page Setup d paste are in

gr Clip board oup in the home tab.

Editing

151. The highest rainfall zone in Uttarakhand is

Rawain Valley

Outer Himalayan Zone

Middle Himalayan Zone

Greater Himalayan Zone

152. The fair organised at the confluence of river Kali and Gauri is known as

Uttarayani fair

Jauljivi fair

Bagwal fair

Chaiti fair

153. The major tributary of River Bhagirathi is Bhilangana, which originates from

Pindari Glacier

Khatling Glacier

Mana Pass

Gomukh Glacier

154. In which year the District headquarters of British Garhwal was established in Pauri

1820

183W0

1840

1850

155. Veer Chandra Singh Garhwali was associated with

Garhwal Sapers

Royal Garhwal Rifles

Kumaun Rifles

Gorkha Rifles

156. Who started the publication of 'Garhwal Samachar' monthly in 1902 from Lansdowne

B.D. Chandola

Pandit Girija Datt Naithani

Almora Debating Club

Kunwar Singh Negi

157. Who was not a member of Garhwal Union (established in 1901)

Tara Datt Gairola

Vishamber Datt Chandola

Chandra Mohan Raturi

Padam Singh Negi

158. The 'Prajamandal Movement' was associated with

Pauri Garhwal

Chamoli

Tehri Garhwal

Haridwar

159. How many members of Parliament from Uttarakhand are given representation in Indian Parliament

Five

Six

Seven

Eight

160. 'Panchayatan style' is associated with the

Construction of Temples.

Construction of Domestic Houses.

Construction of Tourist Guest Houses.

None of the above.

161. 'Fatehprakash' is written by

Kavi Ratan

Bhushan

Mati Ram

Neelkanth

162. According to Census 2011, which one of the following districts is most urbanised

Haridwar

Dehradun

Udham Singh Nagar

Nainital

163. Who was the founder of 'Garhwal Bhratri Mandal' (1907)

Mathura Prasad Naithani

B.D. Chandola

Mahant Parashuram

Dr. Narayan Singh Aswal

164. The main profession of 'Agaria' caste of Kumaun used to be

Mining of gold

Mining of Iron and Copper

Weaving

None of the above

165. The performer of singing is known as

Bakiya

Beda

Dangaria

Jagaria

166. Who was the first king of Chand dynasty of Kumaun

Som Chand

Purna Chand

Jai Chand

Veena Chand

167. In which year 'Nehru Institute of Moutaineering' was established at Uttarkashi

1965

1962

1970

1975

168. Who was the founder of 'Panwar Dynasty' in Garhwal Raj

Ajai Pal

Kanak Pal

Bhaun Pal

Vishnu Pal

169. Who was last Maharaja of Tehri State

Manvendra Shah

Pradymna Shah

Kirti Shah

Narendra Shah

170. 'Bagwaal' the famous 'Stone battle' is played at

Dwarahat Fair

Gananath fair

Devidhura fair

Nandadevi fair

171. Who was the founder of 'Shanti-kunj' in Haridwar

Swami Ram Teerth

Swami Sahjanand

Pandit Sri Ram Sharma

Swami Ramdev

172. Founder of 'Himalayan Institute Hospital Trust' was

Swami Shiva Nand

Swami Veda Bharati

Swami Ram

Swami Ramdev

173. 'Wadia Institute' at Dehradun is working on

Water Conservation

Geological Studies

Forest Studies

Wild Life Studies

174. Which among the following institutions is not situated in Uttarakhand

Bharat Heavy Electricals Ltd. (BHEL

Hindustan Machine Tools (HMT

Indian Drugs and Pharmaceutical Limited (IDPL)

Hindustan Aeronautics Ltd.

175. The initiator of 'Chipko-Movement' in Uttarakhand was

Teelu Rautele

Radha Bhatt

Sarla Ben

Gaura Devi

176. Identify the combination of largest and smallest population Districts of Uttarakhand on the basis of the Census figures of 2011.

Haridwar and Rudraprayag

Udham Singh Nagar and Rudraprayag

Dehradun and Champawat

Haridwar and Bageshwar

177. Based on the figures of Census of 2011, which is the most densely populated District of Uttarakhand

Nainital

Dehradun

Udham Singh Nagar

Haridwar

178. Which is the largest source of tax revenue collection in Uttarakhand

Entertainment Tax

Sales Tax

Stamp Duty

Excise Duty

179. VAT was introduced in the Uttarakhand State on

1st April, 2003

1st April, 2004

1st April, 2005

1st April, 2006

180. Maximum number of paper mills in Uttarakhand are situated in the District of

Nainital

Udham Singh Nagar

Dehradun

Champawat

181. Catechu Factory in Uttarakhand is situated at

Nainidanda

Haldwani

Lachchiwala

Bahadrabad

182. Match the List I and List II and find the correct answer from the given code

List List -II
A. Kumaun Mandal Development Corporation 1. Haridwar
B. G.B. Pant Sugar Mill 2. Ranibag
C. H.M.T. Watch Unit 3. Nainital
D. B.H.E.L. 4. Kichchha
5. Srinagar
Code
A B C D

1 2 34

2 3 45

4 5 12

3 4 21

183. The first political arrest in British Kumaun was of

Victor Mohan Joshi

Ram Singh Dhoni

Mohan Singh Mehta

Badri Dutt Pandey

184. Gorkha Udiyar is famous for

Pre-Historic Implements

Rock Painting

Pottery

Copper Plate Inscriptions

185. Kunindas ruled in the period

300 400 B.C.

800 900 B.C.

100 200 B.C.

200 300 B.C.

186. Guru Ram Rai arrived at Dehradun in the year

1775 AD

1675 AD

1575 AD

1475 AD

188. The name of the Rohilla General who invaded Kumaun Raj was

Hafiz Rahmat Khan

Gulam Khan

Gulam Ali

Pervez Khan

189. Swami Vivekanand visited Almora for the first time in the year

1880

1889

1897

1890

190. Almora coins belong to Kuninda Dynasty Verman Dynasty Paurava Dynasty Katyuri Dynasty

191. Where did Mahatma Gandhi wrote 'Anasakti Yoga Tika'

Almora

Kausani

Haridwar

Ramgarh

192. Tolcha and Marcha tribes live in the area of

Neeti and Mana Valley

Johar Valley

Jaunsar Area

Tarai -Bhaber

193. 'Badrinath' temple is situated in the district

Chamoli

Rudraprayag

Dehradun

Uttarkashi

194. Sri Liladhar Jaguri is a

Bridge builder

Poet

Historian

Astrologer

195. According to Pandu Keshwar Copper plate inscriptions, the rulers of which dynasty had recognised the Nanda Devi as their presiding deity

Panwar

Pal

Katyuri

Chand

196. In the famous ballad of 'Rajula Malushahi', the name of Rajula's father is

Daljit Bora

Haru Saim

Gangnath

Sunpati Shauka

197. Who is the author of the book "Himalayan Folklore"

G.R.C. Williams

E.S. Okley and Tara Dutt Gairola

Narendra Singh Bhandari

William S. Sax

198. 'Jakhya' seeds are used mainly for

Frying

As a tonic

In Puja ritual

As a medicine

199. Which ruler took the idol of Nanda Devi from Badhangarhi to Almora

Udyot Chand

Kalyan Chand

Ishwar Chand

Baj Bahadur Chand

200. After the creation of Uttarakhand as a separate state in Indian Union it became a

27th State

28th State

29th State

26th State


Other Question Papers

Subjects

  • agricultural engineering
  • civil engineering
  • computer science
  • electrical engineering
  • english
  • financial rules
  • general aptitude
  • general english
  • general knowledge & law
  • general studies
  • geology
  • hindi
  • hotel management
  • law
  • mechanical engineering
  • motor vehicles act
  • screening