CBSE Class 11 Informatics Practices Question Paper Set M Solved

Read and download CBSE Class 11 Informatics Practices Question Paper Set M 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 M Solved

Informatics Practices Class 11 Question Paper

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

(b) Write the function of QR code Reader.

(c) Give any two examples of Utility Software.

(d) Expand (i) BIOS     (ii) CAPTCHA

(e) Give a short note on ASCII.

2.
(a) Give a short note on Presentation Tools.

(b) Explain the function of a Compiler.

(c) List any two security measures that can be adopted to minimize threats to a system.

(d) Give a short note on Central Processing Unit.

(e) Explain in detail the role of Digital Signature and Digital Certificate in handling a Cyber Crime.

3.
(a) What will be the result of the following command in Java “Mid-term”.concat(“Exam”)

(b) What is the use of Design Area in NetBeans ?

(c) Avinash designed a form in NetBeans. He placed a button component jButton1 and gave a caption WISH. Write a code in Java to display a message “ALL THE BEST !” in a message box on clicking the button.

(d) Distinguish between Text field and Text Area controls in NetBeans.

(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 M Solved 1

(f) Jeffson developed the following form to computer circumference of a circle. Write the code to store the circumference of the circle in jTextField2 box using the radius given in jTextField1 box on clicking the Compute( jButton1) button. (Formula for computing Circumference of the circle = 2*3.14*radius)

CBSE Class 11 Informatics Practices Question Paper Set M Solved 2

4.
(a) What is the relationship between a table and a database ?

(b) Identify Candidate key(s) in a table SHOP with fields Itemcode, Itemname, Qty and Price.

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

(d) Write a command in SQL to create a table LIBRARY with fields BookNo (integer), BookName (40 characters), Publisher (50 characters) and Qty (integer). Make BookNo as Primary key.

(e) Consider the table FARES with the fields FLNO(Flight Number), Airlines and Amount.

Write SQL commands for (i) to (iv)

(i) To add a new flight with FLNO=WY251 and Airlines = Srilankan Airlines
(ii) To remove a flight with FLNO „KI102‟
(iii) To increase the Amount by 5% for Qatar Airways.
(iv) To display the details of flights whose Airlines name starts with „S‟ and ends with „s‟

 5.
(a) Give the SQL command to display the structure of table STUDENT.

(b) Shruti typed the following SQL command to include a new field Dept (30 characters) in EMPLOYEE table. But it resulted in error. Correct the command. ADD TABLE EMPLOYEE Dept CHAR(30);

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

(d) Write an SQL command to display the details of Orders whose amount is more than 1000 (Amount field) in ORDERS table in ascending order of Ord_date.

(e) Give the output of the following SQL commands
(i) SELECT CONCAT(„GOOD‟ , ‟LUCK‟);
(ii) SELECT TRUNCATE(45.678,2);
(iii) SELECT RIGHT(„SUBJECT‟,3);
(iv) SELECT MONTH(„2016-11-23‟);

6.
(a) Consider the following table

CBSE Class 11 Informatics Practices Question Paper Set M Solved 3

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

(i) Display the different makes from the table.
(ii) Display the details of Tata cars whose charges are below 15.
(iii) Display the names of the cars whose names end with „a‟
(iv) Display name and capacity of Hyundai cabs.
(v) Display VCode and Charges+2 for all cabs. Give the column alias as „New Charges‟ for Charges+2
(vi) Display the details of cabs whose Charges lie in the range 14 to 16

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

(i) SELECT VCode, VName FROM CAB WHERE VCode=102;
(ii) SELECT VName, Capacity FROM CAB WHERE Make LIKE „H%‟;
(iii) SELECT VName FROM CAB WHERE Capacity > 5;
(iv) SELECT VCode FROM CAB WHERE Make = „Tata‟;

(c) Consider the following table
CBSE Class 11 Informatics Practices Question Paper Set M Solved 4
 
Write SQL Commands for (i) to (vi) based on the above table
 
(i) To Display the day of the month of the join_date from the table.
(ii) To Display the year from join_date from the table.
(iii) To Display two letters from third letter in Name field.
(iv) To Display City in upper case.
(v) To Display name of the day of the join_date for George.
(vi) To Display the current date.
 
6
 
(d) Give the output of the following SQL commands based on the above table EMPLOYEES
 
(i) SELECT NAME FROM EMPLOYEES WHERE SALARY IS NULL;
(ii) SELECT EMPID FROM EMPLOYEES WHERE JOIN_DATE<‟2010-01-01‟;
(iii) SELECT EMPID FROM EMPLOYEES ORDER BY JOIN_DATE;
(iv) SELECT CITY FROM EMPLOYEES WHERE NAME LIKE „_e%‟;


Please click on below link to download CBSE Class 11 Informatics Practices Question Paper Set M 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

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...

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 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...

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...

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...

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...

×
Studies Today