Rajasthan Board Class 12 Information Practices Solved Model Paper 2024-25 Information practice IP

 Information Practice IP

RBSE Class 12 Solved Model Paper 2024-25

Candidate must write first his/her Roll No. on the question paper compulsorily.

All the questions are compulsory.

Write the answer to each question in the given answer-book only.

For questions having more than one part, the answers to those parts are to be written together in continuity .

Write down the serial number of the question before attempting it.

If there is any kind of error/difference/contradiction in Hindi & English version of the question paper, the question of the Hindi version should be treated valid.

Rajasthan Board Class 12 Information Practices Solved Model Paper 2024-25 Information practice IP

SECTION-A

Multipe Choice Question ( i to xviii ) All questions bears ½ marks.

(i) The count function in SQL returns the numbers of

(A) Values (B) Distinct Value (C) Group by (D) Columns

Correct Answer : (A) Values

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

(A) 153.6 (B) 153.67 (C) 153.68 (D) 153.7

 Correct Answer : (D) 153.7

(iii) Our digital foot print can be created by -

(A) Visiting any website (B) Sending email (C) Positing online (D) All of the above

 Correct Answer : (D) All of the above

(iv) PANDAS stand for.

(A) Panel Data (B) Panel data system (C) Pandas Data Structures (D) Pandas NumPy Data Structure

 Correct Answer : (A) Panel Data 

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

(A) Mean() (B) Median() (C) Mode() (D) Count()

 Correct Answer : (B) Median() 

(vi) Plot which is used to given statistical summary is

(A) Bar (B) Line (C) Histogram (D) Box plot

 Correct Answer : (D) Box plot

(vii) Matplotlib is .......... plotting library

(A) 1 D (B) 2 D (C) 3 D (D) All of above

 Correct Answer : (D) All of above

(viii) Web pages is created using language

(A) XML (B) JAVA (C) C (D) HTML

 Correct Answer : (D) HTML

(ix) Digital footprints are stored ..............

(A) Temporarily (B) Permanently (C) For 7 days only (D) For 3 days

 Correct Answer : (B) Permanently

(x) 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

  Correct Answer : (B) Bus

(xi) .................. Function is used to display figure chart.

(A) Showing (B) show (C) Display (D) screen

  Correct Answer : (B) show 

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

(A) Histogram (B) Bar graph (C) Line Chart (D) Pie Chart

 Correct Answer : (C) Line Chart

(xiii) Aggregate functions are

(A) Max() (B) Min() (C) Sum() (D) All above

  Correct Answer : (D) All above

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

(A) Update (B) Add (C) Update all (D) Nun of above

 Correct Answer : (A) Update

(xv) Which SQL keyword is used to retrieve a maximum value ?

(A) Maximum (B) Most (C) Upper (D) Max

 Correct Answer : (D) Max

(xvi ) Which of the following is a SQL aggregate function ?

(A) LEFT (B) AVG (C) JOIN (D) LEN

 Correct Answer : (B) AVG

(xvii ) Which function is used to set a label for the x-axis in python?

(A) xlabel() (B) set_x() (C) x_axis() (D) xaxi()

 Correct Answer : (A) xlabel()

(xviii ) In this era of digital society, we can do

(A) Online shopping (B) Online banking (C) Online Education (D) All of the above

  Correct Answer : (D) All of the above

Q 2  Fill in blanks (i to x )

(i) The main computer in any network is called as ............... .             ½

 Correct Answer : Server

(ii) ..................... is the act of unauthorized access to a computer.

 Correct Answer : Hacking

(iii) A Sub query is an SQL expression that is placed ........... another SQL Statement.

 Correct Answer : Within

(iv) The .............clause of select query allows us to select only those rows in the result that satisfy a

specified condition.

Correct Answer : WHERE

(v) The term ............... is used to refer a record in a table.

Correct Answer : a tuple or a row

(vi) The term ................. is used to refer to a field in table

Correct Answer : column

(vii) An attribute in a relation in foreign key it is the ................ key in any other relation.

Correct Answer : primary

(viii) ................. is used to display the minimum values from the data frame.

Correct Answer : .min()

(ix) A ................. is computer that provides service to other programs of computers.

Correct Answer : Server

(x) Digital foot print are stored ...................

Correct Answer : in a distributed manner across various online locations.

Rajasthan Board class 12 IP Important questions English Medium.

We will be updating more important questions for Information Practice Class 12 Rajasthan Board English medium students.