SET - 4

Series: ONS/1

Code No. 90/1

Candidates must write the Code on

the title page of the answer-book.

Roll No.

• Please check that this question paper contains 8 printed pages.

Code number given on the right hand side of the question paper should be written on the title page of the answer-book by the candidate.

Please check that this question paper contains 7 questions.

Please write down the Serial Number of the question before attempting it.

15 minute time has been allotted to read this question paper. The question paper will be distributed at 10.15 a.m. From 10.15 a.m. to 10.30 a.m., the students will read the question paper only and will not write any answer on the answer-book during this period.

INFORMATICS PRACTICES

Time allowed: 3 hours

Maximum marks: 70

Instructions:

(i) All questions are compulsory.

1. Answer the questions after carefully reading the text.

1. (a) Two doctors have connected their mobile phones to transfer a picture file of a person suffering from a skin disease. What type of network is formed? Which communication media out of Coaxial cable, Optical fiber, Bluetooth,

Satellite link should be used to transfer the file? 2

1. State reason why Star topology requires more cable length than Bus topology. 2
2. "Open Source Software developers work for the good of community". Is this statement true? Give reason. 2
3. What happens during 'Domain Name Resolution'? 2
4. How is 'Denial of service' attack, a threat to Network security? 2

1. (a) Identify the odd one out of the following statements. State reason for your choice. 1
2. switch
3. do while
4. while
5. for

90/1 1 [P.T.O.

1 1 1

1. (c)
2. <math>a = 5;</math>
3. <math>if(a = 5)</math> <math>x=3;</math>
4. Write the output in jTextField1 if depcode is 3. switch (depcode) case 1 : allowance=4000; break; case 2: allowance=3200; break; default: allowance=1000; jTextFieldl.setText( " " +allowance);

1. Sandhya is creating a webpage. She is entering HTML code on her computer. In between, she keeps pressing 'Refresh' / 'Reload' button on her browser. What is the purpose?

2

1. What does 'XML' stand for ? How is the purpose of HTML different from XML ? 2
2. Write Java code (statements) to declare Y as integer variable. Then, assign the value 30 to a variable Y. Increase the value of Y by 5 and store the increased value in Z. 2

1

1. (a) What is MySQL?

1

1. Charvi is inserting "Sharma" in the "LastName" column of the "Emp" table but an error is being displayed. Write the correct SQL statement.

INSERT INTO Emp('Sharma')VALUES(LastName) ; 1

1. Kunal created the following table with the name 'Friends':

Table : Friends

<math display="block">Friend Code \\</math> Name Hobbies

F101 Bijoy Swimming

F102 Abhinav Reading books

F103 Dancing Jyotsna

Now, Kunal wants to delete the 'Hobbies' column. Write the MySQL statement. 2 90/1