CBSE Class 11 Informatics Practices Question Paper Set Q Solved

I

1. What is ICT?

2.Mention any two positive benefits of IT.

3.Write any two disadvantages of e-learning.

4.What is e-business?

5.Mention any two weaknesses of computers.

6. Write the address of any two commonly used e-Governance websites.

II

1.Define hardware. Give two examples of hardware.

2.What do you mean by an Analog computer? Explain.

3.Mention any four major features in the second generation of computers.

4.Write a note on Mainframe computers.

5.What do you mean by an operating system? Give examples of two operating system.

6.What is the function of motherboard in a computer?

7. What do you mean by VGA port?

8. What is a MODEM?

9. Draw a neat block diagram of a computer and label its parts.

III.

1. Write the MySQL commands to do the following :

a) Create the following table ITEM with the field ID as the Primary key. (Assume the data type of all fields according to data values in the table).

b) Insert 5 rows in the table with the values as shown above.

c) Display all details of the products whose price is in the range 1500 to 3000 (both inclusive).

d) Display all details of those items which do not have any value for QTY.

e) Display iname of those items whose company is ‘Renix’.

f) Display all details of those items whose qty is greater than 100.

g) Display id,iname and company of those items whose iname has the starting word DIGITAL in it.

h) Display id and iname of those whose company is either Renix,Digipop or Storeking.

i) Display the highest price of the items in the table.

j) Display the number of items in the table.

k) Display the total and average price of the items from the table.

l) Change the qty to 80 for the item with id 105.

IV.

1. What do you mean by cardinality?

2. Define foreign key. 

3. What do you mean by NULL in MySQL? 

4. Mention about any two data types used in MySQL. 

5. What is default constraint? 

6. Define degree with respect to a table in a database. 

7. Explain any two character functions used in MySQL. 

8. What is RDBMS?

Please click on below link to download CBSE Class 11 Informatics Practices Question Paper Set Q Solved