KENDRIYA VIDYALAYA, CHENNAI REGION

SAMPLE QUESTION PAPER

CLASS XI

SUBJECT: INFORMATICS PRACTICES (065)

General Instructions:
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A have 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each.
8. All programming questions are to be answered using Python Language only.

PART A
1 Which of the following is valid arithmetic operator in Python: 1
(i) // (ii) && (iii) > (iv) and
2 Out of the following, which one is an example for Utility software? 1
a. Operating system
b. Antivirus software
c. compiler
d. MS Word

3 In DML, M stands for 1

a. maintain
b. manage
c. manipulation
d. manipulate
4 Which of the following is correct? 1
a. Keywords can be used as a variable name.
b. Variable name can start with a digit.
c. Variable name can start with an underscore.
d. Variable name can have symbols like: @, #, $ etc.
5 Identify the odd one from the following: 1
a. MySQL
b. SQLite
c. Python
d. Oracle
6 consider L=(2,3,4). What is the output of print( L*2) 1
a. (2,3,4),(2,3,4)
b. (2,3,4,2,3,4)
c. (2,2,3,3,4,4)
d. error
7 A candidate key that is not a primary key are 1
called______________________
a. Super key
b. Alternate Key
c. Primary Key
d. Foreign Key
8 The device capable of recognizing a pre-specified type of mark 1
made with dark pencil or ink
a. OCR
b. OMR
c. MICR
d. Barcode reader
9 Evaluate: 1
not(1==1 and 0!=1)
a. True
b. False
c. Error
d. Cannot say
10 The number of rows in a relation is called ________________ 1
a. Tuple
b. Attribute
c. Cardinality
d. Degree

11 Which one is not a characteristic of Big Data? 1

a. Volume
b. Variety
c. Velocity
d. Virtual
12 Identify the correct SQL query to create a database named SCHOOL 1
a. CREATE SCHOOL;
b. CREATE DATABASE SCHOOL;
c. CREATE SCHOOL DATABASE;
d. CREATE DATABASES SCHOOL;
13 1 GB is equivalent to 1
a. 210 bytes
b. 230 bytes
c. 220 bytes
d. None of the above
14 Which SQL command helps to fetch data from a relation. 1
a. Use
b. Show
c. Fetch
d. Select
15 In IoT, T stands for 1
a. Technology
b. Things
c. Technical
d. Traffic
16 D1={1: ‘India’, 2: ‘Russia’, 3: ‘World’} 1
D2={‘School’: ‘EOIS’, ‘Place’: ‘Moscow’}
print( D1.update(D2))
Write the output of the above code:
a. None
b. {1: 'India', 2: 'Russia', 3: 'World', 'School': 'EOIS', 'Place':
'Moscow'}
c. Error
d. None of the above
Q17 and 18 are ASSERTION AND REASONING based questions.
Mark the correct choice as
i. Both A and R are true and R is the correct explanation for A
ii. Both A and R are true and R is not the correct explanation for A
iii. A is True but R is False
iv. A is false but R is True
17 Assertion (A) :MySQL is open source. 1
Reason (R) :MySQL is not available for free of cost.

18 Assertion (A) : Python is an interpreted language. 1

Reason (R) : python executes the code line by line.

PART B
19 Distinguish between primary memory and secondary memory? 2
OR
What is the function of input devices? Write any two examples?

20 Identify the category(Free and open source/proprietary/Freeware) of 2

following software:
a. OpenOffice
b. Adobe Photoshop
c. Skype
d. Python
21 What will be the output of the following code 2
p=10
q=20
p*=q/2
q+=p+q*2
print('p=',p)
print('q=',q)
22 Categorize following commands into DDL and DML commands? 2
INSERT, DROP, ALTER, UPDATE
23 What will be the output of the following program? 2
a,b,c = 10,20,30
a,b,a = c+2,a+5,c+3
print(a,b)

OR

What will be the output?

for num in range(2,10,2):

s=0
print(num,end=’’)
s=s+num
print(“sum=”,s)

24 Arvind is learning MySQL for managing different databases and 2

tables for his Python based application/software. Tell him the SQL
commands for the following:-
(i) How to show pre-existing databases.
(ii) How to use a desired database

25 With the help of suitable table, explain candidate key and alternate 2
key?

PART C
26 Briefly explain computer system with neat diagram 3

27 Evaluate the following 3

a. 17//5
b. 25>10 and 50<10
c. 15<5 or 7>10 and 3>2 or not 5
d.
28 a. What are the different datatypes in SQL. 1+2
b. Differentiate between char and varchar datatype in SQL?
c.
29 a. Explain grid computing? 3
b. List out the three cloud computing services?
c. Write any two applications of Artificial Intelligence

OR
What is big data? What are the characteristics of big data?
30 Consider the given list, L=[20,30,40,100]. What will be the output 3
of the following:
i. print(L*2)
ii. print(L[-2])
iii. print(L.pop())

or
Explain the following list functions with example:
i. insert()
ii. remove()
iii. append()
PART D
31 Write output for SQL queries (i) to (v) based on the table: SCHOOL 5

i. SELECT * FROM SCHOOL WHERE

SUBJECT=’ENGLISH’;
ii. SELECT CODE, TEACHERNAME FROM SCHOOL;
iii. SELECT SUBJECT FROM SCHOOL;
iv. SELECT TEACHERNAME FROM SCHOOL WHERE
EXPERIENCE>10;
v. SELECT DOJ FROM SCHOOL WHERE
SUBJECT=’CHEMISTRY’ OR EXPERIENCE=15;

OR

i. List out any two examples for RDBMS.

ii. Write any two advantages of database over traditional
file system.
iii. What is SQL?
iv. Write the data type for the column teachername and
experience.
v. Which SQL clause is used to apply condition to
individual rows.
32 Lima wants to write a program for currency conversion. The rate for 5
currency conversion is 1$=₹ 72.50. Answer the following questions:
rupee=input("Enter the amount in rupees:")#Statement 1
dollar=rupee//72.5 # Formula for conversion #(Statement2)
if dollar>1: #Statement 3
print("Amount in dollars is:", dollar, end= '') #Statement 4
else:
print("Enter valid amount!!!",end= '')
print("Thank you for using currency converter!")
i. Find out the error in statement 1:
a. No error
b. Single quotations to be used in place of double quotation marks
c. Type conversion function to be used
d. None of the above
ii. Is the operator used in statement 2 correct? If not, which is the
correct one?
a. // is correct
b. /
c. %
d. None of the above
iii. The comment used in statement 2 (shown in bold letters) is:
a. Single line comment
b. Multiline comment
c. Inline comment
d. Specific comment
iv. The best suited data type for rupee will be
a. string
b. int
c. float
d. list
v. Suppose the input value rupees is accepted in integer form, then
what will be the output of the above program, when the input is
given as 200?
33 Consider the given table and write SQL queries for the following: 5

i. To create the table organisation.

ii. To add one more row with the given values(2006,
REENA,DEPUTY MANAGER,D001,22-DEC-2012)
iii. To display the post from the table organisation?
 iv. To display the name and post of employees whose
SGRADE is D003.
v. To display the SGRADE and POST of all employees.

OR
Explain the following terms with an example table:
i. Relation
ii. Tuple
iii. Domain
iv. primary key
v. cardinality
PART E
34 Consider the following table “ACTIVITY” and answer the 1+1+2
following question based on this table?

a. What is the degree and cardinality of the given table?

b. Suppose two more columns are added to the given table, then
what will be the cardinality and degree?
c. Write the names of most appropriate columns, which can be
considered as Primary Key. Justify your answer
OR (Option for part c only)
Difference between DDL and DML with example?
35 Consider the given dictionary, 1+1+2
D={1:’monday’, 2:’Tuesday’, 3:’Wednesday’,4:’Thursday’}.
a. What will be the output of following code:
i. print(D.values())
ii. print(D.get(2))
b. write python code to add a new value ‘Friday ‘with index 5.
Or (Option for part b only)
Write python code to remove the value ‘Wednesday’ from the
dictionary.
 KENDRIYA VIDYALAYA, CHENNAI REGION

