Get documents about "17576Paper preboard XII
Description
IP Sample Papaers for 12std
Document Sample
http://www.cbseguess.com/
Guess Paper – 2011
Class – XII
Subject – Informatics Practices
M.M- 70
Set -I Time- 3 Hrs
1. a) What type of network would you suggest for following type of requirements of an 1
organization
i) Around 200 computers in two different buildings adjacent to one another are to be
connected.
ii) The cost of network should not be very high.
iii) It should be fairly easy to implement.
b) When would you prefer switch over a hub? 2
c) Name two guided transmission media for networking. 1
d) Compare and contrast : 2
i) TTF and OTF
ii) Static and Dynamic fonts
e) Define: IP Address, Node, Bridge, Repeater 4
2. a) Develop an application as per following interface:
a) i) Initially the buttons Replace characters and Append these characters 2
should be disabled. These should become enabled only if the user enters a
string ending with “OK”.
ii) If the input string is not ending with “OK” display an error message and
add “OK” string at the end of it.
b) Upon clicking the Replace characters button, all ‘a’s should be replaced 2
with ‘0’s, all ‘e’s should be replaced with ‘u’s and all ‘i’s should be
replaced with ‘y’s. display the result in output label.
c) Upon clicking Append these characters button, the characters in charTF 1
-------------------------------------------------------------------------------------------------------
www.cbseguess.com
Other Educational Portals
www.icseguess.com | www.ignouguess.com | www.dulife.com | www.magicsense.com
http://www.cbseguess.com/
should get appended to input string and displayed in output label.
b) Sunita is not clear about the difference between the following two statements: 2
i) SELECT (24*8 );
ii) SELECT (24*8 ) from empl;
Help her understand the difference between these two statements.
c) When a PRIMARY KEY constraint is included in a table, what other constraints does this 1
imply?
d) Given the following CREATE TABLE command, identify foreign key constraints and 2
their complete details. (i.e, the parent table, child table, field name, restriction etc.)
CREATE TABLE lego_composer (
Construction int(11) NOT NULL,
Brique int(11) NOT NULL,
Nombre integer NOT NULL Default 1,
CONSTRAINT Construction_composer FOREIGN KEY (construction)
REFERENCES LEGO_CONSTRUCTION(id) ON DELETE RESTRICT
ON UPDATE CASCADE,
CONSTRAINT brique_composer FOREIGN KEY (brique)
REFERENCES LEGO_BRIQUE(id) ON DELETE RESTRICT ON
UPDATE CASCADE,
PRIMARY KEY (Construction, Brique) );
3. a) In JDBC coding, what method would you use to move to last record of the recordset 1
recSet?
b) Identify the errors in the following code and tell the output after correcting the code. 3
12
25
1. int v= Integer.getInt ( text1.getText() + text2.getText());
2. JOptionPane.showMessageDialog( null, (v +1));
c) Write code to remove first and last row of a table namely atbl. 1
d) Define a method. What is method prototype? 1
e) Find out the output of the following java codes: 4
i) int j=1, s=0;
while (j<10) {
System.out.print (j +”+”);
s= s+j;
-------------------------------------------------------------------------------------------------------
www.cbseguess.com
Other Educational Portals
www.icseguess.com | www.ignouguess.com | www.dulife.com | www.magicsense.com
http://www.cbseguess.com/
j= j+ j % 3; }
System.out.println (”=”+s);
ii) float x=9;
float y=5;
int z=(int) (x /y);
switch(z) {
case 1 : x= x+2 ;
case 2 : x= x+3;
default: x= + 1;
}
System.out.println(“Value of x:” +x);
f) Which package is by default imported in every java program? 1
g) Passing the address means call by value or call by reference. 1
4. a) Define abstract classes and methods in java. 2
b) Explain the difference between a constructor and a method by emphasizing on their calling 2
methods.
c) What is an element and an attribute in XML? 2
d) Which two tags let you create the : 2
i) unnumbered lists
ii) numbered lists
e) Name ACID properties of a transaction. 2
5. a) Which command has to be given to start using the database created by you ? 1
b) Create a table MEMBER with the following details . 6
Field name Field type size
Mem_code Character 3
Mem_name Character 30
Mem_phone Character 10
Mem_add Character 50
i) Add the constraint - mem_code as primary key in the existing table MEMBER.
ii) Add a new record in the table.
iii) Show the structure of the table.
iv) Drop the Primary key constraint.
v) Delete the column mem_add.
vi) Drop the table.
c) What will be the output of the following : 5
1. Select ROUND(124.44) + POW(4,2)
2. Select TRUNCATE(30.500,5) + ROUND(100.50,1)
-------------------------------------------------------------------------------------------------------
www.cbseguess.com
Other Educational Portals
www.icseguess.com | www.ignouguess.com | www.dulife.com | www.magicsense.com
http://www.cbseguess.com/
3. Select YEAR(‘2009-08-15 01:02:03’) + 20
4. Select LENGTH(‘RAMESH SHARMA’)
5. Select LCASE(RIGHT(‘AMITY INTERNATIONAL SCHOOL’,6))
6. a) Consider the table BUS given below: 7
TABLE: BUS
Busno Origin Dest Rate KM Time Type
21 Del Jul 45.5 210 9.50 AC
198 Del Amrit NULL 250 10.00 NULL
101 Chandi Del 12.5 250 22.00 NON
49 Mum Pune 35.0 205 11.00 NON
12 Del Agra 50.0 330 6.00 AC
25 Del Hrdw 20.5 250 5.00 NON
24 Del Agra 25.0 330 8.30 NON
b) Insert a new row in the table BUS with data:
22, Agra, Delhi, 50, 330, 14.00, AC
c) Modify a row Busno 198 by changing the Rate to 30 and type to ‘NON’
d) Add a new column Tax_charge number(6) with constraint NOT NULL to the table.
e) Display the starting and the destination stations together in one column.
f) Display the number of buses which start from Delhi before 10 am.
g) Give the output of the following MySQL queries:
1) Select Busno, Type from BUS where dest in(‘Del’, ‘Agra’);
2) Select Busno,origin, Dest from Bus Table where Dest like ‘A%’.
b) Define with examples: Cross join, Equi join, Natural join 3
7. a) What is the impact of e-commerce on Society ? 2
b) Name and explain the purpose of any two e-governance projects in India . 2
c) What is the purpose of comments and indentation in a program? 1
d) What does x mean in javax.swing? 1
Total Pages: 4
Amity International School
Power Grid Complex, Sec-43, Gurgaon
Paper Sumitted By:
Name Mamta Manaktala
Email mamta.manaktala@gmail.com
-------------------------------------------------------------------------------------------------------
www.cbseguess.com
Other Educational Portals
www.icseguess.com | www.ignouguess.com | www.dulife.com | www.magicsense.com
Related docs
Other docs by dholariyagunjanitechpro
1315315385_MicrosoftWord-CBSE_IX_SummativeAssessmentI_SamplePaper7_Question0
Views: 5 | Downloads: 0
1315314032_MicrosoftWord-CBSE_IX_SummativeAssessmentI_SamplePaper3_Solution_30
Views: 6 | Downloads: 1
