CBSE Class 11 Informatics Practices Question Paper Set 18 Solved

I.

1. Explain any two features of computers.

2. What is e-governance? 

3. What do you mean by moodle? 

4. Mention any two disadvantages of e-Business. 

5. Write the address of any two commonly used e-Learning websites. 

6. Mention any two advantages of e-Learning.

II.

1. Define software. Give two examples of application software. 

2. Mention any four major features in the fourth generation of computers. 

3. Write a note on Minicomputers. 

4. What do you mean by utility software? Give examples of two utility software. 

5. What is the function of a power supply unit in a computer? 

6. What is the purpose of Network card in a computer? 

7. What is RAM? Why we need a RAM in a computer? 

8. What do you mean by a Digital computer? Explain. 

9. Write notes on a) Serial port   b) CD-R

III.

1. Write the MySQL commands to do the following :

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

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

c) Display the Pname and Price of all products.

d) Display the different Pnames of the products (without duplicates).

e) Display the PIds of the products supplied by Rotomac.

f) Display Pname and Price of the products whose price not in the range 6 to 10 (inclusive).

g) Display all details of the products in the ascending order of price.

h) Display Pnames of those products whose names end with the letter „n‟.

i) Display the Pid and Pname of those products whose Company has exact four characters.

j) Display the maximum price of a product.

k) Change the price to 5 of that product whose Pid is ER05.

l) Delete the product whose Pname is “Dot Pen”.

IV.

1. What do you mean by an attribute?

2. What is a primary key? 

3. What is DDL? 

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

5. What is alternate key?

6. Write any two characteristics of MySQL. 

7. What is the difference between data and information?

8. What do you mean by a view in MySQL?

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