Students can access the CBSE Sample Papers for Class 12 Informatics Practices with Solutions and marking scheme Term 2 Set 8 will help students in understanding the difficulty level of the exam.

## CBSE Sample Papers for Class 12 Informatics Practices Term 2 Set 8 with Solutions

Maximum Marks : 35
Time : 2 hours

Instructions

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

Section-A
(Each question carries 2 Marks)

Question 1.
Ms. Agnimitra a network operator was scanning through various network topologies which she was trying to implement for network in her company. She came across the mesh topology. Explain her the topology with its structure, advantages and disadvantages.
Or
Aniket found that most people use chatting applications popularly, but could not understand what exactly is chatting? Explain him chatting and the protocol used for it.
In mesh topology, all the computers are interconnected to every other in the network. Each computer not only sends its own signals but also relays data from other computers. The nodes are connected to every other completely via a dedicated link during which information travels from nodes to nodes and there are N(N-l)/2 links in mesh, if there are N nodes. Every node features a point-to-point connection to the opposite node.

The connections within the mesh are often wired or wireless.

• Failure during a single device would not break the network.
• There is no traffic problem as there is a dedicated point-to-point links for every computer.
• Fault identification is straight forward.
• This topology provides multiple paths to succeed in the destination and tons of redundancy.
• It provides high privacy and security.

• It’s costly as compared to the opposite network topologies (i.e. star, bus, point-to -point).
• Installation is extremely difficult in the mesh.
• Power requirement is higher as all the nodes will need to remain active all the time and share the load.
• Complex process.
• The cost to implement mesh is above other selections.

Or

On the Internet, chatting is talking to other people who are using the Internet at the same time you are. Usually, this “talking” is the exchange of typed-in messages requiring one site as the repository for the messages (or “chat site”) and a group of users who take part from anywhere on the Internet.
The protocol used for chatting is IRCP (Internet Relay Chat Protocol).

Question 2.
(i) Mr. Satya Narayan Pal a senior citizen is not quite clear about the benefits of computer network. State few reasons to Mr. Pal of why computer networks are beneficial for people?
Following are the reasons that’s why computer networks are beneficial for people « Flexibility

• Convenient resource sharing
• Connectivity
• Security
• Great storage capacity
• Reduced cost
• Lack of robustness
• Sharing of messages
• Sharing of resources
• Reduction of cost

(ii) NTel Infosystems was recommended by their network engineers to install switch in their network. Inform the manager of the company, how switch will be useful for them?
Switch is more efficient than the hub. A switch can join multiple computers within one LAN and a hub just connects multiple ethemet devices together as a single segment. Switch is smarter than hub to determine the target of the forwarding data.

The primary advantage that a switch has over a hub is the way that bandwidth is distributed. A hub that operates at 10-100 megabits per second (Mbps) must distribute the bandwidth evenly, giving 20 Mbps to each node. A switch, on the other hand, delivers the full 100 Mbps to each node connecting on the network.

Following are the reasons that’s why switch can be used instead of hub in a network

• It can connect multiple segments of a LAN.
• It can filter network traffic.
• Multiple computers can communicate together simultaneously.

Question 3.
The Manager of Bengal Copper Ltd. maintains a table storing its worker details. He wants to get certain outputs from the table for his record analysis. Help him in writing the queries.

Write SQL commands for the following statements.
(i) To display the details of all workers in descending order of DOB.
(ii) To display Name and Desig of those workers whose Plevel is either P001 or P002.
Or
(i) To display the content of all the workers, whose DOB is in between ’19-Jan-1984′ and ’18-Jan-1987′.
(ii) To add a new row with the following data
19, ‘Daya kishore’, ‘Operator’, ‘P003′, ’19-Jun-2008’, ‘ll-Jul-1984′
(i) SELECT * FROM Worker ORDER BY DOB DESC;
(ii) SELECT Name, Desig FROM Worker WHERE Plevel IN (“P001”, “P002”);

Or

(i) SELECT * FROM Worker WHERE DOB BETWEEN “19-JAN-1984” AND “18-JAN-1987”;
(ii) INSERT INTO Worker VALUES (19,’Daya kishore’,’Operator’,
‘P003′,’19-Jun-2008’,
‘ 11 – Jul-1984’);

Question 4.
Blue Men’s organisation maintains its records in different branches but they are not connected. Help them understand the benefits of Internet, so that they can use the Internet services for connecting their branches.
The largest WAN – Internet, is a source of multiple benefits to us. Some of them are listed below

• Connectivity, communication and sharing
• Information, knowledge and learning
• Address, mapping and contact information
• Selling and making money
• Banking, bills and shopping

Question 5.
John a database operator is not able to detect what will be the outputs of the following SQL commands? Help him in his work.
(i) SELECT R0UND(122.982,1);

ROUND( )function rounds a number to certain decimal places as per normal rounding rules. Here, number of decimal places is 1. So, 122.982,1 reduces to 123.0

(ii) SELECT MID( “Applesmartphones”, 7);

The MID() function extracts certain characters from a string from a starting position specified. Here, MID(“Applesmartphones”, 7), extracts characters from position 7 to the end of the string.

Question 6.
Explain to Amitabh how he can use the HAVING clause in specifying conditions with GROUP BY.
The HAVING clause is a group filtering clause much as the WHERE clause is used for filtering individual records. The command
SELECT * FROM Student WHERE perc>=90;
looks at individual records of the Student table and extracts those records where the percentage is >=90 . The command
SELECT Dept, COUNT!*) FROM Emp GROUP BY Dept HAVING C0UNTC*)>5;
displays departments whose number of employees are >5.

