CBSE Class 12 Informatics Practices Question Paper 2021 Set 02

CBSE Class 12 Informatics Practices Question Paper 2021 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) i. If you have not executed the COMMIT command, executing which command will reverse all updates made during the current work session in MySQL? 

ii. What effect does SET AUTOCOMMIT have in trasactions?

b) Write the value of z after execution of following code: 

int j =4 , z; 

z = (4*j) %3; 

c) Write the difference between statement 1 and statement 2 given below : 

Statement1 →A=10and Statement 2 → if(A = =10) 

d) Write two examples of RDBMS software. 

e) Table"Club‟ has 4 rows and 3 columns. Table „Member‟ has 2 rows and 5 columns. What will be the cardinality of the Cartesian product of them? 

f) A numeric data field CHANGER contains 25565.7765. Write a command to round off CHANGER.

 i. up to 2 decimal places(i.e., expected result 25565.78) 

ii. Whole number (i.e., expected result 25566) 

g) Name the methods used to perform the following in NetBeans: 

i. To set jRadioButton1 true at run time. 

ii. To return the index value of the selected item from the list. 

h) Gopi Krishna is using a table Employee. It has the following columns: 

Code, Name, Salary, Deptcode 

He wants to display maximum salary department wise. 

He wrote the following command 

SELECT Deptcode, Max(Salary) FROM Employee; 

But he did not get the desired result. 

Rewrite the above query with necessary changes to help him get the desired output. 

i) How is NULL value different from 0 (zero) value? 

j) Write the UPDATE statement in MySQL to increase commission by 100.00 in the “Commission” 

column in the „Emp‟ table. 

k) When using the LIKE clause, which wildcard symbol represents any sequence of none, one or more characters? 

l) Rewrite the following SQL statement after correcting error(s). Underline the corrections made. 

INSERT IN STUDENT VALUE (5, ajay ,78.5); 

m) What values will the following statements return?

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