aglasem.com
Home Schools Admission Career Mock Test PDF Docs Playground
ClassChoose class
StateSelect state

CBSE Class 10 Information Technology Question Paper 2020

Download the CBSE Class 10 Information Technology Question Paper 2020 PDF for free at AglaSem. Solving this previous year question paper helps you understand the real CBSE Class 10 exam pattern, question types, difficulty level and marking scheme, and reveals important repeated topics — practise it to build speed, accuracy and exam confidence. More Detail
CBSE Class 10 Information Technology Question Paper 2020 - Page 1 of 11

Finished viewing? Save it for later —

Download CBSE Class 10 Information Technology Question Paper 2020 (PDF · 11 pages)
Downloaded 74 times

About CBSE Class 10 Information Technology Question Paper 2020

CBSE Class 10 Information Technology Question Paper 2020 is available here for free download. Published by CBSE for Class 10, this question paper can be viewed online or downloaded as a PDF (11 pages). Candidates preparing for Class 10 can use CBSE Class 10 Information Technology Question Paper 2020 to understand the exam pattern, the type of questions asked, and the overall difficulty level.

Frequently Asked Questions

How can I download CBSE Class 10 Information Technology Question Paper 2020?

Open this page and click the Download button to save CBSE Class 10 Information Technology Question Paper 2020 as a PDF. It is completely free on AglaSem Docs.

Is CBSE Class 10 Information Technology Question Paper 2020 free to download?

Yes. CBSE Class 10 Information Technology Question Paper 2020 can be viewed online and downloaded as a PDF free of cost on AglaSem Docs.

How many pages does CBSE Class 10 Information Technology Question Paper 2020 have?

CBSE Class 10 Information Technology Question Paper 2020 contains 11 pages, which you can read online or download together as a single PDF.

Where can I find more Class 10 study material?

You can find more Class 10 question papers, sample papers, syllabus, and answer keys on AglaSem Docs.

CBSE Class 10 Information Technology Question Paper 2020 – Text

Read the full text of this question paper below — useful to quickly search, copy and reference the content online without downloading the PDF.

📄 View text version (11 pages)

Page 1

