Best Term 2 IP Sample Paper Class 12 2021 With Solution

Share with others


IP Sample Paper Class 12 2021

IP sample paper class 12
IP sample paper class 12

Click for CBSE TERM 2 Sample Question Paper and Marking Scheme

1. Term 2 IP Sample Paper Class 12 2021  – Paper 1 and Marking Scheme (Coming Soon)

2. Term 2 IP Sample Paper Class 12 2021 with Solutions – Paper 2

3. Term 2 IP Sample Paper Class 12 2021 with Solutions – Paper 3

4. Term 2 IP Sample Paper Class 12 2021 with Solutions – Paper 4


IP sample paper class 12
IP sample paper class 12

IP Sample Paper Class 12 2021 with Solutions


Sample Question Paper
INFORMATICS PRACTICES (Code : 065)

Maximum Marks: 35 Time: 2 hrs

General Instructions

  1. The question paper is divided into 3 sections – A, B and C
  2. Section A, consists of 7 questions (1-7). Each question carries 2 marks.
  3. Section B, consists of 3 questions (8-10). Each question carries 3 marks.
  4. Section C, consists of 3 questions( 11-13). Each question carries 4 marks.
  5. Internal choices have been given for question numbers – 1 , 3, 8 and 12.
Section –A
Each question carries 2 marks
Q. No.Part No.QuestionMarks
1Anupam is a class 12 computer science student. He knows about browser and it’s various settings, but he is not very much clear about the term Add-ons and Plugins. As a good friend of Anupam, explain him the difference between Add-ons and Plugins.

OR

Aman is a brilliant child of class VIII. Due to some unavoidable reason, he missed his one computer class in which his teacher taught the difference between Webpage and Website. As his elder brother explain him the difference between Webpage and Website.
2
2iI am a topology in which all the computers are directly connecting to a single cable called backbone.

If the backbone cable break the entire network will be down.

Name the topology.
1
iiWhat is browser?1
3Write the output of the following :
a. Select power(2,0);
b. Select round(345.876);

OR

Explain the following function with example
a. mod( )
b. pow( )
2
4.Explain DNS in brief.2
5.Write the output of the following

a. Select mod(11, 3)
b. Select round(123.456, 2)
2
6. What is the difference between ‘where’ and ‘having’ clause in MySQL. Explain with example.2
7. Mr. Rakesh created the following table ‘Student’ to store the details of students:
NameClassDOB
Aman92001-08-28
Sumit102000-01-28
Naman92001-12-05
Rani111999-09-03
IP Sample Paper Class 12
He has written the following queries.

a. Select min(year(DOB)) from Student;
b. Select * from Student where day(DOB) = 28;

Write the output of the above queries.

OR

Write the queries for the following on the basis of above table : Student

a. Display the name of the student who born in year 2000.
b. Display the detail of the students who born in the month of ‘May’
2
SECTION – B
Each question carries 3 mark
8Write the output of the following queries:

a. Select length(trim(” Computer “));
b. Select mid(“Informatics Practices”, 7, 7);
c. Select instr(“Computer Science”, “e”);

OR

Consider the table “Book” which has the following fields

1. Bookno
2. Bname
3. Price
4. Author_name

Write the queries for the following

a. Display name of all the books in upper case.
b. Display last digit of price column of all the books.
c. Display third, forth and fifth character from all the author name.
3
9.Explain the following SQL functions with example:
a. now( )
b. left( )
c. sum( )
3
10.Name and explain all the functions which are used in the following query with example:

Select right((trim(‘ Common Queries “),6));

Also write the output of the above query.
3
IP Sample Paper Class 12
IP sample paper class 12
IP sample paper class 12
Section C
Each question carries 4 marks
11Consider the following table “Chips” and write queries given below
TABLE : Chips
Brand_nameFlavourPriceQuantity
LaysOnion105
LaysTomato2012
Uncle ChipsSpicy1210
Uncle ChipsPudina1012
HaldiramSalty1020
HaldiramTomato2530
IP Sample Paper Class 12
1. To display detail of all chips in decreasing order of quantity.
2. To display brand name and it’s total quantity available.
3. To display brand name and it’s average price.
4. To display detail of lowest price chips in each brand.
4
12.Consider the table ‘Employee’ given below and write the output of all the queries given below:
TABLE : Employee
Emp_idEnameDesigSalaryIncentive
123Mr. KananManager5000040000
124Ms DaminiManager4500050000
452Mr. KapoorClerk3000015000
231Mr. SharmaAnalyst4000010000
256Mr. KumarClerk25000NULL
IP Sample Paper Class 12
1. Select sum(Salary) from employee where Desig = “Manager”;
2. Select average(Incentive) from employee;
3. Select max(Salary) – min(Incentive) from employee;
4. Select Desig, sum(Salary) group by Desig from employee;

