Practice Paper
TERM II (2021 – 2022)
Class – XI
Informatics Practices (065)
Time: 2 hours Maximum Marks: 35
General Instructions:
(i) The question paper is divided into 3 sections – A, B and C
(ii) Section A, consists of 7 questions (1 – 7). Each question carries 2 marks
(iii) Section B, consists of 3 questions (8 – 10). Each question carries 3 marks
(iv) Section C, consists of 3 questions (11 – 13). Each question carries 4 marks
(v) Internal choices have been given for question numbers – 1, 8 and 13.
SECTION – A
1. Write short notes on big data and its characteristics.
Big Data – Big data hold information and knowledge which can be of high business value. Five characteristics of big data are: Volume, Velocity, Variety, Veracity and Value
OR
Write short notes on Natural Language Processing.
Natural language processing (NLP) facilitates communicating with intelligent systems using a natural language.
2. Differentiate between char (n) and varchar (n) data types with respect to databases
Char (n):
(i) stores a fixed length string between 1 and 255 characters
(ii) if the value is of smaller length, adds blank spaces
(iii) some space is wasted
Varchar (n)
(i) stores a variable length string
(ii) no blanks are added even if value is of smaller length
(iii) no wastage of space
3. Write SQL command to perform the following –
a) Delete last record from the table.
Delete from student values where ID = 103;
b) Add/insert new record in the table {104, ‘Chandresh’, ‘11th’, 3150}
insert into student (104, ‘Chandresh’, ‘11th’, 3150);
4. Mr. Ramesh created a table “Hotel” and inserted two records as given below.
Upon verification of records he found that he entered the wrong phone number of Ramesh. Now help him to correct the phone number by writing the sql command.
The correct Phone Number is 9406688990
Update hotel set phno = 9406688990 where id = 102;
5. Ms Sunita created a database, inside database she created two table (Tb1, Tb2). Later on she finds that table Tb2 is not required for her database. Now she wants to delete the table. Help her by writing the sql command to delete the table from the database.
Drop table Tb2; or Drop table if exists Tb2;
6. Write the name of SQL command for the following:
a) To list all databases;
show databases;
b) To show description of a table “TB2”
desc TB2;
7. Mr Ben appeared for an interview to get job. Interviewer asked the following two questions based on MySQL
a) The key which has unique and not null value is known as _______
primary key
b) A table can contain how many primary keys?
1
Mr Ben answered correctly for both the questions.
SECTION – B
8. Write SQL commands for the following –
Consider the above table student {ID, Name, Class, Fee}
a) Write SQL command to delete column fee.
Alter table student drop fee;
b) Write SQL command to apply primary key constraint on column ID.
Alter table student add primary key (ID);
c) Suggest name of column on which unique constraint can be applied.
ID
OR
a) What is the degree and cardinality of table student.
Degree : 04
Cardinality: 03
b) Write SQL command to add a column city with data type Varchar(25)
Alter table student add city varchar(25);
c) Write SQL command to delete primary key.
Alter table student drop primary key;
9. Write the SQL command to perform the following task.
a) Create a database named “MYKV” and use it.
Create database MYKV;
Use MYKV;
b) Write SQL command to list all tables of MYKV database.
Show tables;
c) Write SQL command to delete database MYKV
drop database MYKV;
10. Explain cloud computing and its services.
Cloud Computing: Clouding 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)
SECTION – C
11. Consider the following table and write the SQL queries for the following: –
a) To display name and date of joining of those student who belongs to Pune
Select sname, dateof_join from student where city= “pune”;
b) To display name of those students who have not paid the fee.
Select sname from student where fee is NULL;
c) To display details of those student who paid fee more than 30000
Select * from student where fee > 30000;
d) To display the records in descending order of Date of joining
Select * from student order by dateof_join desc;
12. Consider the following table Employee and write the output of SQL queries for (a to d) or (e to h)
a) Select * from employee where city = ‘pune’ and bonus > 350;
b) Select ename, salary+bonus as “total_pay” from employee order by Ename asc;
c) Select * from employee where name like ‘-%a’;
d) Select Ename, salary from employee where bonus > 600;
OR
e) Select Ename, city from Employee where city not in (‘pune’, ‘mumbai’);
f) Select Ename, Salary*12 “annual sal”, bonus*12 “annual bonus” from employee;
g) Select distinct(city) from employee;
h) Select * from employee where city like ‘%e%’;
13. Consider the following MOVIE table and answer the SQL queries based on it.
a) To display MovieID, MovieName and BusinessCost of Movies.
Select MovieID, MovieName, Business Cost from Movies;
b) To list the different categories of movies.
Select distinct(category) from movies;
c) To display movieid, name and Net Profit of all the movies
(Hint: Net Profit = BusinessCost – ProductionCost)
Make sure that the new column name is labelled as NetProfit
Select Movieid, moviename, BusinessCost – ProductionCost as “Net Profit” from Movie;
d) To display movieID, Name and ProductionCost of all the movies having ProductionCost greater than 80,000 and less than 1,25,000
Select Movieid, Moviename, ProductionCost from movie where ProductionCost > 80000 and ProductionCost < 125000;