XI IP Sample Paper III Periodical

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!+x²/2!+x³/3!+x⁴/4!+…………….+xⁿ/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	RAVI	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 Om	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.