Question 7.
Ravi Sharma is a manager in a production house. He has been assigned the job of maintaining a database storing the details of the inventory of his company. He created a table Stock storing the details of the products produced by the company. He also wants to produce some outputs from the table that requires use of the MySQL functions.

He wrote the queries for the same, but is not getting the required outputs. Help him with the proper functions/clauses/statements.

Write proper function names that will be required for the following cases.
(i) To display the date part of the DateofProd.
(ii) To display in uppercase, the Stockld and Prodname concatenated.
Or
(i) To display the monthnames of the production dates.
(ii) To display the highest quantity.
(i) The DAY() function extracts the date part of the date given as parameter.
(ii) The CONCAT() function concatenates two strings and the UPPER()/ UCASE() function converts a string to uppercase.
Or
(i) The MONTHNAME() function returns the name of the month for the month given as parameter to the function.
(ii) The MAX() function returns the maximum value from a set of values in a numeric column in a table.

Section – B
(Each question carries 3 Marks)

Question 8.
Gourik a student of class XII, had missed some of the classes of MySQL functions and is now not able to solve the following output questions. Help him in solving the following queries.
(i) SELECT DAY(‘2015-12-05’),’/’ M0NTH(‘2015-12-05’);
(ii) SELECT YEAR( ‘ 2016-01 -01 ’ )*2;
(iii) SELECT P0W(M0NTH( ‘2020-01-01 ’ )*3,2);
Or
(i) SELECT YEAR( ‘ 2021 -11 -06 ‘), ‘ – ’ ,MONTH(‘ 2020-12-01 ’);
(ii) SELECT DAY (‘ 2011 -09-02 ’), ‘ nd MONTHNAME! ‘ 2011 -09-02 ’);
(iii) SELECT MONTH(‘2018-12-02’)*2;

Question 9.
The admin department of railways maintains a master table of trains. They require certain outputs for their analysis work and are not sure about the commands written. Help them in finding the outputs of the commands.

 Tno Tname T12344 Rajdhani Express T12350 NULL T14459 Himgiri Express T12457 Doon Express T12990 Kalka Mail

Write the outputs of the following SQL statements.
(i) SELECT COUNT(Tname) FROM Train;

(ii) SELECT SUB ST R (Tname, 1,3) FROM Train WHERE Tname LIKE “%ss”;

(iii) SELECT COUNT!*) FROM Train WHERE Tno LIKE “%5%”;

Question 10.
On the basis of the Train table (Q.No. 9), maintained by the railways they want certain more outputs. Help them in finding the outputs of the following queries.
(i) SELECT COUNT!*) FROM Train WHERE Tname IS NULL;

(ii) SELECT I NSTR(Tname, “oo”) FROM Train;

(iii) SELECT LENGTH(Tname) FROM Train WHERE Tname LIKE “%Mail”;

Section – C
(Each question carries 4 Marks)

Question 11.
As per instructions, given to Mr. Singhal, a newly appointed database clerk in M/s Sultan Enterprises, he created and stored the details of the employees in table Emp. Now, his manager wants certain aggregate results department wise and designation wise.

Help him in writing the queries.
(i) Display each department and the number of employees in each.
SELECT Dept, COUNT(*) FROM Emp- GROUP BY Dept;

(ii) Display each designation and the total salary paid to each.
SELECT Desig, SUM(Salary) FROM Emp GROUP BY Desig;

(iii) Display department wise average salary but only if the average is above 25000.
SELECT Dept, AVG(Salary) FROM Emp GROUP BY Dept HAVING AVG(Salary)>25000;

(iv) Display each designation and the maximum and minimum salary paid to each.
SELECT Desig, MAX(Salary) AS “Highest”, MIN(Salary) AS “Lowest” FROM Emp GROUP BY Desig;

Question 12.
Mr. Akashdeep, a clerk of the booking department of the railways maintains a table of ticket booking. He was told by the Accounts manager to produce certain reports according to passengers travelling in different classes. Help him in writing the queries.

(i) To display class wise number of passengers.
(ii) To display the maximum fare for “AC2”.
(iii) To display average fares for journeys in the month of September.
(iv) To find the different travelling classes.
Or
(i) To display class wise total fare.
(ii) To display monthnames of all the journey dates.
(iii) To display day names of journey dates that are on the 1st day of the month.
(iv) To find the minimum fare.
(i) SELECT Class, C0UNT(*) FROM Booking GROUP BY Class;
(ii) SELECT MAX(Fare) FROM Booking WHERE Class=“AC2”;
(iii) SELECT AVG(Fare) FROM Booking WHERE M0NTH(JourneyDate)=09;
(iv) SELECT DISTINCT Class FROM Booking;

Or

(i) SELECT Class, SUM(Fare) FROM Booking GROUP BY Class;
(ii) SELECT M0NTHNAME(JourneyDate) FROM Booking;
(iii) SELECT DAYNAME(JourneyDate) FROM Booking WHERE DAY(JourneyDate)=01;
(iv) SELECT MIN(Fare) FROM Train;

Question 13.
JSW Iron industries has the following buildings for their work. The company has multiple computers in each of the buildings.

 Building Number of Computers Sales 10 Accts 30 Sales 20 HR 300
 Building Distance HR- Sales 45m HR- Accts 15m HR- System 120m Sales-Accts 250m Sales-System 15m Accts-System 600m

Help them to find the answer of the following questions.
(i) Suggest a suitable cable layout of connectivity between the buildings.

Since the HR building has maximum number of computers, if all the other buildings are connected to it, best connectivity will be achieved.

(ii) Is a repeater required, if the buildings Sales and Accts are connected?