CBSE Sample Papers for Class 11 Informatics Practices Set 3 with Solutions

Students must start practicing the questions from CBSE Sample Papers for Class 11 Informatics Practices with Solutions Set 3 are designed as per the revised syllabus.

CBSE Sample Papers for Class 11 Informatics Practices Set 3 with Solutions

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 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 02 questions carrying 04 marks each.
7. Section E has 03 questions carrying 05 marks each.
8. 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.
The full form of RAM is ……………. [1]
(A) Read Access Memory
(B) Random Accumulator Memory
(C) Readable Access Memory
(D) Random Access Memory
Answer:
(D) Random Access Memory

Explanation:
RAM (Random Access Memory) is the hardware in a computing device where the operating system (OS), application programs and data in current use are kept so they can be quickly reached by the device’s processor

Question 2.
In which principal computer works? [1]
(A) CCO
(B) IPO
(C) POI
(D) IOP
Answer:
(B) IPO

Explanation:
The IPO cycle is defined as a computer procedure for the processing of information. In computation, it is a critical process through which users get the desired outcome.

Question 3.
What is the size of the computer accumulator register? [1]
(A) 8 bytes
(B) 4KB
(C) 4 bytes
(D) 4 bit
Answer:
(C) 4 bytes

Question 4.
Which command is used to insert a new record in a table ? [1]
(A) ADD
(B) INSERT INTO
(C) INSERT
(D) NEW
Answer:
(B) INSERT INTO

Explanation:
The insert into table values (v1,v2,…..) is used to add a record.

Question 5.
The Select command belongs to ………….. Category. [1]
(A) TCL
(B) DCL
(C) DQL
(D) DDL
Answer:
(C) DQL

Explanation:
The data query language (DQL) category houses the select command.

Question 6.
…………….. technology is able to take an existing environment and add a layer of virtual information on top of it. [1]
(A) AR
(B) VR
(C) Invested reality (IR)
(D) Reality augmentation (RA)
Answer:
(A) AR

Explanation:
Augmented reality is an interactive experience of a real-world environment where the objects that reside in the real world are enhanced by computergenerated perceptual information, sometimes across multiple sensory modalities, including visual, auditory, haptic, somatosensory and olfactory etc.

Question 7.
Which of the following are invalid variables or identifiers in Python? [1]
(A) 4th Sum
(B) Total
(C) Numbers
(D) Data
Answer:
(A) 4th Sum

Explanation:
An identifier canno t begin with a digit and also it can’t be a keyword.

Question 8.
A domain in database means : [1]
(A) Data
(B) Pool of values from which a column derives its values
(C) Numeric values
(D) Rows
Answer:
(B) Pool of values from which a column derives its values

Explanation:
A domain is a pool of values from which a column derives its values.

Question 9.
The file that contains about data [1]
(A) Metadata
(B) Database
(C) Data dictionary
(D) All of these
Answer:
(C) Data dictionary

Explanation:
A database scheme is specified by a set of definitions which are expressed by a special language called DDL. The result of compilation of DDL statements is a set of tables which are stored in a special file called data dictionary.

Question 10.
Choose the odd one out: [1]
(A) List
(B) Tuple
(C) Dictionary
(D) integer
Answer:
(D) integer

Explanation:
All the others are derived data types.

Question 11.
Which statement is not valid regarding Primary key? [1]
(A) It uniquely identifies a record in the relational database table.
(B) It can allow NULL values.
(C) It is one of the candidate keys.
(D) A table can have only one primary key.
Answer:
(B) It can allow NULL values.

Explanation:
Primary key must be unique and NOT NULL

Question 12.
What will be the output of the following code? [1]
2**3**2 + 625**0.5 + 7//
(A) 42.50
(B) 540.0
(C) 539
(D) 541.0
Answer:
(B) 540.0

Explanation:
2**3**2 + 625**0.5 + 7//2
= 2**9 + 25 + 3
= 512.0+28
= 540.0

Question 13.
…………… are the main components in IoT. [1]
(A) Low power embedded systems
(B) Cloud computing
(C) Availability of big data, networking connection
(D) All of the above
Answer:
(D) All of the above

Explanation:
The low power embedded systems, cloud computing, availability of big data, networking connection are the main components in IoT.

