Class 12 Informatics Practices 065 Previous Year Question Paper 2022

Table of Contents

Series %BAB%
Question Paper Code 90 Set 4

INFORMATICS PRACTICES – TERM 2 – SOLUTION
(Session 2021-22)

Time allowed : 2 hours
Maximum Marks : 35

General Instructions :

This question paper is divided into 3 Sections – A, B and C.
Section A, consists 7 questions (1-7). Each question carries 2 marks.
Section B, consists 3 questions (8-10). Each question carries 3 marks.
Section C, consists 3 questions (11-13). Each question carries 4 marks.
Internal choices have been given for question numbers – 1, 3, 7, 8 and 12.

SECTION -A (Each question carries 2 marks)

1. Rushil thought “WWW” and “Internet” are synonyms i.e., they meant same and can be used interchangeably. But the teacher said that they are not same. Help him to understand the meaning of both the terms with the help of a suitable example of each.
Answer: Rushil’s confusion is understandable, but “WWW” (World Wide Web) and “Internet” are not exactly synonymous, although they are closely related.
The World Wide Web, is a specific system of information that is accessed over the Internet. It is a collection of interconnected documents and other resources, linked by hyperlinks and URLs.
Example: If the Internet is the entire road system, then the World Wide Web is like the specific destinations you can reach using those roads. Each website or web page is like a house or a place you can visit on this vast network.
The Internet is a global network (network of networks) that connects millions of private, public, academic, business, and government networks. It is the infrastructure or the physical network of networks that allows information to be exchanged globally.
Example: Think of the Internet as the entire system of roads and highways that connect different cities and towns.
OR
What are Cookies ? How can we disable Cookies ?
Answer: Cookies are small text files that websites store on a user’s device when the user visits the website. These files contain information about the user’s interactions with the website, and they serve various purposes, including remembering user preferences, enhancing user experience, and tracking website usage.
To disable cookies: Find “Settings” and then Click “Privacy and Security” option. Click on “Cookies” option and “Turn off” the toggle switch or click on “Disable” option.

2. (i) What is the function of a Gateway ?
Answer: A gateway is a fundamental component in networking that facilitates communication between different networks by serving as the entry and exit point for data, managing routing paths, and ensuring compatibility between dissimilar network technologies.
(ii) Give examples of any two plug-ins.
Answer: (i) Java (ii) Flash

3. Find the output of the following SQL Queries :
(i) SELECT ROUND (7658.345,2);
Answer: Output: 7658.35
(ii) SELECT MOD(ROUND (13.9,0),3);
Answer: Output: 2
OR
Give any two differences between the POWER( ) and SUM( ) SQL functions.

`POWER()` Function	`SUM()` Function
(i) It calculates the power of a number.	(i) It calculates the sum of values in a numeric column.
(ii) It is not an aggregate function.	(ii) It is an aggregate function.
(iii) Example: `SELECT POWER(2, 3);`	(iii) Example: `SELECT SUM(column_name) FROM table_name;`

4. Give one advantage and disadvantage each of Bus and Star topology.

	Bus Topology	Star Topology
Advantage	Easy to set up and implement.	Easy to manage and troubleshoot as all devices connect to a central hub.
Disadvantage	If the main cable or central hub fails, the entire network is affected.	Initial setup cost can be higher due to the central hub.

5. Find the output of the following SQL queries :
(i) SELECT SUBSTR(“FIT INDIA MOVEMENT”,5);
Answer: Output: INDIA MOVEMENT
(ii) SELECT INSTR(“ARTIFICIAL INTELLIGENCE”, “IA”);
Answer: Output: 8

6. Srikanth created the following table STUDENT in his database.
Class-12-IP-065-Previous-Year-Question-Paper-2022-term-2-Q6
He now wants to count number of students in each class where the number of students is more than 3. He has executed the following query :
SELECT MAX(Marks) FROM STUDENT WHERE COUNT(*)>3 GROUP BY Class;But, he got an error. Identify the error(s) and rewrite the query. Also underline the correction(s) done.
Answer: SELECT Class, COUNT(*) FROM STUDENT GROUP BY Class HAVING COUNT(*) > 3;

7. Ms. Mohini is working in a school and stores the details of all students in a table SCHOOLDATA.
Class-12-IP-065-Previous-Year-Question-Paper-2022-term-2-Q7
Write SQL statements from the above given table to :
(i) To remove leading spaces from the column Name.
Answer: SELECT LTRIM(Name) FROM SCHOOLDATA;
(ii) Display the names of students who were born on Sunday.
Answer: SELECT LEFT(Gender,1), Name FROM SCHOOLDATA WHERE YEAR (Dob)=2005;
OR
Predict the output of the following SQL queries from the given table : SCHOOLDATA
(i) SELECT MAX(Percent) FROM SCHOOLDATA;
Answer: 91
(ii) SELECT LEFT(Gender,1),Name FROM SCHOOLDATA WHERE YEAR (Dob)=2005;
Answer: Output will be:
Class-12-IP-065-Previous-Year-Question-Paper-2022-term-2-solution-Q7

SECTION – B (Each question carries 3 marks)

8. Predict the output of the following SQL queries :
(i) SELECT TRIM(” ALL THE BEST “);
Class-12-IP-065-Previous-Year-Question-Paper-2022-term-2-solution-Q8-i
(ii) SELECT POWER(5,2);

(iii) SELECT UPPER (MID(”start up india”,10));

