XI IP - FIRST TERM EXAM II Set

MM. 70 Time- 3 Hrs

Note: - All questions are compulsory. Marks are indicated with questions.

1) What is an Operating System? (2)
2) What is the difference between Main memory and Secondary memory? (2)
3) What is the use of password field control? (2)
4) Name two container control and two components? (2)
5) What is the difference between Integer data type and float data type? (2)
6) What is the difference between a variable and a constant? (2)
7) Write equivalent Java expression for the following expressions. (4)
i) (p+q)/(r+s)⁴ ii) |e^x-x| + |b| * a
8) What is the function of assembler, compiler and interpreter? (3)
9) What are various types of operating systems? (3)
10) What do you understand by tokens in Java? Explain at least two tokens? (3)
11) Describe the following operators in Java with example. (6)
i) Arithmetic Operators ii) Assignment Operator
12) Describe the following statements with an example each. (9)
i) Entry control loop ii) Exit control loop
13) Write the purpose of following two properties of a label. (6)
i) title ii) icon
14) What is the difference between option buttons and check boxes? (3)
15) What is the technique used to arrange controls in java? Discuss in detail. (3)
16) What is the importance of button group? How do you create a button group? (3)
17) Write a program to print multiplication of 19 by using for loop. (3)
18) Write a program to print numbers in reverse order.(e.g. 100 to 1) (3)
19) Write a program to print even numbers up to 100. (3)
20) Write a program to print the following pattern. (3)
1
11
111
1111
11111
21) Write code to translate to its equivalent name of the month the year. (e.g. 1 to January, 2 to February,…………, 12 to December). (3)

Chapter-3 Getting Started with Programming using IDE - Imporatant Questions

1.What is Byte code?
2.What do you understand by JVM?
3.What are the characteristics of JAVA?
4.What do you understand by a message and an event?
5.What are containers or container controls?
6.What are the similarities and differences between option buttons and check boxes?

Chapter-2 Software concepts - Important Questions

1.What are various categories of software?
2.What are various types of operating systems?
3.What is the difference between an interpreter and a compiler?
4.What is an IDE?
5.What is a virus? What is anti-virus software?
6.What is system software? What role does it play in the functioning of the computer?
7.How is backup utility useful? Is it necessary to take back up of data?

Chapter-1 Hardware concepts - Important Questions

1.What is a computer? What are its characteristics?
2.What are the functional components of computer?
3.What is the function of memory? What are its measuring units?
4.What are the difference between hardware, software, and firmware?
5.Give examples for each of system software and application software. Explain the function of each type. Explain the function of each type.
6.What are the types of computers?
7.How is a compiler different from interpreter?
8.What are the major strengths and weaknesses of computer?
9.Describe various input and output devices.
10.What is the difference between RAM and ROM?
11.What is a port? Name some port types.
12.What is the function of ALU?
13.What are the advantages and disadvantages of using computers?

Class Test- Chapter 4-8

CLASS TEST
XI - INFORMATICS PRACTICES

Time: 90 min. MM: 40
Note: All questions are compulsory. Marks are indicated before questions.
1. What is a token? (½)
2. What is the use of \n and \t escape sequences? (½)
3. What is the use of button group? ( ½)
4. What are the keywords? Name any 5 keywords. (1)
5. What are the identifiers? Give rules to form an identifier. (1)
6. Name any 2 components and 2 container controls. (1)
7. What is the use of layout manager? Name any 4 layout manager. (1)
8. What is the use of mnemonic property? Write the steps to apply it. (1)
9. What is an event? Name any two events. (1)
10. What is the significance of data types in Java? Name any four data types. (1)
11. Write at least 5 points on switch vs if else. (2)
12. What is the use of common handler? Describe with an example. (2)
13. Describe relational operators with an example each (2)
14. Describe the following with an example each. (3/2)
i. getText() method
ii. parse_____() method
iii. setText() method
15. Calculate the value of a, b, c & d. Given a=-13, b=24, c=39 (1)
d=--a + b++ - ++c + a++ - --b - c--;
16. Evaluate the given expression. (1)
k=Math.pow(2,4)+27+Math.sqrt(361)*2+Math.ceil(12.4)-Math.floor(13.9)
-Math.rint(39.56)-Math.abs(-15)+Math.max(7,3)-Math.min(3,7);
17. Write the corresponding Java expression for the following mathematical expression. (1)

