Students must start practicing the questions from CBSE Sample Papers for Class 11 Informatics Practices with Solutions Set 1 are designed as per the revised syllabus.
CBSE Sample Papers for Class 11 Informatics Practices Set 1 with Solutions
Time Allowed: 3 hours
Maximum Marks: 70
General Instructions:
- This question paper contains five sections, Section 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
Section A Consists of 18 questions of 1 mark each
Question 1.
Information and data enter into a computer is called ………… [1]
(A) Input
(B) Output
(C) Insert
(D) None of these
Answer:
(A) Input
Explanation:
Any information or data sent to a computer for processing is considered as input.
Question 2.
Which of the following is not an example of robotics? [1]
(A) Sophia
(B) Drone
(C) CRAY
(D) Both a & b
Answer:
(C) CRAY
Explanation:
CRAY is an example of super computer.
Question 3.
In which type of memory, once the program or data is written, it cannot be changed? [1]
(A) EEPROM
(B) PROM
(C) EPROM
(D) None of these
Answer:
(B) PROM
Explanation:
In Programmable Read-Only Memory (PROM), if there is an error in writing instructions or data, the error cannot be erased. PROM chip becomes unusable.
Question 4.
Which of the following is not an example of impact printer? [1]
(A) Line printer
(B) Drum printer
(C) Dot matrix printer
(D) Laser printer
Answer:
(D) Laser printer
Explanation:
Laser printer is an example of non-impact printer.
Question 5.
The …………. clause can be used in place of multiple Or clauses [1]
(A) between
(B) order
(C) IN
(D) Check
Answer:
(C) IN
Explanation:
The IN clause can be used in place of multiple or OR conditions in a query.
Question 6.
Example of immersive experience Is/are ………. [1]
(A) Robots
(B) AR
(C) VR
(D) Both B & C
Answer:
(D) Both B & C
Explanation:
Immersive experience engages the senses and creates the sense of being present in a particular environment.
Question 7.
Which of the following is a jump statement in python ? [1]
(A) pass
(B) break
(C) continue
(D) All of these
Answer:
(D) All of these
Explanation:
break , continue and pass , all are jump statements used in Python.
Question 8.
A database can be considered as a collection of : [1]
(A) Attributes
(B) Tuples
(C) Keys
(D) Relations
Answer:
(D) Relations
Explanation:
Multiple tables or relations comprise a database.
Question 9.
Which property of a relation is used to represent number of columns? [1]
(A) Key
(B) Tuple
(C) Degree
(D) Cardinality
Answer:
(C) Degree
Explanation:
The total number of columns in table is called degree.
Question 10.
Which of the following is not correct about python? [1]
(A) Python is an open source language.
(B) Python is based on ABC language.
(C) Python is developed by James Gosling
(D) None of the above
Answer:
(C) Python is developed by James Gosling
Explanation:
Python is developed by Guido van Rossum and Java is developed by James Gosling.
Question 11.
A table can have maximum of ………… foreign keys : [1]
(A) 1
(B) 2
(C) 3
(D) Multiple
Answer:
(D) Multiple
Explanation:
A table can have multiple foreign keys to link data with other tables.
Question 12.
What will be the output of the following code : ? [1]
788//55 + 2**6 – 31/12
(A) 75.41
(B) 76.41
(C) 70.0
(D) None of these
Answer:
(A) 75.41
Explanation:
788//55 + 2**6 – 31/12
= 14+64-2.58
= 75.41
Question 13.
Identify the characteristics of big data from the following: [1]
(A) Volume & Velocity
(B) Variety & Veracity
(C) Value
(D) All of these
Answer:
(D) All of these
Explanation:
Big data is a collection of data from many different sources. Its characteristics are volume, value, variety, velocity, and veracity.
Question 14.
The command that changes data of a table belongs to ………… category [1]
(A) DML
(B) DDL
(C) TCL
(D) DCL
Answer:
(A) DML
Explanation:
Any changes to data are done by commands belonging to DML category.
Question 15.
We can not use list as key for a dictionary because [1]
(i) List are mutable and keys are immutable
(ii) List are collection of items and keys are represented with single item
(A) Both (i) & (ii) are True
(B) Both (i) & (ii) are False
(C) (i) True, (ii) False
(D) (i) False, (ii) True
Answer:
(A) Both (i) & (ii) are True
Explanation:
Keys of a dictionary cannot be mutable structures.
Question 16.
Set of programs which consist of full documentation. [1]
(A) Software Package
(B) System Software
(C) Utility Software
(D) File package
Answer:
(A) Software Package
Directions (Q17 and Q18): In the following questions, A statement of Assertion (A) is followed by a statement of Reason (R).
Mark the correct choice.
Question 17.
Assertion (A): Printer is used to print the soft copy into hard copy.
Reason (R): Printer is considered as input device of a computer. [1]
(A) Both A and R are true and R is the correct explanation of A
(B) Both A and R are true but R is NOT the correct explanation of A
(C) A is true but R is False
(D) A is false and R is true
Answer:
(C) A is true but R is False
Explanation:
Printer is considered as output device of a computer.
Question 18.
Assertion (A): / and // operators work differently.
Reason (R): / performs float division with decimal. // performs floor division, that is whole number division. [1]
(A) Both A and R are true and R is the correct explanation of A
(B) Both A and R are true but R is NOT the correct explanation of A
(C) A is true but R is False
(D) A is false and R is true
Answer:
(A) Both A and R are true and R is the correct explanation of A
Section-B
Section B consists of 7 questions of 2 marks each.
Question 19.
Write a short note on Python language.
OR
Differentiate between / = and % = operators. [2]
Answer:
Python is an interpreted and high-level language. Python programming language was developed by Guido Van Rossum in February 1991. It is a general purpose language. It supports multiple programming paradigms including functional programming, procedural programming and object oriented programming. Python is also dynamically typed and garbage collected. Python can run on many operating systems such as Windows, Mac OS, Unix, etc. It is open source and freely distributed.
OR
/= divides the value of left operand by that of right operand and assigns the result to left operand. While
% = divides the value of left operand by right operand and assigns the remainder to left operand.
Question 20.
Write the following mathematical equation as Python expressions. [2]
(i) a = \(\frac{1}{2}\) (a + b) × h
(ii) x = 4x3 + 3 x + 7
Answer:
(i) a =1/2*(a+b)*h
(ii) x = 4*(x**3)+3*x+7
Question 21.
(i) What is IN operator?
(ii) What are wildcard operators? [2]
Answer:
(i) This operator checks a value within a set of values separated by commas and retrieve the rows from the table which are matching.
(ii)Wildcard operators are used to describe patterns to compare a value to a similar value in LIKE clause.
Question 22.
Give the output of following: [2]
x = 3
y = 5
x, y = y, x
print (x, y)
Answer:
5 3
Question 23.
Write the full form for [2]
(i) AI (ii) NLP (iii) VR (iv) AR
Answer:
(i) AI – Artificial Intelligence.
(ii) NLP – Natural Language Processing.
(iii) VR – Virtual Reality
(iv) AR – Augmented Reality
Question 24.
Write a program in python to display the list with elements entered by user with condition if number of elements is greater than 1 or less than 1. [2]
Answer:
list1=[ ]
num = int(input(“Enter number of elements:”))
if (num>1):
for i in range(num):
ele=int(input(“Enter element:”))
list1.append(ele)
else:
print(“Please enter positive number”)
print(list1)
Question 25.
The python code written below has syntactical errors. Rewrite the correct code and underline the corrections made. [2]
a = int( input("Please enter value : ")) b = int( input("Please enter value: ")) temp = b a = b a = temp print ("The Value of a after swapping: ", b) print ("The Value of b after swapping: ", a)
Answer:
a = int( input(“Please enter value : “)) b = int( input(“Please enter value: “)) temp = a a = b b = temp print (“The Value of a after swapping: “, a) print (“The Value of b after swapping: “, b)
Section-C
Section C consists of 5 questions of 3 marks each.
Question 26.
Consider the table Hotel given below and write sql queries for (i) – (iii) [3]
(i) Display details of rooms that have AC
(ii) To display customer names and room types whose charges are more than 1500.
(iii) To display details of customers who arrived after 2020.
Answer:
(i) Select * from Hotel where RoomType like “AC%”;
(ii)Select Customer, RoomType from Hotel where charges> 1500;
(iii)Select * from customer where DtofArrival > “2020-12-31”;
OR
Write SQL queries with respect to the table Graduate given below :
(i) Display names of graduates whose average is greater than equal to 70.
(ii) Display name and subject of graduates who have got second division.
(iii) Display the subject of graduates whose stipend is 450.
Answer:
(i) SELECT NAME FROM GRADUATE WHERE AVERAGE >= 70;
(ii) SELECT NAME, SUBJECT FROM GRADUATE WHERE DIV = II;
(iii) SELECT SUBJECT FROM GRADUATE WHERE STIPEND = 450;
Question 27.
Find the value of following questions based on list: [3]
value = [45, 32, 98, -78, -6, ‘Hello’, ‘Honesty’]
(i) value [5]
(ii) value [-5]
(iii) value [1] + value [-1]
Answer:
(i) Hello
(ii) 98
(iii) Type Error : unsupported operand type (s) for +‘int’ and ‘str’
Question 28.
Write a note on types of SQL statements? [3]
Answer:
SQL statements can be divided into four major categories :
(i) Data Manipulation Language (DML): These statements consist of queries that insert data into tables in a database and statements that change the data in the database. SQL statements under this category are INSERT, UPDATE, DELETE etc.
(ii) Data Definition Language (DDL): These statements define the structure of the database. DDL consists of those statements that create, alter and drop database objects. Statements under this category are CREATE, ALTER, DROP, etc.
(iii) Transaction Control Language (TCL): These commands manage changes made by data manipulation language commands. These commands are COMMIT, ROLLBACK, etc.
(iv) Data Query Language (DQL): The commands of SQL that are used to retrieve data from the database. SQL statement under this category is SELECT
Question 29.
Define data model and also explain its types. [3]
Answer:
Data model is a collection of conceptual tools for describing data, data relationship, data semantics and consistency constraints.
There are three different data models as:
(i)Hierarchical model: It organizes the records as a collection of trees rather than arbitrary graphs. It represents a hierarchy of parent and child data segments.
(ii) Network model: Data are represented by collection of records. Relationships among data are represented by links. Organization is information arbitrary graph.
(iii) Relational model: Data and relationship are represented by a collection of tables. Each table has a number of columns with unique names. e.g. customer, account. It represents a hierarchy of parent and child data segments.
OR
Write the output of the queries (i) to (iii) based on the table, Furniture given below:
(i) SELECT NAME, DISCOUNT FROM FURNITURE WHERE COST>45000;
(ii) SELECT FID FROM FURNITURE WHERE NAME LIKE %Bed%;
(iii) SELECT * FROM FURNITURE WHERE DISCOUNT>10;
Answer:
(i) Dining Table 5
(ii) B001
B004
B006
(iii) T006 Console Table 17-Nov-2019 15000 12
B006 Bunk Bed 01-Jan-2021 28000 14
Question 30.
Write a program to input a number and find that it is perfect number or not.( A perfect number is one whose sum of factors other than itself is equal to the number. Ex : 6 =1+2+3) [3]
Answer:
num=int(input(“Enter the number: “)) sum=0 for i in range(1,num): if (num%i==0): sum=sum+i if(sum==num): print(“The number is a perfect number”) else: print(“The number is not a perfect number”)
Section D
Section D consists of 2 questions of 4 marks each.
Question 31.
Sonali wants to perform certain operations on a table Exam storing exam details. She is not sure about some of the commands and is getting errors. [4]
Help her in proper execution of her operations.
Table : Exam
Exam ID | Examname | Maxmarks | Passmarks |
E01 | Halfyearly | 45 | 14.0 |
E02 | Term-I | 35 | 10.5 |
E03 | Preboard | 50 | 15.0 |
E04 | Unit Test | 20 | 7.0 |
E05 | Term-II | 35 | 10.5 |
(A) To increase the Passmarks by 5
(B) She wants to add a new column “Negativemarks” of type integer. .
(C) She is confused whether she has to use Delete or Drop command for deleting all data of the table keeping the structure. Which command she has to use?
(D) Can she add another ExamID as “E05”? [4]
Answer:
(A) Update Exam set passmarks= passmarks+5;
(B) Alter table exam ADD Negativemarks integer;
(C) Delete
(D) No because ExamID is the possible primary key of the table, so it cannot have duplicate values.
Question 32.
Predict the output of the following Code: [4]
a = [5,9, 7, 6,-9,-7,0,3,5]
(i) print (a [:: 2])
(ii) print(a[-l: :]
(iii) print(a[:20:2]
OR(Option for iii only)
Predict output of the following code :
L=[“abc”, “pqr”, “xyz”,”mno”]
for a in L:
print(a[0], end=’ ‘)
Answer:
(i) [5, 7, –9, 0, 5]
(ii) 5
(iii) [5, 7, -9, 0, 5]
OR(Option for iii only)
a p x m
Section-E
Section E consists of 3 questions of 5 marks each.
Question 33.
Write SQL queries for the questions that follow based on table Student. [5]
(i) Display all records.
(ii) To display the details of those students who have Stu_ID 103.
(iii) To display student name, marks, Address of those students whose marks greater than 85.
(iv) Display Stu_ID, Name of those students who have subject science.
(v) Increase marks of Science students by 15%.
Answer:
(i) SELECT * FROM Student;
(ii) SELECT * FROM Student WHERE Stu_ID = 103;
(iii) SELECT Stu_Name, Marks, Address FROM Student WHERE Marks > 85;
(iv) SELECT Stu_ID, Stu_Name From Student WHERE Subject = “Science”;
(v) Update Student set marks=marks+marks*0.15 where Subject = “Science”;
OR
Let us consider the following table Teacher
T_NO | T_Name | T_Salary | DOJ |
T01 | Aradhna | 17,000 | 2013-01-08 |
T02 | Ritika | NULL | 2013-12-14 |
T03 | Ravindra | NULL | 2013-11-23 |
T04 | Dushyant | 16,000 | 2014-01-10 |
T05 | Swati | 19,000 | 2014-02-10 |
Write queries for the following :
(i) Display details of all teachers
(ii) Display names and salaries of teachers who joined after 2013
(iii) Update salary of Ravindra to 60000
(iv) Display the structure of the table.
(v) Display only names of teachers whose name ends with ‘a’
Answer:
(i) Select * from Teacher;
(ii) Select T_name, T_Salary from teacher where DOJ>”2013-12-31”;
(iii) Update teacher set T_Salary =60000 where T_Name=”Ravindra”;
(iv) Describe Teacher;
(v) Select T_Name from teacher where T_Name like “%a”;
Question 34.
Convert the following into bytes: [5]
(i) 2 MB (ii) 3.7 GB (iii) 1.2 TB
Answer:
(i) 1MB = 210 × 210 bytes = 220 bytes
2MB = 2 × 220 bytes
(ii) 1 GB = 210 × 210 × 210 bytes = 230 bytes
3.7 GB = 3.7 × 210 × 210 × 210 bytes
= 3.7 × 230
(iii) 1 TB = 210 × 210 × 210 × 210 bytes
= 240 bytes
1.2 TB = 1.2 × 210 × 210 × 210 × 210 bytes
= 1.2 × 240 bytes
Question 35.
Write SQL queries for (i) to (v) based on the table Cabhub given below: [5]
(i) To display the names of all the white coloured vehicles.
(ii) To display all the records.
(iii) To display vehicles name and their charges whose capacity is more than 5.
(iv) Delete the records of vehicles of white colour.
(v) Add a column Pnum in the table CABHUB with datatype as integer.
Answer:
(i) SELECT VehicleName From CABHUB WHERE Color = “WHITE”;
(ii) SELECT *FROM CABHUB;
(iii) SELECT VehicleName, Charges FROM CABHUB WHERE Capacity >5;
(iv) DELETE FROM CABHUB WHERE color=’white’;
(v) ALTER TABLE CABHUB ADD(PNUM integer);
OR
Consider the table Employee given below
Based on the table write SQL queries for the following :
(i) To display the name of employees whose salary not known.
(ii) To display DEPTID from the table EMPLOYEE without repetition.
(iii) To modify the column Desig and change its width to varchar(25).
(iv) To display name and designation of those employees whose name starts with N.
(v) To display all records of table Employee.
Answer:
(i) SELECT NAME, SALARY FROM EMPLOYEE WHERE SALARY IS NULL;
(ii) SELECT DISTINCT(DEPTID) FROM EMPLOYEE;
(iii) ALTER TABLE EMPLOYEE MODIFY DESIG VARCHAR(25);
(iv) SELECT NAME, DESIG FROM EMPLOYEE WHERE NAME LIKE N%;
(v) SELECT *FROM EMPLOYEE;