OR

Write the output of the following queries:

1. Select count(*) from employee;
2. Select count(Incentive) from employee;

Write the reason of being different output of above two queries. Also explain the count( ) function.
4
13. A, B, C, and D are four buildings of an IT company. Mr Ramesh want to connect all the four buildings .

The distance between various buildings are as follows:

A to B – 200m
A to C – 150m
A to D – 50m
B to C – 250m
B to D – 350m
C to D – 350m

Number of computers in each building are

A – 160
B – 130
C – 80
D – 50

Based on the above specifications, answer the following questions:

1. Suggest the cable layout of connections between the buildings.
2. Suggest the most suitable building to house the server, with suitable reason.
3. Suggest the placement of the following device with justification
i. Repeater
ii. Hub/Switch
4. Suggest the most suitable wire for fast and secure .
4
IP Sample Paper Class 12

IP Sample Paper Class 12 2021 with Solutions

M.M. – 35                                                                                  Time: 2hrs

General Instructions

  1. The question paper is divided into 3 sections – A, B and C
  2. Section A, consists of 7 questions (1-7). Each question carries 2 marks.
  3. Section B, consists of 3 questions (8-10). Each question carries 3 marks.
  4. Section C, consists of 3 questions (11-13). Each question carries 4 marks.
  5. Internal choices have been given for question numbers – 1 , 3, 8 and 12.
 Section –A Each question carries 2 marks 
Q. No.QuestionsMarks
Q1Aman is a class XII Computer Science student. He is doing a course in Networking from a private institute. He is confused between Bus and Star topology. As a friend of Aman, help him to understand both the topology by drawing suitable diagram.  

OR  

Anamika is a very intelligent girl of class XII. She completed the entire syllabus of Informatics Practices. During revision of syllabus, she had doubt in the following question. What is the difference between hub and switch?   Being a friend of Anamika, explain her the above question.
            2
Q2.Identify the following:

I am a protocol/technology used to make voice call on internet.
I am a network device which is used to boost the signal so that it can be carried to long distance.
    2
Q3.Write the output of the following:

1. Select pow(mod(11,3), mod(12,4));
2. Select round(3478.9456, 2);  

OR  

Explain the following function of MySQL with example instr( )mid( )
    2
Q4.Define the following term:

1. Web page
2. Web server
2
Q5.Write the output of the following:

1. Select upper(left(“computer”,5));
2. Select length(trim(“    Paper@2022    “));
  2
Q6.Suman is learning DBMS. She has written the following query:

Select * from emp where name = “A%”;
Select salary, name from emp where comm = NULL;  

Both the queries are returning error. Help suman in identifying the error and also write the correct query.
2
 Q7. Consider the following table: “Stock” 
S_idTypePriceQuantityDate_of_purchase
S12A4-Paper500102020-02-14
S43Computer20000112022-01-23
S32Printer5000NULL2021-08-20
S22Curtain350092019-08-16
S11Tape250202018-04-18
Write the output of the following:
 
a.       Select sum(Price) from Stock;
b.      Select avg(Quantity) from Stock;
 
OR
 
a.       Select * from Stock where month(Date_of_purchase) = 8;
Select max(Date_of_purchase) from Stock;
2
Section –B
Each question carries 3 marks
Q8.Write the output of the following:
 
a.       Select day(“2022-02-22”);
b.      Select instr(“abcdfbcfhjbcm”,”bcf”);
c.       Select trim(“abcd” from “abcdefghij”);
 
OR

Consider the table “Stock” given below and write the SQL query for the following task:

