MP Board Class 12 Question Paper 2020 for Informatic Practices

Serial Number
1- . E-814 Roll No.
•liff"
....,, -
Higher Secondary Examination (Regular) - 2020

4.441 th if d ti

INFORMATICS PRACTICES
(Hindi & English Versions)

Total Total Printed Time : Maximum
Questions : 18 Pages : 8 3 Hours Marks : 70

(i) 41-itSEA T 3T1 4r4 4 60 %I
(ii) sbilicb 1 # 4 dcb fttZ rcr-aT -51- p - 5 3 TtI
(iii) 779 viict) 5 # 7 doh 31P . fqq 2 eif I -ctt err wriTTr
30 t I
(iv) 7P9 Vilcb 8A" 10 II) -Ckn. 9-Wf raq 3 3i "F4zTiftU t 13zit #(1:11--7.F3-17T
75 Pitsq I
(v) 31P9' ZI-lict) 11 4 15 dcb 949. fo-q 4 3t"" -c-R err car
120 PiGq % I
(vi) 7P9. Zi-lict) 16 4 18 dcb > 9-P9 fo7 5 3 f I 3-clt 4)91 WEI-PT
150 i(sq t I
(vii) sbl-lich 5# 18 cich 311 c f"4"7:1 fk4 Tfq t I

Instructions :
(i) All questions are compulsory to solve.
(ii) Question Nos. 1 to 4 are objective type questions. Each question is allotted
5 marks.
(iii) Question Nos. 5 to 7 carry 2 marks each. Answer word limit is 30 words.
(iv) Question Nos. 8 to 10 carry 3 marks each. Answer word limit is .75 words.
(v) Question Nos. 1.1 to 15 carry 4 marks each. Answer word limit is 120 words.
(vi) Question Nos. 16 to 18 carry 5 marks each. Answer word limit is 150 words.
(vii) Internal options are given in Question Nos. 5 to 18.

151 / E-8 1 4 1 11111111 1111111111111111111 111111111111111 11111IIIIIIII P.T.O.

1d tr Ter 1.oidet) foitrg 5
(31) SIT T (modem) 9Pi t
— 4-111c;e.
(ii) Tr*p1-9- —

(iii) 9isj;eJ — it-75P•19-
(iv) 31:14-or
'TT cto t t —
(i) J Dialog (ii) J Frame
(iii) J Panel (iv) J Button
(i) tLl t cb t; faq ft-
A-4 *Ur ci14P1-ff cht t

(1)vLI dI44

(iii) (iv) GI

(() D.B.M.S. ctql ?
(i) \111).-L fkgrr (ii) A7 itRZIT
4-4-

(iii) 51LI ftcRZI:T (iv) ct)

() E-governance t term if NIC •wi full-form *41 ?

-P1-1C1 (ii) -ncio
(iii) (iv) Ai-tcri

Choose the correct alternatives and write in your answer book :
(A) The full name of the modem :
(i) Modulator — D modulator
(ii) Modulation — D Modulation
(iii) Mopdulator — Discussion
(iv) All of the above
(B) This is used to initiate an action when it is clicked :
(i) J Dialog (ii) J Frame
(iii) J Panel (iv) J Button

151 / E-814 2 1111111 I I 11111111ii i 1110 1111 1 11111 11111 I I I I I I I I I I I I I RT.°.

Reserved memory locations to store values is called -
(i) Data types (ii) Constant
(iii) Class (iv) Variables
What is D.B.M.S. ?
(i) Database Management System
(ii) Database Manager System
(iii) Data Manage System
(iv) None of these
What is the full form of the NIC in E-governance term ?
(i) National Information Center
(ii) Novel Industrial Center
(iii) Nodal Industrial Center
(iv) National Industrial Center

2 ft—or -mr9): 4 TO *rit-4 :
d -Fcr 4 91 w-Rr
(ii) ch. Q,ct) 51di
(iii) 91'1(1) ITIETT t

(iv) cl.) err *-z-r-ku fkg cwilu5

(v) RiZlem wrrd 1I 1lI 1 cn w( c I3[1.-Tr1 Td- wdtti

dill in the following blanks :
(i) Network speed is measured as
(ii) Class is a data type.
is the standard language for the web page.
1117v) To create a new database command is used.
(v) The digital revolutions affect the on social level.

51 / E-8 1 4 3 1111111111111111111111IIIIII1111 II III 11111 1111111111111 P.T.O.

3 Tier rd
"3i" 4V 7
(i) tRitt (a) 4- 14,10-141 3-1711.
(ii) \AN! (b) trir
(iii) cbci 1-1150 (c) ZFA7

(iv) e.Licri (d) yle..lcbto

(v) bre. (e) .) adz 417 7c tii~ t4
(f)
(a)
Match the following pairs :
,,B,,