Question 14.
Select the functions performed by a DDL. [1]
(A) It should specify the proper data types.
(B) It may define the length of the data items.
(C) It may specify the means of checking the errors in the data.
(D) All of these
Answer:
(D) All of the above

Explanation:
A data definition language (DDL) is a computer language used to create and modify the structure of database objects in a database.

Question 15.
The values of a dictionary can be ………. [1]
(A) List
(B) Tuple
(C) integer
(D) All of these
Answer:
(D) All of these

Explanation: The values of a dictionary can be list, tuple, integer etc.

Question 16.
Which memory can access more quickly than RAM? [1]
(A) RAM
(B) ROM
(C) BIOS
(D) Cache
Answer:
(D) Cache

Explanation:
Cache is also called CPU memory that a computer microprocessor can access more quickly than RAM. This memory is typically integrated directly with the CPU chip or placed on a separated chip that has a separate bus interconnect with that CPU.

Directions (Q17 and Q18): In the following questions, A statement of Assertion (A) is followed by a statement Reason (R).
Mark the correct choice.

Question 17.
Assertion (A): Operating system is a system software.
Reason (R): System softwares work with a specific type of applications like word processing etc. [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
(E) Both A and R are false
Answer:
(C) A is true but R is False

Explanation: Application softwares work with a specific type of applications like word processing etc.

Question 18.
Assertion (A): Lists can be change after creation.
Reason (R): Lists are mutable. [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
(E) Both A and R are false
Answer:
(A) Both A and R are true and R is the correct explanation of A

Explanation:
List is a type of container in data structure, which is used to store multiple data at the same time. It contains a sequence of heterogenous elements which makes it powerful tool in Python. Lists are mutable which means they can be changed after creation.

Section B
Section B consists of 7 questions of 2 marks each.

Question 19.
Categorise the following as syntax error, logical error or runtime error. [2]
(i) 25/0
(ii) numl = 25; num2 = 0; snuml/num2
OR
What do you mean by an infinite loop?
Answer:
(i) Logical error
(ii) runtime error
OR
In an iteration the value of the loop control variable must be changed within the loop in order for the condition to become false and the control to move out of the loop. But if this value doesn’t change or so changes that the loop condition never becomes false, the iteration will never end. Such a loop is called an infinite loop.

Question 20.
Write the output from the following code: [2]

x= 1998 if x % 4 = =0:
print ("Leap year")
else: '
print ("Not leap year")

Answer:
Not leap year

Question 21.
Help Ayus in predicting the output of the following queries: [2]
(i) SELECT (2*54-3-2) AS ‘RESULT’; ‘
(ii) SELECT (5*9%6) AS ‘OUTPUT’;
Answer:
(i) RESULT
11

(ii) Output
3

Question 22.
Write the output from the following code. [2]

s = 0
for i in range (10,2, -2):
s = s + i
print ("sum is = ", s)

Answer:
Sum is = 28.

Question 23.
What do you mean by emerging trends ? [2]
Answer:
Emerging trends are the state of the art technology which gain popularity and set a new trend among users. Knowledge of emerging trends is particularly important to individuals and companies who are charged with monitoring a particular field or company.

Question 24.
Write a program that prints out a list of the integers from 1 to 20 and their squares. [2]
The output should look like this.
1……..1
2……..4
3……..9
20…….400
Answer:

i = 1
for i in range (1, 21):
print (i, “.....”, i **2)
i + = 1

Question 25.
Find the errors in the following codes and write the correct codes. [2]
Underline corrections in each.

For p in range (3)
For q in range (3)
Print(p*q)
else:
print (“loop ends”)

Answer:
missing in for statements

for p in range (3):
for q in range (3):
print (p*q)
else:
print (“loop ends”)

Section C
Section C consists of 5 questions of 3 marks each.

Question 26.
Assuming the following table write the following queries : [3]

(i) Create a database SportsDb and open it.
(ii) Create the above table..
(iii) Write a command to add the 1st record
Answer:
(i) Create database SportsDb;
Use SportsDb;
(ii) Create table Match_Details(MatchId char(3), MatchDate Date , FirstteamID int,SecondteamID int, FirstteamScore int, SecondTeamScore int);
(iii) Insert into Match_details values(“M1”,”2018-07-17”,1,2,90,86);

OR

Consider the table Movie, write SQL queries as specified.

(i) Display ID, Name and Business cost of all the movies
(ii) Display only names of horror movies .
(iii) Display name, production cost of movies which are Hindi movies
Answer:
(i) Select MovieID, MovieName , Businesscost from Movie;
(ii) Select MovieName from Movie where Category=”Horror”;
(iii) Select MovieName, productioncost from Movie where MovieName like “Hindi%”;

Question 27.
What will be the output of the following code segment ? [3]
(i) mylist = [1, 2, 3, 4, 5, 6, 7, 8, 9,10]
del mylist [3:]
print (mylist)
Answer:
[1, 2, 3]

(ii) mylist = [1, 2, 3,4, 5, 6, 7,8, 9,10]
del mylist [: 5]
print (mylist)
Answer:
[6, 7, 8, 9, 10]

(iii) mylist = [1, 2, 3, 4, 5, 6, 7, 8, 9,10]
del mylist [:: 2]
print (mylist)
Answer:
[2, 4, 6, 8, 10]

Question 28.
Define the following: [3]
(i) Data item (ii) Record (iii) Table
Answer:
(i) Data item: The smallest unit of named data is called data item. It represents one type of information and is also referred to as a field.
(ii) Record: A named collection of data items that represent a complete unit of information is called a record.
(iii) Table: A group of all logically related records that are given a name is called a table

Question 29.
Give the SQL clauses for each of the following: [3]
(i) To remove a column by alter table command
(ii) To check whether a table exists before deleting it.
(iii) To get only the unique values.
Answer:
(i) DROP COLUMN
(ii) IF EXISTS
(iii) DISTINCT

OR

What do you understand by referential integrity ? What are the conditions for it ?
Answer:
Referential integrity is a system of rules that a DBMS uses to ensure that relationships between records in related tables are valid and that users don’t accidentally delete or change related data.

To set referential integrity ensure that:

• The matching field from the primary table is a primary key or has a unique identity.
• The related fields have the same data types.
• Either both the table belong to the same database or they must be of same DBMS format. The database must be open to set referential integrity.

Question 30.
Write a program that reads three numbers and prints them in ascending order. [3]
Answer:

x = int(input(“Enter first number:”))
y = int(input(“Enter second number.”))
z = int(input(“Enter third number.”))
if x<y and x<z:
a, b, c = x, y, z
else:
a, b, c, = x, z, y
elif y < x and y < z:
if x < z:
a, b, c, = y, x, z
else:
a, b, c, = y, z, x
else:
if x < y:
a, b, c, = z, x, y
else:
a, b, c, = z, y, x
print (“Number in ascending order”,a, b, c);

Section D
Section D consists of 2 questions of 4 marks each.

Question 31.
Consider the table Travel given below . Write SQL queries for the following : [4]
Table : Travel

Tcno	Pname	Class	Tname	Amt
1	Rahul	AC	Rajdhani Express	2500
2	Sujit	SL	Himgiri Mail	4500
3	Ravi	AC	Darjeeling Mail	6000
4	Ankita	AC	Teesta Torsha	1800

(i) Display the passenger names and the train names.
(ii) Display the details of passengers who are travelling by “AC” class.
(iii) Add a new record [5,”Debarati”,”AC”,”Geetanjali”,8000]
(iv) Add a new column Phone of type integer.
Answer:
(i) Select Pname, Tname from Travel ;
(ii) Select * from Travel where class =”AC”;
(iii) Insert into Travel values(5,”Debarati”,”AC”, ”Geetanjali”,8000);
(iv) Alter table Travel ADD Phone integer;

Question 32.
(i) Write for statement to print the series. [4]
10,20, 30, 300
(ii) Write for statement to print the series 105, 98, 91,…. 7.
(iii) How many times is the following loop executed ? for a in range (100,10, -10):
OR (For part iii only)
Write a program to input any number and do print all the factors of that number.
Answer:
(i) for i in range (10, 301, 10):
print (i)

(ii) for i in range (105, 6, -7):
print (i)

(iii) 9 times.
OR

n = int(input(“Enter the number.”))
For i in range (2, n):
If n% i = = 0:
Print (i, is a factor of,n)

Section-E
Section E consists of 3 questions of 5 marks each.

Question 33.
Write SQL queries for the following : [5]

CarNo	Model	Make	Price
WB780	Calistrol80	Maruti	560000
MU879	Roadking500	Hyundai	750000
CH123	Rolls200	Hyundai	200000
DL890	Suzuki800	Tata	350000
CH345	Rivero250	Tata	400000

(i) Display Model, Price of Hyundai cars.
(ii) Display only CarNo of cars whose price is between 400000 and 600000
(iii) To add a new column Grade char(10) to store the grade of the car.
(iv) To display details of cars whose model name has “11” somewhere in between.
(v) To remove the column Make.
Answer:
(i) Select Model, Price from Car where Make=”Hyundai”;
(ii) Select CarNo from Car where Price between 400000 and 600000;
(iii) Alter table car ADD Grade char(10);
(iv) Select * from Car where Model like “%ll%”;
(v) Alter table Car DROP Make;

OR

Give the output of the following queries based on table Car:
Table : Car

CarNo	Model	Make	Price
WB780	Calistrol80	Maruti	560000
MU879	Roadking500	Hyundai	750000
CH123	Rolls200	Hyundai	200000
DL890	Suzuki800	Tata	350000
CH345	Rivero250	Tata	400000

(i) SELECT CarNo, Model FROM CAR WHERE Make = “Tata”;
(ii) SELECT * FROM CAR WHERE CARNO LIKE “%CH%”;
(iii) SELECT Model FROM CAR FROM Make = “Hyundai” AND Price > 500000;
(iv) SELECT Model, Make , Price FROM CAR WHERE Price >700000;
(v) SELECT Make FROM CAR WHERE Model LIKE “%250”;
Answer:
(i) DL890 Suzuki800
CH345 Rivero250
(ii) CH123 Rolls200 Hyundai 200000
(iii) Roadking500
(iv) Roadking500 Hyundai 750000
(v) Tata

Question 34.
What are application softwares? Write its categories. [5]
Answer:
The system software provides the core functionality of the computer system. However, different users use the computer system for different purposes depending upon their requirements. Hence, a new category of software is needed to cater to different requirements of the end users. This specific software that works on top of the system software is termed as application software.

There are two categories of application software as:
(i) General Purpose Application Software: This software is developed for generic applications, to cater to a bigger audience in general. Such readymade application software can be used by end users as per their requirements.

(ii) Specific Purpose Application Software: These are custom or tailor made application software, that are developed to meet the requirements of a specific organisation or an individual. They are better suited to the needs of an individual or an organisation. For example, school management software, accounting software etc.

Question 35.
Write SQL queries for (i) to (v) based on the table School [5]

(i) To display each subject.
(ii) To display the name of teacher whose has more than 10 years experience.
(iii) To display periods of teacher whose subject is Maths.
(iv) To display teacher names and corresponding subject whose code is 1203.
(v) To display date of joining for English teacher.
Answer:
(i) SELECT DISTINCT (Subject) FROM School;
(ii) SELECT TEACHER FROM School WHERE EXPERIENCE > 10;
(iii) SELECT PERIODS FROM School WHERE SUBJECT = “MATHS”;
(iv) SELECT TEACHER, SUBJECT FROM School WHERE CODE = 1203;
(v) SELECT DOJ FROM School WHERE SUBJECT = “ENGLISH”;

OR

Consider the table Teacher given below:

Based on the table write SQL queries for the following :
(i) To display only names of teachers of “History” department.
(ii) To display the name , age and department of teachers whose name has “a” as the 2nd letter.
(iii) To increase the salary of Male teachers by 5% who are in “Computer Sc” department.
(iv) To display the all records.
(v) To display the department of teacher whose age is greater than 30.
Answer:
(i) SELECT Name FROM Teacher WHERE Department=”History”;
(ii) SELECT Name, Age, Department from Teacher where Name like “_a%”;
(ii) Update Teacher Set Salary= Salary + Salary *0.05 where Gender=”M” and Department=”Computer Sc”;
(iv) SELECT * FROM Teacher;
(v) SELECT Department FROM Teacher WHERE Age > 30;