Page 1
Question Paper
2022
docs.
Page 2
A
Joár ÊÜáá©ÅñÜ ±ÜâoWÜÙÜ ÓÜíTæÂ 12 ]
Question Paper Serial No.
Total No. of Printed Pages : 12 ]
CÈÉí¨Ü PÜñܤÄÔ
Joár ±ÜÅÍæ°WÜÙÜ ÓÜíTæÂ 34 ]
Total No. of Questions : 34 ] CCE RF
ÓÜíPæàñÜ ÓÜíTæÂ : 86-E K CCE RR
Code No. : 86-E K NSQF LEVEL-2
ÊÜÞ×£ ñÜíñÜÅþÝ®Ü
101
ËÐÜ¿á
Subject : Information Technology
PܮܰvÜ ÊÜáñÜᤠCíXÉÐ… ÊÜÞ«ÜÂÊÜá / Kannada and English Medium
ÍÝÇÝ A»Ü¦ì & ±Üâ®ÜÃÝÊÜ£ìñÜ ÍÝÇÝ A»Ü¦ì / Regular Fresh & Regular Repeater
©®ÝíPÜ 08. 04. 2022 ] [ Date : 08. 04. 2022
ÓÜÊÜá¿á ¸æÙÜWæY 10-30 Äí¨Ü ÊÜá«ÝÂÖܰ 12-45 ÃÜÊÜÃæWæ ] [ Time : 10-30 A.M. to 12-45 P.M.
TEAR HERE TO OPEN THE QUESTION PAPER
WÜÄÐÜu AíPÜWÜÙÜá 60 ] [ Max. Marks : 60
General Instructions to the Candidate :
1. 34
Functional English
This Question Paper consists of objective and subjective types of 34 questions
including Section – A and Section – B. Section – A consists of questions related
to the subject Information Technology and Section – B consists of the questions
related to Functional English.
2.
This question paper has been sealed by reverse jacket. You have to cut on the
right side to open the paper at the time of commencement of the examination.
Check whether all the pages of the question paper are intact.
3.
Follow the instructions given against both the objective and subjective
types of questions.
4.
Figures in the right hand margin indicate maximum marks for the question.
5. 15
Tear here
The maximum time to answer the paper is given at the top of the question paper.
It includes 15 minutes for reading the question paper.
101 RF/RR(A)-(200)-9101 [ Turn over
Page 3
86-EK (Level-2) 2 CCE RF & RR
SECTION – A
I. D PæÙÜX®Ü ±ÜÅÍæ°WÜÚWæ A¥ÜÊÝ A±Üä|ì ÖæàÚPæWÜÚWæ ®ÝÆáR BÁáRWÜÙÜ®Ü á° ¯àvÜÇÝX¨æ. AÊÜâWÜÙÜÈÉ
ÖæaÜác ÓÜãPܤÊÝ¨Ü EñܤÃÜÊÜ®Üá° BÄÔ, A¨ÜÃÜ PÜÅÊÜÞûÜÃܨæãí©Wæ ±Üä|ì EñܤÃÜÊÜ®Üá° ŸÃæÀáÄ
7×1=7
Four alternatives are given for each of the following questions /
incomplete statements. Choose the correct alternative and write the
complete answer along with its question number and alphabet :
1. PÜí±ÜäÂoÃ…®ÜÈÉ Óèív…ÕGíqÅ BÁáR¿á®Üá° D ¨æãàÐÜ EÙÜÛÊÜÃÜá ŸÙÜÓÜŸÖÜá¨ÝX¨æ
(A) ¨ÜêÑr (B) ÍÜÅÊÜ|
(C) Pæç®ÜvÜáPÜ (D) AÄ訆 ¨ÜáŸìÆñæ
Sounds entry option is designed in computers to help the users with
this impairment.
(A) vision (B) auditory
(C) hand tremors (D) cognitive
2. PæÉ„íp… ÊÜÂÊÜÓæ§Wæ ÓæàÊæWÜÙÜ®Üá° J¨ÜXÓÜáÊÜ PÜí±ÜäÂoÃ…WÜÙÜá
(A) PæÉ„íp… (B) ²2²
(C) ÓÜÊÜìÃ…Õ (D) ÊæçÊÜÞÂP…Õ
The computers that provide services to the client system are
(A) Client (B) P2P
(C) Servers (D) Wimax
RF/RR(A)-(200)-9101
Page 4
CCE RF & RR 3 86-EK (Level-2)
3. ±Üâo¨Ü Êæáà騆 »ÝWÜPæR ÓæàÄÓÜÆ³vÜáÊÜ ¨ÜÓÝ¤Êæài®Ü GÇÝÉ ±ÜâoWÜÙÜÆãÉ
±Üâ®ÜÃÝÊÜ£ìñÜÊÝWÜŸÖÜá¨Ý¨Ü ±ÜsÜ A¥ÜÊÝ bñÜÅ
(A) ±Üâo¨Ü PæÙÜWæ (B) ±Üâo¨Ü ÊæáàÇæ
(C) Aw q±Ü³~ (D) ÎÃæãàÇæàS
The text or image included at the top of the page which repeats in all
the pages of the document is
(A) page down (B) page up
(C) footer (D) header
4. ±æàh…¸æÅàP… BÁáR¿áá D pݸ…®ÜÈÉ Æ»ÜÂËÃÜáñܤ¨æ.
(A) Ãæ¶ÜÃæ®…ÕÓ…
(B) ±æàh… ÇæàLp…
(C) ÊÜäÂ
(D) ÄÊÜäÂ
Page break option is available in this tab.
(A) references
(B) page layout
(C) view
(D) review
RF/RR(A)-(200)-9101 [ Turn over
Page 5
86-EK (Level-2) 4 CCE RF & RR
5. D BÁáR¿á®Üá° BÁáR ÊÜÞw¨ÝWÜ, ÊÝPÜÂ¨Ü Êæã¨ÜÆ ±Ü¨Ü¨Ü Êæã¨ÜÆ AûÜÃÜÊÜâ ¨æãvÜx
AûÜÃÜPæR ( capital letter ) ±ÜÄÊÜñÜì®æ¿ÞWÜáñܤ¨æ
(A) Óæípæ®…Õ PæàÓ… (B) ÇæãàÊÜÃ… PæàÓ…
(C) PݲoÇæçh… Da… ÊÜv…ìPæàÓ… (D) aæàíh… PæàÓ…
On selecting which of the following, the first character in the first word
of the selected sentence will be converted to capital letter.
(A) Sentence case (B) Lower case
(C) Capitalize each word case (D) Change case
6. ËñÜÄñÜÖÝÙæ¿á ñÜíñÝÅíÍܨÜÈÉ C¨Üá wà¶ÝÇ…r ËàûÜOæ¿ÞXÃÜáñܤ¨æ
(A) ±æàh… ÇæàLp… ÊÜäÂ
(B) PÜÓÜrí ÊÜäÂ
(C) ®ÝÊÜáìÇ… ÊÜäÂ
(D) ¶ÜâÇ… Ôðà®… ÊÜäÂ
The default view in spreadsheet software is
(A) page layout view
(B) custom view
(C) normal view
(D) full screen view
RF/RR(A)-(200)-9101
Page 6
CCE RF & RR 5 86-EK (Level-2)
7. {¶æç®…Õ ®æàÊÜå…Õ WÜáí±Üâ D pݸ…®ÜÈÉ Æ»ÜÂ˨æ
(A) C®ÜÕp…ì
(B) Ãæ¶ÜÃæ®…ÕÓ…
(C) Öæãàí
(D) ¶ÝÊÜááìÆ
'Defines Names' group is available in this tab
(A) insert
(B) references
(C) home
(D) formula
II. 3×1=3
Fill in the blanks with suitable answer :
8. DSL ®Ü ËÓÜõñÜ ÃÜã±Ü .......................... .
Expanded form of DSL is ................... .
9. ¨ÜñݤíÍÜÊÜ®Üá° ÓÜÊÜá®Ý¨Ü WÝñÜÅ¨Ü ¹p…WÜÙÝX ËíWÜwÔÃÜáÊÜ ñÜá|áPÜáWÜÚWæ
.......................... G®Üá°ÊÜÃÜá.
The data is broken up into bits of same sized pieces are
called .......................... .
10. ÄÇæàÐÜ®ÜÇ… ¨ÜñݤíÍÜÊÜâ ŸÖÜá PæãàÐÜrPܨÜÈÉ ÓÜíWÜÅ×ÓÜÇÝWÜáÊÜâ¨Üá ¶ÝÉp… ........... .
Relational : Data is stored in multiple tables : : Flat : .................... .
RF/RR(A)-(200)-9101 [ Turn over
Page 7
86-EK (Level-2) 6 CCE RF & RR
III. 11. A- ËñÜÄñÜÖÝÙæ¿á PÝ¿áìWÜÙÜ®Üá° ÊÜáñÜᤠB- AÊÜâWÜÙÜ BÁáR¿á®Üá°
¯àvÜÇÝX¨æ.
4×1=4
Functions of spreadsheet is given in Column-A and their options
are given in Column-B. Match them and write answer with
alphabet :
A- B-
Column-A Column-B
i) ÓæÇ…WÜÙÜÈÉ®Ü ÊÜåèÆÂWÜÙÜ®Üá° ñÝÊÝXÁáà PÜãvÜáÊÜâ¨Üá a) pÝWÜÇ… PæàÓ…
Adding the values of cells automatically toggle case
ii) BÁáR¿ÞXÃÜáÊÜ ¨ÜñݤíÍÜÊÜ®Üá° hæãàwÓÜáÊÜâ¨Üá b) µÅàh… ±æà®…Õ
Arrange selected data freeze panes
iii) ¯WÜ©ñÜ ¨ÜñݤíÍÜÊÜ®Üá° ñæWæ¿ááÊÜâ¨Üá c) ¶Ýíp… Óæçh…
Extract particular data font size
iv) AvÜxÓÝÆá / PÜíŸÓÝÆá Ÿ¨ÜÇÝÊÜOæ¿ÞWܨæ CÃÜáÊÜâ¨Üá d) BpæãàÓÜÊÜå…
Row/column remains constant autosum
e) ±æàh… ¸æÅàP…
page break
f) ÓÝp…ì
sort
g) µÆrÃ…
filter
IV. 6×1=6
Answer the following questions :
12. WÜ|PÜ¿áíñÜÅ hÝÆ Gí¨ÜÃæà®Üá ?
What is computer network ?
RF/RR(A)-(200)-9101
Page 8
CCE RF & RR 7 86-EK (Level-2)
13. ±Ü¨ÜÓÜíÓÜRÃÜOæ¿á ñÜíñÝÅíÍܨÜÈÉ ¨ÜñÝ¤Êæàg®Üá° pæí±æÉàp… BX EÚÓÜáÊÜ ŸWæ¿á®Üá°
ŸÃæÀáÄ.
Write the procedure to save a document as template in word
processing software.
14. ±Ü¨ÜÓÜíÓÜRÃÜOæ¿á ñÜíñÝÅíÍܨÜÈÉ pÝWÜÇ… PæàÓ…®Ü ( toGGLE case ) PÝ¿áìÊæà®Üá
What is the function of toGGLE case in word processing software ?
15. ËñÜÄñÜÖÝÙæ¿á ñÜíñÝÅíÍܨÜÈÉ µÆrÃ… BÁáR¿á®Üá° HPæ ŸÙÜÓÜáñæ¤àÊæ ?
Why do we use filter option in spreadsheet software ?
16. ËñÜÄñÜÖÝÙæ¿á ñÜíñÝÅíÍܨÜÈÉ BpæãàÓÜÊÜå… BÁáR¿á®Üá° ŸÙÜÓÜáÊÜâ¨ÜÄí¨ÝWÜáÊÜ
A®ÜáPÜãÆñæWÜÙÜ®Üá° ŸÃæÀáÄ.
Write the advantages of using autosum in spreadsheet software.
17. ËñÜÄñÜÖÝÙæ¿áÈÉ, ÍæàÃ… ÊÜP…ìŸáP… BÁáR¿á WÜáí±Üâ ÊÜáñÜᤠpݸ… A®Üá° ÖæÓÜÄÔ.
Name the group and tab of share workbook option in spreadsheet.
V. 5 × 2 = 10
Answer the following questions :
18. EbñÜÊÝX Qɱ…Bp…ìWÜÙÜ®Üá° J¨ÜXÓÜáÊÜ ¿ÞÊÜâ¨Ý¨ÜÃÜã GÃÜvÜá hÝÆñÝ|ÊÜ®Üá°
ŸÃæÀáÄ.
Write any two websites that offer free clipart.
/OR
RF/RR(A)-(200)-9101 [ Turn over
Page 9
86-EK (Level-2) 8 CCE RF & RR
±Ü¨ÜÓÜíÓÜRÃÜOæ¿áÈÉ Qɱ…Bp…ìWÜÙÜ®Üá° ŸÙÜÓÜáÊÜâ¨ÜÄí¨Ü BWÜáÊÜ ¿ÞÊÜâ¨Ý¨ÜÃÜã GÃÜvÜá
A®ÜáPÜãÆWÜÙÜ®Üá° ŸÃæÀáÄ.
Write any two advantages of using clipart in a word document.
19. ËñÜÄñÜÖÝÙæ ñÜíñÝÅíÍܨÜÈÉ Æ»ÜÂËÃÜáÊÜ ¿ÞÊÜâ¨Ý¨ÜÃÜã ®ÝÆáR ŸWæ¿á aÝp…ìWÜÙÜ®Üá°
£ÚÔ.
Mention any four different chart types available in spreadsheet
software.
20. wioÇ… ±ÜÅÓÜᤣ ñÜíñÝÅíÍܨÜÈÉ (±ÜÅÓæípæàÍÜ®… Óݶ…rÊæàÃ…) ÊÜáãË ñÜá|áPÜ®Üá° Óæà±Üìvæ
ÊÜÞvÜáÊÜ ŸWæ¿á®Üá° ŸÃæÀáÄ.
Write the procedure to insert a movie clip into the digital presentation
software.
21. PÝÂÇæívÜÃ… ñÜíñÝÅíÍÜÊÜ®Üá° E±ÜÁãàXÔPæãívÜá PÝÂÇæívÜÃ… A®Üá° ÖÜíaÜáÊÜ ŸWæ¿á®Üá°
ËÊÜÄÔ.
Explain the procedure to share a calendar using calendar software.
/OR
PÝÂÇæívÜÃ… ñÜíñÝÅíÍܨÜÈÉ, PÝÂÇæívÜÃ… A®Üá° ÊÜáá©ÅÓÜáÊÜ ŸWæ¿á®Üá° ËÊÜÄÔ.
Explain the procedure to print a calendar in calendar software.
22. væàpݸæàÓ…®ÜÈÉ, pæàpÝ ÊÝÂTÝ娆 »ÝÐæ (væàpÝ v浯ÐÜ®… ÇÝíWæÌàh…) Gí¨ÜÃæà®Üá ?
væàpÝ v浯ÐÜ®… ÇÝíWæÌàh…®Ü (w.w.GÇ….) ÓÝÊÜÞ®ÜÂ Óæràp…Êæáíp…WÜÙÜ®Üá° ŸÃæÀáÄ :
What is Data Definition Language (DDL) in database ? Write common
Data Definition Language (DDL) statements.
RF/RR(A)-(200)-9101
Page 10
CCE RF & RR 9 86-EK (Level-2)
VI. 4 × 3 = 12
Answer the following questions :
23. ±Ü¨ÜÓÜíÓÜRÃÜOÝ ñÜíñÝÅÍܨÜÈÉ Æ»ÜÂËÃÜáÊÜ ¿ÞÊÜâ¨Ý¨ÜÃÜã BÃÜá ÊÜv…ì ÃݲíW… ( word
wrapping ) BÁáRWÜÙÜ®Üá° ±ÜqrÊÜÞw.
List any six word wrapping options available in a word processing
software.
24. ±ÜÅÓÜᤣ (±æÅÓæípæàÍÜ®…) ñÜíñÝÅíÍÜÊÜ®Üá° ŸÙÜÔ EñܤÊÜá ±ÜÅÓÜᤣ (±æÅÓæípæàÍÜ®…)
ñÜ¿ÞÄÓÜÆá ¸æàPÝ¨Ü ¿ÞÊÜâ¨Ý¨ÜÃÜã BÃÜá E±Ü¿ááPܤ ÓÜÆÖæWÜÙÜ®Üá° £ÚÔ.
Mention any six useful tips to make effective presentation using
presentation software.
/OR
±ÜÅÓÜᤣ (±æÅÓæípæàÍÜ®…)¿áÈÉ PæãàÐÜrPÜÊÜ®Üá° ÓæàÄÓÜáÊÜ GÃÜvÜá ŸWæWÜÙÜ®Üá° ŸÃæÀáÄ ÊÜáñÜá¤
±ÜÅÓÜᤣ¿áÈÉ PæãàÐÜrPÜÊÜ®Üá° ÓæàÄÓÜÆá ŸÙÜÓÜáÊÜ ¿ÞÊÜâ¨Ý¨ÜÃÜã Jí¨Üá ŸWæ¿á®Üá°
ËÊÜÄÔ.
Mention two ways to insert a table in presentation and explain any
one of these procedures to insert table in presentation.
25. PÝÂÇæívÜÃ… ñÜíñÝÅíÍܨÜÈÉ A±ÝÀáíp…Êæáíp… A®Üá° ñÜ¿ÞÄÓÜáÊÜ GÃÜvÜá ŸWæWÜÙÜ®Üá°
±ÜqrÊÜÞw ÊÜáñÜᤠAÊÜâWÜÙÜ®Üá° ËÊÜÄÔ.
List two ways to schedule an appointment in calender and explain
them.
26. ®ÜãÂÊÜáÄP… væàpÝpæç±…®ÜÈÉ Æ»ÜÂËÃÜáÊÜ ¿ÞÊÜâ¨Ý¨ÜÃÜã BÃÜá væàpÝpæç±…WÜÙÜ®Üá° £ÚÔ.
Mention any six data types available in numeric data types.
RF/RR(A)-(200)-9101 [ Turn over
Page 11
86-EK (Level-2) 10 CCE RF & RR
VII. 2×4=8
Answer the following questions :
27. ËñÜÄñÜÖÝÙæ¿á ñÜíñÝÅíÍܨÜÈÉ, PÜíwàÐÜ®ÜÇ… ¶ÝÊæáàìqíW… BÁáR¿á®Üá° ŸÙÜÓÜáÊÜ
ŸWæ¿á®Üá° ËÊÜÄÔ.
Explain the procedure to use conditional formatting option in
spreadsheet software.
28. væàpݸæàÓ…Wæ ÓÜíŸí˜Ô¨Üíñæ, D PæÙÜWæ ¯àwÃÜáÊÜ ±ÜÅÍæ°WÜÚWæ (PæÌÄàÓ…) ÓÝÊÜÞ®ÜÂ
ÓÜãñÜÅÊÜ®Üá° E¨ÝÖÜÃÜOæÓÜ×ñÜ ŸÃæÀáÄ :
(i) ÓæÇæP…r (ii) C®ÜÕp…ì
With reference to the database, write the syntax for the following
queries with an example :
(i) SELECT (ii) INSERT
/OR
væàpݸæàÓ…Wæ ÓÜíŸí˜Ô¨Üíñæ, D PæÙÜX®ÜÊÜâWÜÚWæ ÓÜíü±Ü¤ÊÝ¨Ü q±Ü³~¿á®Üá° ŸÃæÀáÄ :
(i) o±ÜÇ…Õ (ii) ±æùÊÜáÄ Qà
(iii) ¶ÝÄ®… Qà (iv) µàÇ…x$Õ
Write brief notes on the following related to database :
(i) Tuples (ii) Primary key
(iii) Foreign key (iv) Fields
RF/RR(A)-(200)-9101
Page 12
CCE RF & RR 11 86-EK (Level-2)
SECTION – B
I. Four alternatives are given for each of the following questions /
incomplete statements. Choose the correct alternative and write the
complete answer along with its question number and alphabet : 3 × 1 = 3
29. Identify an article in the following :
(A) beside (B) at
(C) an (D) and
30. Find the sentence that is in passive voice :
(A) The document had to be revised by Ravi
(B) Ravi has to revise this document
(C) Ravi will revise this document
(D) Ravi is revising this document
31. A word that links a noun or pronoun to other words in a sentence is
(A) article (B) connector
(C) conjunction (D) preposition
II. Fill in the blank with suitable word given in the brackets : 11=1
32. A document which is a summary of your skills, education and work
experience is ................... . ( resume, job accepting letter )
III. Answer the following question : 12=2
33. Mention any four terms and phrases for giving directions.
IV. Answer the following questions : 4×1=4
34. Fill in the blanks with the appropriate word given in the brackets.
i) We must reach the airport on time or else ............ will miss the
flight. ( we, us)
ii) The jeweler's store is right next .............. the bus stop. ( for, to )
iii) Oh! I think that's my bus .................... that red truck.
( behind, over )
iv) Walk .............. you reach the traffic point. ( till, before )
OR
i) I ................ moved to a new house. ( recently, daily )
ii) Now I, live ................... in the heart of Delhi.
( comfortable, comfortably )
iii) My house is a ................. two bedroom flat in Ashoknagar.
( spaceful, spacious )
iv) I live here with my ................friend Manish. ( best, better )
RF/RR(A)-(200)-9101 [ Turn over
Page 13
86-EK (Level-2) 12 CCE RF & RR
RF/RR(A)-(200)-9101