(i) TCP (a) Programming language
(ii) Java (b) A row of table
(iii) Hierarchical model (c) User
(iv) Tuple (d) Protocol
(v) Front end (e) One parent and many children
(f) FLOAT

4 .) clice4 \-(1(e-
A-F3i :
(i) ctql t ?
(ii) JDK VCrl 4,14 fkitr4

(iii) ct)(ci-w•ff ct ce-11 c1 ?
(iv) fr Lil<t-p-rff 4 t-R_«41 rfit5(tb--fff cblvi I wild! ? CD

(v) 14c1I-lcb1Lcb11-1., 4'1 t ?
Answer in one sentence :
(i) What is protocol ?
(ii) Write the full form of JDK.
(iii) What do we say to collection of field ?
(iv) Which function helps to find any number of the remainder ?
(v) Which website is Flipkart.com ?

151 / E-8 1 4 4 HINDI 111 111111 1111131111 MEDIAE P.T.O.

5 Chl t-14-1 i4 I
E lain the wireless network.

,4t14T / OR

fOitR I

e any two advantages of open source software.

Whit are identifiers ?
4 aTtrgt / OR

47 *ftR1 .di).-e. 4 3T----( foit7 I

II difference between Break statement and Continue statement.
Wrie

ae,

7 M QL FLOAT ak DOUBLE efiri foitm
D. rentiate between FLOAT and DOUBLE of MYSQL.

ariT / OR
atff kftAz Wftr7

Direntiate between primary key and candidate key.

8 clr-. el t cf-cl t ill fli-i*ii etl-T TErk ycbt( -fkkg I 3
Exp.
Expin the java control structure and write its types.

TT /OR

z.-14k41 cb) fli-ii44 Wk 54c4)1( fffitfq I

Explain the inheritance and write its types.

151 / E-8 1 4 •5 1111111111110111111 11E111 1111111111111111 P.T.o.

1

9 -I 4-115t1iT1-14-$4 - t? -&=rk ch
31-rct mil- foftR
What do you mean by network model ? Write its any three advantages.
3-1"1 / OR

1.1 -1 criNd 3qlt :1-1167 :

(i) SIGN ( )
(ii) TRUNCAT ( )
(iii) POWER ( )
Explain the following functions with an example :
(i) SIGN ( )
(ii) TRUNCAT ( )
(iii) POWER ( )

ciNd .ffro. : 3
10
(i) 74ra
7ernz
(iii) Rc4fffefiT
Explain the following with example :
(i) Entity
(ii) Attribute
(iii) Relationship
171 / OR
311

(i)
(ii) t-447
(iii)
Explain the following :
(i) E-governance
(ii) E-learning •
(iii) E-commerce

151 / E-814 .6 I1111111111111111111111111111111II I I 11111111 1111 I I P.T.O.

11 f mull( ? Tt=rk WIT foitm
many types of Networks are there ? Write its advantages.
3T T /OR
f4 sttt t old ? w()- TA- ikfkrq
w many are types of computer virus ? Write its disadvantages.

12 HTML ‘3-il-g-T f4z c4 syntex .11-1-11Z I

Explain Ordered list with syntex in HTML.
zTerm / OR
HTML ti4-isii4
Explain font tag in HTML.

13 My SQL 4 fWrisr-d-rq foftrq
Write features of My SQL.
aTemi / OR
,i\))ct-P.T9- q ACID vrtre
t-ii-14-1
Explain ACID properties of a transaction.

14 MYSQL TIT'R th-4PT9 ct
Explain Aggregate function with its type in MYSQL.
ZPIT / OR
f c ? Tfrk 1;rWrT 'PAR I
What is Join ? Write its types.

15 w-fivi 4 ICT ticbioricb Wi-TT4 iftr7
Write the positive impact of ICT in society.
ZTP441 / OR

E-P4TT t 9-Fr fo-N7
Write the advantages of E-learning and mention the names of two
E-learning websites.

151 / E-814
I I 11111111 111111 I I I I I I I I I I I I I 11111111 I I P.T.o.

tii-tz.1I 5
16 ..e.t;e. fdir IT
---
Explain various security-threats of internet.
zr-r4T / OR

te.R e)(AW zi-f &ro-ty:t ? •kr,trr -cr4 Ttlzit f4N17 1
What do you mean by Star Topology ? Write its advantages and
disadvantages.

f40-q-a-rq foitrq 5
17 alTOTZ drfk-t -
Write the features of object oriented programming.
314-41 / OR

quell .A.ai-T 4)ti krE 44T'- 4R aTcrT 4>ki kri
rfo Wtrq
Write lower case string method and upper case string method with
example and syntex in Java.

? EN faiti7 5
18 /07 re69 qzfr
What is menu-driven user interface ? Write its advantages.
arm / OR
CID
SDLC
Explain SDLC.

151 E-814 8 111111111110111111111111111111111111111111111111