CBSE Class 12 Informatics Practices Sample Paper 2014 Set G

1 (a) Two doctors in the same room have connected their palm tops using Bluetooth for working on a group presentation. Out of the following, what kind of networks they have formed? LAN,MAN,PAN,WAN. 

(b)Arrange the following communication channels in ascending order of their data transmission rates. ETHERNET CABLE,OPTICAL FIBER,TELEPHONE CABLE,COAXIAL CABLE. 

(c)Which transmission medium should be used to transfer data across two continents at very high speed? 

(d) Which of the following software’s are open source:

LINUX,MS WINDOWS 7,PHOTOSHOP,MYSQL 

(e) Explain the difference between domain name and URL with the help of appropriate example of each. 

(f)Name any two Indian scripts included in Unicode. 

(g)Differentiate star and bus topology of networks. 

2 (a) while working in netbeans ,ranjeeta included a listbox in the form.now she want

the list of her friend’s names to be displayed in it .which property of listbox control should she use to do this? 

(b)What is the purpose of default clause in a switch statements ? 

(c) What is the purpose of break statements in a loop? 

(d)Write the two properties of jtextfield? 

(e)What will be the value of x and y after execution of the following code: 

int x,y=0;

for(x=1;x<=5;x++)

y=x++;

- -y;

(f) Write a function in java that takes principal,rate and time as parameters and returns simple interest. 

(g) Write a function in java that takes two numbers as parameters and returns their sum. 

3 (a) if database “Emplyoee” exists, which Mysql command helps you to starts working in that database? 

(b) Mohit created a table in Mysql .lateron he found that there should have been another column in the table. Which commands should he use to add another column to the table? 

(c)Removing the errors from query and rewriting it. 

Select* from book where Price=NULL;

(d)Which command is used in MySql to make the changes in database permanents? 

(e)In students table ,out of rollno,name,address which column can be set as primary key and why? 

(f)The itemno and cost column of a table “ITEM” are given below. 

Find the output of the following queries:

a)SELECT AVG(cost) FROM ITEMS;

b) SELECT cost+100 FROM ITEM WHERE itemno>102;

(g)A table PET in a database has 5 column and no rows in it. What is its cardinality?

What will be its cardinality if 4 rows are added in the table? 

4 (a) Define inheritance with reference to object oriented programming. 

(b)What will be the content of jtext field after executing the following code: 

int n=6;

n=n+1;

If(n>5)

Jtextfield1.setText(Integer.toString(n));

else

jtextfield1.setText(Integer.toString(n+5));

(c) What will be the contents of jTextarea1 after executing the following code: 

 jTextarea1.setText(“Kendriya\n Vidyalaya\t Guna”); 

Please refer to attached file for CBSE Class 12 Informatics Practices Sample Paper 2014 Set G