Class 11 IP Sample Paper Term 2 Set 2

Term-2 Examination 2021-22

Class: 11   

Subject: Informatics Practices

Subject Code: 065

Duration : 2 hrs. Max Marks : 35

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

1. Karan is confused with the terms Cardinality and Degree. Help him to understand the terms with a suitable example of each.

OR

Kritika is creating a table with following field names in Emp table:

EmpId ,Ename, Date of birth, Date of Joining,Designation, Address, PhoneNo, Driving LicenseNo.

She is not able to differentiate between Primary Key and Unique Key . Help her to understand the difference between them and keeping in view to the above fields decide which field name can kept as Primary Key and Unique Key.

 

2. i) _____________ technology is able to take an existing environment and adds a layer of virtual information on top of it.

a) Immersive

b) Augmented

c) Non Immersive

d) Virtual Reality

 

ii) Which one of these is not an area of Artificial Intelligence (AI)?

a) Image recognition

b)Voice Recognition

c) Web designing

d) Robotics

 

3. Pooja a student of class XI created a table “BOOK”. Price is a column of this table to find the details of books whose price have not been entered, she wrote the following query:

Select * from Book where Price=NULL;

Help Pooja to run the query by removing the errors from the query and rewriting it.

OR

Sujata has created a table Emp in MySQL. Later on she found that the width of name column is not sufficient for entering some long names. She wants to increase the width of the name column by 40. What command she should write to do this?

 

4. What is Referential integrity in respect to RDBMS?

 

5. Differentiate between DDL and DML command with One example of each command?

 

6. Write a query to update the table BOOK by increasing the price of all books by 2%

 

7. Differentiate between CHAR and VARCHAR data types in SQL. 

 

SECTION – B

Each question carries 3 marks

8. Write the output for the SQL queries (i) to (iii) on the basis of the ITEM relation given below:

Table: ITEM

Itemno Iname Price Quantity
101 Soap 50 100
102 Powder 100 50
103 Face Cream 150 25
104 Pen 50 200
105 Soap box 20 100

i) SELECT * FROM ITEM WHERE ITEMNO IN(101,103,105);

ii) SELECT Itemno ,Iname , Price FROM ITEM WHERE PRICE BETWEEN 50 AND 100;

iii) SELECT * FROM ITEM ORDER BY INAME;

 

OR

i) Display the item information whose name has letter ‘o’.

ii) Increase the price of Soap and Soap box by 2%

iii.) Write SQL query to insert one record 106, Sanitizer , 60, 250 3

 

9. i) “XYZ” Company has organized their Annual Conference. Participants are coming from different parts of the country to attend. Write SQL query to create a table Participant with the following structure:

Field Type Constraint
ParticipantID Integer Primary Key
Name Varchar (50)
ArrivalDate Date
DepartureDate Date
Phone Integer
EmailID Varchar(30)

 

ii) Write the command to display the tables created in a database and write command to view the structure of the table. 

 

10. a) Give full form of IoT and WoT

b) Explain NLP give any two examples. 

 

SECTION – C

Each question carries 4 marks

11. Differentiate between with example-

a) Delete and Drop command

Alter and Update Command

 

12. Study the following table DOCTOR and answer the following questions:-

TABLE : DOCTOR

ID NAME DEPT SEX EXPERIENCE
101 John ENT M 12
104 Smith ORTHOPEDIC M 5
107 George CARDIOLOGY M 10
114 Lara SKIN F 3
109 K George MEDICINE F 9
105 Johnson ORTHOPEDIC M 10
117 Lucy ENT F 3
111 Bill MEDICINE F 12

i) Give the cardinality and degree of the table Doctor.

ii) Write SQL Query to display the details of all those Doctors whose name either starts with ‘J’ or starts with ‘S’.

iii) Write SQL Query to display the details of all female doctors having experience more than 5 years.

iv) Write SQL Query to add column contact no, with data type as int and size as 10.

OR

i) Write the SQL Query to display the records of ENT department.

ii) Write the SQL Query to update the experience of all doctors by 1.

iii) Write the SQL Query to display Name, Dept in ascending order by and then by experience in descending order.

iv) Write the SQL Query to ADD Primary Key to column ID in the existing table.

 

13. Consider the “Sales” table :

Table: Sales

Ecode Ename Address dojoin Amount Area
100 Amit Delhi 2017-09-29 5000.90 East
101 Sushant Gurgaon 2018-01-01 7000.75 East
102 Priya Noida 2018-04-25 3450.45 West
103 Mohit Delhi 2018-11-03 6000.50 North
104 Priyanshi Delhi 2019-12-15 8000.62 North

 

a) Write a SQL query to display the name of the oldest employee first then 2nd oldest and so on.

 

b) Which of the following command(s) will display all sales whose date of joining is after 31st March 2018.

i) Select * from Sales where dateofjoin>=”31-03-2018”;

ii) Select * from Sales where dojoin>=”2018-03-31”;

iii) Select * from Sales where dojoin>”2018-03-31”;

iv) Select * from Sales where dojoin>”2018/03/31”;

 

c) Select Area, Ename as Employee, Amount *0.01 as PF from Sales where Area=”East” OR Area=”West”;

d) Write a SQL query to delete the record of Ecode as 102.

Copywrite © 2020-2024, CBSE Python,
All Rights Reserved