SUPPOSE PAPER – 2014

CATEGORY - XII

SUBJECT – INFORMATICS TECHNIQUES (065)

Optimum Marks: 70

Duration: a few Hours

Basic Instructions:

My spouse and i. All questions happen to be compulsory.

2. Answer the question after properly reading the text.

1 . (a) Two neighbors schools far away of 140 meters coming from each other, opt to join their very own LANs using UTP cables so that they can talk about their e-learning resources. Nevertheless after signing up for LANs they can be not able to reveal the resources because of loss of signal in between. Which in turn device should they use in order that signal is usually amplified inbetween? 1

(b) Sumit features written two addresses while 198. one hundred sixty five. 1 . 5 and STOMACH. YU. 2F. K7. doze. 65. he could be not able to find out the difference among these addresses. Help him for the same.

one particular

(c) Write example of a single Proprietary and one Open Source Software. 1

(d) Identify the wired and wireless systems from the followings: 1

Wireless bluetooth, Optical Dietary fiber, Co-axial, Infrared

(e)Define any two threats to Network Security?

a couple of

(f)Define this: Bridge and a Router.

2

(g)Give suitable sort of URL and Domain Name

2

2 . (a)Mr. RajKumar does Java program from HURUF Computers. This individual has very clear the concepts of different workers. Now he could be studying regarding conditional statements. He really wants to use the relational and rational operators with conditional transactions but he could be confused which in turn conditional affirmation use among IF and Switch. Help him to get the hie.

1

(b) What are the values we can give with type feature in label? 1

(c)Why is it necessary to place break affirmation after every case in a swap statement? you

(d)Which indicate is used to define the Header line of a stand?

1

(e)What will be the value of total after carrying out the following code: 2

int x, total = zero;

for (x= 1; by i

jTextField1.getText("j is greater”);

j --; ++I;

joptionpan. showMessageDialog(" Hello”);

(g) ABC School uses this interface integrated java to evaluate the membership of a scholar for a particular stream from scientific research, commerce and humanities. The user first goes in the total percentage and chooses the desired stream by selecting the proper option key. An additional 5% is markings is given to students of NCC.

Write Java Code for the following

a) On the Action event from the close button the application gets closed.

one particular

b) For the Action function of the very clear button every one of the text fields and the check boxes get cleared. one particular c) On Action function of the button ‘Calc Percentage' Net percentage of the college student is determined and displayed in the suitable text filed. Net percentage is identical to that of some of the percentage in the event the student doesn't opts pertaining to NCC or else 5% is definitely added to real percentage.

two

d) In Action Function of the key ‘Result', the application form checks the eligibility of the students. And display effect " inside the appropriate textual content field. Bare minimum percentage to get science is 70, intended for commerce 70 and for humanities 40.

two

5. (a) How can you take away the column of your table? Make clear with model. 2

(b) What are TCL commands? Describe the part of Commit and Rollback with example. (c)Consider the table Doctor given below, create command in SQL for (1) to (4) and output intended for (5) to (8). 6

Table: DOCTOR

ID

201

457

365

221

122

110

Name

R. E. Nath

Mahavir Singh

M. Asthana

Sixth is v. S. Nag

S. G. Sinha

T. P. Pandey

Dept

ING

SKIN

REMEDIES

ENT

NEPHRO

CARDIOLOGY

Sexuality

M

Meters

F

M

F

Meters

Experience

doze

9

several

9

ConstFee

300

five-hundred

250

one hundred and fifty

200

500

(1) To show name coming from all doctors who also are in Medicine having more than a decade of knowledge. (2) To show off the different departments.

(3) To display minimum appointment fee of female doctors

(4) To display name and department of male doctors who has zero experience. (5) SELECT AVG(ConstFee) FROM Doctor WHERE NOT REALLY Gender='F'; (6) SELECT Count(Experience) FROM Doctor;

(7) CHOOSE Name, Encounter FROM Doctor WHERE identity BETWEEN 75 AND two hundred; (8) SELECT SUM(ConstFee), MAX( Experience) VIA Doctor;

6. (a) Publish MySql Command to create...