Rajasthan Board 12th Model Paper 2024 Informatics Practices

MODEL
PAPER बोर्ड ऑफ सेकं डरी एज्युके शन राजस्थान
RAJASTHAN BOARD

2024

Download PDF

ek/;fed f'k{kk cksMZ jktLFkku]vtesj
ekWMy iz’u i= mPp ek/;fed ijh{kk 2024
Subject - INFORMATICS PRACTICES

No of Question :- 18
No of Printing pages :-

TIME % 3%15 hour Maximum Marks % 56

ijh{kkfFkZ;ksa ds fy, lkekU; funZs'k %&
GENERAL INSTRUCTION TO THE EXAMINEES:
1- ijh{kkFkhZ loZizFke vius iz'u i= ij ukekad vfuok;Zr% fy[ksaA

Candidate must write first his/her Roll No. on the question paper compulsorily.
2- lHkh iz'u djus vfuok;Z gSA

All the questions are compulasory.
3- izR;sd iz'u dk mÙkj nh xbZ mÙkj iqfLrdk esa gh fy[ksaA
Write the answer to each question in the given answer book only.
4- ftu iz'uksa esa vkUrfjd [k.M gS mu lHkh ds mÙkj ,d lkFk gh fy[ksaA
For questions having more than one part the answers to those parts are to be written
together in continuity.

[k.M & v
SECTION-A

(i) SQL esa count function dh la[;k nsrk gSA ½
(A) Values (B) Distinct Value

(C) Group by (D) Columns

The count function in SQL returns the numbers of

(A) Values (B) Distinct Value

(C) Group by (D) Columns

(ii) SELECT ROUND ¼153-678] 2½ Dosjh ls D;k fjVZu gksxk \ ½

(A) 153.6 (B) 153.67

(C) 153.68 (D) 153.7

What will be returned by the given query ? SELECT ROUND (153.678,2)

(A) 153.6 (B) 153.67

(C) 153.68 (D) 153.7

(iii) gekjs digital foot print fdlds }kjk cuk;k tk ldrk gSA ½

(A) Visiting any website (B) Sending email

(C) Positing online (D) All of the above

Our digital foot print can be created by -

(A) Visiting any website (B) Sending email

(C) Positing online (D) All of the above

(iv) PANDAS dk vFkZ gS ½

(A) Panel Data (B) Panel data system

(C) Pandas Data Structures (D) Pandas NumPy Data Structure

PANDAS stand for.

(A) Panel Data (B) Panel data system

(C) Pandas Data Structures (D) Pandas NumPy Data Structure

(v) la[;kvksa ds leqPp; ls e/; la[;k Kkr djus ds fy, fdl Qyu dk iz;ksx fd;k tkrk gSA ½

(A) Mean () (B) Median ()

(C) Mode () (D) Count ()

Which function is used to find the middle numbers from a set of numbers ?

(A) Mean () (B) Median ()

(C) Mode () (D) Count ()

(vi) Plot tks lkaf[;dh; lkjka'k nsus ds fy, iz;ksx fd;k tkrk gS og gS ½
(A) Bar (B) Line

(C) Histogram (D) Box plot.

Plot which is used to given statistical summary is

(A) Bar (B) Line

(C) Histogram (D) Box plot.

(vii) Matplotlib IykWfVax ykbZczsjh gS \ ½
(A) 1 D (B) 2 D

(C) 3 D (D) All of above

Matplotlib is .......... plotting library

(A) 1 D (B) 2 D

(C) 3 D (D) All of above

(viii) osc ist fdl Hkk"kk dk mi;ksx dj cuk;k tkrk gS \ ½

(A) XML (B) JAVA

(C) C (D) HTML

Web pages is created using language

(A) XML (B) JAVA

(C) C (D) HTML

(ix) fMftVy in fpUg laxzfgr gksrs gS \ ½

(A) Temporarily (B) Permanently

(C) For 7 days only (D) For 3 days.

Digital footprints are stored ..............

(A) Temporarily (B) Permanently

(C) For 7 days only (D) For 3 days.

(x) fuEufyf[kr esa ls fdl topology esa usVodZ dh iwjh yEckbZ esa pyus okyh ,d cSdcksu
dsoy gksrh gSA ½
(A) Star (B) Bus

(C) Mesh (D) Tree

Which of the following topology contains a backbone cable running though the whole
length by the network .

(A) Star (B) Bus

(C) Mesh (D) Tree

(xi) ------------------ QaD'ku dk mi;ksx fp=@pkVZ iznf'kZr djus ds fy, fd;k tkrk gSA ½

(A) Showing (B) show

(C) Display (D) screen
.................. Function is used to display figure chart.

(A) Showing (B) show

(C) Display (D) screen

(xii) fMQkYV :i ls plot () ,d ------------- pkVZ cukrk gSA ½

(A) Histogram (B) Bar graph

(C) Line Chart (D) Pie Chart

By default plot () function plots a............. .

(A) Histogram (B) Bar graph

(C) Line Chart (D) Pie Chart

(xiii) Aggregate function gksrs gS & ½

(A) Max () (B) Min ()

(C) Sum () (D) All above

Aggregate functions are

(A) Max (B) Min

(C) Sum (D) All above

(xiv) Record dks la'kksf/kr djus ds fy, mi;ksx fd;k tkus okyk dekaM gSA ½

(A) Update (B) Add

(C) Update all (D) Nun of above

Perform's pattern the command used for modifying the record is -

(A) Update (B) Add

(C) Update all (D) Nun of above

(xv) vf/kdre eku izkIr djus ds fy, dkSu ls SQL dh oMZ dk mi;ksx fd;k tkrk gSA ½

(A) Maximum (B) Most

(C) Upper (D) Max

Which SQL keyword is used to retrieve a maximum value ?

(A) Maximum (B) Most

(C) Upper (D) Max

(xvi ) fuEufyf[kr esa ls SQL aggregate function gSA ½

(A) LEFT (B) AVG

(C) JOIN (D) LEN

Which of the following is a SQL aggregate function ?

(A) LEFT (B) AVG

(C) JOIN (D) LEN

Q 2 (i) fdlh Hkh usVodZ esa eq[; dEI;wVj dks dgk tkrk gS ------------ ½
The main computer in any network is called as ............... .

(ii) -------------------- dEI;wVj vukf/kd`r igqap dk dk;Z gSA ½
..................... is the act of unauthorized access to a computer.

(iii) ,d mi Dosjh ,d SQL vfHkO;fDr gSA ftls ------------- ,d vU; SQL dFku esa j[kk x;k gSA ½
A Sub query is an SQL expression that is placed ................. another SQL Statement.

(iv) Select query dk ------------------ clause ges ifj.kke eas dsoy mUgh iafDr;ksa dk p;u djus dh
vuqefr nsrk gS tks ,d fufo"B 'krZ dks iqjk djrh gSA ½
The .............clause of select query allows us to select only those rows in the result that satisfy a
specified condition.

(v) -------------------- 'kCn dk mi;ksx rkfydk eas fdlh record dks lanfHkZr djus ds fy, fd;k tkrk gSA ½

The term ............... is used to refer a record in a table.

(vi) -------------------- 'kCn dk mi;ksx rkfydk esa fdlh field dks lanfHkZr djus ds fy, fd;k tkrk gSA ½

The term .......... is used to refer to a field in table

(vii) fdlh laca/k eas dksbZ fo'ks"krk foreign key gS ;fn og fdlh vU; laca/k eas ------------ daqth gSA ½
An attribute in a relation in foreign key it is the ................ key in any other relation

(viii) -------------------- dk mi;ksx data frame ls U;wure eku iznf'kZr djus ds fy, fd;k tkrk gSA ½
................. is used to display the minimum valus from the data frame.

(ix) ------------------ ,d computer gS tks vU; izksxzke ;k dEI;wVj dks lsok,a iznku djrk gSA ½
A................. is computer that provides serious to other programs of computers.

(x) Digital foot print ----------------- :i ls laxzghr gksrs gSA ½
Digital foot print are stored .................. .

Q3 fn;s x;s iz'uksa ds mÙkj nhft,A
Answer the following questions
(i) Table 1

Name Unite test Maths Science S. St. Hindi English
Arvind 1 15 22 25 22 21

lHkh fo"k;ksa ds fy, vjfoUn }kjk izkIr U;wure vad iznf'kZr djus ds fy, Statement fy[ksA
Write the statement to display the minimum marks obtained by Arvind in limit test for all subject.

(ii) Missing value ls vki D;k le>rs gS \ 1
What do you understand by the term missing value.

(iii) "Rajasthan" 'kCn esa v'kj Kkr djus dk SQL statement fy[ksA 1
Write SQL statement to count alphabets in word "Rajasthan"

(iv) dkSulk SQL fLVªx QaD'ku fdlh nh xbZ fLVªx ds lQsn LFkku o.kksZ dks gVkus ds ckn]
fjVuZ djus esa mi;ksx fd;k tkrk gSA 1
Which SQL string function is used to returns the given string after removing trailing white space
characters.

(v) Pandas dks bUlVkWy djus ds fy, dekaM ykbu fy[ksA 1
Write command line to install Pandas.

(vi) Legend dk D;k mís'; gS \ 1
What is the purpose of a Legend ?

(vii) fdl topology eas cSdcksu dscy gksrh gS tks iwjs usVodZ eas pyrh gS \ 1
Which topology contains a backbone Cable running through the whole length of the network?

(viii) 'Cyber Crime' ls D;k etyc gS \ 1
Wwhat is meant by the term 'Cyber Crime'?

[k.M c
Section B

Q4. SQL command lss mRiUu vkmViqV fy[ksA 1½

Write the output produced by the SQL Commands;

SELECT POW (3,2)

Q5. SQL Dosjh lss mRiUu vkmViqV fy[ksA 1½

Write the output of the following SQL queries
SELECT RIGHT('SCIENCE', 4);

Q6. Series ds vkdkj ls vki D;k le>rs gS \ 1½

What do you understand by the size of Series?

Q7. Dataframe, 2D array ls fdl izdkj fHkUu gS \ 1½

How is it Dataframe different from a 2D array ?

Q8. SQL Dosjh ls mRiUu vkmViqV fy[ks \ 1½

Write the output the following SQL queries SELECT LENGTH ("Gurpreet") ?

Q 9. Data frame. quantile () dks ifjHkkf"kr djksA 1½

Define the terms Data frame.quantile()

Q10. Pandas fctqvykbts'ku dks ifjHkkf"kr djsA 1½

Define Pandas Visualisation.

Q11. SQL Dosjh ls mRiUu vkmViqV fy[ks \ 1½

Write the output of the following SQL queries
SELECT RIGHT ("SCIENCE" 3)

Q12. osclkbM vkSj osc ist esa vUrj crkb, \ 1½

Differentiate between Website and web page.

Q13. VoIP le>kvks \ 1½

Explain VoIP ?

Q14. Copyrights vkSj Patents esa vUrj crkb,A 1½

Write the differences between Copyrights and Patents .

Q15. Phishing vkSj Fraud, bZ&esy esa vUrj fyf[k,A 1½

Write the difference between Phishing and Fraud Emails.

[k.M l
Section C

Q 16. Single row function vkSj Aggregate function esa dksbZ nks vUrj fyf[k,A 3

Write any two difference between Single row function and Aggregate function.

vFkok@OR
dkrhZ; xq.k ls vki D;k le>rs gSA
What do you understand by Cartesian Product ?

Q17. ikbZ pkVZ ds IykWV djus dks ifjHkkf"kr djsaA 3

Define Plotting Pie chart.
vFkok@OR
Plotting scatter chart dks ifjHkkf"kr djsaA

Define Plotting Scatter chart

Q18. ,d mnkgj.k dh lgk;rk ls Group by dh vo/kkj.kk dks le>kb,A 3

Explain the concept of Group by with help of an example.

vFkok@OR
Data analysis esa vuqeku ,d egRoiiw.kZ vo/kkj.kk D;ksa gS
Why estimation is an important concept in data analysis?

[k.M n
Section D

Q19. 4
Table: Student

SCode SName SMarks SSubject
S01 GURPREET 82 ENGLISH
S02 ARVIND 54 MATHS
S03 MANDJ 45 COMPUTER
S04 RAVINEDRA 65 ECONOMICS
S05 NARESH 38 BIOLOGY
S06 SAKSHI 89 BIOLOGY
¼A½ Student lkj.kh cuk;sA
¼B½ dqy Nk= iznf'kZr djsaA
¼C½ lkj.kh dks Nk=ksa ds o.kZ Øekuqlkj iznf'kZr djsaA

Table: Student
SCode SName SMarks SSubject
S01 GURPREET 82 ENGLISH
S02 ARVIND 54 MATHS
S03 MANDJ 45 COMPUTER
S04 RAVINEDRA 65 ECONOMICS
S05 NARESH 38 BIOLOGY
S06 SAKSHI 89 BIOLOGY

(A) Create Student table.
(B) Display the total number of student.
(C) Display Student Name in Ascending Order.

vFkok@OR
Using the sale table from CAR SHOWROOM database
SALE
INVOICE Carld Cust ID Sale Date Pyment Emple Sale Commiss
No Mode Price

1001 D001 C0001 14-09- Online. E004 63247 10,000
2022
1002 S0001 C0002 12-12- Credit Card E001 590312 12,000
2021
1003 S002 C0003 15-01- Cheque E010 604000 11,000
2022
1004 D002 C0004 11-11- Bank E007 569982 11,000
2022 Finance

1005 E001 C0005 01-02- Credit card E002 639310 11,500
2022
1006 S002 C0006 20-02- Bank E007 620214 12,500
2022 Finance

fczØh rkfydk ls
¼A½ izR;sd xzgd }kjk [kjhnh xbZ dkjks dh la[;k iznf'kZr dhft,A
¼B½ ;fn xzkgd us fcØh rkfydk ls ,d ls vf/kd dkj [kjhnh gS rks [kjhnh xbZ dkjks dh xzkgd vkbZ Mh
vkSj la[;k iznf'kZr djsA

Sale table from

Using the sale table from CAR SHOWROOM database
SALE
INVOICE Carld Cust ID Sale Date Pyment Emple Sale Commiss
No Mode Price

1001 D001 C0001 14-09- Online. E004 63247 10,000
2022
1002 S0001 C0002 12-12- Credit Card E001 590312 12,000
2021
1003 S002 C0003 15-01- Cheque E010 604000 11,000
2022
1004 D002 C0004 11-11- Bank E007 569982 11,000
2022 Finance
1005 E001 C0005 01-02- Credit card E002 639310 11,500
2022
1006 S002 C0006 20-02- Bank E007 620214 12,500
2022 Finance
(A) Display the number of cars purchased by each customer from the Sale table.
(B) display the customers Id and numbers of Cars purchased if the customer purchased more
than one car from Sale table.

Q20. 4
TABLE : PRODUCT
Item Company Rupees USD
TV LG 12000 700
TV VIDEOCON 10000 650
TV LG 15000 800
AC SONY 14000 750

nh xbZ lkj.kh izkM
s sDV ds fy, fuEufyf[kr ikbFku Code fyf[k,A
¼A½ mijksDr rkfydk ds fy, data fram cukus ds fy,A

¼B½ LG TV ds vf/kdreewY; dks iznf'kZr djus ds fy,A

TABLE : PRODUCT

Item Company Rupees USD
TV LG 12000 700
TV VIDEOCON 10000 650
TV LG 15000 800
AC SONY 14000 750

Assuming the given table: Product. Write the Python Code for the following
(A) To create the data Frame For the above table.
(B) To display the maximum price of LG TV.

vFkok@ OR

fuEu ifjHkkf"kr dhft,A

¼i½ ek/; ¼ii½ cgqyd ¼iii½ ekud fopyu
Define the terms: (1) Mean, (ii) Mode, (iii) Standard Deviation.