CLASS-XI
INFORMATICS PRACTICES
Time: 1:30 Hrs MM: 40
Note: - All questions are compulsory. Marks are indicated with questions.
1) What is the difference between a list box control and a combo box control? Define with the help of example. (3)
2) Write a program to insert and delete elements from a list box control. (2)
3) What is the difference between call by value and call by reference? Give example of each. (2)
4) Define the following. (2)
i)Formal argument ii) Actual argument iii) Class method iv) Instance method
5) What is the significance of constructor in a class? Describe various types of constructors with example. (2)
6) Write a program to calculate the sum of the following series. (2)
1+x/1!+x2/2!+x3/3!+x4/4!+…………….+xn/n!
7) Design and implement a class & constructor add with one public method, sum. This method takes two arguments & returns one in type value. (2)
8) What are the characteristics of a good program? (2)
9) Write a short note on different types of errors. (2)
10) What is Exception handling in Java? Give an example. (2)
11) What are the advantages of using DBMS? (2)
12) Describe the following. (3)
i)Tuple ii) Attribute iii) Views iv) Primary key v) Candidate key vi) Foreign key
13) What are the various key features of MySQL? (2)
14) How are SQL commands classified? (2)
15) Differentiate between CHAR & VARCHAR data types. (2)
16) What will be the output of following code? (5)
i) mysql>SELECT CONCAT(CONCAT(‘Inform’,’atics’),’Practices’);
ii) mysql>SELECT LCASE(‘NiMaWaT pUbLiC sChOOl’);
iii) mysql>SELECT UCASE(‘IP Is Easy’);
iv) mysql>SELECT CONCAT(LOWER(‘Class’),UPPER(‘xii’));
v) Write a command to display the system date.
vi) Write a command to display name of current month.
vii) Write a command to display current time.
Table:STUDENT
| STUD_ID | NAME | AGE | CLASS | SUBJECT | GENDER |
| 1 | AMIT | 16 | 12 | PHYSICS | M |
| 2 | NITIN | 14 | 9 | MATHS | M |
| 3 | ANITA | 15 | 11 | HINDI | F |
| 4 | ABDUL | 16 | 12 | ENGLISH | M |
| 5 | GARIMA | 16 | 12 | CHEMISTRY | F |
| 6 | DINESH | 14 | 10 | ENGLISH | M |
| 7 | NEELAM | 16 | 12 | BIOLOGY | F |
| 8 | RAJ | 15 | 11 | HINDI | M |
| 9 | | 16 | 12 | IP | M |
| 10 | MANEESH | 16 | 12 | ENGLISH | M |
viii) SELECT LCASE(NAME) FROM STUDENT;
ix) SELECT MOD(Age,5) FROM STUDENT WHERE Gender=’M’;
x) SELECT POWER(3,2) FROM STUDENT WHERE Subject=’ENGLISH’;
17) Write SQL commands for the following on the basis of given relation Teacher. (3)
Table: Teacher
| No. | Name | Age | Department | Dateofjoin | Salary | Gender |
| 1 | Jugal | 34 | Computer | 10/01/97 | 12000 | M |
| 2 | Sharmila | 31 | History | 24/03/98 | 20000 | F |
| 3 | Sandeep | 32 | Maths | 12/12/96 | 30000 | M |
| 4 | Sangeeta | 35 | History | 01/07/99 | 40000 | F |
| 5 | Rakesh | 42 | Maths | 05/09/97 | 25000 | M |
| 6 | Shyam | 50 | History | 27/06/98 | 30000 | M |
| 7 | Shiv | 44 | Computer | 25/02/97 | 21000 | M |
| 8 | Shalakha | 33 | Maths | 31/07/97 | 20000 | F |
i) To show all information about the teacher of history department.
ii) To list the names of female teachers who are in Computer department.
iii) To list names of all teacher with their date of joining in ascending order.
iv) To list departments present in the relation.
v) To show the names of teachers whose name contains ‘S’ as the first alphabet.
vi) To show all information whose salary is above 15000.
Posts
