CBSE Class 11 Informatics Practices Question Paper Set O Solved

Section - A

Q1. Draw the Block Diagram of functional units of a computer, 

Q2. Write the full form of the following

(a) ALU (b) OCR

Q3. Define a nibble. 

Q4. Explain Biometric sensors. 

Section - B

Q1. How jTextField is different from jTextArea? Write any one method of each object. 

Q2. Write a JAVA program to accept any number from the user and check the number is ODD or EVEN.

Q3. Convert the following if statement to switch

int a=Integer.parseInt(jTextField1.getText() );
if(a = = 1)
System.out.print(“one”);
else if(a= =2)
System.out.print(“two”);
else if(a= =3)
System.out.print(“three”);

Q4. Define “Fall Through”. 

Q5. Define Loop. Write the complete syntax of for loop. 

Q6. How jRadioButton is different from jCheckBox? Explain with an example.

Q7. Write a JAVA program to print all the even numbers from 51 to 100 on the System output Window.

Q8. Write any one method of jListBox and jComboBox.

Q9. What is the use of Button Group? Explain with an example. 

Q10. Write a JAVA program to accept any month number from the user and print the corresponding month name based on the accepted month number.(use switch… case)

Q11.XYZ Pens Company sells each pen at the cost of `25.00. The Programmer has developed a GUI application as shown below :

Instructions:

• The number of pens bought are entered by the user.
• The Amount is Number of Pens * 25.00
• If a person buying pens is a „Special C ustomer‟, a discount of 5% is given on the amount, otherwise no discount is given.
• Amount to be paid = Amount – Discount

Write code in Java to do the following :

(i) When Calculate button is clicked the Amount, Discount and Amount to be Paid are calculated and should be displayed in appropriate text fields.

(ii) When Clear button is clicked, all the Textfields and Checkbox are cleared. 

(iii) When Stop button is clicked, the application is closed.

Section - C

Q1. What is the use of Alter command in MySql? Explain with an example. 

Q2. Explain any two date functions with an example.

Q3. Mr.Rahul wants to display all the table names form the database EMP124,he wrote the following query but he is not able to get the result.
Mysql> display tables;
Write a proper query to display the result.

Q4. Consider the table TEACHER given below. Write the commands in SQL for (i) to (viii) and output for (ix) and (x).

i. To display all information about teachers of PGT category.
ii. To list the names of female teachers of Hindi department.
iii. To list names, departments, and hiring dates of all the teachers in ascending order of hiring date.
iv. To count the number of teachers in English department.
v. To Display the name of teacher whose name starts with „S‟.
vi. To display all the name of teacher whose salary is not yet fixed.
vii. Write a query to display the total salary of Male Teachers.
viii. Write a Query to count how many Male and Female Techers are there in the table.

Find the output of the following quires:ix. SELECT DISTINCT(Category) FROM TEACHER;

x. SELECT YEAR(HIREDATE) FROM TEACHER;

Q5. Explain the following terms with an example.

(a) DDL (b) DML (c) COMMIT (d) ROLLBACK

Q6. How ORDER BY clause is different from GROUP BY clause? Explain with an example.

Q7. Write an SQL query to create the table 'SALESPERSON' with the following structure:

Q8. What is the use of DISTINCT key word in MySql? Explain. 

Q9. Find the output of the following:

(a) Select Dayofmonth(“12/12/2012”);
(b) Select Round(3456.678,2);
(c) Select SQRT(2,3);
(d) Select concat(left(“ABCD”,2,right(“DECD”,2);

Q10 Differentiate CHAR and VARCHAR data types with an example. 

Q11 What is Cardinality and Degree? Explain. 

Q12 Write command to delete a column email column from EMP table. 

Q13 What is wrong in the following Query.(rewrite the correct query) Select ename from emp where deptno=NULL;

Q14 How DROP command is different from DELETE command? Explain with an example.

Section- D

Q1. Write any two benefits of E-governance. 

Q2. Write any two E- learning web site names. 

Q3. How E-business is different from traditional business? Explain.

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