CBSE Class 11 Informatics Practices Question Paper Set S Solved

I.

1.What is e-Learning? 

2.Mention any two advantages of e-Business. 

3.Mention any two negative impacts of IT. 

4.What are the objectives of e-Governance? 

5.Write any two features of computers. 

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

II.

1.Define firmware. Give an example

2.What do you mean by a Hybrid computer? Explain 

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

4.Write a note on Microcomputers. 

5.Why we need a parallel port in a computer? 

6.What are language processors? 

7.Write a note on special purpose computers. 

8.What are the functions of an operating system? 

9.Write notes on a) Application Software    b)DVD-R

III.

1.Write the MySQL commands to do the following :

a) Create the following table WORKER with the field WNO 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 Names of all female workers.

d) Display wno and name of those workers who are born between ‘1987-01-01’ and ‘1991-12-01’

e) Display the names of all male workers who have joined after ‘1986-01-01’.

f) Display the name and date of birth of the workers whose name starts with ‘A’.

g) Display all details of the workers in the descending order of DOB.

h) Display names and DOJ of male workers.

i) Display wno and name of those workers who has a substring ‘nil’ in their name.

j) Display the minimum DOJ from the worker table.

k) Change the date of birth of the worker with wno 1004 to ‘1986 –10 -14’.

l) Delete all rows of the table worker.


IV.

1.What do you mean by a tuple?

2. Define candidate key. 

3. What is DML? 

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

5. What is unique constraint?

6. What is a record with respect to a database? 

7. Explain any two mathematical functions used in MySQL.

8. What is a database?

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