CBSE Class 12 Informatics Practices Sample Paper 2019 Set 02

CBSE Class 12 Informatics Practices Sample Paper 2019 (2). It’s always recommended to practice as many sample papers as possible before the examinations. Students can download the sample papers and also question papers of previous years to practice and score better marks in examinations. Refer to other links too for more sample papers.

1 (a) Why is switch called an intelligent hub? 

(b) What was the objective behind developing UNICODE? 

(c) Expand the following terms : 

i OSS

ii ODF

(d) What is the use of repeater in a Network? 

(e) i Identify the following device :

A device that is used to connect different types of networks. It performs the necessary translation so that the connected networks can communicate properly.

2 ii A device that converts data from digital bit stream into an analog signal and vice versa

(f) Write one advantage and one disadvantage of using Optical fibre cable. 

(g) Distinguish between Open Source Software and Proprietary Software. 

2 (a) Is a string containing a single character same as a char? 

(b) Write a statement in Java to declare a String type variable with a name City. 

(c) Distinguish between ‘/ ’ and ‘%’ operators. 

(d) Which tag / attributes of HTML are used to 

i Insert a picture in the web page.

ii Insert an empty line in the web page.

(e) What will be the values of variables agg and agg1 after the execution of the following loops?

(f) What will be displayed in jTextArea1 after the execution of the following loop?

for (int I=5;I>=2;I– –)

jTextArea1.setText(jTextArea1.getText()+” "+Integer.toString(I*I));

(g) Give two attributes of Table element of HTML. 

3 (a) Distinguish between ALTER TABLE and UPDATE commands of MySQL. 

(b) Mention two categories in which MySQL commands are broadly classified. 

( c) Give two characteristics of Primary Key. 

(d) A table FUNFOOD has 13 rows and 17 columns. What is the cardinality and degree of this table?

(e) A numeric column MONEY contains 34567.7896. Write a command to truncate

MONEY

i Up to 2 decimal places. (i.e. expected result 34567.78)

ii Up to -3 places. (i.e. expected result 34000)

(f) What happens when ‘‘ROLLBACK’’ command is issued in a transaction process?

(g) Shanya Khanna is using a table Employee. It has the following columns.

Admno, Name, Agg, Stream

[column Agg contains Aggregate marks]

She wants to display highest Agg obtained in each Stream.

She wrote the following statement :

SELECT Stream, MAX(Agg) FROM Employee;

But she did not get the desired result. Rewrite the above query with necessary

changes to help her get the desired output.

4 (a) Define Object Oriented Programming. 

(b) Rewrite the following Java code using a Switch Case statement :

int option=Integer.parseInt(jTextField1.getText());

if (option==1)

jTextField2.setText("Regular employee");

else if (option==2)

jTextField2.setText("On Probation");

else if (option==3)

jTextField2.setText("Visiting faculty");

else if (option==4)

jTextField2.setText("On Contract");

else

jTextField2.setText("Invalid option!");

(c) What will be the value X1 after the execution of the following code :

String X1="Spread",X2="PEACE";

X1=X2.concat(X1);

(d) Write Java statement to make a jTextfield1 disabled 1

(e) What will be displayed in jTextArea1 after the execution of the following code :

int G=1;

do

{

jTextArea1.setText(Integer.toString(G++));

G=G+1;

} while(G<=5);

(f) Give the output of the following Java code :

String name="Chennai Express";

int TM=name.length(),TN;

TN=80–TM; 

Please click the link below to download CBSE Class 12 Informatics Practices Sample Paper 2019 (2).