No.

of pages - 10 (M)
MARKING SCHEME
COMMON ANNUAL SCHOOL EXAMINATION (2023-24)
CLASS : XI
SUBJECT : INFORMATICS PRACTICES (065)
Time Allowed : 3 hours 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 (1 to 18) carrying 01 mark each. Choose the most appropriate
answer for Multiple Choice Questions.
4. Section B has 07 Very Short Answer type questions (19 to 25) carrying 02 marks each.
5. Section C has 05 Short Answer type questions (26 to 30) carrying 03 marks each.
6. Section D has 02 questions (31 to 32) carrying 04 marks each.
7. Section E has 03 questions (33 to 35) carrying 05 marks each. Question 34 and 35 are
based on case studies, refer the case study for answering these questions.
8. All programming questions are to be answered using Python Language only.

Note for Teachers:

 Partial marks to be awarded (wherever justified)
 Alternate correct answers also to be awarded

Q Answer & Division of Marks Total

No. Marks

1 False 1
1 mark for correct answer.

2 c.RAM(Random Access Memory) 1

1 mark for correct answer

3 c. Tuple 1
1 mark for correct answer.

1 XI-INFORMATICS PRACTICES-M
4 b. = 1
1 mark for correct answer.

5 c. A decentralized ledger technology 1

1 mark for correct answer.

6 d. To remove the table EMPLOYEE from the database 1

1 mark for correct answer.

7 b. RAM (Random Access Memory) 1

1 mark for correct answer.

8 False 1
1 mark for correct answer.

9 b. Bit 1
1 mark for correct answer.

10 c. It is used to indicate the beginning and end of code blocks 1

1 mark for correct answer.

11 b. append 1
1 mark for correct answer.

12 a. It is a group of one or more attribute that uniquely identify each record. 1

1 mark for correct answer.

13 c. 2_varName 1
1 mark for correct answer.

14 b. Operating System 1
1 mark for correct answer.

15 c. To modify the structure of an existing table 1

1 mark for correct answer.

2 XI-INFORMATICS PRACTICES-M
16 b. Interactive mode 1
1 mark for correct answer.

17 d. A is False but R is True 1

1 mark for correct answer.

18 a. Both A and R are True and R is the correct explanation for A 1

1 mark for correct answer.

19 System software manages hardware and provide platform for other 2

softwares to run (e.g., OS), while application software performs specific
tasks for users e.g., word processor
1.5 marks for correct difference and 1/2 mark for example
OR
Specific Purpose Software: Designed specifically to meet the requirements
of a particular individual or organization. It is created to address their
unique needs. Examples: websites developed for specific businesses, or
accounting software customized for the needs of a particular company
1.5 marks for correct definition and 1/2 mark for example

20 num = int(input("Enter a number: ")) 2

# Added closing parenthesis
print("The number is: ", num)
# Added comma
2 marks for correcting and underlining both errors

21 Purpose: Retrieve data from a relation in a database. 2

Example: SELECT name, age FROM customers WHERE city = 'Delhi';
1 mark for correct purpose
1 mark for correct example

3 XI-INFORMATICS PRACTICES-M
22 Virtual Reality: Computer-generated immersive environment simulating 2
physical presence.
Example: VR gaming.
1 mark for correct explanation
1 mark for correct example

23 DDL: 2

 CREATE TABLE

 ALTER TABLE

 DROP TABLE
DML:

 INSERT
1/2 mark for each correct classification

24 i. Mutable Data Type: 2

Value can be changed after object creation.
Example: list (e.g., [1, 2, 3])

ii. Immutable Data Type:

Value can not be changed after object creation.
Example: integer (e.g., 5)
1 mark for both definitions
1 mark for both examples

25 IOT involves connecting everyday object and devices to the internet so that 2
they can communicate and exchange data.
Example: Devices like Smart lights, and Smart security cameras.
1 mark for definition
1 mark for example

4 XI-INFORMATICS PRACTICES-M
26 In Python, Loop is used to repeatedly execute a block of code. 3
i. for loop example:
for fruit in ["apple", "banana", "cherry"]:
print(fruit)
ii. while loop example:
count = 0
while count < 5:
print(count)
count += 1
1 marks for concept of loop
1 marks each for correct examples of both type of loops
OR
Importance of Comments:
Comments provide explanations about code, enhancing readability and
understanding.
Example :
# This is a comment
2 marks for correct importance
1 mark for correct example

