CBSE Class 11 Informatics Practices Question Paper Set L Solved

Read and download CBSE Class 11 Informatics Practices Question Paper Set L Solved designed as per the latest question paper pattern and Class 11 examination guidelines issued by CBSE, NCERT and KVS. The past year Question Papers for Class 11 Informatics Practices have been provided with solutions which will help students to assess their performance and find out topics in Informatics Practices Class 11 which they need to improve to get better marks in Class 11 exams. After solving these last year papers also refer to solved Sample Papers for Class 11 Informatics Practices available on our website to build strong understanding of the subject

Informatics Practices Question Paper Class 11

Students can refer to the below Class 11 Informatics Practices Question Paper designed to help students understand the pattern of questions that will be asked in Class 11 exams. Please download CBSE Class 11 Informatics Practices Question Paper Set L Solved

Informatics Practices Class 11 Question Paper

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

(b) Write the function of Biometric sensor.

(c) Give any two examples of System Software.

(d) Name any two types of Operating System.

(e) Give a short note on Unicode.

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

(b) Distinguish between a text editor and a word processor.

(c) What is meant by CIA? Explain.

(d) Give a short note on e-waste and explain any three methods of its disposal.

(e) Explain (i) Virus (ii) Worms. How do they spread? What damages do they cause?

3.
(a) What is the most suitable component in NetBeans to accept multiline text?

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

(c) Akshita designed a form in NetBeans. She placed a button component jButton1 and gave a caption QUIT. Write a code in Java to terminate the application on clicking the QUIT button.

(d) Explain the use of getText() and parseInt() methods in Java.

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

CBSE Class 11 Informatics Practices Question Paper Set L Solved 1

(f) Sharmila designed the following form to perform temperature conversion. Write the code in Java to convert the temperature in Celsius stored in jTextField1 to Fahrenheit and display the result in jTextField2 on clicking Compute (jButton1) button. (F = C*1.8 + 32)

CBSE Class 11 Informatics Practices Question Paper Set L Solved 2

4.
(a) Expand SQL.

(b) Identify Primary key in a STUDENT table with fields Admno, Name and Marks.

(c) What do you mean by cardinality of a table ? Explain with an example.

(d) Write a command in SQL to create a table SHOP with fields Itemcode (integer), ItemName (20 characters), Qty (integer) and Price (decimal number). Make Itemcode as Primary key.

(e) Give the output of the following SQL commands
(i) SELECT LENGTH(‘GOODLUCK’);
(ii) SELECT ROUND(45.678,2);
(iii) SELECT INSTR(‘KARISHMA’,’SH’);
(iv) SELECT MONTH(‘2016-11-23’);

5.

(a) Name any two DDL commands in SQL.

(b) Shankar typed the following SQL command to change the data type of a field Category to 20 characters in BOOK table. But it resulted in error. Correct the command.
MODIFY TABLE BOOK Category CHAR(20);

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

(d) Write an SQL command to display the details of salesmen who are from city ‘Mysore’ (City field) in SALESMAN table in descending order of Commission.

(e) Consider the table GYM with the fields PrCode(Product Code), PrName (Product Name), UnitPrice and Manufacturer. Write SQL commands for (i) to (iv)

(i) To add a new Product with PrCode= P104 and PrName = TreadMill
(ii) To remove a Product with PrCode ‘P102’
(iii) To increase the UnitPrice by 5 for the Product whose Code is ‘P105’
(iv) To display the details of Products whose name starts with ‘V’ and ends with ‘r’

6.
(a) Consider the following table

CBSE Class 11 Informatics Practices Question Paper Set L Solved 3

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

(i) Display the different companies from the table.
(ii) Display the details of items whose price is above 5 from the company ‘XYZ’
(iii) Display the names of the items whose ID starts with ‘P’
(iv) Display name and price of the items supplied by the company ‘ABC’
(v) Display the ID and Price *3 of all items. Give the column alias as ‘New Price’ for Price*3
(vi) Display the details of items whose Price is in the range 4 to 8

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

(i) SELECT S_ID, Name FROM STATIONERY WHERE S_ID=’PL01’;
(ii) SELECT Name, Price FROM STATIONERY WHERE Name LIKE ‘E%’;
(iii) SELECT Name FROM STATIONERY WHERE Price < 10;
(iv) SELECT S_ID FROM STATIONERY WHERE Company = ‘CAM’;

(c) Consider the following table

CBSE Class 11 Informatics Practices Question Paper Set L Solved 4

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

(i) Display the day of the month of the launchdate from the table.
(ii) Display the year from launchdate from the table.
(iii) Display three letters from second letter in Description field.
(iv) Display Description of dresses in lower case.
(v) Display name of the day of launchdate for formal shirt.
(vi) Display the current date and time.

(d) Give the output of the following SQL commands based on the above table DRESS