SAMPLE QUESTION PAPER

CLASS XI

SUBJECT: INFORMATICS PRACTICES (065)

ANSWER KEY

PART A
1 (i) // 1
2 Antivirus software 1
3 Manipulation 1
4 Variable name can start with an underscore. 1
5 Python 1
6 b. (2,3,4,2,3,4) 1
7 Alternate Key 1
8 OMR 1
9 False 1
10 Cardinality 1
11 Virtual 1
12 CREATE DATABASE SCHOOL; 1
13 230 bytes 1
14 Select 1
15 Things 1
16 None 1
17 iii 1
18 i 1
PART B
19 Any two correct difference 2
Or
Function of input device( 1 mark), two eg(1 mark)
20 a. OpenOffice-Free and open source 2
b. Adobe Photoshop-Proprietary
c. Skype-Freeware
d. Python- Free and open source
21 p=100.0 2
q=160.0
(1 mark for each correct answer)
22 DDL-, DROP, ALTER 2
DML-INSERT,UPDATE
23 33 15 2
Or
 2468
Sum=8

24 (i) SHOW DATABASES; 2

(ii) USE<DATABASENAME>
25 Candidate key and alternate key with example 2
PART C
26 Diagram- 1.5mark 3
Explanation -1.5 mark
27 a. 3 3
b. False
c. False

28 a. Int,date, float,decimal, char, varchar( Any four-1 mark0 3

b. Any two difference( 2 mark)

29 a. A grid is a computer network of geographically dispersed and 3

heterogeneous computational resources. Unlike cloud, whose
primary focus is to provide services, a grid is more application
specific and creates a sense of a virtual supercomputer with an
enormous processing power an storage.(1 mark)
b. Infrastructure as a Service (IaaS), Platform as a Service
(PaaS), Software as a Service (SaaS)- 1 mark
c. (Any two application)-1 mark
Handwriting Recognition, Gaming Intelligent Robots
Natural Language Processing

OR
(definition-1 mark, charctersitics with explanation-2 mark)
Data sets of enormous volume and complexity are called Big Data.
Characteristics of Big Data:
o Volume : Enormous size.
o Velocity : Rate at which the data under consideration is being
 generated and stored.
o Variety : Data set has varied data, such as structured,
semistructured and unstructured data. Some examples are text,
images,
videos, web pages and so on.
o Veracity : Veracity refers to the trustworthiness of the data. Big
data can be sometimes inconsistent, biased, noisy.
o Value : Big data possess to have hidden patterns and useful
knowledge.

30 a. [20,30,40,100,20,30,40,100] 3
b. 40
c. 100

or
explanation with eg, each carries 1 mark
PART D
31 5
i. SELECT * FROM SCHOOL WHERE
SUBJECT=’ENGLISH’;

ii. SELECT CODE, TEACHERNAME FROM SCHOOL;

iii. SELECT SUBJECT FROM SCHOOL;

iv. SELECT TEACHERNAME FROM SCHOOL WHERE

EXPERIENCE>10;
 v. SELECT DOJ FROM SCHOOL WHERE
SUBJECT=’CHEMISTRY’ OR EXPERIENCE=15;

OR
i. MySQL, oracle, SQlite, Postgres(any two- 1 mark)
ii. Database facilitates centralized storing, Reduces Data
inconsistency, Reduces data redundancy, Sharing of data is
possible etc (Any two correct points- 1 mark)
iii. Structured Query Language (SQL) is a standard language for
accessing and manipulating databases.(1 mark)
iv. Teachername-char/varchar(1/2 mark)
Experience-int(1/2 mark)
v. WHERE(1 mark)

32 i. Type conversion function to be used

ii. b./
iii. a. Single line comment
iv. c. float
v. Amount in dollars is:2.0Thank you for using currency converter!
33 5
i. CREATE TABLE ORGANISATION(ECODE
INT,NAMEVARCHAR(10),POST
VARCHAR(20),SGRAD VARCHAR(4),DOJ DATE);
ii. INSERT INTO ORGANISATION VALUES(2006,
“REENA”,”DEPUTY MANAGER”,”D001”,”22-DEC-
2012”);
iii. SELECT POST FROM ORGANISATION;
iv. SELECT NAME,POST FROM ORGANISATION
WHERE SGRADE=’D003’;
v. SELECT SGRADE,POST FROM ORGANISATION;

OR
 i. Relation - Tables in Relational Database
ii. Tuples - Records/Rows in a relation
iii. Domain - Set of values taken for an attribute
iv. Primary key - Key attribute that uniquely identifies a tuple
v. Cardinality – No. of Tuples/records in a relation
(explanation with eg table- 1 mark for each)

PART E
34 a. DEGREE=5,CARDINALITY=5(1 mark) 4
b. DEGREE=7, CARDINALITY=5(1 mark)
c. ACODE as PRIMARY KEY, Because it is unique and not
null( 2 mark)
OR
Any two difference with eg(2 mark)
35 a. i. Monday,Tuesday, Wedneday,Thursday( 1 mark) 4
ii.Tuesday(1 mark)
b. D[5]=’Friday’(2 mark)
Or
del D[3](2 mark)
KENDIRYA VIDYALAYA SANGATHAN, CHENNAI REGION
SAMPLE PAPER CLASS XI
INFORMATICS PRACTICES 065
MM:70 TIME: 180 MIN

General Instructions:

1. This question paper contains five sections, Section A to E.

2. All questions are compulsory.

3. Section A have 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each. One internal choice is given in
Q35 against part c only.

8. All programming questions are to be answered using Python Language only.

PART-A

1 1
An Antivirus software is an example of
i) Application Software
ii) System software
iii) Utility software
iv) None of these

2 1
First time, Integrated Circuits (ICs) are introduced in generation of
computers?
i) First generation
ii) Second generation
iii) Third generation
iv) Fourth generation

3 8 GB=________ bits? 1

4 Which one of the following is invalid Identifier? 1

(i) 11IPCommerce (ii) While (iii) _Number (iv) Apple12
5 Operator with the highest precedence is : 1
i) %
ii) +
iii) and
iv) **

6 Which of the following are illegal operations on lists? 1

i) L+L
ii) L*2
iii)L+2
iv) L*L

7 Which of the following is a mutable data type? 1

i) String
ii) List
ii) Tuple
iv) Float

8 Tuples are represented using : 1

i) []
ii) ( )
iii { }
iv) < >

9 SQL stands for: 1

i) Scripting Questioning Language
ii) Scripting Query Language
iii) Simple Query Language
iv) structured Query Language

10 Which command is used to show the structure of a table? 1

i) Use
ii) Show
iii) Desc
iv) Alter

11 Which command is used to delete a column from a table: 1

i) Update
ii) Delete
iii) Drop
iv) Alter

12 Attribute is another name for: 1

i) Row
ii) column
iii) Table
iv) Relation
13 Which one is not a DDL command: 1
i) Alter
ii) Update
iii) Create
iv) Drop

14 Which key is having constraint Unique and Not NULL in it. 1

i) Primary Key
ii) Foreign Key
iii) Not Null Key
iv) Unique Key

15 What does IoT stand for? 1

i) Internet Of Transmission
ii) Interview Of Things
iii) Internet Of Things
iv) Interconnection Of Tables

16 Which is not a personal assistant application : 1

i) Alexa
ii) Google Assistant
iii) Instagram
iv) Siri

Q17 and 18 are ASSERTION AND REASONING based questions. Mark the correct choice as

i. Both A and R are true and R is the correct explanation for A

ii. Both A and R are true and R is not the correct explanation for A

iii. A is True but R is False

iv. A is false but R is True

17 Assertion (A): - Updating value of any element in a tuple will give error. 1

Reasoning (R):- Tuple is Immuatble

18 Assertion (A): -.Alter command is used to update values in a table. 1

Reasoning (R):- Alter is a DDL command and it deals with the structure of a table.
PART-B
19 Differentiate between RAM and ROM. 2

Or

Differentiate between Primary and Secondary Memory.

