CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved

Informatics Practices
Download PDF

Read and download CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved designed as per the latest question paper pattern and Class 12 examination guidelines issued by CBSE, NCERT and KVS. The past year Question Papers for Class 12 Informatics Practices have been provided with solutions which will help students to assess their performance and find out topics in Informatics Practices Class 12 which they need to improve to get better marks in Class 12 exams. After solving these last year papers also refer to solved Sample Papers for Class 12 Informatics Practices available on our website to build strong understanding of the subject

Informatics Practices Question Paper Class 12

Students can refer to the below Class 12 Informatics Practices Question Paper designed to help students understand the pattern of questions that will be asked in Class 12 exams. Please download CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved

Informatics Practices Class 12 Question Paper

Q1. a) How SWITCH is different from HUB? Explain 
b) What is the purpose of IP address of computer ? 
c) How BUS topology is different from STAR topology? 
d) Which of the following are valid IP addresses ? Give reason(s) if invalid.
 
(i) 121.23.1.45
(ii) 192.168.0.254
(iii) 192.168.AS.1
(iv) 198.-1.1.1
 
e) How Cracker is different from Hacker in Computer Science? 
f) Identify the odd one out of the following :
Optical Fiber/Coaxial Cable/Bluetooth/Twisted Pair Cable Give reason for your answer.
 
g) Define Network. Write any two application of network. 
h) Define Domain Name Resolution. . 
i) Write the full form of a) CDMA b)GSM 
j) Explain the following term a) Firewall b) Snooping 
 
Q2. a) How WHERE clause is different from HAVING Clause? Explain with an example. 
b) What is the use of BETWEEN AND operator in mysql? Explain with an example.
c) Find the output of the following:
1. Select left(concat(“ABCD”,”EFG”),2);
2. Select dayofyear(“2017-02-04”);
3. Select round(5567.78,1)+truncate(3758.91,1);
4. Select pow(length(“Chennai”),4);
5. Select instr(“FLOOR”,”OR”);
 
d) Ms. Rhea created the table EMPLOYEE with the following fields:
ENO,ENAME,ESALand DEPTNO. While creating a table she forgot to add the primary key. Help her to add the primary key to the above table and identify the primary key field.
 
e) Define Transaction and write all the commands under TCL. 
f) Karanwants to add another column „Gender‟ in the already existing table „CUST‟.he has written the following statement.
However, it has errors. Rewrite the correct statement.
 
CHANGE TABLE CUST GENDER char(1);
 
g) How Single Row functions are different from Aggregate Functions. Explain with an example.
 
h) Given below is the „Department‟ table :

CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved 1

SET AUTOCOMMIT = 0;
UPDATE Department SET DEPNAME = „IT‟ WHERE
DEPNAME = „PERSONAL‟;
INSERT INTO Department VALUES(104,„SALES‟);
UPDATE Department SET DEPNAME = „FRONT OFFICE‟ WHERE
DEPNAME = „RECEPTION‟;
COMMIT;
DELETE FROM Department WHERE DEPNAME = „FRONT
OFFICE‟;
ROLLBACK;
SELECT * FROM Department;
 
What will be the output of the above given SELECT statement ?
 
i) “A & B” Company conducts workshops for employees of organizations.The company requires data of workshops that are organized. Write SQL query to create a table „Workshop‟ with the following structure :

CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved 2

j) Consider the Table “ Employee” shown below :

CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved 3

Write the commands in SQL for (i) to (viii) and output for (ix) and (x).
 
(i) To display the details about the Employee name which contains the character“i” anywhere.
 
(ii) To list the names of employee and their salary who are all in C and B grade.
 
(iii) To list the names who are all in South and their department is Comp.
 
(iv) To display the number of employees in each grade.
 
(v) Write a Query to display the structure of the table.
 
(vi) To increase the salary of the employees by 10 % those who are all from “SOUTH”.
 
(vii) To display the minimum salary from the table employee.
 
(viii) To display all the employees namein descending order of their grade.
 
(ix)SELECT MID (ename,length(“A”)) FROM employee;
 
(x) SELECT MAX(salary)-MIN(SLARY) FROM EMPLOYEE GROUP BY AREA;
 

