Term-2 Sample Question Paper : 2021-22

Class: 11th INFORMATICS PRACTICES (Code : 065)

Marking Scheme

Maximum Marks: 35 Time: 2 hours

General Instructions
 The question paper is divided into 3 sections – A, B and C
 Section A, consists of 7 questions (1-7). Each question carries 2 marks.
 Section B, consists of 3 questions (8-10). Each question carries 3 marks.
 Section C, consists of 3 questions( 11-13). Each question carries 4 marks.
 Internal choices have been given for question numbers – 1 , 3, 8 and 12.
Section –A

Each question carries 2 marks

Q1)
Big data: - Big data holds rich information and knowledge which can be of high
business value. Five characteristics of big data are: Volume, Velocity, Variety, Veracity,
and Value.
OR
NLP: Natural language processing (NLP) facilitates communicating with intelligent
systems using a natural language.

Consider any other correct answers.

Q2) ) char(n):  stores a fixed length string between 1 and 255 characters  if the
value is of smaller length, adds blank spaces  some space is wasted
varchar(n) :  stores a variable length string  no blanks are added even if value is
of smaller length  no wastage of space

for each correct difference : 1 mark. or correct explanation of both 2 marks.

Q3) a) delete from student where ID=103;

b) insert into student values (104 , ‘Chandresh’,’11th ‘ , 3150);

for each correct answer : 1 mark

Q4) update hotel set phno= 9406688990 where id=102;

Q5) Drop Table Tb2; or DROP TABLE IF EXISTS Tb2 ;

Q6) a) show databases ;

 b) desc TB2;

for each correct answer : 1 mark

Q7) a) primary key

b) 1

for each correct answer : 1 mark

Section –B

Each question carries 3 marks

8) a) alter table student drop fee;

b) alter table student add primary key(ID);

c) ID

OR

a) degree : 04 and cardinality : 03

b)alter table student add city varchar(25);

c) alter table student drop primary key;

For Each correct answer : 1 mark

Q9) a) create database MYKV

use MYKV

b) show tables;

c) drop database MYKV

for each correct answer : 1 mark

Q10) Cloud Computing : Cloud computing allows resources located at remote locations to be made
available to anyone anywhere. Cloud services can be Infrastructure as a Service (IaaS), Platform as a
Service (PaaS), and Software as a Service (SaaS).

For correct definition 1 mark, any two services : 1 mark each

 Section –C

Each question carries 4 marks

Q11) a) select sname , Dateof_join from student where city=”pune”;

b) select sname from student where fee is NULL;

C) Select * from student where fee>30000;

d) select * from student order by dateof_join desc;

for each correct answer : 1 mark

Q12)

a) Select * from employee where city=’pune’ and bonus>350;

EmpNo Ename Salary Bonus city

103 Shabbir 45000 566 Pune
b) select ename , salary+bonus as”total_pay” from employee order by Ename asc;

Ename Total_Pay
Aaliya 10234
Kritika 60123
Shabbir 45566
Gurpreet 19565
Joseph 34875
c) select * from employee where name like ‘ - %a’ ;

EmpNo Ename Salary Bonus city

101 Aaliya 10000 234 Pune
102 Kritika 60000 123 Mumbai
d) select Ename , salary from employee where bonus > 600 ;

Ename Salary
Joseph 34000

OR (choice for all four )

e) select Ename,city from employee where city not in (‘pune’,’mumbai’);

Ename city
Gurpreet Delhi
Joseph Delhi

f) select Ename,Salary*12 “annual sal”, bonus*12 “annual bonus” from employee ;

Ename annual sal annual

bonus
Aaliya 120000 2808
 Kritika 720000 1476
Shabbir 540000 6792
Gurpreet 228000 6780
Joseph 408000 10500

g) select distinct(city) from employee;

Distinct(city)
Pune
Mumbai
Delhi

h) select * from employee where city like ‘%e%;

EmpNo Ename Salary Bonus city

101 Aaliya 10000 234 Pune
103 Shabbir 45000 566 Pune
104 Gurpreet 19000 565 Delhi
105 Joseph 34000 875 Delhi

For each correct : 1 mark

Q12) Consider the following MOVIE table and answer the SQL queries based on it. 4

MovieID MovieName Category ReleaseDate ProductionCost BusinessCost

001 Hindi_Movie Musical 2018-04-23 124500 130000
002 Tamil_Movie Action 2016-05-17 112000 118000
003 English_Movie Horror 2017-08-06 245000 360000
004 Bengali_Movie Adventure 2017-01-04 72000 100000
005 Telugu_Movie Action NULL 100000 NULL
006 Punjabi_Movie Comedy NULL 30500 NULL

a) select MovieID, MovieName, BusinessCost from Movies;

b) select distinct(Category) from movies;

c) Select Movieid,Moviename , BusinessCost – ProductionCost as “ Net Profit” from Movie
d) select Movieid,Moviename ,ProductionCost from movie where ProductionCost > 80000 and
ProductionCost<125000 ;

for each correct answer : 1 mark

----------------------------------------------------------X$X-----------------------------------------------------