CBSE Class 11 Informatics Practices Question Paper Set N Solved

1.
(a) State the use of RJ11 Port.

(b) Write the function of OCR.

(c) Give any two examples for Specific Purpose Application software.

(d) What is a device driver ?

(e) Give a short note on ISCII.

2.
(a) Give a short note on IDE.

(b) List any two functions of an Operating System.

(c) Explain any one threat and precaution related to online social networking.

(d) Give a short note on any four types of Printers.

(e) What do you mean by Cyber Crime? List any four of them. What is IT Act of India?

3.
(a) Which window in NetBeans contains Swing Controls ?

(b) What is the use of Inspector Window in NetBeans ?

(c) Suraj designed a form in NetBeans with a button(jButton1) with the caption „Morning‟. He also placed a textfield named jTextField1 for getting user‟s name in the form. Write a
code which will display “Good Morning user name” in the text field (jTextField2) on clicking the Morning button. For example, on running the application, if the user enters “Vijay” in the text field jTextField1, the text “Good Morning Vijay” should be displayed in jTextField2 on clicking Morning button.

(d) Distinguish between line wrap and word wrap properties of a text area in NetBeans.

(e) Identify the various components used in the form. List the various properties of the controls used to design the following form.

(f) Mohammed Irfan developed the following form to compute area of a square. Write code in Java to display the area of the square in jTextField2 box using the side entered jTextField1 box on clicking Compute(jButton1) button. (Area of a square = side * side)

4.
(a) How is data organized in a table ?

(b) Identify Alternate key(s) in a table LIBRARY with fields BookNo, BookName, Publisher and Qty.

(c) What do you mean by database ? Give two examples.

(d) Write a command in SQL to create a table STUDENT with fields Admno (integer), Name (30 characters) and Marks (decimal number). Make Admno as Primary key.

(e) Consider the table SUPPLIER with the fields S_ID(Supplier ID), Name, City and Amount. Write SQL commands for (i) to (iv)

(i) To add a new supplier with ID=S128 and Name = Amit Kumar
(ii) To remove a supplier with ID „S102‟
(iii) To increase the Amount by 10% for Suppliers from city „Kanpur‟.
(iv) To display the details of suppliers whose name starts with „R‟ and ends with „e‟

5.
(a) Name any two DML commands in SQL.

(b) Shikhar typed the following SQL command to remove a field Qty in SHOP table. But it resulted in error. Correct the command.
 DELETE Qty from TABLE SHOP;

(c) Explain any two numeric functions in MYSQL with examples.

(d) Write an SQL command to display the details of customers who are from city „Shimla‟ (City field) in CUSTOMER table in descending order of custno.

(e) Give the output of the following SQL commands

(i) SELECT LENGTH(„PROGRAMMING‟);
(ii) SELECT POWER(-4,3);
(iii) SELECT LEFT(„COMMERCE‟,3);
(iv) SELECT YEAR(„2016-10-14‟);

6.
(a) Consider the following table

Write SQL Commands for (i) to (vi) based on the above table

(i) Display the different cities from the table.
(ii) Display the details of clients whose amount is below 4000
(iii) Display the names of clients whose names end with „l‟
(iv) Display name and Amount of clients from Mumbai.
(v) Display C_ID and 2% of Amount for all clients. Give the column alias as „Discount‟ for 2% of Amount
(vi) Display the details of clients whose Amount is in the range 5000 to 7000

(b) Give the output of the following SQL commands based on the above table CLIENTS

(i) SELECT C_ID, Name FROM CLIENTS WHERE C_ID=‟ND05‟;
(ii) SELECT Name, City FROM CLIENTS WHERE Name LIKE „%tt%‟;
(iii) SELECT Name FROM CLIENTS WHERE Amount > 6000;
(iv) SELECT C_ID FROM CLIENTS WHERE city = „New Delhi‟;

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