Page 26 - IPP-12-2024

PRACTICE PAPER

CLASS XII
INFORMATICS PRACTICES (065)
Time Allowed: 3 hrs Maximum Marks: 70

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 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. Which of the following statements is false about topologies?
(i) In bus topology, several devices are connected to a main long cable.
(ii) A fully connected mesh network has n(n-1)/2 links, where n is the total number of connecting nodes.
(iii) Tree topology cannot be implemented when bus and star topology are not implemented individually.
(iv) In ring topology, signal is transmitted only in one direction. (1)
2. _______________________ is the primary law in India to deal with cybercrime. (1)

3. Which of the following is not a concern caused due to the overuse of technology?
(i) Social Isolation (ii) Loss of attention
(iii) Computer Vision Syndrome (iv) Anaemia (1)
4. Which of the following commands will give the output as 10?
(i) SELECT MONTH ("1993-10-09");
(ii) SELECT DATE ("09-10-1993");
(iii) SELECT MONTH ("1993-09-10");
(iv) SELECT MONTHNAME ("1993-10-09"); (1)
5. What will be the output of the following function?

SELECT ROUND (99.02355,3);
(i) 99.0235 (ii) 99.023
(iii) 99.02355 (iv) 99.024 (1)
6. IPR stands for
(i) Intellect Property Rights (ii) Internet Privacy Rights
(iii) Information Privacy Rights (iv) Intellectual Property Rights (1)
7. Which one of the following is the correct syntax to read a csv file named “student.csv” in pandas alias
pd?
(i) pd.read("student.csv") (ii) pd.read.csv("student")
(iii) pd.read_csv("student") (iv) pd.read_csv("student.csv") (1)

8. Which command is used to remove the entire table ‘HARDWARE’ from the database?
(i) DROP TABLE HARDWARE; (ii) DELETE TABLE HARDWARE;
(iii) TRUNCATE TABLE HARDWARE; (iv) REMOVE TABLE HARDWARE; (1)

Practice Paper A.1