CBSE Class 12 Informatics Practices Sample Paper 2019 Set 01

CBSE Class 12 Informatics Practices Sample Paper 2019 (1). 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) A school with 20 stand-alone computers is considering networking them together and adding a server. State 2 advantages of doing this.

(b) Distinguish between LAN and WAN. 

(c) What is the purpose of Modem in network? 

(d) Write one example of IP Address. 

(e) Define ‘Domain Name Resolution’. 

(f) Name two threats to security in a network. What is the role of Firewall in Network security?

(g) Write one advantage and one disadvantage of Open Source software over Proprietary software.

2. (a) Write the value of variable ‘c’ after execution of the following code :

int d; int c;

d=7;

c = (5*++d)%3;

(b) What is the difference between jTextField and jPasswordField components? 

(c) In a SWITCH statement, what is the purpose of ‘default’ section? 

(d) After typing the HTML code using a text editor, how do you see how it would look as a web page?

(e) Write Java code to assign the value 500 to variable x. Increase the value of x by 50 and store it in variable y.

(f) Write the output that will be generated by the code given below :

int i;

i = 7;

int r;

r=8;

while (i<=10)

{

System.out.println(r*i);

i = i+2;

}

(g) “‘With XML there are no predefined tags’’ – Explain in brief with the help of an example. 

3. (a) What is MySQL? 

(b) Is NULL value the same as 0 (zero)? Write the reason for your answer. 

(c) Write the UPDATE command to increase the commission (Column name: COMM) by 500 of

all the Salesmen who have achieved Sales (Column name: SALES) more than 200000. The table’s name is COMPANY.

(d) While using SQL pattern matching, what is the difference between ‘_’ (underscore) and ‘%’ wildcard symbols?

(e) How is Primary key constraint different from Unique key constraint? 

(f) Write one similarity and one difference between CHAR and VARCHAR data types. 

(g) What is a Transaction? Which command is used to make changes done by a Transaction permanent on a database?

4.(a) The following code has some error(s). Rewrite the correct code Underlining all the corrections made.

int marks, temperature;

marks = jTextField1.getText());

temperature = Integer.parseInt(jTextField2.getText());

if (marks < 80) and (temperature >= 40)

{

System.out.println("Not Good");

}

else;

{ System.out.println("OK");

}

(b) How many times will the following WHILE loop execute?

int y = 7, sum = 0;

while (y<= 15)

{

sum = sum + y;

y = y+2;

}

(c) Rewrite the following program code using IF ELSE IF instead of SWITCH statement :

String tour;

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

switch (cl)

{ case 8: tour = "\n You are going to Camp Ramgarh";

break;

case 9: tour = "\n You are going to Manali, Rohtang Pass";

break;

case 10: tour = "\n You are going to Chail";

break;

default: tour = " No School tour for you this time";

}

(d) Write the values of sum and x after execution of the following code :

int sum, x;

sum = 7; 

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