20 Differentiate between System Software and Application Software. Give examples of each. 2

21 2
Write the corresponding Python assignment statement.
a) Assign 10 to a variable height and 20 to a variable weight.
b) Assign the sum of height and weight to a variable total.

22 Write the output of following code: 2

d1={'Name':'Mohit','Age':15,'Class':11,'Section':'B'}
d2={'Name':'Astha','Age':17,'RollNo':3}
d1.update(d2)
print(d1)
print(d2)

23 Name any two DML commands along with their use. 2

Or
Write the use of Show and Use command.

24 2
Explain the role of where clause in MYSQL with the help of an example.

25 Differentiate between Char and Varchar datatypes in MySQL. 2 2

PART-C

26 Write a short note on Operating Systems and its Functions. 3

27 Write a program to calculate factorial of a given number. 3

28 Write a program to take a list input and find the smallest number from the list. 3

29 Write SQL queries for the following: 3

(i) Create table Result having following columns:
RollNo int,
Name varchar(30),
Marks int
(ii) Add a column Percentage of type decimal(5,2) in an existing table Result.
(iii) Delete table Result.

OR

Explain the Purpose of Database Management System

30 What is Cloud Computing? Explain its three different Services. 3
Or
Write a short note on Big Data.

PART-D

31 Write a program to take input as a list and store the characters and their number of 5
occurences in a dictionary as key value pairs and then display the dictionary.
Eg: Input :[ 'a','a','b','b','a','c','c','c','c','c','d','d','d','d','d','e','e','e']
Output: {'a':3,'b':2,'c':5,'d':5,'e':3}

Or

Write a program to Create a dictionary of students to store names and marks obtained in 5
subjects.

32 5

Write SQL Queries for the following:

i) To display names of stores along with SalesAmount of those stores that have
NoOfEmp is more than 10 in their store names.
ii) To display Stores names, Location and DateOfOpen of stores that were opened
before 1st March, 2015.
iii) To display name and location of those store which have salesAmount less
than 40000.
iv) To display all the records of the table Store where city is Mumbai.
v) To display the stores where sales amount is between 40000 to 70000.
33 On the basis of following table answer the given questions: 5

(i) Write the degree and cardinality of the above table.

(ii) What will be the output of the following query :
Select * From Customer_Details order by DOJ;
(iii) Write the sql query to display the row from the table where customer has no accumulated
amount.
(iv) What will be the output of the following query:
Select * from Customer_Details where Acc_Type='Savings';
(v) Write the sql query to display all the customer names having DOJ more than ‘02/19/1994’.

Or

i) What are the attributes available in the table Customer Details?

ii) What do you mean by a tuple in an SQL table?
iii) Write a query to update the Accumlt_Amt=20000 for Manpreet.
iv) What will be the output of the following query:
Select * from Customer_Details where Acc_Type='Current'
v) Write a query to display all customer name salong with their DOJ.

PART- E
34 Consider the following list and answer any four questions from (i) to (iv) 1+1+2
lst1 = [1, 3, 5]
lst2 = [6, 7, 8]
lst3 = [10, 11, 12]
i) Predict the output for the following process
>>> lst1 + lst2 + lst3

ii) What will be the possible result of the replication process of the given list
>>> lst1 * 3
a) [3, 9, 15]
b) [1, 3, 5, 1, 3, 5, 1, 3, 5]
c) [4, 6, 8]
c) None of the Above

iii) What will be the output of the following code?

>>> len(lst1 + lst2 + lst3)
a) [17, 21, 25]
b) 9
c) 8
d) None of the Above

or
Predict the output of the following code >>>l1.append(100)
a) [1, 3, 5, 100]
b) [1, 3, 100, 5]
c) [100, 1, 3, 5]
d) None of the Above

35 1+1+2
a)Using SQL statements in MySQL, create the Database Name: Univ also write a
query to open the database Univ.
Answer parts b), c) on the basis of the structure table job.

b) Create a table Job with the specification given above.

c) Identify the primary and alternate key.
or
How will you enlist the name of database and the tables in a database?
KENDIRYA VIDYALAYA SANGATHAN, CHENNAI REGION
SAMPLE PAPER MARKING SCHEME CLASS XI
INFORMATICS PRACTICES 065
MM:70 TIME: 180 MIN

General Instructions:

1. This question paper contains five sections, Section A to E.

2. All questions are compulsory.

3. Section A have 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each. One internal choice is given in
Q35 against part c only.

8. All programming questions are to be answered using Python Language only.

PART-A

1 iii) Utility software 1

2 iii) Third generation 1

3 8 GB=________ bits? 1

4 i)11IPCommerce 1

5 iv) ** 1

6 i) L+L 1
ii) L*2

7 ii) List 1

8 ii) () 1

9 iv) structured Query Language 1

10 iii) Desc 1

11 iv) Alter 1

12 ii) column 1

13 ii) Update 1

14 i) Primary Key 1

15 iii) Internet Of Things 1

16 iii) Instagram 1

Q17 and 18 are ASSERTION AND REASONING based questions. Mark the correct choice as

i. Both A and R are true and R is the correct explanation for A

ii. Both A and R are true and R is not the correct explanation for A

iii. A is True but R is False

iv. A is false but R is True

17 i 1

18 iv 1

PART-B

19 2 Marks for any two differences 2

Or

2 Marks for any two differences

20 2 Marks for any two differences along with example 2

21 2

a) 1 mark for correct answer

b) 1 mark for correct answer

22 {'Name': 'Astha', 'Age': 17, 'Class': 11, 'Section': 'B', 'RollNo': 3} 2

{'Name': 'Astha', 'Age': 17, 'RollNo': 3}
1 Mark each for each output
23 Name any two DML commands along with their use. 2
Or
Write the use of Show and Use command.

24 2
1 Mark for explanation and 1 Mark for example

25 2 Marks for 2 correct differences 2

PART-C

26 1 Mark for definition 3

1 Mark for functions
1 Mark for Examples

27 1 Mark for correct input 3

1 Mark for correct loop
1 Mark for calculation of factorial

28 1 Mark for correct input 3

1 Mark for correct loop
1 Mark for computing smallest number

29 Write SQL queries for the following: 3

(i) Create table Result (RollNo int, Name varchar(30), Marks int);
(ii) Alter table Result add column Percentage decimal(5,2)
(iii) Drop table Result.
1 Mark for each correct query

OR

3 Marks for correct explanation

30 3 Marks for correct explanation 3

Or
3 Marks for correct explanation

PART-D
31 L=eval(input("Enter list elements : ")) 1 Mark for correct input 5
d={} ½ mark for empty dictionary
for e in L: 1 Mark for correct outer loop
if e not in d.keys(): 1 Mark for correct outer loop
d[e]=L.count(e) 1 Mark for correct statement
print(d) ½ mark for output

Or

d={}
ch='y'
while ch=='y': #1 Mark for loop
name=input("Enter name of student") #2 Marks for all inputs
m1=int(input("Enter marks in subject 1:"))
m2=int(input("Enter marks in subject 2:"))
m3=int(input("Enter marks in subject 3:"))
m4=int(input("Enter marks in subject 4:"))
m5=int(input("Enter marks in subject 5:"))
d[name]=[m1,m2,m3,m4,m5] #1 Mark for adding element to
dictionary
ch=input("Add more...?? (y/n") #1 Mark for statement
print(d)

32 i) Select name, salesAmount from Stores where NoOfEmp>10; 5

ii) Select Stores names, Location, DateOpen from stores where DateOpen
<’15-03-01’.
iii) Select name, location from stores where salesAmount < 40000
iv) Select * from stores where city=’ Mumbai’.
v) Select name from stores where sales amount between 40000 and 70000.

33 5

(i) Degree=6 and cardinality=4.

(ii) 1st, 4th, 2nd and 3rd will be sequence of rows
(iii) Select * from Customer_Details where Accumlt is null;
(iv) 1st and 3rd row
(v) Select cust_names from customer_details where DOJ > ‘02/19/1994.

Or

i) Cust_ID, Cust_Name, Acc_Type, Accumlt_Amt,DOJ, Gender