OR
Consider a table "MYPET" with the following data:

Write SQL queries for the following :
(i) Display the Breed of all the pets in uppercase.
Answer: SELECT UPPER(BREED) FROM MYPET;
(ii) Display the total price of all the pets.
Answer: SELECT SUM(PRICE) FROM MYPET;
(iii) Display the average life span of all the pets.
Answer: SELECT AVG(LIFESPAN) FROM MYPET;

9. Write the names of SQL functions to perform the following operations :
(i) Display name of the Month from your date of birth.
Answer: SQL Function – MONTHNAME()
(ii) Convert email-id to lowercase.
Answer: SQL Function – LCASE() or LOWER()(iii) Count the number of characters in your name.
Answer: SQL Function – LENGTH()

10. Consider the following table : PRODUCT
Class-12-IP-065-Previous-Year-Question-Paper-2022-term-2-Q10
Find the output of the following SQL queries :
(i) SELECT 10+MOD(QUANTITY,3) FROM PRODUCT WHERE PNAME = “Eraser”;

(ii) SELECT ROUND(PRICE,2)*QUANTITY FROM PRODUCT WHERE QUANTITY > 2;

(iii) SELECT UCASE(RIGHT(PNAME,2)) FROM PRODUCT;
Class-12-IP-065-Previous-Year-Question-Paper-2022-term-2-solution-Q10-iii

SECTION – C (Each question carries 4 marks)

11. Consider the table : ITEM
Class-12-IP-065-Previous-Year-Question-Paper-2022-term-2-Q11
Write SQL queries for the following :
(i) Display all the records in descending order of Stockdate.
Answer: SELECT * FROM ITEM ORDER BY Stockdate DESC;
(ii) Display the Type and total number of items of each Type.
Answer: SELECT Type, COUNT(*) FROM ITEM GROUP BY TYPE;
(iii) Display the least Price.
Answer: SELECT MIN(Price) FROM ITEM;
(iv) Display the Itemname with their price rounded to 1 decimal place.
Answer: SELECT Itemname, ROUND(PRICE,1) FROM ITEM;

12. Consider the following table :
Class-12-IP-065-Previous-Year-Question-Paper-2022-term-2-Q12
Predict the output for the following SQL queries :
(i) SELECT MAX(Qtysold), MIN(Qtysold) FROM SALESMAN;

(ii) SELECT COUNT (Area) FROM SALESMAN;

(iii) SELECT LENGTH (Sname) FROM SALESMAN WHERE MONTH(Dateofjoin)=10;
Class-12-IP-065-Previous-Year-Question-Paper-2022-term-2-solution-Q12-iii
(iv) SELECT Sname FROM SALESMAN WHERE RIGHT(Scode,1)=5;

OR
Based on the given table SALESMAN write SQL queries to perform the following operations :
(i) Count the total number of salesman.
Answer: SELECT COUNT(*) FROM SALESMAN;
(ii) Display the maximum qtysold from each area.
Answer: SEELCT AREA, MAX(Qtysold) FROM SALESMAN GROUP BY Area;
(iii) Display the average qtysold from each area where number of salesman is more than 1.
Answer: SELECT AVG(Qtysold) FROM SALESMAN GROUP BY Area HAVING COUNT(*) > 1;
(iv) Display all the records in ascending order of area.
Answer: SELECT * FROM SALESMAN ORDER BY Area;

13. ABC International School, Delhi has different wings Administrative Wing (W1), Primary Wing (W2), Middle Wing(W3) and Secondary Wing(W4) as shown in the diagram :
Class-12-IP-065-Previous-Year-Question-Paper-2022-term-2-Q13i
The school also has a branch in Mumbai. The school management wants to connect all the wings as well as all the computers of each wing (W1, W2, W3, W4).
Distance between the wings are as follows :

Number of computers in each of the wing :
Class-12-IP-065-Previous-Year-Question-Paper-2022-term-2-Q13iii
Based on the above specifications, answer the following questions :
(i) Suggest the topology and draw the most suitable cable layout for connecting all the wings of Delhi branch.
Answer: Star topology

(ii) Suggest the kind of network required (out of LAN, MAN, WAN) for connecting
(a) Administrative Wing (W1) with Middle Wing (W3)
Answer: LAN
(b) Administrative Wing (W1) with the Mumbai branch.
Answer: WAN
(iii) Suggest the placement of the following devices with justification :
(a) Repeater
Answer: Repeater can be placed between W3 and W4 as per the layout given.
(b) Switch/Hub
Answer: Switch or Hub can be placed in each wing.
(iv) Due to pandemic school had to adopt Online classes. Suggest the protocol that is used for sending the voice signals over internet. Also, give an example of an application of WWW that helped the teachers to send messages instantly to the students.
Answer: Voice over Internet Protocol (VoIP) or Real-time Transport Protocol (RTP) can be used to send the voice signals over the internet.
Some examples of a World Wide Web (WWW) application that facilitates instant messaging between teachers and students are Google Classroom, Google Hangout, WhatsApp

Class 12 Informatics Practices 065 Previous Year Question Paper 2022 – Term 2 – Solution

Find Class 12 Informatics Practices Previous Year Question Papers

Find Class 12 Informatics Practices Previous Year Question Papers Solution

Find Class 12 Informatics Practices Previous Year Compartment Question Papers

Find Class 12 Informatics Practices Previous Year Compartment Question Papers Solution

Leave a Comment Cancel reply