Page 33 - IPP-12-2024

APPENDIX E

PRACTICE PAPER
CLASS XII
INFORMATICS PRACTICES (065)

Maximum Marks: 70 Time Allowed: 3 hrs

General Instructions:
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A has 18 questions carrying 1 mark each.

4. Section B has 7 Very Short Answer type questions carrying 2 marks each.
5. Section C has 5 Short Answer type questions carrying 3 marks each.
6. Section D has 2 Long Answer type questions carrying 4 marks each.
7. Section E has 3 questions carrying 5 marks each.
8. All programming questions are to be answered using Python language only.

Section A
1. Computers connected by a network across different cities is an example of _____________. [1]
(i) LAN (ii) MAN (iii) WAN (iv) PAN
2. Out of the following, which crime(s) will come under the cybercrime category? [1]
(i) Identity theft (ii) Invasion of privacy
(iii) Online harassment (iv) All of these
3. E-waste is harmful to the environment and human health if not properly treated or disposed of, therefore,
it must be handled with care. What are the health hazards which can be caused by E-waste? [1]
(i) Lung cancer (ii) DNA damage
(iii) Brain damage (iv) All of these
4. What will be returned by the given query?
SELECT RIGHT(“LEFT”, 2); [1]
5. In the table ‘Student’ in MySQL, if column ‘Fees’ contains the data (5000,8000,7500,NULL,5000,8000),
what will be the output after the execution of the given query? [1]
SELECT COUNT (DISTINCT Fees) FROM student;
6. Online ______________ is a theft of personal information in order to commit a fraud. [1]
7. Identify the Single Row function of MySQL among the following: [1]
(i) Trim() (ii) Max() (iii) Avg() (iv) Count()
8. What will be returned by the given query? [1]
select round(23456.1234,-2) ;
(i) 23456.00 (ii) 23400 (iii) 23500 (iv) 23456.1200
9. Which one of the following functions is used to find the smallest value from the given data in MySQL? [1]
(i) MIN() (ii) MINIMUM() (iii) SMALL() (iv) SMALLEST()
10. Choose the correct statement to print the label in the line chart. [1]
(i) pl.xlabel("some values")

(ii) pl.xlable("some values")
(iii) pl.plotlabel("some values")
(iv) None of these
11. Which clause is used in the query to place the condition on group in MySQL? [1]
(i) WHERE (ii) HAVING (iii) GROUP BY (iv) Both (i) and (ii)