ii) Tuple means row
iii) update customer_details set Accumlt_Amt=20000 where name= ‘Manpreet’.
iv) 2nd and 4th row
v) Select cust_name, DOJ from Customer_Details.
 PART- E

34 1+1+2
i) [1,3,5,6,7,8,10,11,12]

ii) b) [1, 3, 5, 1, 3, 5, 1, 3, 5]

iii) b) 9

or

a) [1, 3, 5, 100]

35 1+1+2
a) create database Univ.

Use univ

b) Create table Job (Job_Id int(4), Job_des varchar(30), Alloc_on date, Due_on date, Emp_id
int(4));
c) primary key- Job_id and there is no alternate key.
or
show databases and show tables.
 KENDRIYA VIDYALAYA SANGATHAN CHENNAI REGION

SAMPLE QUESTION PAPER

CLASS : XI

INFORMATICS PRACTICES ( 065 )

DURATION: 3 Hrs. MAX MARKS : 70

______________________________________________________________________________
General Instructions:
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A have 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each. One internal choice is
given in Q35 against part c only.
8. All programming questions are to be answered using Python Language only.
Section A [18 x 1= 18]

Q Question Mark
No s
.

1 Who developed python? 1

a) Charles Babbage b) Guido Van Rossum

c) Tim Berners Lee d) Robert E Kahn

2 ROM is a --------- memory. 1

a) Volatile b) non- volatile c) both a and b
d) None of these
3 Which of the following is not an input device? 1
a) Keyboard b) Monitor c) Joystick
d) Microphone
4 ____________ is a system software that translates and executes 1
instructions
written in a computer program line-by-line.
a) Assembler b) Interpreter c) Compiler
d) None of these
5 Which for loop statement will produce first 5 odd numbers: (Two 1
options are correct)
a) for x in range(1,9,2): b) for x in range(1,10,2):
 c) for x in range(9, 1, -2): d) for x in range(9,-1,-2):
6 Suppose list1 is [1,3,2], What is list1 * 2? 1
a) [2,6,4] b) [1,3,2,1,3] c) [1,3,2,1,3,2]
d) [1,3,2,3,2,1]
7 What will be the output of the following Python code? 1
D={1:”A”,2:”B”,3:”C”}
for i in D:
print(i,end=” “)
a) 1 2 3 b) A B C c) 1 ‘A’ 2 ‘B’ 3 ‘C’
d) Error
8 Write output of the expression, 22 % 3 : 1
a) 7 b) 1 c) 0 d) 5
9 Find the invalid identifier(s) from the following: 1
a) Name1 b) _Total c) my-name d) break
10 _______________ command is used to add a new record in a table. 1
a) SELECT b) INSERT c) UPDATE d) USE
11 Choose DML command from the following: 1
a) CREATE b) ALTER c) DELETE d) DROP
12 SELECT * statement displays all -------------------- of a table. 1
a) Rows b) Attributes c) Tuples d)
Domain values
13 Horizontal subset of table is known as ---------------- 1
a) Tuple b) Attribute c) domain d) Degree
14 Consider the table EMPLOYEE 1

EID NAME SALES JOBID

E1 SUMIT SINHA 1100000 102

E2 VIJAY SINGH 1300000 101

TOMAR

E3 AJAY RAJPAL 1400000 103

E4 MOHIT 1250000 102

 E5 SHAILAJA 1450000 103

What is the cardinality of the table?

a) 4 b) 5 c) 1 d) 20

15 --------------------- is an artificially intelligent technology that help 1

computers understand, interpret, and manipulate human language.
a) NLP b) AR c) VR d) ML
16 Which one of these is not an area of AI? 1
a) Face/Image Recognition b) Voice Recognition
c) Robotics d) Web Designing
17 Q No. 17 and 18 are ASSERTION AND REASONING based 1
questions. Mark the correct choice as
i. Both A and R are true and R is the correct explanation for A
ii. Both A and R are true and R is not the correct explanation for A
iii. A is True but R is False
iv. A is false but R is True
Assertion (A): - The keyword DISTINCT is used to eliminate
redundant data from a table.
Reasoning (R):- WHERE clause is used to select specific rows.
18 Assertion (A): - Python is an interpreted programming language. 1
Reasoning (R):- The Python program is processed at runtime by the
interpreter and you do not need to compile your program before
executing it.

Section B [7 x 2= 14]
19 Briefly explain system software and application software with 2
examples.
OR
Briefly explain the components of computer system using block
diagram.
20 Write the difference between compiler and interpreter. 2

21 Predict the output of the following code 2

x=2
y=5
 z =x + 2**3
x = y *2
y=x+z
print (“Python Program”)
print (“Value of x : ”, x)
print (“Value of y : ”, y)
print (“Value of z : ”, z)
22 What will be the output of the following statements? 2

i) list1 = [12,32,65,26,80,10]
list1.sort()
print(list1)
ii) myList = [1,2,3,4,5,6,7,8,9,10]
del myList[:5]
print(myList)
23 Consider the table STUDENT and answer the following: 2

RollNo Name Class Mark

1 Anitha 11C 58

2 Neha 11C 65

3 Sanjay 11D 89

i) Write the degree and cardinality of the table STUDENT.

ii) Write the query to display name and mark of the
student whose roll number is 2.

OR

Predict output:

i) SELECT name FROM STUDENT WHERE Mark>70;

ii) SELECT * FROM STUDENT WHERE class=”11D”;

24 What is DBMS ? Write names of any two DBMSs. 2

25 Define Primary key of a table with the help of an example. 2

Section C [5 x 3= 15]

26 Explain primary memory and secondary memory with examples. 3

OR
Expand the following
 i) ALU ii) LCD iii) CD-ROM iv) DVD v)
FOSS vi) MICR
27 Write a Python program to print the factorial of a number. 3

OR

Write a Python program to calculate the compound interest. The

principal, rate of interest and time must be entered by the user.

(Formula: Compound Interest = Principal (1 + Rate/100)Time )

28 Write a program to calculate the average and total of 5 numbers in a 3

list.

29 Explain two categories of SQL and mention the commands in each. 3

30 What is artificial intelligence? List any 2 applications of AI 3

OR

What do you understand by immersive experience?

Section D [3 x 5= 15]

31 Write a program to read a list of n integers (positive as well as 5

negative). Create two new lists, one having all positive number and
the other having all negative numbers from the given list. Print all
three lists.

OR

The record of a student (Name, Roll No., Marks in five subjects and
percentage of marks) is stored in the following list:

stRecord = ['Raman','A-36',[56,98,99,72,69], 78.8]

Write Python statements to retrieve the following information from

the list stRecord.

(a) Percentage of the student

(b) Marks in the fifth subject

(c) Maximum mark of the student

(d) Roll no. of the student

(e) Change the name of the student from ‘Raman’ to ‘Raghav’

32 Explain the following terms in DBMS with the help of a table. 5
Mention examples of each term based on the table data:

i) Relation
ii) Tuple
iii) Domain
iv) Attribute
v) Primary key

33 Consider the table SUBJECT and answer the following: 5

SubCode SubName Teacher EnrolNum

S065 Informatics Practices Rahul Sharma 40

S083 Computer Science Varun Kumar 45

S042 Physics K Raja 50

S030 Economics Ahmed Khan 48

i) Write query to display the name of the teacher teaching subject

with subject code “S042”.
ii) Write query to display the number of enrolled students for the
subject Economics.
iii) Write query to display the details of subjects in which enrolled
students are more than 45.
iv) Write query to display the subject name that Varun Kumar
teaches.
v) Write query to display the name of Physics teacher.

OR

Predict Output:

i) SELECT * FROM subject where SubCode=”S042”;

ii) SELECT SubName from Subject WHERE EnrolNum<45;
iii) SELECT Teacher from Subject WHERE EnrolNum<48 AND
EnrolNum>=45;
iv) SELECT * from Subject WHERE SubName=’Economics’;
v) SELECT SubName, EnrolNum from Subject;

Section E [2 x 4= 8]