k=√xy+√a2+b2+c3+3-2ye2y-|ex-x|+n*log(-3)+p/q;
18. Write a program to find greatest number among three numbers. (2)
19. Write a program to print table of 19 in Text Area by using for, while & do while loop. (3)
20. Write a program to find out the given character is a vowel or a consonant
by using switch case. (2)
21. Write a program to calculate factorial of a given number.(2)
22. Write a program to print the following pattern. (2)
*****
****
***
**
*
23. Write a program to perform add and delete operation in list box control at a
specific index. (2)
24. Find out the differences between the following with example. (8)
i. break statement and continue statement
ii. declaration and initialization of a variable
iii. textbox control and passwordfield control
iv. checkbox control and radio button control

My SQL Sample Paper

CLASS TEST
XI - INFORMATICS PRACTICES

Time: 1 hour MM: 20
Note: All questions are compulsory. Marks are indicated before questions.
1. Write the output of the following: - 3 Marks
i. SELECT CONCAT('Nimawat',NULL,'School');
ii. SELECT CHAR(65,67.3,69.3);
iii. SELECT DAYOFMONTH(‘2009-02-03);
iv. SELECT MOD(79,2)+ ROUND(-7344.48,1)+ TRUNCATE(15.865,-1)+SQRT(196);
v. SELECT SUBSTR(TRIM(' INDIA IS GREAT '),-5,3);
vi. Write a SQL function to remove leading $ character from a given expression.
P=’$$$$MUKESH$KUMAR'
2. What is Foreign Key? Define with an example. - 1 Mark
3. Write SQL commands to create the table COLLEGE with following specifications. 6 - Marks

Field Name	Data Type	Constraints
Cno	Int(4)	Primary Key
Name	Varchar(20)
Department	varchar(15)
Dateofadm	date
Fees	Double(7,2)
Gender	Char(1)

i. To list the structure of the table COLLEGE?
ii. Write SQL commands to insert 3 records in COLLEGE table.
iii. Add one more column Age of type int(2) default 18 in the COLLEGE table.
iv. Write SQL command to insert default Age.
v. Modify the column Age as int (3).
vi. Insert Age in first record of COLLEGE table.
vii. Change the name of the column Age to Student_Age.
viii. Create a new table StudentDetail with Name, Age & Gender fields from COLLEGE table.
ix. Remove the Primary Key from COLLEGE TABLE.
x. Delete all the tuples of COLLEGE table.
xi. Delete the last attribute of COLLEGE table.
xii. Delete the College table.

4. Write SQL commands to the HOSPITAL table. - 4 Marks

No	Name	Age	Department	Dateofadm	Charges	Gender
1	Arpit	62	Surgery	1998-01-21	300	M
2	Zarina	22	ENT	1997-12-12	250	F
3	Kareem	32	Orthopedic	1998-02-19	200	M
4	Arun	12	Surgery	1998-01-11	300	M
5	Zabed	30	ENT	1998-01-12	250	M
6	Ketaki	16	ENT	1998-02-24	250	F
7	Ankita	29	Cardiology	1998-02-20	800	F
8	Zareen	45	Gynecology	1998-02-22	300	F
9	Kailash	19	cardiology	1998-01-13	800	M
10	Shilpa	23	Nuclear Medicine	1998-02-21	400	F

i. To list the names of female patients who are in ENT department.
ii. To list names of all patients with their date of admission in ascending order.
iii. To count the number of patients with Age<30.>5. Given the following EMPLOYEE relation. Write SQL command. 6 - Marks

