Section-A

1.(a) Expand the following term:-

(I)ODF

(ii)FLOSS

(b) B R international school is planning to connect all computers,each spread over

45 meters.Suggest an economical cable type having high-

data transfer, which can be used to connect these computers

 (c) Write examples of one Proprietry and one Open Source Software.?

d) Mr.Ram want to prevent unathurized access to/from his company's local area

network. Write the name of a system(software/hardware),which he should instal

to do it.

(e) Ms. Kavya ,GM of MNC recently discovered that the communication between

her company accounts office and HR office is extremely slow and signal drop

quite frequently. These offices are 120 meters away from each other and

connected by an ehternet cable.

(i)Which device will you suggest for connecting all the computers with in each

their office units?

(ii) What type of network is formed by having this kind of connectivity out of

LAN,MAN,WAN?

(f) Raysha is confused between the MAC address and IP address. Help her by

differentiating between MAC and IP address.

(g) Write differences between Shareware and Open source software?

2 (a) Ms Ram has developed a Java application through which the students of her

school can view their marks by entering their admission number.The marks

are displayed in various text fields. What should she do so that the students ar

able to view but not change their marks in text fields?Write appropriate

command also.

(b)Write difference between arithmetic operator and relational operator with the help of appropriate examples

(c)will the output from the following two code be any different ?

  First code :

Int x=35, y =55;

While (x<=y) {

jTextField1.setText(“”+x);

x=x+8;

}

Second code :

Int x=35 ,y =55;

do {

jTextField1.setText(“”+x);

x=x+8;

}while (x<=y);

Give reasons for your answer

                                                           OR

Predict the output of the following  code

Int n=4,m=1,I;

for (i=1;i<=n,i++)

{

M=m*I;

}

 jTextField1.setText(“ ”+m);

jTextField2.setText(“ ”+i);

