Page 54 - IP

PREBOARD
EXAMINATION

CLASS - XII
SUBJECT – INFORMATICS PRACTICES
(065) MODEL TEST PAPER -I
Duration : 3 Hours Maximum Marks : 70

General Instructions:
I. All questions are compulsory.
II. Answer the question after carefully reading the text.

1.(a) Two neighbors schools at a distance of 130 meters from each other, decide to join their LANs using UTP
cables so that they can share their e-learning resources. But after joining their LANs they are not able to share
the resources due to loss of signal in between. Which device should they use so that signal is amplified in-
between? 1
(b) Sumit has written two addresses as 198.165.1.5 and AB.YU.2F.K7.12.65.he is not able to find out the
difference between these addresses. Help him for the same.

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

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

1
Bluetooth, Optical Fiber, Co-axial, Infrared
(e)Define any two threats to Network Security?

2 (f)Define the following: Bridge and a Router.

2 (g)Give suitable example of URL and Domain Name

2

2.(a)Mr. RajKumar is doing Java course from ABC Computers. He has clear the concepts of different
operators. Now he is studying about conditional statements .He wants to use the relational and logical
operators with conditional statements but he is confused which conditional statement use between IF and
Switch.Help him for the same. 1
(b) What are the values we can give with type attribute in <UL>tag? 1
(c)Why is it necessary to put break statement after every case in a switch statement? 1
(d)Which tag is used to define the Header row of a table? 1
(e)What will be the value of sum after executing the following code: 2
int x, sum = 0;
for (x= 1; x <=5; x++)
{
sum+ =x;
}
(f) Write a function in Java that accepts two numbers as parameters and returns the greater one. 2
(g)How are tags used in XML different from tags in HTML? Write 2 points. 2

3. (a) If a database “Student” exists, which Mysql command helps you to start working in that database?1
(b)Pooja created a table in Mysql. Later she found that there should have been another column in the table
.Which command should she use to add another column to the table.? 1
(c)Give one difference between ROLLBACK and COMMIT commands used in MySql. 1
(d) Can a table have multiple primary key? Can it have multiple foreign key? 1