ENO	ENAME	JOB	MGR	HIREDATE	SAL	COMM	DEPT
7369	Sunita Sharma	CLERK	7902	1980-12-17	2800	NULL	20
7499	Ashok Singhal	SALESMAN	7698	1981-02-20	3600	300	30
7521	Rohit Rana	SALESMAN	7698	1981-02-22	5250	500	30
7566	Jyoti Lamba	MANAGER	7839	1981-04-02	4975	NULL	20
7654	Martin S.	SALESMAN	7698	1981-09-28	6250	1400	30
7698	Binod Goel	MANAGE	7839	1981-05-01	5850	NULL	30
7782	Cheten Gupta	MANAGER	7839	1981-06-09	2450	NULL	10
7788	Sudhir Rawat	ANALYST	7566	1987-04-19	5000	NULL	20
7839	Kavita Sharma	PRESIDENT	NULL	1981-11-17	5000	NULL	10
7844	Tushar Tiwari	SALESMAN	7698	1981-09-08	4500	0	30
7876	Anand Rathi	CLERK	7788	1987-05-23	6100	NULL	20
7900	Jagdeep Rana	CLERK	7698	1981-12-03	4950	NULL	30
7902	Sumit Vats	ANALYST	7566	1981-12-03	3500	3600	20
7934	Manoj Kaushik	CLERK	7782	1982-01-23	5300	NULL	10

i. To list the employee name and his annual salary (Annual salary=12*sal+100).
ii. To list the unique jobs from the table.
iii. To list the mgr which are in 7902, 7566, 7788.
iv. To list Comm as 1000 which are NULL.
v. To list all the columns in the ascending order of deptno and descending order of salary.
vi. To display the employee name and job of employees hired between Feb 20, 1981 and May 1, 1981.
vii. To list the name and salary of all the employees who earn more than 1200 and are in department 10 or 40.
viii. To list all the employees who do not have manager.
ix. To list name and salary of all employees who earn commissions.
x. To list the names of all employees where the second letter of their name is an 'a'.
Write the output of the following:
xi. SELECT LEFT(ENAME,4), COMM+SAL*20 FROM EMPLOYEE WHERE ENAME='Ashok Singhal';
xii. SELECT ENAME FROM EMPLOYEE WHERE ENAME LIKE 'a%';

XI IP First Term Exam

FIRST TERM EXAM

XI-INFORMATICS PRACTICES

MM. 70 Time- 3 Hrs

Note: - All questions are compulsory. Marks are indicated with questions.

1) What are the functional components of a computer? 2

2) What is the difference between RAM and ROM? 2

3) What is the difference between Label and TextField control? 2

4) What is the difference between component and container? 2

5) What is the difference between an interpreter and a compiler? 2

6) What is the difference between a TextField and a TextArea? 2

7) Write equivalent Java expression for the following expressions. 4

i) ut + ¹/₂(ft)² ii) |a| + b > |b| + a

8) What are the major strengths and weaknesses of computer? 3

9) What is a port? Name some port types 3

10) What do you understand by keyboards in Java? Write any 5 keyboards? 3

11) Describe the following operators in Java with example. 6

i) Increment/Decrement Operators ii) Logical Operators

12) Describe the following statements with an example each. 9

i) Switch Statement

ii) for loop

iii) While loop

13) Write the short notes on the following. 6

i) break statement

ii) continue statement

14) Describe CheckBox control with an example. 3

15) Discuss briefly about different layout manager offered by Swing API. 3

16) What is the use of panel? How can we use panel in our program? 3

17) Write a program to calculate simple interest. 3

18) Write a program to calculate factorial of a given number. 3

19) Write a program to print odd numbers up to 100. 3

20) Write a program to print the following pattern. 3

*

**

***

****

*****

21) Write code to translate to its equivalent name of the day of the week.(e.g. 1 to Sunday, 2 to Monday,……., 7 to Saturday). 3