(d)  what will be the content of jtextfield1, jtextfield2, jtextfield3 and jtextfield4 for after execution of the following code:

      Stringx=”Informatics practices”;

    jTextField1.setText(math.round(2,3)+””);

    jTextField2.setText(Math.pow(2,3)+””);

    jTextField3.setText(x.subString(4)

    jTextField4.setText(x.subString(2,14)+””);

3.(a) Difference between DDL and DML commands ?

  (b) Write SQL command for the following on the basis of given table STUDENT

                                                           STUDENT

STUD_ID	NAME	STREAM	MARKS	GRADE	CLASS
S01	RUHI	MEDICAL	78	B	12B
S02	AMOL	COMMERCE	88	A	12D
S03	NITIKA	COMMERCE	76	B	12C
S04	VASU	HUMANITIES	89	A	12E
S05	RASHI	SCIENCE	87	A	12A

Help in writing SQL query for the following purpose

(I) display all the students who are from commerce stream

(II) to display name and class of those students who got marks more than 85

(III) to display info of students whose name start with R

 to add a column remark with suitable data type

 (IV)list all the student sorted by marks in descending order

 (C)observe the table name student given above carefully and predict the output of the following querY

 (i)select name from Student where class =’12 A’

 (ii)select marks from Student

 (iii)select sum (marks) from student who stream =’commerce’

 (iv)select Max (marks) from student

(d) what is the degree  and cardinality of the above given table named student

4. (a) Radhika has place to reduce button on a payment form design in NetBeans to accept     mode of payment on out of and cash but during runtime a customer is able to select both           options for a single transaction what went wrong

                                                              OR

mention any one advantage of jcombobox control over a jlistbox control

 (b)Pratham is working with the following swing controls

 J checkbox ,jbutton,jRadioButton,jLabel.

 Suggest him any two basic methods commonly available with all the four control mentioned above

                                                     OR

 write the function of getting item from jail listbox which property we use to add in JS listbox

 (C)what will be an output of the following code if value of variable choice is 1

 case 1  : jTextField1.setText(“Monday”);

 case 2  : jTextField1.setText(“tuesday”);

 case 3  : jTextField1.setText(“wednesday”);break;

 case 4  : jTextField1.setText(“thursday”);break;

default  :jTextField1.setText(“FRIDAY”);BREAK;

                                                                 OR

RE WRITE the above given code throygh if else statement .

(d) (i) aysha a beginner in java programming has vwritten following code with some mistakes (4 mistakes)

int k=0;

i=6;

for (int i=0;k<l,i++)

{

jTextArea1.append(i+/n);

k++;

};

Help her in identifying and correcting the errors.

(ii) convert the following code into do while looping statement

Observe the given code:

Int x=10;

While (x>5)

{

X=x-2;

}

                                                                      OR

Attempt the following questions based on the above given code

Q  how many times the above given loop will run and what will be the value of x immediately after the existing of from the loop

 out of entry control or exit control loop above given will come under which category and why?

(e) study the following code and answer the questions that FOLLOW

 study the following code and answer the questions that follow:

String str=”Assisi convent School”; int r;

Int len=str.length();

jTextField2.setText(str.toUpperCase());

r=100-len;

jTextField3.setText(Integer.toString(r)+”characters can be entered” );

predict the output displayed in text field named jTextFiled2 and jTextFiled3 after running the above code

(f) what do you understand by class and object in oop? Explain with example .

(g)mrs babita ji a programmers in mnc has designed application for a hotel as shown below

HELP HER IN WRITING THE CODE TO DO THE FOLLOWING:

(I)Write the code to disable the text boxes rate and net amount when form activated

 (II)write the code for clear and exit button

 (III) after clicking on the calculate button rate should be calculated depending on the type of room selected by a customer and displayed in the respective text field as per the given formula

ROOM TYPE      RATE PER DAY

SINGLE                1500

DOUBLE              2800

DELUX                5000

 ( RATE=NO OF DAYS * RATE PER DAY)

(IV) if a customer is having membership card than 10% discount should be given and after the giving the discount net amount should be  display in net amount text field net amount equal to rate minor discount

5 (a)write one similarity and one difference between primary key and unique constraint

 (B)write difference between SQL and mySQL

 (C )consider the following table book given below:

BID	AUTHOR	PRICE	NAME	MEM_NAME	ISSUE_DATE
B01	APJ ABDUL KALAM	550	WINGS OF FIRE	SARITA	2018-05-20
B02	ROBIN ARORA	340	THE MONK	MAJU	2018-03-15
B03	SHIV KHERA	230	MONKEY	ANU	2018-04-16
B04	SPENCER JHONSON	450	SUMIT PANDIT	GOBAR	2018-03-17
B05	PATRICKMATHER	250	PATRICK	PROBSEET	2018-06-18

 (I)suggest the suitable data type for issue date column

 (II)suggest the suitable SQL command to change the size of column name from 30 character 250 character

(III) mention the significance of read column in table book

(IV)which command will you increase the price of books by 50 rupees 

(D)write difference between delete and drop command

6 (a) Write Sql query to create  a table “LIBRARY” with the following structure.

                                        TABLE LIBRARY

FIELD_NAME	DATA_TYPE	SIZE	CONSTRAINT
BOOK_ID	INTEGER	2	PRIMARY KEY
BOOK_NAME	VARCHAR	20
CATEGORY	VARCHAR	10
ISSUE_DATE	DATE

                                                 OR

HELP  RAMESH in identifying any two column for a table named employee along with their suitable data type.

(b) differenece between candidate keys and alternate keys.

(c)(i)what do you understand by denial of service attack?

 (ii) what do you understand bu inheritance ?

(iii)what is result set?

7 (a) Write difference between ring and star topology ?

(b) which of the following is not the feature of networking

(i) resource sharing

 (ii)uninterrupted power supply

(iii) reduced cost

(iv) Reliability

 (c) Mrs Rama work as an programmer in a form in her current project she is supposed to design a registration page for an online Educational Institute help her into tsing the most  appropriate control for the specified from textfield label radio button checkbox listbox and combobox button and write in the third column:

S NO	CONTROL USED TO INPUT	CONTROL
1	STUDENT NAME
2	STUDENT LOCATION
3	CHOOSE STREAM
4	SUGGESTION