Class 11 Informatics Practices Term 2 Sample Paper Set-1

Class 11 Informatics Practices Term 2 Sample Paper Set-1

Subject: Informatics Practices 

Subject Code: 065

Class 11

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 ,4, 8 and 12.

 

Section –A (2 marks each)

1. Differentiate between Candidate Key and Alternate Key with an example.

Or

Differentiate between DDL and DML with example.

 

2. Ms Purva wants to create a database with her name,and then she wants to switch to the newly created database.Help her to write both the SQL statements.

_______________statement 1

_______________ statement2

 

3. Mr. Anirban has created a database named “virtual” using mysql command and created few tables inside it,now he wants to check what are tables he has created.What query he should write to print list of all the tables inside the database? What command he should write to remove the database “virtual”?

 

4. What do you understand by the Internet of Things? List some of its potential applications.

Or

List some of the cloud-based services that you are using at present.

 

5. Among the following commands choose DDL and DML commands separately

INSERT,SELECT,CREATE,DROP,DELETE,ALTER 

 

6. Differentiate between DELETE and DROP command, add one example too.

 

7. Subhee has created a table named Orders, she has been asked to increase the value of a column named salesamount by 20. She has written the following query for the same.

Alter table Orders Add salesamount =salesamount+20;

But it is not solving the purpose.

i)Rewrite the correct query.

ii) Now Subhee wants to remove the table Orders from Database.Write the appropriate query.

 

Section –B (3 marks each)

8. Check the following table:-

table: SCHEDULE

SLOTID MOVIEID TIMESLOT
S001 M010 10 AM to 12 PM
S002 M020 2 PM to 5 PM
S003 M010 6 PM to 8 PM
S004 M011 9 PM to 11 PM

i)Write SQL command to display the structure of the table SCHEDULE

ii)Write SQL command to create one new row in the table.

iii)Write SQL command to add a new column “Revenue” to the table SCHEDULE

 

Or

Check the following table and answer the questions below.

table: PRODUCTS

Code Item Qty Price Transaction Date
1001 Plastic Folder 14″ 100 3400 2014-12-14
1004 Pen Stand Standard 200 4500 2015-01-31
1005 Stapler Mini 250 1200 2015-02-28
1009 Punching Machine Small 200 1400 2015-03-12
1003 Stapler Big 100 1500 2015-02-02

i)Sabina wants to print the above table in descending order of Price,help her to write the quote.

ii)Now Sabina wants to remove the column Transaction Date,what command she should write?

iii)Sabina wants to print the details of the items whose name has “t” as the second letter.Help her write the query.

 

9. Write a short note on the following:

a) Cloud computing

b) Big data and its characteristics

c) Artificial Intelligence

 

10. Raman has to create a database named MYEARTH in MYSQL. She now needs to create a table named FARES in the database to store the records of various cities across the globe. The table FARES has the following structure:

TABLE: FARES

FL_NO AIRLINES FARE TAX%
IC701 Indian Airlines 6500 10
MU499 Sahara 9400 5
AM501 Jet Airways 13450 8

Help him to complete the task by suggesting appropriate SQL commands.

 

Section –C (4 marks each)

11. See the following table and solve the questions :-

TABLE: FLIGHT

FL_NO STARTING ENDING NO_FLIGHT NO STOPS
IC301 MUMBAI DELHI 8 0
IC799 BANGALORE DELHI 2 1
MC101 INDORE MUMBAI 3 0
IC302 DELHI MUMBAI 3 0
AM812 KANPUR BANGALORE 3 1
IC899 MUMBAI KOCHI 1 4
AM501 DELHI TRIVENDRUM 1 5
MU499 MUMBAI MADRAS 3 3
IC701 DELHI AHEMDABAD 4 0

                                                               

i)What is the Degree and Cardinality of the table Flight.

ii)Which attribute should be the primary key of the table?

iii)Write the statement to assign primary key to the table.

iv)Write statement to delete all rows from the table.

 

12. Check the table Stock given below:-

table: Stock

Pid PName Category Qty Price
1 Keyboard IO 15 450
2 Mouse IO 10 350
3 Wifi-router NW 5 2600
4 Switch NW 3 3000
5 Monitor O 10 4500
6 Printer O 4 17000

Write SQL queries for the following:

(a) To display the records in decreasing order of quantity.

(b) To display category and quantity of the Products if quantity is ranged between 10 to 15.

(c) To display the details of the products whose name starts with “M”

(d) To increase the price of all the monitors by 100. 

 

13. Consider the following tables DRESS . Write outputs of SQL commands for the statements (i) to (iv)                                        

Table :DRESS

DCODE DESCRIPTION PRICE MCODE LAUNCHDATE
10001 FORMAL SHIRT 1250 M001 12-JAN-08
10020 FROCK 750 M004 09-SEP-07
10012 INFORMAL SHIRT 1450 M002 06-JUN-08
10019 EVENING GOWN 850 M003 06-JUN-08
10090 TULIP SKIRT 850 M002 31-MAR-07
10023 PENCIL SKIRT 1250 M003 19-DEC-08
10089 SLACKS 850 M003 20-OCT-08
10007 FORMAL PANT 1450 M001 09-MAR-08
10009 INFORMAL PANT 1400 M002 20-OCT-08
10024 BABY TOP 600 M003 07-APR-07

 

i) SELECT * FROM DRESS WHERE MCODE= ‘M001’;

ii) SELECT DESCRIPTION,TYPE FROM DRESS WHERE PRICE>=1250 ;

iii) SELECT * FROM MATERIAL WHERE DESCRIPTION LIKE “%T” ;

iv) SELECT DISTINCT PRICE FROM DRESS ;

 

Or

See the following table and Write output for i) to iv)

Table :EMPLOYEE

ENO NAME DOJ DOB GENDER DCODE
1001 Gorge K 2013-02-09 1991-09-01 MALE D01
1002 Ryma Sen 2012-12-11 1990-12-15 FEMALE D03
1003 Mohitesh 2013-02-03 1987-09-04 MALE D05
1007 Anil Jha 2014-01-17 1984-10-19 MALE D04
1004 Manila Sahai 2012-12-09 1986-11-14 FEMALE D01
1005 R Sahay 2013-11-18 1987-03-31 MALE D02
1006 Jaya Priya 2014-06-09 1985-06-23 FEMALE D05

 

i) Select ENO,Name,Gender from EMPLOYEE order by ENO;

ii) Select Name from EMPLOYEE where Gender=”MALE”;

iii) Select Eno,Name from EMPLOYEE where DOB between ‘1987-01-01’ and ‘1991-12-01’;

iv) select NAME from EMPLOYEE where GENDER=”FEMALE” and DOJ> ‘1986-01-01’;

 

Source: KENDRIYA VIDYALAYA SANGATHAN, VARANASI REGION

Leave a Reply

Your email address will not be published. Required fields are marked *