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 grade 11 which they need to improve to get better marks in Standard 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 Grade 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

Tags: 

 


Click to View or Download pdf file
Click for more Informatics Practices Study Material

Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

Moderation of Marks Class 11 and 12 Board Exams

The portal for moderation and finalization of results for Class-12 is being opened from 16.07.2021 to 22.07.2021. As Board has to declare the result latest by 31.07.2021, schools have been requested to follow the schedule strictly and complete the moderation within...

MCQ Question based CBSE examination

For 2021-22 CBSE has launched MCQ question-based examination for Term 1 & Term 2 board examinations. The entire syllabus has been divided into two parts each including 50% of the entire syllabus. To score well, students must practice as per the new CBSE term-wise...

CBSE Board Examination Scheme of Assessment 2021 2022

A. Academic session to be divided into 2 Terms with approximately 50% syllabus in each term: The syllabus for the Academic session 2021-22 will be divided into 2 terms by following a systematic approach by looking into the interconnectivity of concepts and topics by...

Score well in Class 12 English Boards Exam

12th Board exams are an important part of students' lives. The marks obtained in the board exam decide the college in which one can study. In class 12 the syllabus of each and every subject increases vastly and it is difficult to cover up every point. In English also...

CBSE Class 10 Revised Syllabus

Last year CBSE had to reduce the syllabus because of the pandemic situation but it was not very effective because there were no examinations. This year to avoid any confusion and conflict, CBSE has decided to reduce the syllabus into term 1 and term 2. 50 percent of...

How To Solve Unseen Passages In English

Unseen passages may contain one or many paragraphs. This is one of the important yet easy parts for a student to get marks. Students should thoroughly study and understand the passage to answer the related questions. The unseen passages are there just to test the...

×
Studies Today