34 Write a program to calculate EMI as per formula: E=PR(1+R)n 4

/((1+R)n -1)
 Where E=EMI, P= Principal Loan amount, R= Rate of Interest per
month (i.e. Annual Rate of Interest/100/12), tenure of loan repayment
in months;

Get the input from user (e.g., calculate EMI for loan amount of 200000
at 10% p.a. rate of interest) for a period of 2 years i.e., 24 months.

OR

Write a Python program to accept a number from user and prints the
frequency of the number in the list LST . If the number is not in LST ,
it should print “ Not in the list”.

For example : LST=[12,25,15,64,12,65]

If the number entered by user is 12, it will show the output : 2

35 Consider the table EMP_TBL and answer the following: 4

ECode EName Dept Salary

101 Gautam Gupta Sales 55000

102 Nina Sharma Marketing 62000

103 Venkat HR 75000

104 Karan Kumar Sales 45000

105 Asha Yadav HR 72000

A. Write Query :
i) To display the names of employees whose salary is between
50000 and 70000.
ii) To display the name and salary of employees of sales
department.
B. Predict Output
i) SELECT Ename FROM EMP_TBL WHERE dept=”Sales”;
ii) SELECT salary FROM EMP_TBL WHERE ECode=”103”;

OR ( Choice is only for Part B)

Predict Output:
i) SELECT dept FROM EMP_TBL WHERE EName=”Nina
Sharma”;
ii) SELECT * FROM EMP_TBL WHERE Salary >60000 and
Salary<75000;
 KENDRIYA VIDYALAYA SANGATHAN CHENNAI REGION

SAMPLE QUESTION PAPER

CLASS : XI - INFORMATICS PRACTICES ( 065 )

MARKING SCHEME

DURATION: 3 Hrs. MAX MARKS : 70

______________________________________________________________________________
General Instructions:
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A have 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each. One internal choice is
given in Q35 against part c only.
8. All programming questions are to be answered using Python Language only.

Section A [18 x 1= 18]

Q Question Mark
No s
.

1 Who developed python? 1

a) Charles Babbage b) Guido Van Rossum

c) Tim Berners Lee d) Robert E Kahn

2 ROM is a --------- memory. 1

a) Volatile b) non- volatile c) both a and b d)
None of these
3 Which of the following is not an input device? b)
a) Keyboard b) Monitor c) Joystick d)
Microphone
4 ____________ is a system software that translates and executes
instructions
written in a computer program line-by-line.
 a) Assembler b) Interpreter c) Compiler d)
None of these
5 Which for loop statement will produce first 5 odd numbers: (Two options
are correct)
a) for x in range(1,9,2): b) for x in range(1,10,2):
c) for x in range(9, 1, -2): d) for x in range(9,-1,-2):
6 Suppose list1 is [1,3,2], What is list1 * 2?
a) [2,6,4] b) [1,3,2,1,3] c) [1,3,2,1,3,2] d)
[1,3,2,3,2,1]
7 What will be the output of the following Python code? 1
D={1:”A”,2:”B”,3:”C”}
for i in D:
print(i,end=” “)
a) 1 2 3 b) A B C c) 1 ‘A’ 2 ‘B’ 3 ‘C’ d)
Error
8 Write output of the expression, 22 % 3 :
a) 7 b) 1 c) 0 d) 5
9 Find the invalid identifier(s) from the following:
a) Name1 b) _Total c) my-name d) break
10 _______________ command is used to add a new record in a table.
a) SELECT b) INSERT c) UPDATE d) USE
11 Choose DML command from the following:
a) CREATE b) ALTER c) DELETE d) DROP
12 SELECT * statement displays all -------------------- of a table.
a) Rows b) Attributes c) Tuples d) Domain
values
13 Horizontal subset of table is known as ----------------
a) Tuple b) Attribute c) domain d) Degree
14 Consider the table EMPLOYEE 1

EID NAME SALES JOBID

E1 SUMIT SINHA 1100000 102

 E2 VIJAY SINGH 1300000 101
TOMAR

E3 AJAY RAJPAL 1400000 103

E4 MOHIT 1250000 102

E5 SHAILAJA 1450000 103

What is the cardinality of the table?

a) 4 b) 5 c) 1 d) 20

15 --------------------- is an artificially intelligent technology that help 1

computers understand, interpret, and manipulate human language.
a) NLP b) AR c) VR d) ML
16 Which one of these is not an area of AI? 1
a) Face/Image Recognition b) Voice Recognition
c) Robotics d) Web Designing
17 Q No. 17 and 18 are ASSERTION AND REASONING based questions. 1
Mark the correct choice as
i. Both A and R are true and R is the correct explanation for A
ii. Both A and R are true and R is not the correct explanation for A
iii. A is True but R is False
iv. A is false but R is True
Assertion (A): - The keyword DISTINCT is used to eliminate redundant
data from a table.
Reasoning (R):- WHERE clause is used to select specific rows.
Ans. ii
18 Assertion (A): - Python is an interpreted programming language. 1
Reasoning (R):- The Python program is processed at runtime by the
interpreter and you do not need to compile your program before
executing it.
Ans. i

Section B [7 x 2= 14]
19 Briefly explain system software and application software with examples. 2
Ans. System software Example- Operating System
Application software Example- MS Office, MS Paint
 OR
Briefly explain the components of computer system using block diagram.
Ans . Input unit, Output unit, CPU- ALU, Control unit, Memory unit
20 Write the difference between compiler and interpreter. 2
Ans. Compiler transforms code written in a high-level programming
language into the machine code, at once, before program runs, whereas
an Interpreter converts each high-level program statement, one by one,
into the machine code, during program run.
Compiled code runs faster while interpreted code runs slower.
Compiler displays all errors after compilation, on the other hand, the
Interpreter displays errors of each line one by one.
Compiler takes an entire program whereas the Interpreter takes a single
line of code.
21 Predict the output of the following code 2

x=2
y=5
z =x + 2**3
x = y *2
y=x+z
print (“Python Program”)
print (“Value of x : ”, x)
print (“Value of y : ”, y)
print (“Value of z : ”, z)
Ans. 10
20
10
22 What will be the output of the following statements? 2

i) list1 = [12,32,65,26,80,10]

list1.sort()

print(list1)

Ans. [10, 12, 26, 32, 65, 80]

ii) myList = [1,2,3,4,5,6,7,8,9,10]

del myList[:5]
 print(myList)

Ans. [6, 7, 8, 9, 10]

23 Consider the table STUDENT and answer the following: 2

RollNo Name Class Mark

1 Anitha 11C 58

2 Neha 11C 65

3 Sanjay 11D 89

i) Write the degree and cardinality of the table STUDENT.

ii) Write the query to display name and mark of the
student whose roll number is 2.

Ans. i) Degree =4, Cardinality = 3

ii)SELECT Name, Mark from Student WHERE RollNo=2;

OR

Predict output:

i) SELECT name FROM STUDENT WHERE Mark>70;

ii) SELECT * FROM STUDENT WHERE class=”11D”;

Ans. i) Sanjay

ii).

3 Sanjay 11D 89

24 What is DBMS ? Write names of any two DBMSs. 2

Ans. It is a software that is responsible for storing, manipulating,

maintaining and utilizing database. Eg:- MySQL, Oracle

25 Define Primary key of a table with the help of an example. 2

Ans. Key attribute that uniquely identifies a tuple

• Only one primary key in a relation

• No null values in primary key column

• No values can be repeated in a primary key column

Definition 1 mark, Example with table I mark

 Section C [5 x 3= 15]

26 Explain primary memory and secondary memory with examples. 3

Ans. Primary memory -RAM and ROM : 1.5 marks
Secondary memory with example : 1.5 marks
OR
Expand the following
i) ALU – Arithmetic Logic Unit ii) LCD – Liquid Crystal
Display
iii) CD-ROM - Compact Disk- Read Only Memory iv) DVD –
Digital Video Disk
v) FOSS–Free and Open Source Software vi) MICR-Magnetic Ink
Character Recognition
27 Write a Python program to print the factorial of a number. 3

Ans. num = int(input("Enter a number: "))

