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

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 M 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 M 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 M 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 M 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 M 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 M 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 M 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 M Solved in Pdf

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

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

Yes, the CBSE Class 11 Informatics Practices Question Paper Set M 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 M Solved

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

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

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

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

Regular practice of sample question paper given on studiestoday for CBSE Class 11 Informatics Practices Question Paper Set M 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 M 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 M Solved be accessed on mobile devices

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

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

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