27 Candidate Key: Uniquely identifies a record in a relation; a relation can 3

have multiple candidate keys.
Example: In a "Person" table, both "Employee_ID" and "Aadhar_Number"
can be candidate keys.
Primary Key: Candidate key chosen as the main identifier to uniquely
identify each record in the table.
Example: "Employee_ID" may be chosen as the primary key for the
"Person" table.

5 XI-INFORMATICS PRACTICES-M
 2 marks for correct difference
1 marks for correct example

28 a) Create database department; 1x3

b) Select * from employee;
c) Update employee set name = 'anaya' where emp_id = 1001;
1 mark for each correct query

29 Output : 3
List : [10, 15, 20, 30]
Length : 4
Count : 1
1 mark for correct output of each point statement
OR
Output :
{'a': 10, 'b': 20, 'c': 30, 'd': 40, 'e': 50}
{'a': 10, 'b': 25, 'c': 30, 'd': 40, 'e': 50}
Number 5
1 mark each correct output of each point statement

30 old_list = [1, 2, 3, 4, 5, 6] 3
new_list = []
for num in old_list:
if num % 2 == 0:
new_list.append(num)
print("new_list = ", new_list)
3 marks for correct program

31 a) Random Access Memory: Temporary storage for active programs and 4

data, fast but volatile (data lost when powered off).
b) Secondary Memory: Permanent storage for data, slower but non-volatile.
c) System Software: Controls and manages hardware, provides platform for

6 XI-INFORMATICS PRACTICES-M
 other application software (e.g., OS, device drivers).
d) Application Software: Performs specific tasks for users (e.g., word
processors, MS Excel).
1 mark each for each correct definition

32 a) 1+1+2=4

empid empname phone email dateofjoining

2001 Sachin 9876542312 [email protected] 2019-10-30

2002 Rohit 9857452896 [email protected] 2020-10-23

2003 Rishi NULL [email protected] 2019-11-25

2004 Mohit 9857417458 [email protected] 2021-10-24

b)
empid empname
2003 Rishi
2004 Mohit

c)

empname email
Sachin [email protected]
Rohit [email protected]
Mohit [email protected]

7 XI-INFORMATICS PRACTICES-M
 OR (Option for part C only - 2 marks)
c)

empname dateofjoining
Sachin 2019-10-30
Rishi 2019-11-25

33 a) 1+2+1+1
CREATE DATABASE school; =5

b)
CREATE TABLE staff (
empid numeric PRIMARY KEY,
first_name varchar(20),
last_name varchar(20),
date_of_birth date,
salary float(10,2)
);

c)
INSERT INTO staff (empid, first_name, last_name, date_of_birth, salary)
VALUES (1001, 'Aarav', 'Sharma', '1990-10-12', 70000.00);

d)
DELETE FROM staff WHERE salary > 70000;

OR
a)
CREATE DATABASE library;

8 XI-INFORMATICS PRACTICES-M
 b) 1+2+1+1
CREATE TABLE books ( =5
book_id NUMERIC PRIMARY KEY,
title VARCHAR(50),
author VARCHAR(50),
genre VARCHAR(20)
);

c)
INSERT INTO books (book_id, title, author, genre) VALUES (1, 'Wings of
Fire', 'Dr. APJ Abdul Kalam', 'Autobiography');
d)
DELETE FROM books WHERE book_id = 1;

34 a) Select cust_id, cust_name from customerpayments where payment_mode 5

= 'upi';
b) Select total_bill from customerpayments where cust_name = 'Aarushi';
c) Select cust_name from customerpayments where total_bill > 20000;
d) Alter table customerpayments add address varchar(255);
e) Drop table customerpayments;
1 marks for each correct answer

35 a) False (lst1 is mutable) 5

b) 6
c) 2

9 XI-INFORMATICS PRACTICES-M
d) 10
e) [2, 100, 6, 8, 10]

OR
a) False (dict1 is mutable)
b) 6
c) 2
4
d) 5
e) {'a': 2, 'b': 100, 'c': 6, 'd': 8, 'e': 10}

10 XI-INFORMATICS PRACTICES-M