a. Display the details of stock which are purchased in year 2019.
b. Display the values of “Type” column in upper case.
c. Display the last two digits from the “S_id” column.
S_idTypePriceQuantityDate_of_purchase
S12A4-Paper500102020-02-14
S43Computer20000112022-01-23
S32Printer5000NULL2021-08-20
S22Curtain350092019-08-16
S11Tape250202018-04-18
Q9. What do you mean by Aggregate function in MySQL? Explain any 2 aggregate functions with example.
Q10. Ashu is a student of class 12 computer science. He got an assignment from the school. He has done the entire assignment and having doubt in the following questions. Being a friend of Ashu, explain him the following questions.
 
a.       Name a SQL function which removes the leading as well as trailing spaces.
b.      Name two string/text function of SQL which returns the numeric value.
c.       What is the difference between count() and count(*)
Section –C
Each question carries 4 marks
Q11. Consider the following table: Student and write the queries for the following:
AdmnoNameFeeDOB
A102Ashok50002001-03-23
A212Aman45602000-05-25
S213Suman45002000-04-07
P324Simran55002002-11-15
  1. Write a query to display the total of fees deposited by all students.
  2. Write a query to display all the records in decreasing order of DOB.
  3. Write a query to display records of all students whose Admission number start from alphabet ‘P’.
  4. Write a query to display Admission number, DOB and first three characters of name.
Q12Raman has created the following table: Emp and write the queries for the following
EmpidNameEmailSexMobile
E123Mr. Ashokashe123@yahoo.comM6789876545
S345Mr. Ramrams345@gmail.comM9899878987
A199Ms. Swatiswaa199@yahoo.comF7898789878
R230Ms. Manishamanr230@gmail.comFNULL
  1. Display the details of all female employees.
  2. Display the details of all those employees who has email on google.
  3. Display name and email id in upper case.
  4. Let us assume that four digits area code is reflected in the mobile number starting from position number 3. For example, 1851 is the area code of mobile number 9818511338. Now, write the SQL query to display the area code of the male employees.

OR

Write the output of the following:

  1. Select Name, instr(Email, ‘@’) from Emp;
  2. Select trim(“.com” from Email) from Emp;
  3. Select count(Mobile) from Emp;
  4. Select length(Email), left(Email, instr(Email, “@”)-1) from Emp;1;
Q13.Nirmal Public School, Noida has four building in its compound:
IP Sample paper class 12
IP Sample paper class 12
  1. Suggest a cable layout of connections between the buildings.
  2. Suggest the most suitable place (i.e., building) to house the server of this organization with a suitable reason.
  3. Suggest the placement of the following devices:
    1. Hub
    2. Repeater
  4. Nirmal Public School, Noida wants to connect Senior School Building with another branch which is at a distance of 20km. What type of network out of LAN, MAN or WAN will be formed?
IP sample paper class 12
IP sample paper class 12

IP Sample Paper Class 12

IP Sample Paper Class 12 2021 with Solutions

M.M. – 35                                                                                  Time: 2hrs

General Instructions

  1. The question paper is divided into 3 sections – A, B and C
  2. Section A, consists of 7 questions (1-7). Each question carries 2 marks.
  3. Section B, consists of 3 questions (8-10). Each question carries 3 marks.
  4. Section C, consists of 3 questions (11-13). Each question carries 4 marks.
  5. Internal choices have been given for question numbers – 1 , 3, 8 and 12.
Q1.Manoj is confused between LAN and WAN type of Network. As a friend of Manoj, explain him the difference between LAN and WAN.  

OR  

Raju is a networking engineer. He wants to connect 4 computers. Which device will help him to form/create a network? Also suggest a device which helps him to connect computers with internet.
Q2.Identify me:

a. I am an analog device which regenerates the week signals.
b. I am an intelligent hub.
Q3.Write the output of the following:

a. Select pow(100,-2);
b. Select round(1578.3871, -3);

OR  

What is the difference between left() and right() functions of MySQL? Explain with example
Q4.Differentiate between dynamic and static webpage.
Q5.Write the output of the following :

a. Select length(left(“Computer Science”, 25));
b. Select lower(“CaLcULAtioN”);
Q6.Identify the errors in the following query and also write the correct query.  

a. Select sum(salary), maximum(salary) from emp;
b. Select * from book where book_id is 1010;
Q7.Observe the following column “quantity” of table “stock” and write the output of the following:  

quantity
12
23
NULL
11

a. Select sum(quantity) from stock;
b. Select average(quantity) from stock;  