Please click on below link to download CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved

2022
CBSE Class 12 Informatics Practices Question Paper 2022 Set A
CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved
CBSE Class 12 Informatics Practices Question Paper 2022 Set B Solved
2021
CBSE Class 12 Informatics Practices Question Paper 2021 Set A
CBSE Class 12 Informatics Practices Question Paper 2021 Set B
2020
CBSE Class 12 Informatics Practices Question Paper 2020 Set A
CBSE Class 12 Informatics Practices Question Paper 2020 Set B
CBSE Class 12 Information Practices Compartment Question Paper Solved 2020
2019
CBSE Class 12 Informatics Practices Question Paper Solved 2019
2018
CBSE Class 12 Informatics Practices Boards Question Paper Solved 2018
2017
CBSE Class 12 Informatics Practices Question Paper All India with answers 2017 (1)
CBSE Class 12 Informatics Practices Question Paper Delhi with answers 2017 (1)
2016
CBSE Class 12 Informatics Practices Question Paper 2016 Delhi
2015
CBSE Class 12 Informatics Practice Question Paper 2015 Delhi with Answers
CBSE Class 12 Informatics Practice Question Paper 2015 Outside Delhi with Answers
2014
CBSE Class 12 Informatics Practices Question Paper 2014 - Set 1
CBSE Class 12 Informatics Practices Question Paper 2014 - Set 2
CBSE Class 12 Informatics Practices Question Paper SA1 2014
2013
CBSE Class 12 Informatics Practices Delhi Question Paper 2013 (1)
CBSE Class 12 Informatics Practices Question Paper SA1 2013
CBSE Class 12 Informatics Practices Question Paper SA2 2013 (1)
CBSE Class 12 Informatics Practices Question Paper SA2 2013 (2)
2012
CBSE Class 12 Informatics Practices Question Paper 2012 (1)
CBSE Class 12 Informatics Practices Question Paper SA1 2012
CBSE Class 12 Informatics Practices Question Paper SA1 2012 (1)
CBSE Class 12 Informatics Practices Question Paper SA1 2012 (2)
2011
CBSE Class 12 Informatics Practices Question Paper 2011 (1)
2010
CBSE Class 12 Informatics Practices Question Paper 2010 (1)
CBSE Class 12 Informatics Practices Question Paper SA1 2010 (1)
2007
CBSE Class 12 Informatics Practices Question Paper 2007 (1)
CBSE Class 12 Informatics Practices Question Paper 2007 (2)
CBSE Class 12 Informatics Practices Question Paper 2007 (3)
CBSE Class 12 Informatics Practices Question Paper 2007 (4)
CBSE Class 12 Informatics Practices Question Paper 2007 (5)
* More Question Papers
CBSE Class XII Informatics Practices Question Paper 1

CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved

We hope you liked the above provided CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved. To get an understanding of the type of questions which were asked in previous year exams, it is important for Class 12 students to refer to CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved that we have provided above. Students can download all the Question Papers for Class 12 Informatics Practices which were issued in the exams so that you can practise them and solve all types of questions which have been asked till now. By doing all CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved PYP (previous year papers) you will understand the regular questions and MCQ questions for Class 12 Informatics Practices which are always asked and learn them so that you can get full marks in those questions. You can download CBSE Class 12 Informatics Practices Previous Year Question Papers and Class 12 Informatics Practices Sample Papers in PDF. You should attempt all the last year question paper for Class 12 and Class 12 Informatics Practices MCQ Test in examination conditions at home and then compare their answers with the solutions provided by our teachers.
 

Where can I download CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved in Pdf

You can download CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved from StudiesToday.com

How can I download and print CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved

You can easily access the link above and download CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved and save on your computer of mobile

How can I improve my scores by solving CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved

Regular practice of sample question paper given on studiestoday for CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved can help you to score better marks in exams

Are there any websites that offer free CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved

Yes, studiestoday.com provides all latest CBSE Class 12 Informatics Practices Question Papers with answers based on the latest format issued for current academic session

Are mock CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved available in multiple languages

Yes, mock CBSE Class 12 Informatics Practices Question Paper 2022 Set A Solved are available in multiple languages, including English, Hindi