CBSE Class 11 Informatics Practices Question Paper Set M Solved

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.

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

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

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

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