OR  

a. Select quantity from stock;
b. Select max(quantity) + min(quantity) from stock;
Section –B Each question carries 3 marks
Q8.Write the output of the following:  

Select instr(“1234567891262512145”,”4”);
Select mid(“Informatics Practices”, 4, 8)
Select year(now());  

OR   Consider the table “Car” given below and write SQL queries:  

Car_idPriceModelTaxBrand
C101550000201650000Maruti
C124720000201975000Datsun
C129655000202248000Maruti
  1. Display total price and tax of each brand.
  2. Display the average price of brand “Maruti”.
  3. Display the detail of those cars whose model year is 2020.
Q9.Explain the following function with example:   trim()month()dayname()
Q10.What is function in MySQL? Explain two categories of function with one example of each.          
IP Sample Paper Class 12

Q11. Carefully observe the following table “Hotel”

Room_idCategoryTariffWi-FiFloor
1245Deluxe2500YesGround
1374Semi_Deluxe2000YesFirst
1152Super_Deluxe3500YesGround
1235Normal1500NoSecond
  1. Display the details of rooms where Wi-Fi is available in decreasing order of tariff.
  2. Display the number of rooms available on each floor.
  3. Display the last three and first three characters from column “Category”.
  4. Display the maximum tariff from above table.

Q12. Aman is working as a Database administrator in a company. He shared the following data with his junior analyst “Sumit”.

Table : Book

B_idPriceClassAuthorSubject
B121250IXR.K.I.T.
B200350XR.D.Math
B191400XM.L.I.T.

Sumit has written the following queries. Help him in predicting the output of the given queries.

  1. Select sum(Price) from Book where Subject = “I.T.”;
  2. Select avg(Price) from Book where Class = “X”;
  3. Select trim(‘B’ from B_id) from Book;
  4. Select * from Book where Subject like “%t%”;

OR

  1. Differentiate between count() and count(*). Explain with example.
  2. Write the output of the following:
  3. Select left(“LEFT”,2), right(“Right”,3);
  4. Select length(mid(“I love MySQL”,4,5)) ;

Q13. Mr. Khanna is an Entrepreneur. He started his business in 2005 in a small rented room. Now after 17 years his business has grown up exponentially. He has four divisions in his Office located in Gurugram. All divisions are shown below:

IP sample paper class 12
Four Divisions

Distance between various divisions are given below:

Production to R&D120m
Production to Design50m
Production to Packaging70m
R&D to Design80m
R&D to Packaging60m
Design to Packaging102m

Number of computer in each divisions are given below:

Production80
R & D40
Design32
Packaging18

As a network expert, answer the following

  1. Suggest the most suitable place to house the Server.
  2. Suggest a cable layout of connections between the various divisions.
  3. Suggest the placement of (i) modem (ii) hub/switch in the network.
  4. The organization is planning to link its Gurugram office with four retail outlets situated in various parts of the same city, which type of network will be formed?

Disclaimer : I tried to give you the correct format of ” IP Sample Paper Class 12 ” , but if you feel that there is/are mistakes in the Questions of IP Sample Paper Class 12 given above, you can directly contact me at csiplearninghub@gmail.com. NCERT book and CBSE study material is used to create IP Sample Paper Class 12 questions.

IP Sample Paper Class 12


MCQ of Computer Science Chapter Wise

1. Functions in Python

2. Flow of Control (Loop and Conditional statement)

3. 140+ MCQ on Introduction to Python

4. 120 MCQ on String in Python

5. 100+ MCQ on List in Python

6. 50+ MCQ on Tuple in Python

7. 100+ MCQ on Flow of Control in Python

8. 60+ MCQ on Dictionary in Python


Important Links

100 Practice Questions on Python Fundamentals

120+ MySQL Practice Questions

90+ Practice Questions on List

50+ Output based Practice Questions

100 Practice Questions on String

70 Practice Questions on Loops

70 Practice Questions on if-else

Computer Science Syllabus 2021-2022.

Informatics Practices Syllabus 2021-2022

Class 12 Computer Science Chapter wise MCQ

IP Sample Paper Class 12

IP Sample Paper Class 12

IP Sample Paper Class 12

IP Sample Paper Class 12


Share with others

Leave a Reply

%d bloggers like this: