Page 1
RAJASTHAN BOARD
QUESTION
PAPER
2025
ANNUAL EXAMINATION
Download PDF
Page 2
Zm_m§H$ Roll No.
Tear Here
Sl.No. :
No. of Questions – 18
SS–04–Info. Prac. (Opt.)
No. of Printed Pages – 15
Cƒ _mÜ`{_H$ narjm, 2025
SENIOR SECONDARY EXAMINATION, 2025
TEAR HERE TO OPEN THE QUESTION PAPER
BÝ’$m°a‘o{Q>³g n«¡p³Q>gog
INFORMATICS PRACTICES
EopÀN>H$ (Optional)
àíZ nÌ H$mo ImobZo Ho$ {bE `hm± \$m‹S>|
g_` : 3 KÊQ>o 15 {‘{ZQ>
nyUmªH$ : 56
narjm{W©`m| Ho$ {bE gm_mÝ` {ZX}e :
GENERAL INSTRUCTIONS TO THE EXAMINEES :
1) narjmWu gd©àW_ AnZo àíZ nÌ na Zm_m§H$ A{Zdm`©V… {bI|&
Candidate must write first his / her Roll No. on the question paper
compulsorily.
2) g^r àíZ H$aZo A{Zdm`© h¢&
All the questions are compulsory.
3) àË`oH$ àíZ H$m CÎma Xr JB© CÎma-nwpñVH$m _| hr {bI|&
Write the answer to each question in the given answer-book only.
`hm± go H$m{Q>E
SS–04–Info. Prac. (Opt.) 7004 [ Turn Over
Page 3
2
4) {OZ àíZm| ‘| AmÝV[aH$ IÊS> h¢, CZ g^r Ho$ CÎma EH$ gmW hr {bI|&
For questions having more than one part, the answers to those parts are to be
written together in continuity.
5) àíZ nÌ Ho$ {hÝXr d A§J«oOr ê$nmÝVa ‘| {H$gr àH$ma H$s Ìw{Q>/AÝVa/{damoYm^mg hmoZo na {hÝXr ^mfm Ho$ àíZ
H$mo hr ghr ‘mZ|&
If there is any error/ difference/ contradiction in Hindi & English version of the
question paper, the question of Hindi version should be treated valid.
6) àíZ H$m CÎma {bIZo go nyd© àíZ H$m H«$‘m§H$ Adí¶ {bI|&
Write down the serial number of the question before attempting it.
SS–04–Info. Prac. (Opt.) 7004
Page 4
3
IÊS> - A
SECTION - A
1) ~hþ{dH$ënr àíZ (i go xviii VH$)& [18×½=9]
Multiple Choice Questions (i to xviii):
i) SELECT POW(4, 2), H$m AmCQ>nwQ> ³¶m hmoJm? [½]
A) 6 ~) 2
g) 16 X) 8
What will be the output of SELECT POW(4, 2)?
A) 6 B) 2
C) 16 D) 8
ii) ........... ’§$³eZ {Z{X©îQ> H$m°b‘ ‘| ‘mZm| H$m Am¡gV bm¡Q>mVm h¡& [½]
A) SUM (Column) ~) MIN (Column)
g) MAX (Column) X) AVG (Column)
_______ function returns the average of the values in the specified column.
A) SUM (Column) B) MIN (Column)
C) MAX (Column) D) AVG (Column)
iii) {ZåZ ‘| go H$m¡Zgm pñQ´>¨J ’§$³eZ Zht h¡? [½]
A) TRIM ( ) ~) DATE ( )
g) LENGTH ( ) X) UCASE ( )
Which of the following is not a String function?
A) TRIM ( ) B) DATE ( )
C) LENGTH ( ) D) UCASE ( )
SS–04–Info. Prac. (Opt.) 7004 [ Turn Over
Page 5
4
iv) .............. Am°naoeZ H$m Cn¶moJ EH$ g‘¶ ‘| Xmo Vm{bH$mAm| H$s M¶{ZV n§{³V¶m| H$mo g§¶mo{OV H$aZo
Ho$ {bE {H$¶m OmVm h¡& [½]
A) ¶y{Z¶Z ~) B§Q>ago³Q>
g) ‘mBZg (–) X) Cnamo³V g^r
________ operation is used to combine the selected rows of two tables at a
time.
A) UNION B) INTERSECT
C) MINUS (–) D) All of these
v) {ZåZ ‘| go H$m¡Z-gr EH$b-n§{³V ’§$³eZ (qgJb amo ’§$³eZ) H$s loUr h¡? [½]
A) ݶy‘o[aH$ ’§$³eZg² ~) pñQ´>¨J ’§$³eZg²
g) S>oQ> ’§$³eZg² X) Cnamo³V g^r
Which of the following is single row function category?
A) Numeric functions B) String functions
C) Date functions D) All of these
vi) nm§S>mµO ‘| grarO EH$ .................. hmoVm h¡& [½]
A) dZ-S>m¶‘|eZb Aao ~) Qy>-S>m¶‘|eZb Aao
g) W«r-S>m¶‘|eZb Aao X) BZ‘| go H$moB© Zht
Series in Pandas is a __________.
A) One-dimensional array B) Two-dimensional array
C) Three-dimensional array D) None of these
SS–04–Info. Prac. (Opt.) 7004
Page 6
5
vii) NumPy H$m ‘Vb~ ³¶m hmoVm h¡? [½]
A) Z§~a nm¶WZ ~) ݶy‘o[aH$b nm¶WZ
g) ZoñQ>oS> nm¶WZ X) ݶy‘o[aH$b àmoJ«m‘
What is the meaning of NumPy?
A) Number Python B) Numerical Python
C) Nested Python D) Numerical Program
viii) {ZåZ ‘| go H$m¡Zgm nm§S>mµO S>oQ>m’«o$‘ H$m EQ´>rã¶yQ> h¡? [½]
A) DataFrame.Index ~) DataFrame.Values
g) DataFrame.Size X) Cnamo³V g^r
Which of the following is an attribute of Pandas DataFrame?
A) DataFrame.Index B) DataFrame.Values
C) DataFrame.Size D) All of these
ix) nm§S>mµO Ho$ Xmo ‘w»¶ S>mQ>m ñQ´>³Ma grarO Am¡a ................ hmoVo h¢& [½]
A) SQL ~) H$mC§Q> (Count)
g) S>mQ>m’«o$‘ X) Cnamo³V ‘| go H$moB© Zht
Two main data structures in Pandas are series and _______.
A) SQL B) Count
C) DataFrame D) None of these
SS–04–Info. Prac. (Opt.) 7004 [ Turn Over
Page 7
6
x) 14 Am¡a 8 H$m ‘mܶ ³¶m hmoJm? [½]
A) 14 ~) 22
g) 8 X) 11
What is the mean of 14 and 8?
A) 14 B) 22
C) 8 D) 11
xi) DataFrame.Median ( ), S>mQ>m Ho$ .................... ‘mZ H$mo àX{e©V H$aoJm& [½]
A) Am¡gV ~) Omo‹S>
g) ‘ܶ X) àW‘
DataFrame.Median ( ) will display the ________ value of the data.
A) Average B) Sum
C) Middle D) First
xii) VËdm| Ho$ {XE JE g§J«h H$mo H«$‘ ‘| aIZo H$s à{H«$¶m .............. H$hbmVr h¡& [½]
A) N>±Q>mB© (gm°{Q>ªJ) ~) ImoOZm
g) aIZm X) Cnamo³V g^r
Process of arranging data in a specified order is called as _________.
A) Sorting B) Searching
C) Putting D) All of these
SS–04–Info. Prac. (Opt.) 7004
Page 8
7
xiii) plt.xlabel ( ) Am¡a plt.ylabel ( ) H$m Cn¶moJ ßbm°Q> Ho$ X Am¡a ............... bo~b H$mo goQ> H$aZo
‘| {H$¶m OmVm h¡& [½]
A) Z ~) Y
g) X X) BZ‘| go H$moB© Zht
plt.xlabel ( ) and plt.ylabel ( ) are used to set the X and _____ label of the
plot.
A) Z B) Y
C) X D) None of these
xiv) {ZåZ ‘| go H$m¡Zgm EH$ MmQ>© H$m àH$ma Zht h¡? [½]
A) nmB© (Pie) ~) bmBZ (Line)
g) S>mQ>m’«o$‘ (DataFrame) X) ~ma (Bar)
Which of the following is not a type of chart?
A) Pie B) Line
C) DataFrame D) Bar
xv) .............. Xmo ¶m Xmo go A{YH$ H§$ß¶yQ>am| ¶m H§$ß¶yqQ>J CnH$aUm| Ho$ ~rM EH$ B§Q>aH$Zo³eZ h¡& [½]
A) H§$ß¶yQ>a ZoQ>dH©$ ~) ‘moS>‘
g) h~ X) pñdM
_______ is an interconnection among two or more computers or computing
devices.
A) Computer Network B) Modem
C) Hub D) Switch
SS–04–Info. Prac. (Opt.) 7004 [ Turn Over
Page 9
8
xvi) {ZåZ ‘| go H$m¡Zgm Q>m°nmobmoOr H$m àH$ma Zht h¡? [½]
A) ‘¡e ~) [a¨J
g) gZ X) ~g
Which of the following is not a type of topology?
A) Mesh B) Ring
C) Sun D) Bus
xvii) ~m¡{ÕH$ g§nXm A{YH$ma (B§Q>obo³MwAb àm°nQ>u amBQ>) {H$gHo$ Ûmam gwa{jV aIm Om gH$Vm h¡? [½]
A) H$m°nramBQ> ~) noQ>|Q>
g) Q´>oS>‘mH©$ X) Cnamo³V g^r
Which is used to protect Intellectual Property Right?
A) Copyright B) Patent
C) Trademark D) All of these
xviii)HTTP ‘| 'P' H$m ‘Vb~ ³¶m hmoVm h¡? [½]
A) àmoQ>moH$m°b ~) ng©Z
g) àmBdoQ> X) {n³Ma
What is the meaning of 'P' in HTTP?
A) Protocol B) Person
C) Private D) Picture
SS–04–Info. Prac. (Opt.) 7004
Page 10
9
2) [aº$ ñWmZm| H$s ny{V© H$s{OE (i go x VH$) : [10×½=5]
Fill in the blanks (i to x) :
i) do~ noOm| Ho$ g‘yh H$mo .............. H$hVo h¢& [½]
Collection of web pages is called as _________.
ii) SELECT LENGTH ("RAJASTHAN") H$m AmCQ>nwQ> .................... hmoJm& [½]
Output of SELECT LENGTH ("RAJASTHAN") is ___________.
iii) SQL ‘| ................. , EH$ S>oQ> ’§$³eZ H$m CXmhaU h¡& [½]
In SQL, __________ is an example of Date function.
iv) RIGHT ("COMPUTER", 4) H$m AmCQ>nwQ> .................. hmoJm& [½]
_________ is the output of RIGHT ("COMPUTER", 4).
v) ................... ’§$³eZ H$m Cn¶moJ pñQ´>¨J H$mo ~S>o Ajam| ‘| (AnaHo$g) ~XbZo Ho$ {bE {H$¶m OmVm h¡&
[½]
__________ function is used to convert string into upper case.
vi) ................ E-waste H$m EH$ CXmhaU h¡& [½]
________ is an example of E-waste.
vii) Matplotlib ‘| ................ ’§$³eZ H$m Cn¶moJ ßbm°Q> ~ZmZo Ho$ {bE {H$¶m OmVm h¡& [½]
In Matplotlib, ________ function is used to build a plot.
viii) ................... EH$ ZooQ>dH©$ CnH$aU H$m CXmhaU h¡& [½]
__________ is an example of network device.
ix) RDBMS ‘| 'R' H$m nyam Zm‘ ..................... h¡& [½]
Full form of 'R' in RDBMS is ___________.
x) WAN H$m nyam Zm‘ ........................ h¡& [½]
Full form of WAN is ________________.
SS–04–Info. Prac. (Opt.) 7004 [ Turn Over
Page 11
10
3) A{VbKwÎmamË‘H$ àíZ (i go x VH$) : [10×1=10]
Very short answer type questions (i to x) :
i) h¢qH$J ³¶m h¡? [1]
What is Hacking?
ii) ~«mCOa H$mo n[a^m{fV H$s{OE& [1]
Define Browser.
iii) VoIP H$m nyam Zm‘ {b{IE& [1]
Write full form of VoIP.
iv) Matplotlib library Ho$ Xmo Cn¶moJ {b{IE& [1]
Write any two uses of Matplotlib library.
v) nm§S>mµO Ho$ Xmo gm§p»¶H$s¶ ’§$³eZ Ho$ Zm‘ {b{IE& [1]
Write names of two statistical functions in Pandas.
vi) 3, 2, 3, 4, 1, 5, 3 H$m ~hþbH$ kmV H$s{OE& [1]
Find the mode of 3, 2, 3, 4, 1, 5, 3.
vii) nmB© MmQ>© ³¶m hmoVm h¡? [1]
What is Pie chart?
viii) Q´>oS>‘mH©$ ³¶m h¡? [1]
What is Trademark?
ix) B§Q>aZoQ> Ho$ Xmo ’$m¶Xo {b{IE& [1]
Write two benefits of Internet.
x) plt.show ( ) H$m ³¶m Cn¶moJ h¡? [1]
What is the use of plt.show ( )?
SS–04–Info. Prac. (Opt.) 7004
Page 12
11
IÊS> - ~
SECTION - B
bKwÎmamË‘H$ àíZ : [10×1½=15]
Short answer type questions :
4) SQL ‘| ‘ëQ>r amo ’§$³eZ ³¶m h¡? [1½]
What is multi row function in SQL?
5) pñQ´>¨J ’§$³eZ LENGTH ( ) Ho$ ~mao ‘| {b{IE& [1½]
Write about String function LENGTH ( ).
6) B§Q>ago³Q> Am°naoQ>a H$m Cn¶moJ {b{IE& [1½]
Write use of Intersect operator .
7) S>mQ>m’«o$‘ ³¶m h¡? [1½]
What is DataFrame?
SS–04–Info. Prac. (Opt.) 7004 [ Turn Over
Page 13
12
8) H$m°nramBQ> Ho$ ~mao ‘| {b{IE& [1½]
Write about Copyright.
9) do~ gd©a Ho$ Cn¶moJ {b{IE& [1½]
Write uses of Web server.
10) ñQ>ma Q>m°nmobmoOr Ho$ ~mao ‘| {b{IE& [1½]
Write about Star topology.
11) SQL Ho$ ~mao ‘| {b{IE& [1½]
Write about SQL.
12) {S>{OQ>b ’w$Q>{àÝQ> ³¶m hmoVm h¡? [1½]
What is digital footprint?
13) ~hþbH$ ³¶m h¡? [1½]
What is Mode?
SS–04–Info. Prac. (Opt.) 7004
Page 14
13
IÊS> - g
SECTION - C
XrK©CÎmamË‘H$ àíZ : [3×3=9]
Long answer type questions :
14) {XE JE ‘mZm| Ho$ {bE ‘mpܶH$m kmV H$s{OE& [3]
[19, 16, 2, 8, 15, 21, 6]
Find the median for given values -
[19, 16, 2, 8, 15, 21, 6]
AWdm/OR
nm§S>mµO ‘| ñbmBqgJ ³¶m hmoVr h¡? [3]
What is Slicing in Pandas?
15) gmB~a AnamY (H«$mB‘) go ~MZo Ho$ VarHo$ {b{IE& [3]
Write the ways to avoid Cyber Crime.
AWdm/OR
Pandas ‘| GROUP BY H$mo CXmhaU g{hV g‘PmBE& [3]
Explain GROUP BY in Pandas with example.
16) B©-‘ob ³¶m h¡? dU©Z H$s{OE& [3]
What is E-mail? Explain.
AWdm/OR
nm§S>mµO ‘| EH$ Imbr S>oQ>m’«o$‘ H$mo ~ZmZo H$s ñQ>oQ>‘oÝQ²>g {b{IE& [3]
Write statements in Pandas to create an empty DataFrame.
SS–04–Info. Prac. (Opt.) 7004 [ Turn Over
Page 15
14
IÊS> - X
SECTION - D
XrK© CÎmar¶ àíZ/{Z~§YmË‘H$ àíZ : [2×4=8]
Long answer type questions :
17) Table : English [4]
SID SNAME SMARKS
ST01 RAM 89
ST02 SALEEM 80
ST03 MANPREET 75
ST04 SHERIN 91
ST05 SHREYA 79
Cnamo³V Vm{bH$m go {ZåZ SQL ³doarO {b{IE&
Write the following SQL queries from above table.
i) English Vm{bH$m ~ZmBE&
Create table English.
ii) B§p½be ‘| A{YH$V‘ ‘mH©²$g dmbo {dÚmWu H$m Zm‘ àX{e©V H$aZo Ho$ {bE&
To display Name of student having maximum marks in English.
AWdm/OR
{ZåZ H$mo n[a^m{fV H$s{OE - [4]
A) gm‘m{OH$ (gmoeb) ‘r{S>¶m EQ>rHo$Q²>g
~) ¶y{Z¶Z Am°naoQ>a
Define following -
A) Social media etiquettes
B) Union operator
SS–04–Info. Prac. (Opt.) 7004
Page 16
15
18) {ZåZ{b{IV SQL H$‘m§S> H$m AmCQ>nwQ> {b{IE - [4]
A) SELECT UCASE ("delhi")
~) SELECT ROUND (896.4)
g) SELECT DAY ("2025-02-12")
X) SELECT INSTR ("America", "er")
Write output of following SQL commands -
A) SELECT UCASE ("delhi")
B) SELECT ROUND (896.4)
C) SELECT DAY ("2025-02-12")
D) SELECT INSTR ("America", "er")
AWdm/OR
Table : COURSE [4]
S.No. Name Degree Score (%)
1 Aparna B.Tech. 90.3
2 Shabana BCA 82.6
3 Naveen M.Tech. 86.7
4 Peter MBA 79.4
5 Baljeet MBBS 81.7
6 Pankaj B.Com. 78.5
Xr JB© Vm{bH$m "COURSE" H$m Cn¶moJ H$aHo$ {ZåZ H$m nm¶WZ ‘| H$moS> {b{IE&
Write Python Code for the following by using given table "COURSE".
i) Cnamo³V Vm{bH$m "COURSE" Ho$ {bE S>mQ>m’«o$‘ ~ZmBE&
Create the DataFrame for above table "COURSE".
ii) A{YH$V‘ ñH$moa Ho$ ‘mZ H$m Zm‘ Am¡a {S>J«r H$mo àX{e©V H$aZo Ho$ {bE&
To print the name and degree of maximum score value.
SS–04–Info. Prac. (Opt.) 7004
Page 17
E
ER
H
NG
I
TH
NY
A
TE
RI
W
O T
N
DO
Page 18
Study Materials
Notes
Model Papers Class 6 Notes
Sample Papers Class 7 Notes
Half Yearly Sample Papers Class 8 Notes
Class 9 Notes
Important Resources
Class 10 Notes
Periodic Table
Class 11 Notes
Writing Skills / Formats
Maps of India / World Class 12 Notes
Books and Solutions
NCERT Books
NCERT Book Solutions
HC Verma Chapter Wise Solutions
RD Sharma Solutions
CGBSE Solutions