factorial = 1
if num < 0:
print("Sorry, factorial does not exist for negative numbers")
elif num == 0:
print("The factorial of 0 is 1")
else:
for i in range(1,num + 1):
factorial = factorial*i
print("The factorial of",num,"is",factorial)
OR

Write a Python program to calculate the compound interest. The

principal, rate of interest and time must be entered by the user.

(Formula: Compound Interest = Principal (1 + Rate/100)Time )

Ans.

principal = int(input("Enter principal amount: "))

rate = int(input("Enter interest rate: "))
time = int(input("Enter time(years): "))
ci= principal * ((1 + rate / 100)**time) - principal
print("Compound interest is ",ci)
28 Write a program to calculate the average and total of 5 numbers in a list. 3

Ans.
 a=[]
for i in range(0,5):
elem=int(input("Enter element: "))
a.append(elem)
avg=sum(a)/5
print("Average of elements in the list", avg)
29 Explain two categories of SQL and mention the commands in each. 3

Ans. DDL – Create, Alter, Drop

DML- Insert , Update, Delete
DQL – Select
Category+ example :- 1 mark each

30 What is artificial intelligence? List any 2 applications of AI 3

AI refers to artificial creation of human like intelligence.

Applications:

1. Gaming
2. Natural Language processing
3. Expert systems
4. Speech Recognition
5. Intelligent robots

Or

What do you understand by immersive experience?

Ans. It includes various technologies that enhance our senses and gives
us immersive experience. It includes technologies Virtual Reality (VR)
and Augmented Reality (AR).

Points on AR, and VR :- 1 mark each

Section D [3 x 5= 15]

31 Write a program to read a list of n integers (positive as well as negative). 5

Create two new lists, one having all positive number and the other having
all negative numbers from the given list. Print all three lists.

Ans.

L=eval(input("Enter list elements"))

P=[]
N=[]
for i in L:
if i<0:
 N.append(i)
elif i>0:
P.append(i)
print("Positive elements are: ",P)
print("Negative elements are: ",N)
print("Original elements are: ",L)
OR

The record of a student (Name, Roll No., Marks in five subjects and
percentage of marks) is stored in the following list:

stRecord = ['Raman','A-36',[56,98,99,72,69], 78.8]

Write Python statements to retrieve the following information from the

list stRecord.

(a) Percentage of the student

(b) Marks in the fifth subject

(c) Maximum mark of the student

(d) Roll no. of the student

(e) Change the name of the student from ‘Raman’ to ‘Raghav’

Ans. a) stRecord[3]

b) stRecord[2][4]
c) max(stRecord[2])
d) stRecord[1]
e) stRecord[0]=”Raghav”

Each correct answer carries 1 mark

32 Explain the following terms in DBMS with the help of a table. Mention 5
examples of each term based on the table data:

i) Relation
ii) Tuple
iii) Domain
iv) Attribute
v) Primary key

Ans.

Empi Enam Ag Dept Designatio Date_of_Joi Salar

d e e n n y
 101 Manis 35 Sales Salesman 22-05-2010 35000
h

102 Rekha 30 HR Accountant 01-07-2015 40000

103 Swati 40 HR Manager 05-09-2011 55000

104 Rahul 26 Marketin Manager 08-01-2018 30000

g

➢ Relation - Tables in Relational Database

Eg:Employee

➢ Attributes - Columns in a Relation

Eg: Empid, Ename, Age, Dept, Designation, Date_of_Join, Salary

➢ Tuples - Records/Rows in a relation

Eg: 101, Manish, 35, Sales, Salesman, 22-05-2010 ,

35000

➢ Domain - Set of values taken for an attribute

Eg: Domain of (Ename)={ Manish, Rekha, Swati, Rahul}

➢Primary key - Key attribute that uniquely identifies a tuple

Eg: Empid in Employee table

a Consider the table SUBJECT and answer the following: 5

SubCode SubName Teacher EnrolNum

S065 Informatics Rahul 40

Practices Sharma

S083 Computer Varun 45

Science Kumar

S042 Physics K Raja 50

S030 Economics Ahmed 48

Khan
 i) Write query to display the name of the teacher teaching subject
with subject code “S042”.
ii) Write query to display the number of enrolled students for the
subject Economics.
iii) Write query to display the details of subjects in which enrolled
students are more than 45.
iv) Write query to display the subject name that Varun Kumar teaches.
v) Write query to display the name of Physics teacher.
S030 Economics Ahmed 48
Ans.
Khan

i) Select teacher from Subject where SubCode=”S042”;

ii) Select EnrolNum from subject where Subname=”Economics”;
iii) Select * from Subject where enrolnum>45;
iv) Select subname from subject where Teacher=”Varun Kumar”;
v) Select Teacher from Subject where Subname=”Physics”;

OR

Predict Output:

i) SELECT * FROM subject where SubCode=”S042”;

ii) SELECT SubName from Subject WHERE EnrolNum<45;
iii) SELECT Teacher from Subject WHERE EnrolNum<48 AND
EnrolNum>=45;
iv) SELECT * from Subject WHERE SubName=’Economics’;
v) SELECT SubName, EnrolNum from Subject;

Ans. S042 Physics K Raja 50

i)
ii) Informatics Practices
iii) Varun Kumar

iv) SubName EnrolNum

Informatics Practices 40
v)
Computer Science 45

Physics 50

Economics 48

Section E [2 x 4= 8]
34 Write a program to calculate EMI as per formula: E=PR(1+R)n /((1+R)n - 4
1)

Where E=EMI, P= Principal Loan amount, R= Rate of Interest per month

(i.e. Annual Rate of Interest/100/12), tenure of loan repayment in
months;

Get the input from user (e.g., calculate EMI for loan amount of 200000 at
10% p.a. rate of interest for a period of 2 years i.e., 24 months.),
calculate and print the EMI.

Ans. Correct input statement for P, R and n – 1 ½ marks

Correct expression for calculating EMI – 1 ½ marks

Correct print statement – 1 mark

OR

Write a Python program to accept a number from user and prints the
frequency of the number in the list LST . If the number is not in LST , it
should print “ Not in the list”.

For example : LST=[12,25,15,64,12,65]

If the number entered by user is 12, it will show the output : 2

Ans.

LST=eval(input(“Enter elements”))
elm=int(input(“Enter elemnt:”))
c=0
for I in range(0,len(LST)):
if elm==LST[i]:
c=c+1
if c==0:
print(elm,” Not Found”)
else:
print(c )
35 Consider the table EMP_TBL and answer the following: 4

ECode EName Dept Salary

101 Gautam Gupta Sales 55000

102 Nina Sharma Marketing 62000

103 Venkat HR 75000

104 Karan Kumar Sales 45000

105 Asha Yadav HR 72000

A. Write Query :
i) Write query to display the names of employees whose salary is
between 50000 and 70000.

Ans. SELECT EName FROM EMP_TBL WHERE SALARY>=50000

AND SALARY<=70000;

ii) Write query to display the name and salary of employees of

sales department.

Ans. SELECT EName, SALARY FROM EMP_TBL WHERE

DEPT=’Sales’;

B. Predict Output
i) SELECT Ename FROM EMP_TBL WHERE dept=”Sales”;
Ans. GAUTAM GUPTA
KARAN KUMAR
ii) SELECT salary FROM EMP_TBL WHERE ECode=”103”;
Ans. 75000

OR ( Choice is only for Part B)

Predict Output:
i) SELECT dept FROM EMP_TBL WHERE EName=”Nina
Sharma”;
Ans. MARKETING
ii) SELECT * FROM EMP_TBL WHERE Salary >60000 and
Salary<75000;
102 Nina Sharma Marketing 62000
Ans.
105 Asha Yadav HR 72000
 KENDRIYA VIDYALAYA SANGATHAN CHENNAI REGION
SAMPLE QUESTION PAPER
CLASS XI INFORMATICS PRACTICES (065)
TIME: 3 HOURS M.M.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 01 marks each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each. One internal choice is given in Q35
against part c only.
8. All programming questions are to be answered using Python Language

