KENDRIYA VIDYALAYA SANGTHAN, MUMBAI REGION
PRE-BORAD EXAMINATION (2023-24)
Class: XII
SUB:INFORMATICS PRACTICES (065)
Maximum Marks: 70M Time Allowed: 3 Hours
General Instructions:
The question paper is divided into 5 sections – A to E
All questions are compulsory.
Section A has 18 questions carrying 01 mark each.
Section B has 07 Very Short Answer type questions carrying 02 marks each.
Section C has 05 Short Answer type questions carrying 03 marks each.
Section D has 02 questions carrying 04 marks each.
Section E has 03 questions carrying 05 marks each.
All programming questions are to be answered using Python Language only.
SECTION-A
Q1. The software that filters the incoming and outgoing network traffic of an organisation is 1
known as _____________
a. Cookies
b. Firewall
c. Digital footprint
d. All of the above
Q2. E-waste stands for 1
a. Electrical waste
b. Electronic waste
c. Engine waste
d. None of the above
Q3. The software which is owned by a person or an organisation is known as ___ 1
a. Free software
b. Open software
c. Proprietary software
d. Shareware
Q4. Write the output of the following SQL command. 1
select round (49.88,1);
a. 49.88
b. 49.8
c. 49.9
d. 50
Q5. Which among the given options is an aggregate function in mysql? 1
a. Round()
b. Now()
c. Count()
d. Substr()
, Q6. ___________ is an example of open source software. 1
a. Windows
b. MS Excel
c. Mysql
d. photoshop
Q7. The function used to exporting dataframe into csv file is : 1
a.read_csv()
b.to_csv()
c.to.csv()
d.readcsv()
Q8. Ram executed the query SELECT COUNT(COMM) FROM EMP; Though there were 15 1
rows in the table he got the output as 12. What could be the reason?
a. There is problem with the installed mysql
b. There is NULL values in the comm field of any three rows
c. The query is wrong
d. None of the above
Q9. If the column sal of the EMP table contains the data (5000,10000,15000,5000,10000) , what 1
will be the output of the following query
SELECT COUNT( SAL) FROM EMP;
a. 3
b. 5
c. 4
d. 2
Q10. The command used to display the last 3 rows of a dataframe(Df) is __ 1
a. Df.head()
b. Df.head(3)
c. Df.tail()
d. Df.tail(3)
Q11. The command used to plot a line graph is 1
a. plt.show()
b. plt.plot()
c. plt.xlabel()
d. plt.title()
Q12. To display first element of a Series object S, you will write 1
(a) S[0]
(b) S[1]
(c) S[2]
(d) S[3]
Q13. Legal term to describe the rights of a creator of original work is ________. 1
a. Copyright
b. GPL
c. FOSS
d. None of the above
Q14. The default date format in mysql is ____________ 1
a. ‘dd-mm-yyyy’
b. ‘mm-dd-yyyy’
c. ‘yyyy-mm-dd’
d. .‘dd-mm-yy’
PRE-BORAD EXAMINATION (2023-24)
Class: XII
SUB:INFORMATICS PRACTICES (065)
Maximum Marks: 70M Time Allowed: 3 Hours
General Instructions:
The question paper is divided into 5 sections – A to E
All questions are compulsory.
Section A has 18 questions carrying 01 mark each.
Section B has 07 Very Short Answer type questions carrying 02 marks each.
Section C has 05 Short Answer type questions carrying 03 marks each.
Section D has 02 questions carrying 04 marks each.
Section E has 03 questions carrying 05 marks each.
All programming questions are to be answered using Python Language only.
SECTION-A
Q1. The software that filters the incoming and outgoing network traffic of an organisation is 1
known as _____________
a. Cookies
b. Firewall
c. Digital footprint
d. All of the above
Q2. E-waste stands for 1
a. Electrical waste
b. Electronic waste
c. Engine waste
d. None of the above
Q3. The software which is owned by a person or an organisation is known as ___ 1
a. Free software
b. Open software
c. Proprietary software
d. Shareware
Q4. Write the output of the following SQL command. 1
select round (49.88,1);
a. 49.88
b. 49.8
c. 49.9
d. 50
Q5. Which among the given options is an aggregate function in mysql? 1
a. Round()
b. Now()
c. Count()
d. Substr()
, Q6. ___________ is an example of open source software. 1
a. Windows
b. MS Excel
c. Mysql
d. photoshop
Q7. The function used to exporting dataframe into csv file is : 1
a.read_csv()
b.to_csv()
c.to.csv()
d.readcsv()
Q8. Ram executed the query SELECT COUNT(COMM) FROM EMP; Though there were 15 1
rows in the table he got the output as 12. What could be the reason?
a. There is problem with the installed mysql
b. There is NULL values in the comm field of any three rows
c. The query is wrong
d. None of the above
Q9. If the column sal of the EMP table contains the data (5000,10000,15000,5000,10000) , what 1
will be the output of the following query
SELECT COUNT( SAL) FROM EMP;
a. 3
b. 5
c. 4
d. 2
Q10. The command used to display the last 3 rows of a dataframe(Df) is __ 1
a. Df.head()
b. Df.head(3)
c. Df.tail()
d. Df.tail(3)
Q11. The command used to plot a line graph is 1
a. plt.show()
b. plt.plot()
c. plt.xlabel()
d. plt.title()
Q12. To display first element of a Series object S, you will write 1
(a) S[0]
(b) S[1]
(c) S[2]
(d) S[3]
Q13. Legal term to describe the rights of a creator of original work is ________. 1
a. Copyright
b. GPL
c. FOSS
d. None of the above
Q14. The default date format in mysql is ____________ 1
a. ‘dd-mm-yyyy’
b. ‘mm-dd-yyyy’
c. ‘yyyy-mm-dd’
d. .‘dd-mm-yy’
