Class 11 Informatics Practices Term 2 Sample Paper Set-1

Last updated on February 7th, 2022 at 11:31 am

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

SLOTIDMOVIEIDTIMESLOT
S001M01010 AM to 12 PM
S002M0202 PM to 5 PM
S003M0106 PM to 8 PM
S004M0119 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

CodeItemQtyPriceTransaction Date
1001Plastic Folder 14″10034002014-12-14
1004Pen Stand Standard20045002015-01-31
1005Stapler Mini25012002015-02-28
1009Punching Machine Small20014002015-03-12
1003Stapler Big10015002015-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_NOAIRLINESFARETAX%
IC701Indian Airlines650010
MU499Sahara94005
AM501Jet Airways134508

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_NOSTARTINGENDINGNO_FLIGHTNO STOPS
IC301MUMBAIDELHI80
IC799BANGALOREDELHI21
MC101INDOREMUMBAI30
IC302DELHIMUMBAI30
AM812KANPURBANGALORE31
IC899MUMBAIKOCHI14
AM501DELHITRIVENDRUM15
MU499MUMBAIMADRAS33
IC701DELHIAHEMDABAD40

                                                               

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

PidPNameCategoryQtyPrice
1KeyboardIO15450
2MouseIO10350
3Wifi-routerNW52600
4SwitchNW33000
5MonitorO104500
6PrinterO417000

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

DCODEDESCRIPTIONPRICEMCODELAUNCHDATE
10001FORMAL SHIRT1250M00112-JAN-08
10020FROCK750M00409-SEP-07
10012INFORMAL SHIRT1450M00206-JUN-08
10019EVENING GOWN850M00306-JUN-08
10090TULIP SKIRT850M00231-MAR-07
10023PENCIL SKIRT1250M00319-DEC-08
10089SLACKS850M00320-OCT-08
10007FORMAL PANT1450M00109-MAR-08
10009INFORMAL PANT1400M00220-OCT-08
10024BABY TOP600M00307-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

ENONAMEDOJDOBGENDERDCODE
1001Gorge K2013-02-091991-09-01MALED01
1002Ryma Sen2012-12-111990-12-15FEMALED03
1003Mohitesh2013-02-031987-09-04MALED05
1007Anil Jha2014-01-171984-10-19MALED04
1004Manila Sahai2012-12-091986-11-14FEMALED01
1005R Sahay2013-11-181987-03-31MALED02
1006Jaya Priya2014-06-091985-06-23FEMALED05

 

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

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