H$moS> Z§.
Code No. 89
amob Z§. narjmWu H$moS >H$mo CÎma-nwpñVH$m Ho$ _wI-n¥ð
Roll No. >na Adí` {bIo§ &
Candidates must write the Code on the
title page of the answer-book.

ZmoQ> NOTE
(I) H¥$n`m Om±M H$a b| {H$ Bg àíZ-nÌ _o§ _w{ÐV (I) Please check that this question
n¥ð> 11 h¢ & paper contains 11 printed pages.

(II) àíZ-nÌ _| Xm{hZo hmW H$s Amoa {XE JE H$moS (II) Code number given on the right
>Zå~a H$mo N>mÌ CÎma-nwpñVH$m Ho$ _wI-n¥ð> na hand side of the question paper
{bI| & should be written on the title page of
the answer-book by the candidate.
(III) H¥$n`m Om±M H$a b| {H$ Bg àíZ-nÌ _| (III) Please check that this question
>39 àíZ h¢ & paper contains 39 questions.
(IV) H¥$n`m àíZ H$m CÎma {bIZm ewê$ H$aZo go (IV) Please write down the Serial
nhbo, CÎma-nwpñVH$m _| àíZ H$m H«$_m§H$ Number of the question in the
Adí` {bI| & answer-book before attempting it.
(V) Bg àíZ-nÌ H$mo n‹T>Zo Ho$ {bE 15 {_ZQ >H$m (V) 15 minute time has been allotted to
g_` {X`m J`m h¡ & àíZ-nÌ H$m {dVaU read this question paper. The
nydm©• _| 10.15 ~Oo {H$`m OmEJm & question paper will be distributed
10.15 ~Oo go 10.30 ~Oo VH$ N>mÌ Ho$db at 10.15 a.m. From 10.15 a.m. to
10.30 a.m., the students will read the
àíZ-nÌ H$mo n‹T>|Jo Am¡a Bg Ad{Y Ho$ Xm¡amZ question paper only and will not
do CÎma-nwpñVH$m na H$moB© CÎma Zht {bI|Jo & write any answer on the
answer-book during this period.

gyMZm àm¡Úmo{JH$s
INFORMATION TECHNOLOGY

{ZYm©[aV g_` : 2 KÊQ>o A{YH$V_ A§H$ : 50
Time allowed : 2 hours Maximum Marks : 50

.89 1 P.T.O.

Page 2

gm_mÝ` {ZX}e :
{ZåZ{b{IV {ZX}em| H$mo ~hþV gmdYmZr go n{‹T>E Am¡a CZH$m g™Vr go nmbZ H$s{OE :
(a) Bg àíZ-nÌ _| Xmo IÊS> h¢ — IÊS> H$ … amoµOJma H$m¡eb Am¡a IÊS> I … {df` H$m¡eb &
(b) IÊS> H$ … amoµOJma H$m¡eb (10 A§H$)
(i) {XE JE 6 àíZm| _| go {H$Ýht 4 àíZm| Ho$ CÎma Xr{OE & àË`oH$ àíZ 1 A§H$ H$m h¡ &
(ii) {XE JE 5 àíZm| _| go {H$Ýht 3 àíZm| Ho$ CÎma Xr{OE & àË`oH$ àíZ 2 A§H$ H$m h¡ &
(c) IÊS> I … {df` H$m¡eb (40 A§H$)
(i) {XE JE 12 àíZm| _| go {H$Ýht 10 àíZm| Ho$ CÎma Xr{OE & àË`oH$ àíZ 1 A§H$ H$m h¡ &
(ii) {XE JE 6 àíZm| _| go {H$Ýht 4 àíZm| Ho$ CÎma Xr{OE & àË`oH$ àíZ 2 A§H$ H$m h¡ &
(iii) {XE JE 6 àíZm| _| go {H$Ýht 4 àíZm| Ho$ CÎma Xr{OE & àË`oH$ àíZ 3 A§H$ H$m h¡ &
(iv) {XE JE 4 àíZm| _| go {H$Ýht 2 àíZm| Ho$ CÎma Xr{OE & àË`oH$ àíZ 5 A§H$ H$m h¡ &
(d) Bg àíZ-nÌ _| 39 àíZ em{_b h¢ {OZ_| go 27 àíZm| Ho$ CÎma XoZo h¢ &
(e) g^r àíZm| Ho$ {deof ^mJ/IÊS> H$mo ghr H«$_ _| H$s{OE &
(f) A{YH$V_ g_` 2 K§Q>o h¡ &
IÊS> H$
(amoOJma H$m¡eb) (10 A§H$)
{XE JE 6 àíZm| ‘| go {H$Ýht 4 àíZm| Ho$ CÎma Xr{OE & à˶oH$ àíZ 1 A§H$ H$m h¡ & 14=4
1. ___________ eãXm| Ho$ do g_yh h¢ Omo ~mobr Ho$ EH$ VÎd Ho$ g§àofU Ho$ {bE EH$ gmW
H$m_ H$aVo h¢ & 1
2. ___________ H$m g§~§Y X~mdnyU© n[apñW{V`m| H$m ~ohVa gm_Zm H$aZo Ho$ {bE eara Am¡a
_Z H$mo ñdñW ~ZmE aIVo hþE _mZd à`mgm| na Ü`mZ H|${ÐV H$aZm h¡ & 1
3. AnZo hr AmË_, j_VmAm|, ^mdZmAm| Am¡a AnZo M[aÌ Ho$ gMoV kmZ hmoZo H$mo __________
H$hm OmVm h¡ & 1
4. ___________ EH$ gm°âQ>do`a h¡ Omo {H$gr H$åß`yQ>a na Q>oŠñQ> H$mo Q>mBn H$aZo Am¡a Cg na
H$m_ H$aZo _| ghm`Vm XoVm h¡ & (dS>© àmogoga/ñàoS>erQ>/H¡$ëHw$boQ>a) 1

5. CÚ_r amoOJma Ty>±‹T>Zo dmbo Zht hmoVo, qH$Vw do bmoJm| Ho$ {bE amoOJma Ho$ Adgam| H$m g¥OZ
H$aVo h¢ & (gË`/AgË`) 1
6. ___________ h[aV AW©ì`dñWm H$mo Bg ê$n _| n[a^m{fV H$aVm h¡ {OgHo$ n[aUm_ñdê$n
‘‘_mZd H$ë`mU Am¡a gm_m{OH$ g_Vm _| gwYma hmoVm h¡ Am¡a gmW-hr-gmW n`m©daUr` IVao
VWm nm[apñW{VH$ A^md H$_ hmoVo h¢’’ & 1

.89 2

Page 3

General Instructions :
Read the following instructions very carefully and strictly follow them :
(a) This question paper consists of two sections viz. Section A : Employability
Skills and Section B : Subject Skills.
(b) Section A : Employability Skills (10 Marks)
(i) Answer any 4 questions out of the given 6 questions of 1 mark each.
(ii) Answer any 3 questions out of the given 5 questions of 2 marks each.
(c) Section B : Subject Skills (40 Marks)
(i) Answer any 10 questions out of the given 12 questions of 1 mark each.
(ii) Answer any 4 questions out of the given 6 questions of 2 marks each.
(iii) Answer any 4 questions out of the given 6 questions of 3 marks each.
(iv) Answer any 2 questions out of the given 4 questions of 5 marks each.
(d) This question paper contains 39 questions out of which 27 questions are to be
answered.
(e) All questions of a particular part/section must be attempted in the correct
order.
(f) The maximum time allowed is 2 hours.

SECTION A
(Employability Skills) (10 Marks)

Answer any 4 questions out of the given 6 questions of 1 mark each : 14=4

1. __________ are a group of words that work together to communicate an
element of speech. 1

2. __________ refers to focusing human efforts for maintaining a healthy
body and mind capable of better withstanding stressful situations. 1

3. Having conscious knowledge of your own self, capabilities, feelings and
one’s own character is called as __________ . 1

4. A __________ is a software that helps you type and work with text on a
computer. (word processor / spreadsheet / calculator) 1

5. Entrepreneurs are not job seekers but they create opportunities of
employment for people. (True/False) 1

6. __________ defines a Green economy as one that results in ‘‘improved
human well-being and social equity, while significantly reducing
environmental risks and ecological scarcities’’. 1

.89 3 P.T.O.

Page 4

{XE JE 5 àíZm| ‘| go {H$Ýht 3 àíZm| Ho$ CÎma Xr{OE & à˶oH$ àíZ 2 A§H$ H$m h¡ & 23=6

7. A§J«oµOr Ho$ Mma àH$ma Ho$ dmŠ`m| H$mo g_PmBE & 2

8. CÚ{_Vm H$s {H$Ýht Mma {deofVmAm| H$s gyMr ~ZmBE & 2

9. AmonZAm°{\$g amBQ>a _| Q>oŠñQ> H$mo hmBbmBQ> H$aZo Ho$ gmonmZm| H$mo {b{IE & 2

10. AmË_-{dídmg H$mo à^m{dV H$aZo dmbo {H$Ýht Mma H$maH$m| H$s gyMr ~ZmBE & 2

11. nm[apñW{VH$ Ag§VwbZ ~ZmZo dmbo Mma H$maH$m| H$s gyMr ~ZmBE & 2

IÊS> I
({df¶ H$m¡eb) (40 A§H$)
{XE JE 12 àíZm| ‘| go {H$Ýht 10 àíZm| Ho$ CÎma Xr{OE & à˶oH$ àíZ 1 A§H$ H$m h¡ & 110=10

12. O~ hmS>©do`a Am¡a gm°âQ>do`a H$m EH$ g_m`moOZ {H$gr j{V `m Aj_Vm dmbo ì`{º$ H$mo
H$åß`yQ>a Ho$ Cn`moJ _| gj_ ~ZmVm h¡, Vmo `h H$hbmVm h¡ 1
(A) `m§{ÌH$ ghm`Vm
(B) {ZíM`mË_H$Vm
(C) ghm`H$ VH$ZrH$s
(D) ghm`Vm Am¡a g§àofU
13. AmnHo$ H$s-~moS>©, {S>ñßbo `m _mCg \§$ŠeZ H$mo H$ñQ>_mBµO H$aZo Ho$ {bE H§$Q´>mob n¡Zb na
___________ H$m Cn`moJ {H$`m OmVm h¡ & 1

14. {nŠMa Am¡a pŠbnAmQ>© ___________ Ho$ A§VJ©V CnbãY {dH$ën h¢ & 1

15. B§gQ>© Q>¡~ _| ___________ J«wn Ho$ A§VJ©V hoS>a H$m {dH$ën hmoVm h¡ & 1

16. ñno«S>erQ> na MwZr hþB© g§»`mAm| H$m `moJ H$aZo Ho$ {bE CnbãY àH$m`m] (\§$ŠeÝg) _| go EH$
h¡ __________ & 1

17. Am°Q>mog_ gobm| Ho$ Mmam| Amoa _yë`m| (d¡ë`yg) H$m MwZmd _________ AWdm _________
ñd`§ H$aVm h¡ & 1

18. hmo_ Q>¡~ _| bo-AmCQ> H$m {dH$ën ___________ g_yh Ho$ A§VJ©V hmoVm h¡ & 1
.89 4

Page 5

Answer any 3 questions out of the given 5 questions of 2 marks each : 23=6

7. Explain four types of sentences in English. 2

8. List any four characteristics of entrepreneurship. 2

9. Write steps to highlight text in an OpenOffice Writer. 2

10. List any two factors that affect self-confidence. 2

11. List any four factors causing ecological imbalance. 2

SECTION B
(Subject Skills) (40 Marks)

Answer any 10 questions out of the given 12 questions of 1 mark each : 110=10

12. When a combination of hardware and software enables a person with a
disability or impairment to use a computer, it is known as 1
(A) Mechanical assistance
(B) Assertiveness
(C) Assistive Technology
(D) Assistance and communication

13. __________ in Control Panel are used to customize the way your
keyboard, display, or mouse function. 1

14. Picture and Clipart options are available under __________ . 1

15. Header option is available under __________ group in Insert Tab. 1

16. __________ is one of the functions available in the spreadsheet to perform
addition of selected numbers in the sheet. 1

17. Autosum automatically selects the values around the cells either _______
or __________ . 1

18. Layout option is available under __________ group in the Home tab. 1
.89 5 P.T.O.

Page 6

19. àoO|Q>oeZ gm°âQ>do`a ___________ S>mQ>m H$mo gmW©H$ ê$n go àñVwV H$aZo Ho$ {bE Cn`moJH$Vm©
H$mo ñbmBS>m| _| Q>o~b| bJmZo Ho$ {bE gj_ ~ZmVm h¡ & 1
20. g_` {Z`moOZ gwì`dpñWV ~Zo ahZo H$s `moOZm ~ZmZo H$m H$m`© h¡ {OgHo$ n[aUm_ñdê$n
___________ VWm __________ _| d¥{Õ hmoJr & 1
21. ___________ Anm°B§Q>_|Q²>g H$m Cn`moJ Amd¥{Îm_ybH$ H$m`m] H$mo {Z`V H$aZo Ho$ {bE {H$`m
Om gH$Vm h¡ & 1
22. ___________ ñQ>oQ>_|Q> H$m Cn`moJ S>mQ>m~og _| EH$ `m A{YH$ [aH$m°S>© Omo‹S>Zo Ho$ {bE {H$`m
OmVm h¡ & 1
23. ___________ ñQ>oQ>_|Q> EH$ `m A{YH$ S>mQ>m~og Q>o~bm| go eyÝ` `m A{YH$ n§{º$`m| H$mo nwZ:
àmá H$a boVm h¡ & 1

{XE JE 6 àíZm| ‘| go {H$Ýht 4 àíZm| Ho$ CÎma Xr{OE & à˶oH$ àíZ 2 A§H$ H$m h¡ & 24=8
24. ãbm°J H$mo g_PmBE & {H$Ýht Xmo do~gmBQ>m| Ho$ Zm_ {b{IE Omo ãbm°J godm {Z:ewëH$ àXmZ
H$aVr h¢ & 2

25. hoS>a E[a`m _| Omo‹S>o Om gH$Zo dmbo {H$Ýht Mma _Xm| (AmBQ>åg) H$s gyMr ~ZmBE & 2

26. {H$Ýht Xmo pñW{V`m|/\$m°_}Q>/AmBQ>åg H$s gyMr ~ZmBE {OZH$m Cn`moJ ñàoS>erQ> _| H§$S>reZb
\$m°_}qQ>J Ho$ {bE hmo gH$Vm h¡ &> 2

27. Xmo {d{Y`m| H$m C„oI H$s{OE {OZgo àñVw{V (àoO|Q>oeZ) _| _ydr µ\$mBbm| H$mo {Z{dï> (B§gQ>}S>)
{H$`m Om gH$Vm h¡ & 2

28. {H$gr Anm°B§Q>_|Q> H$mo {Z`V H$aZo Ho$ {bE Xmo {d{Y`m± {b{IE & 2

29. S>mQ>m~og _| S>mQ>m {Z{_©V H$aZo Am¡a Cgo n[aMm{bV H$aZo Ho$ {bE H$m_ _| bmB© OmZo dmbr Xmo
àH$ma H$s ^mfmAm| H$mo g_PmBE & 2

{XE JE 6 àíZm| ‘| go {H$Ýht 4 àíZm| Ho$ CÎma Xr{OE & à˶oH$ àíZ 3 A§H$ H$m h¡ & 34=12
30. goŠeZ ~«oH$ Š`m hmoVo h¢ ? {H$gr S>m°Š`y_|Q> Ho$ ñdê$nU (\$m°_}qQ>J) _| goŠeZ ~o«H$ H¡$go
ghm`H$ hmoVo h¢ ? 3

31. {H$gr S>m°Š`y_|Q> Ho$ qbqH$J Am¡a E§~oqS>J _| A§Va ñnï> H$s{OE & Š`m {H$gr dñVw (Am°ãOoŠQ>)
H$s Eå~oqS>J go S>m°Š`y_|Q> H$m AmH$ma ~‹T> OmVm h¡ ? Xmo do~gmBQ>m| Ho$ Zm_ {b{IE Omo
{Z:ewëH$ pŠbnAmQ>© àXmZ H$aVr h¢ & 3

32. àñVw{V (àoO|Q>oeZ) _| MmQ>© Ho$ VrZ AmYma^yV {Xem-{ZX}em| (JmBS>bmBZg) H$m C„oI
H$s{OE & 3
.89 6

Page 7

19. Presentation software enables the user to add tables in the slides in order
to represent the __________ data meaningfully. 1

20. Time management is the act of planning to stay organized that will result
in increased __________ and __________ . 1

21. __________ appointments can be used for scheduling repetitive tasks. 1

22. __________ statement is used to add one or more records to a database. 1

23. __________ statement retrieves zero or more rows from one or more
database tables. 1

Answer any 4 questions out of the given 6 questions of 2 marks each : 24=8

24. Explain Blog. Give any two websites that offer free blog services. 2

25. List any four items that may be added in the Header area. 2

26. List any two conditions/formats/items that can be used for conditional
formatting in a Spreadsheet. 2

27. Mention two ways in which a movie file may be inserted in a
presentation. 2

28. Mention two ways of scheduling an appointment. 2

29. Explain two types of languages used for creating and manipulating the
data in databases. 2

Answer any 4 questions out of the given 6 questions of 3 marks each : 34=12

30. What are section breaks ? Explain how a section break helps in
formatting a document. 3

31. Differentiate between linking and embedding a document. Does
embedding an object increase the size of the document ? List any two
websites that offer free clipart. 3

32. Give any three basic guidelines for charts in a presentation. 3

.89 7 P.T.O.

Page 8

33. no«O|Q>oeZ gm°âQ>do`a _| g§H«$_U à^md (Q´>m§OreZ B\¡$ŠQ>) XoZo Ho$ gmonmZ {b{IE & 3

34. AmonZAm°{\$g ~og Ho$ {H$Ýht 3 S>mQ>m àH$mam| H$mo g_PmBE & 3

35. S>mQ>m~og Ho$ g§~§Y _§o {ZåZ{b{IV H$mo ñnï> H$s{OE : 3
(a) \$m°åg©
(b) [anmoQ>©
(c) Q>o~b

{XE JE 4 àíZm| ‘| go {H$Ýht 2 àíZm| Ho$ CÎma Xr{OE & à˶oH$ àíZ 5 A§H$ H$m h¡ & 52=10

36. (a) H$åß`yQ>a Ho$ Cn`moJ H$mo à^m{dV H$aZo dmbr {H$Ýht VrZ àH$mam| H$s j{V`m|
(B§no`a_|Q>) H$mo g_PmBE &
(b) ŠbmB§Q>-gd©a AmH$s©Q>oŠMa VWm {n`a-Qw>-{n`a AmH$s©Q>oŠMa H$mo g_PmBE & 5

37. {ZåZ{b{IV ñàoS>erQ> Ho$ AmYma na (a) go (e) Ho$ {bE Cn`wº$ \$m°_w©bm/EŠgàoeZ/\§$ŠeZ
Xr{OE : 5

A B C D E F G H
1 {V_mhr {~H«$s [anmoQ>©
OZdar- OwbmB©- AŠQy>~a- Hw$b
2 joÌ Aà¡b-OyZ
_mM© {gVå~a {Xgå~a `moJ
3 CÎmar 500 420 290 400
4 npíM_r 150 130 400 250
5 nydu 400 270 320 350
6 X{jUr 540 530 457 380
7

(a) CÎmar joÌ H$s Hw$b {~H«$s H$s JUZm Ho$ {bE \$m°_w©bm {b{IE &
(b) {~H«$s H$mo Ý`yZV_ go CƒV_ VH$ ì`dpñWV H$aZo Ho$ {bE \$sMa {b{IE &
(c) nydu joÌ H$s A{YH$V_ {~H«$s kmV H$aZo Ho$ {bE &
(d) gob C7 _| OZ-_mM© H$s Am¡gV {~H«$s _mby_ H$aZo Ho$ {bE &
(e) Aà¡b-OyZ _| nydu joÌ Am¡a npíM_r joÌ _| {~H«$s _| A§Va _mby_ H$aZo Ho$ {bE &
.89 8

Page 9

33. Write steps to give transition effects in a presentation software. 3

34. Explain any thee data types in OpenOffice base. 3

35. Explain the following with respect to Databases : 3
(a) Forms
(b) Reports
(c) Table

Answer any 2 questions out of the given 4 questions of 5 marks each : 52=10

36. (a) Explain any three types of impairments that impact computer
usage.
(b) Explain Client-Server architecture and Peer-to-Peer Architecture. 5

37. Given the following Spreadsheet, write the appropriate Formula/
Expression/Function to be used for (a) to (e) : 5

A B C D E F G H
1 Quarterly sales report
2 Zone Jan-Mar Apr-Jun Jul-Sep Oct-Dec Total
3 North 500 420 290 400
4 West 150 130 400 250
5 East 400 270 320 350
6 South 540 530 457 380
7

(a) Write the formula to calculate the Total sales of North Zone.
(b) Write the feature used for arranging the Sales from Lowest to the
Highest.
(c) To find the Maximum Sales in East Zone.
(d) To find the Average Sales in Jan-Mar in cell C7.

(e) To find the difference between the sales in East Zone and West
Zone in Apr-Jun.

.89 9 P.T.O.

Page 10

38. am{eH$m dm{f©H$ {~H«$s H$s [anmoQ>© VWm AnZr joÌr` Q>r_m| Ho$ Ûmam H$s JB© àJ{V H$m EH$
no«O|Q>oeZ V¡`ma H$a ahr h¡ & Cgo AnZo àoO|Q>oeZ _| {ZåZ{b{IV H$aZm h¡ & Eogm H$aZo Ho$ {bE
Cn`wº$ Cnm`m| H$m gwPmd Xr{OE & 5

(a) dh {~H«$s S>mQ>m H$mo {MÌ Ho$ ê$n _| ({nŠQ>mo[a`b \$m°_©) àX{e©V H$aZm MmhVr h¡ &
S>mQ>m H$s VwbZm Ho$ {bE Cgo {H$g Qy>b/{dH$ën H$m Cn`moJ H$aZm Mm{hE ?
(b) O~ ^r ñbmBS> ~Xbo Vmo dh Hw$N> à^md (B\¡$ŠQ>) XoZm MmhVr h¡ & dh Eogm H¡$go
H$a gH$Vr h¡ ?
(c) Cgo EH$ Q>o~b àX{e©V H$aZr h¡ Omo CgH$s ñbmBS> na ñno«S>erQ> _| ~Zr hmo &
(d) dh qàQ>AmCQ> Bg àH$ma boZm MmhVr h¡ {H$ Ho$db {df`-gm_J«r (Q>oŠgMwAb
H$m°ÝQ>|Q>) dmbo n¥îR> na EH$ go A{YH$ ñbmBS>| _w{ÐV hm| &
(e) àoO|Q>oeZ ~ZmZo Ho$ {bE Cgo EH$ A{V[aº$ {Xem-{ZX}e Xr{OE &

39. (a) EMPLOYEE Q>o~b ~ZmBE 2
EMPID Char(4)
EMPNAME Varchar(15)
DESIGN Varchar(20)
SALARY Decimal

(b) àmB_ar Hw§$Or Š`m h¡ ? 1

(c) {ZåZ{b{IV AmXoem| H$s DDL Am¡a DML Ho$ ê$n _| H$mo{Q>`m± ~ZmBE : 2
SELECT, ALTER, INSERT, DROP

.89 10

Page 11

38. Rashika is preparing a presentation to give an annual sales report and
the progress made by her zonal teams. She has to do the following in the
presentation. Suggest appropriate measures to do so. 5

(a) She wants to show the sales data in a pictorial form. Which
tool/option should she use to compare the data ?

(b) She wants to give some effect whenever the slide changes. How can
she do this ?
(c) She has to show a table created in spreadsheet on her slide.

(d) She wants to take printouts such that more than one slide is
printed on the page having only textual content.

(e) Give her an additional guideline for preparing a presentation.

39. (a) Create table EMPLOYEE 2
EMPID Char(4)
EMPNAME Varchar(15)
DESIGN Varchar(20)
SALARY Decimal

(b) What is a primary key ? 1

(c) Categorize the following commands as DDL and DML : 2
SELECT, ALTER, INSERT, DROP

.89 11 P.T.O.

Document Details

Board / OrgCBSE
ExamClass 10
TypeQuestion Paper
Pages11
Updated22 Jul 2026