PART A
1 Arrange the memory in ascending order 1
TB, MB, GB, KB, B
2 What will be the value of the following Python expression? 1
4+3%5
3 Which of the following characters is used to give single- 1
line comments in Python?
a) //
b) #
c) !
d) /*
4 What will be the output of the following Python code? 1

x = [1,4,5,3]
for i in x:
print(i)

5 To add a new element to a list we use which Python 1

command?
a) list1.addEnd(5)
 b) list1.addLast(5)
c) list1.append(5)
d) list1.add(5)
6 What will be the output of the following Python statement? 1

>>>[1]]+[3,4]
a) [1,4,3]

b) [[1],[3,4]]

c) [1,3,4]

7 1. names1 = ['Amir', 'Bala', 'Chales'] 1

2.
3. if 'amir' in names1:
4. print(1)
5. else:
6. print(2)

a) None
b) 1
c) 2
d) Error

8 What is the full form of DBMS? 1

a) Data of Binary Management System
b) Database Management System
c) Database Management Service
d) Data Backup Management System
9 Which of the following provides the ability to query 1
information from the database and insert tuples into, delete
tuples from, and modify tuples in the database?
DML(Data Manipulation Language)
DDL(Data Definition Language)
Query
Relational Schema
10 Which one of the following attribute can be taken as a 1
primary key?
a) Name
b) Street
c) Id
d) Department
11 What is true about Unique and primary key? 1
a) Unique can have multiple NULL values but Primary
can’t have.
b) Unique can have single NULL value but Primary can’t
have even single.
c) Both can have duplicate values
d) None of the Mentioned
12 Rows of a relation are known as the _______. 1
a) Degree
b) Tuples
c) Entity
d) All of the above

13 Which one of the following is a type of Data Manipulation 1

Command?
a) Create
b) Alter
c) Delete
d) All of the above

14 A Group of columns serving as a primary key are known 1

as:
a. Primary key
b. Candidate key
c. Foreign key
d. None of the above
15 In the query mentioned below which keyword has to be 1
inserted
Insert into employee _______(1002,”kaushik”,2000)

a. Table
b. Values
c. Relation
 d. field
16 Distributed computing system formed by a network of 1
independent computers is known as___________
computing
a. Cloud
b. Grid
c. AI
d. Smart
Q17 and 18 are ASSERTION AND REASONING based questions. Mark the
correct choice as
i. Both A and R are true and R is the correct explanation for A
ii. Both A and R are true and R is not the correct explanation for A
iii. A is True but R is False
iv. A is false but R is True
17 Assertion: Cloud computing is the internet based 1
computing
Reasoning: It enables uses to be able to provision, monitor
and manage the computing resources
18 Assertion: List is mutable data type 1
Reasoning: We can update the values of list elements like
l[1]=5
PART B

19 Define the software and write the classification of software 2

Or
Define the computer memory and write the classification
of memory
20 Predict the error 2
x= int(“Enter value of x:”)
for in range [0,10]:
if x=y
print( x + y)
else:
Print( x‐y)
21 Predict the output 2
a. for i in range (10,6,-2):
print (i* 2)
b. for x in range (10,20):
if (x%2==0) :
continue
print (x)

22 Consider a table student 2

rollno name city 10marks

1 anu tiruvallur 90
2 mohini chennai 56
3 zafreen bangalore 98
4 christia rameshwara 70
m

Write the SQL Query to

1. Insert one more record with rollno 5, name mohan,
city chennai and 10marks 89
2. Display the students with names starting with ‘a’
23 Define DDL and DML statements. Give two examples of 2
each
Or
Categorize the following into DDL or DML
Create
Alter
Select
Update

24 I. What do you mean by volatile memory. Give one 2

example
 II. What do you mean by compiler and interpretor

25 A school has a rule that each student must participate 2

in a sports activity. So each one should give only one
preference for sports activity. Suppose there are five
students in a class, each having a unique roll number.
The class representative has prepared a list of sports
preferences as shown below. Answer the following:

Table: Sports Preferences

Roll_no Preference

9 Cricket

13 Football

17 Badminton

21 Hockey

24 NULL

NULL Kabaddi

I. What is the degree and cardinality of the table

II. Can Roll_No be the primary key. Give the reason for
the same
SECTION C

26 What will be the output produced by the following code: 3

lst1=[0,1,[2]]
lst1[2][0]=3
print(lst1)
 lst1[2].append(4)
print(lst1)
lst1[2]=2
print(lst1)
27 Write a python program which takes a list from the user 3
and finds the average of the elements of the list
28 Based on table STUDENT given here, 3

RollNo Name Gender

1 Abhishek M
2 Anamika F

write suitable SQL queries for the following:

i. Display the whole table
ii. Display the Name column of the table
iii. Display the name of females
29 I. Give 2 examples of input and output devices 3
II. What is cache memory
III What is the difference between RAM and ROM

Or
I. What do you mean by operating system
II. Write 2 functions of operating system
Iii. give 2 examples of operating systems
30 Define the following: 3
a. Machine Learning
b. Blockchain technology
c. Internet of Things

Or

Write a short note on smart cities

SECTION D

31 Consider the following dictionary: 5

statecapital={“Assam”:”Guwahati”,”Bihar”:”patna”,”Rajas
 than”:”Jaipur”}

Find the output of following:

a. print(statecapital.keys())
b. print(statecapital.values())
c. print(len(statecapital)
d. print(statecapital.get(“Bihar”))
e. print(“Maharashtra” in statecapital)

Or

I. Define dictionary with an example

Ii Write the code to take a dictionary from user
Iii Write a code to add an element to the dictionary
Iv write the code to find the number of elements in the
dictionary
V Write the code to find the values of the dictionary

32 Consider the table Library and the queries, predict the 5

output:

Title Author Pub Price

Data Lipschutz McGraw 217
Structure
Computer Sumita BPB 75
Science Arora
DBMS Palmer BPB 350
OS Norton PHI 175

I. select * from Library where Title like “O%”

II select * from Library where Price>100
III select distinct(Pub) from Library
IV select Author from Library
V select Title from Library where Price >200

33 Write the SQL Queries to perform the following: 5

1. Create the database school
 2. Select the database school
3. Create a table student inside the school database
having studentid, studentname, and gender
4. Insert 1 record in the table student
5. Display all the records from the table student

Or

Write the SQL queries to perform the following:

1. Create a table employee with employeeid,
employeename, designation and salary
2. Insert 2 records in the table
3. Select all the records from the table employee
4. Select two columns employeename and designation
from the table employee
5. Select all the details of employee whose employeeid
is 1

SECTION E

34 Write the python program to do the following: 1+1+2

I. Which accepts 3 marks from the user
II. Find the average of marks
III. If the average marks is greater than 50, print it is
greater than 50 otherwise print it is less than 50
marks

Or
Write a python program which
I takes the selling price and cost price from the user
Ii find whether it is profit or loss
Iii if it is profit, display the total profit and if it is loss,
display the total loss

35 Define the following: 4

I. primary key
II. Candidate key
III. Tuple
IV Attribute
 Or
Answer the following:
I. what do you mean by constraints
II. Name any two constraints
III. What is a database
IV. why do we need dbms
 KENDRIYA VIDYALAYA SANGATHAN CHENNAI REGION
SAMPLE QUESTION PAPER
CLASS XI INFORMATICS PRACTICES (065)
TIME: 3 HOURS M.M.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 01 marks each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each. One internal choice is given in Q35
against part c only.
8. All programming questions are to be answered using Python Language

PART A
1 Arrange the memory in ascending order 1
TB, MB, GB, KB, B

Ans: B, KB, MB, GB, TB

2 What will be the value of the following Python expression? 1
4+3%5

Ans: 7
3 Which of the following characters is used to give single-line 1
comments in Python?
a) //
b) #
c) !
d) /*

Ans: b #
4 What will be the output of the following Python code? 1

x = [1,4,5,3]
for i in x:
 print(i)

Ans: 1
4
5
3
5 To add a new element to a list we use which Python 1
command?
a) list1.addEnd(5)
b) list1.addLast(5)
c) list1.append(5)
d) list1.add(5)

Ans: c list1.append(5)
6 What will be the output of the following Python statement? 1

>>>[1]]+[3,4]
a) [1,4,3]

b) [[1],[3,4]]

c) [1,3,4]

Ans: [1,3,4]
7 1. names1 = ['Amir', 'Bala', 'Chales'] 1
2.
3. if 'amir' in names1:
4. print(1)
5. else:
6. print(2)

a) None
b) 1
c) 2
d) Error

Ans: c 2
8 What is the full form of DBMS? 1
a) Data of Binary Management System
b) Database Management System
c) Database Management Service
d) Data Backup Management System

Ans b Database Management System

9 Which of the following provides the ability to query 1
information from the database and insert tuples into, delete
tuples from, and modify tuples in the database?

a. DML(Data Manipulation Language)

b. DDL(Data Definition Language)

c. Query

d. Relational Schema

Ans: DML

10 Which one of the following attribute can be taken as a 1

primary key?
a) Name
b) Street
c) Id
d) Department

Ans c Id
11 What is true about Unique and primary key? 1
a) Unique can have multiple NULL values but Primary can’t
have.
b) Unique can have single NULL value but Primary can’t
have even single.
c) Both can have duplicate values
d) None of the Mentioned

Ans b
12 1
Rows of a relation are known as the _______.

a. Degree

b. Tuples

c. Entity

d. All of the above

Ans b
13 1
Which one of the following is a type of Data Manipulation
Command?

a. Create

b. Alter

c. Delete

d. All of the above

Ans c delete
14 A Group of columns serving as a primary key are known as: 1
a. Primary key
b. Candidate key
c. Foreign key
d. None of the above
Ans b candidate key
15 In the query mentioned below which keyword has to be 1
inserted
Insert into employee _______(1002,”kaushik”,2000)

a. Table
b. Values
c. Relation
d. field
Ans b values
16 Distributed computing system formed by a network of 1
independent computers is known as___________ computing
a. Cloud
b. Grid
c. AI
d. Smart
Ans: cloud
Q17 and 18 are ASSERTION AND REASONING based questions. Mark the
correct choice as
i. Both A and R are true and R is the correct explanation for A
ii. Both A and R are true and R is not the correct explanation for A
iii. A is True but R is False
iv. A is false but R is True

17 Assertion: Cloud computing is the internet based computing 1

Reasoning: It enables uses to be able to provision, monitor
and manage the computing resources

Ans: ii
18 Assertion: List is mutable data type 1
Reasoning: We can update the values of list elements like
l[1]=5

Ans i

PART B

19 Define the software and write the classification of software 1

Or marks
Define the computer memory and write the classification of for
memory each
correct
answer

20 Predict the error 1/2

x= int(“Enter value of x:”) marks
for in range [0,10]: for
 if x=y input
print( x + y)
else: 1/2
Print( x‐y) marks
for ==
in
checki
ng

½ for
range

½ for
semico
lon
21 Predict the output 1
a. for i in range (10,6,-2): marks
for
print (i* 2) each
Ans: 20 correct
answer
16 r

for x in range (10,20):

if (x%2==0) :
continue
print (x)
Ans: 11
13
15
17
19

22 Consider a table student 1

marks
for
 rollno name city 10marks each
correct
1 anu tiruvallur 90 query

2 mohini chennai 56
3 zafreen bangalore 98
4 christia rameshwara 70
m

Write the SQL Query to

1. Insert one more record with rollno 5, name mohan,
city chennai and 10marks 89
2. Display the students with names starting with ‘a’
23 Define DML statements. Give two examples 1 mark
Or for
Categorize the following into DDL or DML each
Create correct
Alter answer
Select
Update Or

½
marks
for
each
correct
classifi
caion
24 I. What do you mean by volatile memory. Give one example 1
II. What do you mean by compiler and interpretor marks
for
each
correct
answer
25 A school has a rule that each student must participate in 1
a sports activity. So each one should give only one marks
preference for sports activity. Suppose there are five for
students in a class, each having a unique roll number. each
The class representative has prepared a list of sports correct
 preferences as shown below. Answer the following answer

Table: Sports Preferences

Roll_no Preference

9 Cricket

13 Football

17 Badminton

21 Hockey

24 NULL

NULL Kabaddi

I. What is the degree and cardinality of the table

II. Can Roll_No be the primary key. Give the reason for the
same
SECTION C

26 What will be the output produced by the following code: 1

marks
lst1=[0,1,[2]]
for
lst1[2][0]=3 each
correct
print(lst1)
print
lst1[2].append(4)
print(lst1)
lst1[2]=2
 print(lst1)

Ans:
[0, 1, [3]]
[0, 1, [3, 4]]
[0, 1, 2]

27 Write a python program which takes a list from the user and 1
finds the average of the elements of the list marks
for
input
1
marks
for
adding
1
marks
for
averag
e
28 Based on table STUDENT given here, 1
marks
for
RollNo Name Gender each
correct
1 Abhishek M answer
2 Anamika F

write suitable SQL queries for the following:

i. Display the whole table
ii. Display the Name column of the table
iii. Display the name of females
29 I. Give 2 examples of input and output devices 1
II. What is cache memory marks
III What is the difference between RAM and ROM for
each
 Or correct
I. What do you mean by operating system answer
II. Write 2 functions of operating system
Iii. give 2 examples of operating systems
30 Define the following: 1
a. Machine Learning marks
b. Blockchain technology for
c. Internet of Things each
Or
Or 1
marks
Write a short note on smart cities for
definiti
on
2
marks
for
charact
eristics

SECTION D

31 Consider the following dictionary: 1

statecapital={“Assam”:”Guwahati”,”Bihar”:”patna”,”Rajast marks
han”:”Jaipur”} for
each
Find the output of following: correct
a. print(statecapital.keys()) answer
b. print(statecapital.values())
c. print(len(statecapital)
d. print(statecapital.get(“Bihar”))
e. print(“Maharashtra” in statecapital)

Ans: dict_keys(['Assam', 'Bihar', 'Rajasthan'])

dict_values(['Guwahati', 'patna', 'Jaipur'])
3
patna
False
 Or

I. Define dictionary with an example

Ii Write the code to take a dictionary from user
Iii Write a code to add an element to the dictionary
Iv write the code to find the number of elements in the
dictionary
V Write the code to find the values of the dictionary

32 Consider the table Library and the queries, predict the 1

output: marks
for
Title Author Pub Price each
correct
Data Lipschutz McGraw 217 output
Structure
Computer Sumita BPB 75
Science Arora
DBMS Palmer BPB 350
OS Norton PHI 175

I. select * from Library where Title like “O%”

II select * from Library where Price>100
III select distinct(Pub) from Library
IV select Author from Library
V select Title from Library where Price >200

33 Write the SQL Queries to perform the following: 1

1. Create the database school marks
2. Select the database school for
3. Create a table student inside the school database each
having studentid, studentname, and gender correct
4. Insert 1 record in the table student query
5. Display all the records from the table student

Or
 Write the SQL queries to perform the following:
1. Create a table employee with employeeid,
employeename, designation and salary
2. Insert 2 records in the table
3. Select all the records from the table employee
4. Select two columns employeename and designation
from the table employee
5. Select all the details of employee whose employeeid is
1

SECTION E

34 Write the python program to do the following: 1

I. Which accepts 3 marks from the user (input marks
statements) +1
II. Find the average of marks (add and divide by 3) marks
III. If the average marks is greater than 50, print it is +2
greater than 50 otherwise print it is less than 50 marks marks
1 marks for if else and 1 marks for logic

Or
Write a python program which
I takes the selling price and cost price from the user
Ii find whether it is profit or loss
Iii if it is profit, display the total profit and if it is loss,
display the total loss

35 Define the following: 1 mark

I. primary key for
II. Candidate key each
III. Tuple correct
IV Attribute answe
R
Or
Answer the following:
I. what do you mean by constraints
II. Name any two constraints
III. What is a database
IV. why do we need dbms