(i) SELECT DESCRIPTION FROM DRESS WHERE PRICE IS NULL;
(ii) SELECT DCODE FROM DRESS WHERE LAUNCHDATE>’2015-01-01’;
(iii) SELECT DCODE FROM DRESS ORDER BY LAUNCHDATE;
(iv) SELECT DESCRIPTION FROM DRESS WHERE DESCRIPTION LIKE ‘FOR%’;


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

More Study Material

Previous Year Question Paper Informatics Practices Class 11

We hope you liked the above provided CBSE Class 11 Informatics Practices Question Paper Set L Solved. To get an understanding of the type of questions which were asked in previous year exams, it is important for Class 11 students to refer to CBSE Class 11 Informatics Practices Question Paper Set L Solved that we have provided above. Students can download all the Question Papers for Class 11 Informatics Practices which were issued in the exams so that you can practise them and solve all types of questions which have been asked till now. If you do CBSE Class 11 Informatics Practices Question Paper Set L Solved for Class 11 Informatics Practices you will easily understand the way examination question papers are set by teachers.

Class 11 Informatics Practices Previous Year Question Papers

The past year question papers CBSE Class 11 Informatics Practices Question Paper Set L Solved covers all the topics which have been suggested by CBSE in their Class 11 Informatics Practices syllabus for the current year. By doing all CBSE Class 11 Informatics Practices Question Paper Set L Solved PYP (previous year papers) you will understand the regular questions and MCQ questions for Class 11 Informatics Practices which are always asked and learn them so that you can get full marks in those questions.

Class 11 Informatics Practices Model Question Paper Pdf Download

We have provided links above of CBSE Class 11 Informatics Practices Question Paper Set L Solved in Pdf format so that you can just click the links and easily download the papers with answers. On studiestoday, we have also provided a download and print option for all CBSE Class 11 Informatics Practices last year papers and Sample Papers for Class 11 Informatics Practices to make it more easy for students. You can download CBSE Class 11 Informatics Practices Previous Year Question Papers and Class 11 Informatics Practices Sample Papers in PDF absolutely free of cost.

Informatics Practices Previous Year Question Papers Class 11 with Solutions

We have provided CBSE Class 11 Informatics Practices Question Paper Set L Solved with solutions. You will be able to understand the type of answers which you should write in Class 11 Informatics Practices exams to score good marks. You should attempt all the last year question paper for Class 11 and Class 11 Informatics Practices MCQ Test in examination conditions at home and then compare their answers with the solutions provided by our teachers. This way you will be able to identify your weak areas and also understand how the teachers of Class 11 Informatics Practices set their questions in the exams.

CBSE Class 11 Informatics Practices Previous Year Question Papers with solutions

We have provided the last 10 years Class 11 Informatics Practices Question Papers. Students who want to practice question papers from all previous years can easily get them on studiestoday. We are the leading website in India from which you can download all the latest Class 11 Informatics Practices study material for free as per the CBSE syllabus for Class 11 Informatics Practices for the current academic year.
 

Where can I download CBSE Class 11 Informatics Practices Question Paper Set L Solved in Pdf

You can download CBSE Class 11 Informatics Practices Question Paper Set L Solved from StudiesToday.com

Can I download the previous year Question Papers of Class 11 Informatics Practices in Pdf

Yes, you can click on the links above and download Question Papers in PDFs for Class 11 for Informatics Practices. Click on above link to download CBSE Class 11 Informatics Practices Question Paper Set L Solved

Is the Class 11 Informatics Practices Question Paper available for the latest session

Yes, the CBSE Class 11 Informatics Practices Question Paper Set L Solved issued for Class 11 Informatics Practices have been made available here for latest academic session

How can I download and print CBSE Class 11 Informatics Practices Question Paper Set L Solved

You can easily access the link above and download CBSE Class 11 Informatics Practices Question Paper Set L Solved and save on your computer of mobile

Is there any charge for CBSE Class 11 Informatics Practices Question Paper Set L Solved

There is no charge for CBSE Class 11 Informatics Practices Question Paper Set L Solved you can download everything free

How can I improve my scores by solving CBSE Class 11 Informatics Practices Question Paper Set L Solved

Regular practice of sample question paper given on studiestoday for CBSE Class 11 Informatics Practices Question Paper Set L Solved can help you to score better marks in exams

Are there any websites that offer free CBSE Class 11 Informatics Practices Question Paper Set L Solved

Yes, studiestoday.com provides all latest CBSE Class 11 Informatics Practices Question Papers with answers based on the latest format issued for current academic session

Can model paper CBSE Class 11 Informatics Practices Question Paper Set L Solved be accessed on mobile devices

Yes, studiestoday provides CBSE Class 11 Informatics Practices Question Paper Set L Solved in Pdf and can be accessed on smartphones and tablets.

Are mock CBSE Class 11 Informatics Practices Question Paper Set L Solved available in multiple languages

Yes, mock CBSE Class 11 Informatics Practices Question Paper Set L Solved are available in multiple languages, including English, Hindi