ࡱ > W Y T U V @ 5 bjbjVV 8P r< r< <, 2 2 2 F .d .d .d 8 fd d F & h h F i i i kj kj kj 3 5 5 5 5 5 5 $ ژ R , v Y 2 l gj kj l l Y i i G n v v v l 8 i 2 i 3 v l 3 v v ? h 2 { i h 0 .d r _ 0 ,t D { F F 2 { kj k r v }k \ k kj kj kj Y Y F F ]
b $ pv ^ F F
b Sample Paper 2012Class XIISubject INFORMATICS PRACTICES
Time : 3 hours SET-I Max Marks:70
Q1(a)Which of the following provides the maximum bandwidth:
(i)Optical fibre (ii) Thin Ethernet (iii) Arcnet1(b)A school would like to go in for network of all the computers .Which topology would you suggest and why?1(c)Name these:
(i)It is a software package that allows people to send electronic mail along a network of computers and workstation ?
(ii)It is a network topology in which there are bi-directional links between each possible
node ? 1(d)Write two advantages and two disadvantages of following network topologies:
(i)Star (ii) Tree2(e)Compare and Contrast Free software and Open Source software.2(f) What are the different ways that help you to type Indian script on computer ?1(g)Name an open standard formats for
(i)Creation of vertical images which are re-scaleable.
(ii)Text without any formatting.1(h)What for are these software used ?
(i)linux (ii) PHP 1
Q2
a)
What criteria would you suggest to choose the right loop for a specific job?1(b) Find out the value of variable a.
(ii)
x=0; y=14; if(6 > 7 || 8 > 7){
if( y > 8) { a=10;
a = 2; } else {
} else { a=20;
a = 6; }
}1(c)What would be the possible problem with the following code that prevents following code from adding elements to a list list1 ?
ListModel L1 = list1.getModel();
L1.addElement(new element) 1(d)Differentiate between Call by Value and Call by Reference.1(e) Can a public member of private class get accessed by
(i)Same class (ii) Other classes in same package
(iii) class in any other package(f)If a base class as well as derived class contain a member function with a same name ,say add(),can an object of derived class access both these function? 1(g)How would you count the number of rows and number columns in a table(JTable object) namely tbl1?1(h) Write a statement to open a connection object namely Con for a MySQL database namely School.1(i)Name the following:
(i)It is technology that creates and handles dynamic documents.
(ii)In a URL it is the computer on which the information is located.1(j)Differentiate between
and
tag.1Q3(a)A database db1contains three tables namely tb1,tb2,tb3.To delete all the tables and database following set of commands is given ,but it is not working. Why?
Drop database db1;
Drop table tb1;
Drop table tb2;
Drop table tb3;1(b)Write a SQL statement to display
Today, the date is 1(c)Consider the table employee(empid,sal,job) job is a not null column
The following statement is correct or not? Why?
Delete empid,sal,job
From employee
Where sal >=10000;1(d)Name a SQL command which point to a transaction uptil which all changes have been saved permanently.1(e)A numeric data field CNT contains 35675.8765.Write a SQL command to round off CNT to
(i)Whole number (ii) Upto 3 decimal places1(f)Name the SQL commands for the following situations:
(i)To add tuples in a relation.
(ii)To view the structure of the table.1(g)Name the keyword used to:
(i)To combine all those records that have identical values in a particular field or group of fields.
(ii)To enforce referential integrity .1(h)List any three clauses ,which can be used with select statements.1(i)A table student in a database has 10 columns and 21 rows. There are 5 new admissions and e_mailid of those students also inserted in the above table. Initially e_mailid column was not there in the table. Now what is the degree and cardinality of the relation.1(j)Consider the table student given below. Find out the output of the following queries:
Student
Select count(*) from student;
Select count(Fees) from student;
Rno
Fees
1
4000
2
4300
3
5000
4
Null
5
4000
6
Null
1Q4(a)Consider the following XML document. Check this for well formedness.
XII A
XII B
XII C1(b)What will be the contents of TextField1after executing the following code:
String str = Informatics Practices;
str = str.replace(a,o);
str = str.replace(e,u);
str = str.replace(i,y);
jTextField1.setText(str);1(c)The following code has some error(s).Rewrite the correct code underlining all the corrections made.
Class book {
String title;subject;
Int edition
Float price;
public void book {
this.title = ;
this.subject = ;
this.edition = 0 ;
this.title = ;
}
}
1(d)Rewrite the following program code using a do loop.
Int x,c;
for(x=10,c=20; c >=10;c=c-2)
x++;1(e)Find out the output.
String s= School;
char ch=o;
int count =0;
for(int i=0;i<=s.length();i++) {
if (s.charAt(i) == ch)
count++;
}
System.out.println(+count);1(f)Convert the following Switch into equivalent if else.
switch(ch) {
case A : System.out.println(Grade A);
case B : System.out.println(Grade B);
break;
case C : System.out.println(Grade C);
default : System.out.println(Grade F);
} 1(g)Prerna is programmer at HDFC bank. To calculate the amount and interest she has developed the following GUI in NetBeans.
(i) Make sure that Principal amount entered is positive numbers only. 1(ii)Write the code for cmdCalculate to calculate compound interest and amount and display the values in textboxes txtInterest and txtAmount .
Compund Interest = P*(1+r/100)^T
Amount = Principal + Interest
Rate is calculated based on the time according to the following table.
Account
Time(in yrs)
Rate
Fixed Deposit
Recurring Deposit
<=1
>1 and <=5
<=2
>2 and <=7
10%
12%
10%
12%
An additional rate of 2% is given to senior citizens.2(iii) Write the code to clear all the textboxes and checkboxes except Date text field. Set the default choice in the option button as fixed deposit. 1(iv)Display the current date in the textfield Date. 1(h)Write a java method that receives a 3 digits integer and returns its middle digit.2(i)What do you understand by elements and attributes of XML-document. 1(j)Write HTML code to produce these controls.
(i) A text box (ii)A label1
Q5(a)Differentiate between SQL commands DROP TABLE and DELETE.1(b)How will you drop a constraint from a table.1(c)Write the command to Display the first three and last four characters of Information?1(d)Find out the output.2(i)SELECT 1000+SQRT(25);
(ii)SELECT FLOOR(144.34)+1000+CELL932.23);
(iii)SELECT SUBSTR(TRIM( I LOVE PROGRAMMING )5,7);
(iv)SELECT MOD(ROUND(125.60,1),5); (e)Write SQL commands for statements (i) to (vi) and give output for SQL queries (vii) to (x) on the basis of the table FAMILY:
No
Name
Female Members
Male Members
Income
Occupation
1
Mishra
3
2
67000
Service
2
Gupta
4
5
150000
Business
3
Khan
6
4
48000
Mixed
4
Chaddha
2
2
125000
Bisiness
5
Yadav
7
4
120000
Mixed
6
Joshi
1
4
114000
Service
7
Maurya
6
3
45000
Farming
8
Rao
5
2
110000
Service
5(i)To select all the information of family whose occupation is service.
(ii)To list the names of the families where female members are more than 3.
(iii)To list names of family with income in descending order whose occupation is either service or business and number of male members should be more than 3 .
(iv)To count the number families whose income is less than 10,000. (v)To display familys name ,male member and occupation of business family whose income is more than average income of all the families.(vi)To insert a new record in the Family table with the following data:
9,Dsouza,2,1,15000,Service.
(vii)SELECT MIN(DISTINCT Income) FROM Family;
(viii)SELECT MIN(Female Members) FROM Family
WHERE Occupation = Mixed;
(ix)SELECT Occupation ,SUM( Income) FROM Family
group by Occupation ;
(x) SELECT AVG( Income) FROM Family;Q6(a)Write SQL commands to create the table HOSPITAL with following specification:
Field Name
Data Type
Constraints
DId
Int(4)
Part of primary key
PNo
Int(4)
Part of primary key
Age
Int(2)
<=16
Department
Varchar(20)
Not Null
DateOfAdm
Date
Charges
Double(7,2)
Address
Varchar(15)
Default Hyderabad
2(b)In a database there are two tables Books and Issued as shown below.
Books Issued2Book_id
Book_name
Quantity
Book_Id
Quantity-issued
C001
Fast Cook
5
T001
4
F001
The Tears
20
C001
5
T001
C++
10
F001
2
T002
VB
15
F002
NeatBeans
50
(i)Identify the foreign key column in the table Issued.(ii)How many rows and columns will be there in the Natural Join of these two tables?(c)Evaluate this CREATE TABLE statement.Which line will cause an error?Why?1Create table part( Part_id number, Part_name varchar(250),
Cost number(7,2),
Constraint pk1 primary key (Part_id),
Constraint cost_nn not null(cost));(d)Given following CREATE TABLE statement ,identify constraints and their complete details:
CREATE TABLE Orders (
O_Id int not null,
Orderno int not null,
P_Id int,
primary key(O_Id),
constraint fk_PerOrders foreign key (P_Id)
references Persons(P_Id));1(c)Consider the following tables Stationery and Consumer.
Stationery
S_ID
StationeryName
Company
Price
DP01
Dot Pen
ABC
10
PL02
Pencil
XYZ
6
ER05
Eraser
XYZ
7
PL01
Pencil
CAM
5
GP02
Gel Pen
ABC
15
Consumer
C_ID
ConsumerName
Address
S_ID
01
Good Learner
Delhi
PL01
06
Write Well
Mumbai
GP02
12
Topper
Delhi
DP01
15
Write & Draw
Delhi
PL02
16
Motivation
Banglore
PL01
4(I)Write a query to display ConsumerName, Address, Company,Price for those whose price is not more than 10.(ii)Display the company whose consumers are located in Delhi.(iii)Select company,ConsumerName,address
From Stationery RIGHT JOIN Consumer
ON Stationery.S-ID= Consumer.S-ID; (iv)Select company,count(*)
From Stationery, Consumer
Where Stationery.S-ID= Consumer.S-ID
Group by company;Q7(a)How has e-governance have benefitted the common man?1(b)Define front-end and back-end of an information system1(c)Draw an entity-relationship diagram to illustrate the case given below. Also write what kind of relationship is this.
In a company, a vendor can supply various items. 1(d)Which controls would you suggest for the following types of inputs.
(i)Typed text which should remain hidden.
(ii)Multiple choices from a set.
(iii)A mouse click.
(iv)Typed text (multiple line).2Paper Submitted By:
Name Sharmishtha Dhole
Email sharmishtha.dhole@gmail.com
Phone No. 9441528790--------
HYPERLINK "http://www.cbseguess.com/" http://www.cbseguess.com/
PAGE
HYPERLINK "www.cbseguess.com" www.cbseguess.comOther Educational Portals HYPERLINK "www.icseguess.com%20|%20www.ignouguess.com%20|%20www.dulife.com%20|%20www.magicsense.com%20|%20www.niosguess.com%20|%20www.iitguess.com" www.icseguess.com | www.ignouguess.com | www.dulife.com | www.magicsense.com | www.niosguess.com | www.iitguess.com
* ? @ A H I | ~ ѿ{sh]R]G]<] hPR hO OJ QJ hPR h OJ QJ hPR h_' OJ QJ hPR hd OJ QJ hPR h&