CBSE Class 12 Informatics Practices Question Paper 2020 Set 02

CBSE Class 12 Informatics Practices Question Paper 2020 Set B. Students can download the last year board exams question papers using the link below. Free download of examination question papers with solutions. Last 10 year question papers should be practised to get better marks in examinations. 

1. a) A school with 20 stand-alone computers is considering networking them together and adding a server. State 2 advantage 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) Draw the diagram of star topology and give one advantage of it.

2. a) Write the value of variable 'e' after execution of the following code:

int d;

int e;

d=7;

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

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

c) In a SWITCH statement, what is the purpose of 'default' statement?

d) Which HTML tag is used to:

i) Change the font of the page

ii) Create a table

e) Write Java code to assign the value 79.5 to variable A. Increase the value of A by 5.5 and store it in variable B. 

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

int x;

x = 7;

int r;

r = 8;

while (x<=10)

{

System.out.println(r*x);

x +=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 750 of all the salesman who have achieved Sales (Column name: SALES) more than 159000. The table's name is COMPANY.

d) While using SQL pattern matching what is the difference between ' _ ' underscore and '%' wildcard symbols?

e) Name the SQL Commands used to:

Please click the link below to download pdf file of CBSE Class 12 Informatics Practices Question Paper 2020 Set B