class 12 : 2017

Sample Paper Class – XII
Subject –Informatics Practices (065)

Theory

Time: 3 hours Maximum Marks: 70

General Instructions:

1. Question paper contains total 7 questions.

2. Marks are show against each question.

1. (a) Name the protocol used for sending and receiving e-mails. 1

(b) Define the following 1

i. Baud ii. Bps

i. NFS ii. MODEM

(d) Differentiate between MAC address and IP address. 2

(e) Which of the following are open source LINUX , MS Window Vista , Python , MySQL , PageMaker. 1

(f) Write down two merits and two demerits of the following topologies 2

i. STAR ii. Tree

(g) List down merits of open standards. 1

2. (a) ABC public school has developed a JAVA application through which the parents are able to see their

deposited fee details for their ward. What should school do so that parents / students are able to

view the details shown in text field and can’t modify them. 1

(b) What is the used of return statement in method. 1

(d) Is justified alignment to a paragraph will be assigned in HTML. Justify your answer. 1

(e) Write code in Java to find out enter number is palindrome or not. 2

(f) Write a small code for Exit Control Loop. 2

(g) Write down some features of XML. 2

3. (a) MySQL runs on which operating systems. 1

(b) Sachin is assigned a assignment to create a table in which field named DOB may or may not contain

value. Tell what is the significance of the keyword.1

(d) What will be the output of following code? 1

i. SELECT UASE (“ Redundancy”);

(e) What is SQL? Write down its different categories also? 2

(f) The Pincode column of table ‘Post’ is given below- 2

Pincode

110001

120012

300048

281001

i. SELECT Pincode from Post where Pincode LIKE = “ %1” ;

ii. SELECT Pincode from Post where Pincode LIKE = “ 0 %” ;

(g) A table “Animals“ in a database has 3 columns and 10 records. What is the degree and cardinality of this table? 2

4. (a) What will be the contents of jTextField after executing the following statement? 1

jTextField.setText ( ‘B’ + ‘a’ )

(b) Predict the output for tan & tan1 if sac equals 7? 2

int tan = 0, tan1 = 4 ;

if ( sac == 2 )

{ tan = 4 ; tan1 = 0; }

else if (sac == 8)

{ tan = 0 ; tan1 = 4; }

JOptionPane.showMessageDialog ( null , “ tan = “ + tan +” , tan1 = “ + tan1 ) ;

(d) In JDBC coding, what methods would be opted to move to last record of the recordset recSet? 1

(e) Identify the errors and tell the output ( jTF 1 = 20 , jTF2 = 10 ) 2

(i) int m = integer.getInt(jTFl.getText() + jTFl.getText());

(ii) JOptionPane.showMessageDialog(null , “ ” + ( m +1 ) ) ;

(f) Give the output for the following code fragment: 2

v = 20 ;

{

JOptionPane.showMessageDialog( null , v + “ ” ) ;

} while ( v < 50 ) ;

JOptionPane.showMessageDialog( null , “ Bye “ ) ;

(g) Virus software Hut has developed the following Interface as shown below.

If Bill amount is > 10,000 than discount is as follow

Payment Mode	Discount
Cost	15 %
Credit Card	N/L
Cheque	10 %

i. Write the code to make the TextFields for Discount & Net Amount in editable. 1

ii. Write code to “Calculate Discount“ button as per given criteria and discount and net amount should be displayed in TextField. 3

iii. Write code for “Stop“ button to close the interface. 1

5. (a) What do you understand by primary key and candidate key. 2

(b) Write the output of following SQL queries. 2

i. SELECT ROUND(6.88,2) ;

ii. SELECT MID(‘Discovery Channel’,4,6) ;

iii. SELECT DAYOFMONTH (‘2011–03–30‘);

iv. SELECT TRUNCATE (7.727,1);

RollNo	Name	Class	DOB	Sex	City	Marks
1	Nanda	X	6/6/95	M	Agra	551
2	Saurabh	XII	7/5/93	M	Mumbai	462
3	Sanal	XI	6/5/94	F	Delhi	400
4	Trisla	XII	8/8/95	F	Mumbai	450
5	Store	XII	8/10/95	M	Delhi	369
6	Marisla	XI	12/12/94	F	Dubai	250
7	Neha	X	8/12/95	F	Moscow	377
8	Nishant	X	12/6/95	M	Moscow	489

(i) To Display all information about class XII students. 1

(ii) List the name of made student of class X. 1

(iii) List names all class of all students in descending order of DOB. 1

(iv) To count the number of student in XII Class of Mumbai city. 1

(v) SELECT DISTINCT(Sex) FROM Student. ½

(vi) SELECT AVERAGE(Marks) FROM Student GROUP BY Sex. ½

(vii) SELECT COUNT(*)FROM Student where Class = ‘XI’ ½

(viii) SELECT MAX(Marks) FROM Student. ½

6. (a) Write an SQL query to create the table books with following structure. 2

Field	Type	Constraints
BookID	Varchar (5)	Primary Key
BookName	Varchar (20)
Author	Varchar (20)
Price	Decimal (5, 2)

(b) Following two tables are shown below are preset in database-

BOOK

EID	EbookName	Author
3	Internal terms	Okhla
4	RDBMS	Steve
5	NetBeans	Gosling

COST

Subj ID	EID	Cost
E40	1	2000
E41	4	1700
E42	3	1800
E43	5	1250

i. Identify the foreign key column in the table COST. 2

ii. Check every value in EID column of both in table. Do you find any discrepancy. 2

Product

PID	ProdName	Manufactures	Price
T P01	Pen	Cello	5
T P02	Gel pen	Luxar	10
T P03	Ink pen	Luxar	10
T P04	Pencil	Natraj	2
T P05	Sketch	Camel	2

Client

CID	CliName	City	PID
01	Rakesh	Delhi	TP01
02	Prakash	Mumbai	TP05
03	Suresh	Delhi	TP03
04	Dinesh	Delhi	TP02
05	Pravesh	Banglore	TP04

i. To Display the details of products whose Price is in the range of 6 to 10 2 ( Both value included )

ii. To display client name, city from table chart and ProdName and price from table product. 2

iii. To increase the price of all products by 10. ( Product the output only) 2

7. (a) What is front-end? 1

(b) Give one societal impact of e-business. 1

Choose appropriate controls from TextField, Label , RadioButton , CheckBox , List , ComboBox ,

Button and write in the third column.

S.No.	Controls use to	Control
1	Select room type
2	Enter customers name
3	Enter arrival date
4	To book rook

class 12

Monday, 13 February 2017

class 12 informatics practices