CBSE Class 12 Informatics Practices Sample Paper 2017 Set D

1.(a)Vidya College has three departments that are to be connected into a network. Which of the following communication medium (out of the given options), should be used by the college for connecting their departments for very effective High Speed communication?

• Coaxial Cable

• Optical Fiber

• Ethernet Cable

Also name the type of network (out of PAN/LAN/WAN) formed.

(b) State reason why Star topology requires more cable length than Bus topology.

(c) Seema needs a network device that should regenerate the signal over the same network before the signal becomes too weak or corrupted.

Amit needs a network device to connect two different networks together that work upon different networking models so that the two networks can communicate properly.

Name the devices that should be used by Seema and Amit.

(d) How is a domain name related to an IP address? 

(e) How is firewall useful in ensuring network security? 

2. (a) Identify the odd one out of the following Java statements. State reason for your choice.

(i) for

(ii) do while

(iii) switch

(iv) while

(b) Write the purpose of parseint() method. 

(c) Identify invalid variable names out of the following. State reason if invalid.

(i) for

(ii) - salary (iii) salary12 (iv) product

(d) What is the difference between statements (i) and (ii)? 

(i) t = 2;

(ii) if (t = =2 )

d = 3; 

(e) Write HTML tags to do the following : 

(i) Inserting a horizontal line in a web page.

(ii) Inserting a line break

(f) What does 'XML' stand for ? How is the purpose of HTML different from XML?

(g) Rewrite the following code using if else if statement : 

switch(depcode)

{

case 1.

allowance = 4000;

break;

case 2

allowance = 3200;

break;

default

allowance = 1000;

}

3. (a) What is the meaning of 'Open Source' in the term 'Open Source Database  Management System' ?

(b) In a table 'Employee', a column 'Occupation' contains many duplicate 1 values. Which keyword would you use if you wish to list only different values?

(c) How is ALTER TABLE statement different from UPDATE statement? 

(d) Charvi wants to delete the records where the "FirstName" is "Rama" in the 'Emp' Table. She has entered the following SQL statement. An error is being displayed. Rewrite the correct statement.

DELETE 'Rama' FirstName FROM Emp; 

Please click the link below to download CBSE Class 12 Informatics Practices Sample Paper 2017 Set D