CBSE Class 12 Informatics Practices Sample Paper 2019 Set 03

CBSE Class 12 Informatics Practices Sample Paper 2019 (3). 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) Which wireless communication channel is most appropriate in each of the following situations?

i Communication in a hilly area.

ii Very fast communication between two offices in two different countries.

(b) With what aim UNICODE was developed? 

(C) Expand the following file extensions:

(i) ODF (ii) XML

(d) Give one example of URL and one example of domain name. 

(e) What is the use of repeater in a Network? How is it different from Hub? 

(f) Give two characteristics of Star Topology. Also, show it using a diagram with interconnection of 5 computers.

(g) What is Snooping? 

2 (a) Name method is used to extract value of Index while using ListBox in Java. 

(b) What is the difference between the use of isSelected() and setSelected() methods used with JCheckBox in Java?

(c) Name any two commonly used methods of jComboBox control. 

(d) Name any two attributes used in <img> tag of HTML 

(e) How many times the following loops will execute? Which one of them is Entry Controlled and which one is Exit Controlled?

(f) What will be displayed in jTextField1 and jTextField2 after the execution of the following loop?

int Total =0 ,End=10;

for (int Turn=1,Turn<=End; Turn+=2)

Total++;

jTextField1.setText(Integer.toString(Total));

jTextField2.setText (Integer.toString(Turn));

(g) Differentiate between the <BR> and <HR> tags of HTML with suitable example. 

3 (a) Write a command to add a NOT NULL constraint on FEES column of a student table 

(b) Write SQL command to create a SAVEPOINT called AI. 

(c) Define Foreign Key with reference to RDBMS. 

(d) Table BANK has 2 rows and 3 columns .Table CUSTOMER has 4 rows and 3 columns.

What will be the cardinality and degree of the Cartesian product of them?

(e) There is column HOBBY in a Table CONTACTS .The following two statements are giving different outputs. What may be the possible reason?

SELECT COUNT (*) FROM CONTACTS;

SELECT COUNT (HOBBY) FROM CONTACTS;

(f) Name the methods used to convert one type of data to another in the following statement of java.

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

jTextField2.setText(Integer.toString(Num));

(g) Mr. Tandon is using table EMP with the following columns.

ECODE,DEPT,ENAME,SALARY

He wants to display all information of employees (from EMP table) in ascending order of ENAME and within it in ascending order of DEPT. He wrote the following command, which did not show the desired output.

SELECT * FROM EMP ORDER BY NAME DESC,DEPT;

Rewrite the above query to get the desired output.

4 (a) What will be the content of jTextArea1 and TextField1 after the execution of the following statements?

i jTextArea1.setText( “Go\t Green\n INDIA”) ;

ii String Message = “ All The Best” ;

jTextField1.setText(Message.length () -6)+” “ );

(b) Rewrite the following program code using a while loop statement:

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

for (int C=1; C<=Last; C++)

jTextArea1.setText(Integer.toString (C) ) ;

(c) Observe the following code carefully and find which statement will never get

executed in the code.

int Count=1; // Statement 1

do // Statement2

{ // Statement3

If (Count <15) // Statement4

jTextField1.setText (“Jump”) ; // Statement5

else // Statement6

jTextField1.setText (“STOP”); // Statement7

Count+=4; // Statement8

} // Statement9

while(t<=15); // Statement10

(d) Write java statement to make jButton1 disabled. 

(e) What will be displayed in jTextField1 after the execution of the following code?

int Sum, One=3,Two=5;

Sum =One + Two ++;

jTextField1. setText (Integer.toString(Sum) ) ;

jTextField2.setText (Integer.toString(Two) ) ;

(f) What will be the contents of Text1 and Text2 after the following code is executed? 

String Text2,Text1 ;

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