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

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

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

Time: 2 Hours
Maximum Marks: 35

General 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 [2 Marks each]

Question 1.
Anish a freelance Network engineer has been assigned the task to design a Network for an Office.
Help Anish by clearly differentiating between star topology and bus topology on at least two points so, that he can decide which is to be implemented. [2]
OR
Debika, a beginner in IT field has just started learning networking- technologies. Help her in understanding the difference between LAN and WAN. [2]
Answer:

Star Topology	Bus Topology
(i) All nodes are directly connected with the central node or server.	(ii) There is a single length of transmission medi­um, on which various nodes are attached and the server can be any-where in the transmis­sion cable
(ii) Easy to detect faults.	(ii) Faults cannot be detected easily.

OR

LAN (Local Area Network)	WAN (Wide Area Network)
It is owned by a private organisation.	Multiple organisations can sub­scribe to a WAN.
Spans for less than a few kms.	Spans over a large area usually an entire city.

Question 2.
(i) I:
(a) am a network device.
(b) more useful in connecting LAN with the internet.
(c) I can convert the digital signal into an analog signal and vice versa.
Who am I?
Answer:
Modem

(ii) Name any two popular network topologies. [2]
Answer:
Ring Topology & Star Topology

Question 3.
Predict the output of the following queries: [2]
(i) SELECT MONTH (‘2022-01-12’);
(ii) SELECT YEAR (‘2022-01-10’);
OR
Briefly explain the purpose of the following SQL functions:
(i) MONTH()
(ii) YEARQ
Answer:
(i) 1
(ii) 2022

OR

MONTH() : This function returns the month, in the range 1 to 12 for January to December, for date Syntax: SELECT MONTH (date) e.g., SELECT MONTH (‘2020-07-28’);
Output 7

YEAR() : This function returns the year of the given date. It returns a year value in the range 1000 to 9999. If the date is zero, it returns 0.

Syntax: SELECT YEAR(date)
e.g., mysql > SELECT YEAR (‘2020-07-28’);
Output
2020

Commonly Made Error: Many a times students provide date in wrong format as argument.

Answering Tip: Always remember that the correct date format is “yyyy-mm-dd”

Question 4.
Ayus wants to create a network environment for his company. Briefly discuss the role of a Topology in a Networked Communication. [2]
Answer:
Network topology refers to the manner in which the links and nodes of a network are arranged to relate to each other. Physical network topology examples include star, mesh, tree, ring, point-to- point, circular hybrid, and bus topology networks, each consisting of different configurations of nodes and links. Network topology refers to the manner in which the links and nodes of a network are arranged to relate to each other. Physical network topology examples include star, mesh, tree, ring, point-to-point, circular, hybrid, and bus topology networks, each consisting of different configurations of nodes and links.

Commonly Made Error: Students mix Topology with LAN.

Answering Tip: Network topology is the arrangement of the elements of a communication network.

Question 5.
Help Arnit in predicting the output of the following queries:
SELECT M3D(‘MY SQL DBMS’, 4, 3);
SELECT ROUND(-85.2365,2) [2];
Answer:

Question 6.
Armaan, a database administrator, has sorted the records of a table with the help of Order by clause. By default the result is sorted in Ascending order. He needs to display records in Descending order. Suggest suitable clause for it and properly explain its usage with the help of an example. [2]
Answer:
He needs to use DESC Keyword along with Order By.
The ORDER BY keyword is used to sort the result-set in ascending or descending order.
The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.
Syntax
SELECT columnl, column2,… FROM table name ORDER BY columnl, column2,… ASCI DESC; for example, to sort the table ‘student’ in descending order on the basis of student’s name th command will be:
SELECT * FROM student ORDER BY stud_name DESC.

Question 7.
Observe the table ‘Club’ given below:

(i) SELECT MAX(Fees) FROM Club WHERE LENGTH(Member_Name )=5;
(ii) SELECT AVG(Fees) FROM Club WHERE LEFT(Member_Name,2) LIKE ‘Ni%’;
OR
Based on the table given above, write the queries for the following:
(i) To display the Total fees amount for all the members.
(ii) To display the minimum age of those employees who’s Fees is more than 3000. [2]
Answer:
(i) 3500
(ii) 2800
OR
(i) SELECT SUM(FEES) FROM Club;
(ii) SELECT MIN(Age) FROM Club WHERE FEES >3000;

Section – B [3 Marks each]

Question 8.
Predict the output of the following queries:
(i) SELECT TRUNCATE (192.672, -1);
(ii) SELECT SUBSTR(‘My Python Language’,11,4);
(iii) SELECT MONTHNAME (‘2020-11-28’);
OR
Ms.Bose is working on a MySQL table named ‘Mobi_Shop’ having following structure:

She needs to perform following tasks on the table:
(i) To fetch FIRST 3 characters from the BNAME column for SLNO = 2.
(ii) To display the values of BNAME column in lower case.
(iii) To display average Price of all mobiles which are manufactured in the year 2021.
Suggest suitable SQL function for the same. Also write the query to achieve the desired task. [3]
Answer:
(i) 190
(ii) Lang
(iii) November

Commonly Made Error: Students start to write output from the next character as specified in the argument, like in this case select substr(‘My Python Language’,11,4); 11th character is ‘L’ but students may start from ‘a’.

Answering Tip: in substr() start argument indicates the number of the character from which extracting is to start.

OR

(i) LEFT()
SELECT LEFT(BNAME,3) FROM Mobi_Shop WHERE SLNO=2;
(ii) LOWER()/lcase()
SELECT LOWER(BNAME) FROM Mobi Shop;
or
SELECT LCASE(BNAME) FROM Mobi_Shop;
(iii) AVG()
SELECT AVG(PRICE) WHERE YEAR(DOM)=’2021′;

Question 9.
Sumit is working with functions of MySQL. Explain him the following:
(i) What is the purpose of DAYNAME0 function?
Answer:
The DAYNAME() function returns the name of the weekday for a given date.

(ii) How many parameters does it accept?
Answer:
It will accept only one parameter of DATE type (‘YYYY-MM-DD’).

(iii) What is the general format of its return type?
Answer:
Its return type is VARCHAR.

Question 10.
While dealing with DATE data type in MySQL, How to know which day of the month is represented by the given date? Explain with an example. [3]
Answer:
The DAYOFMONTH0 function returns the day of the month for a given date (a number from 1 to 31).
Note: This function equals the DAYQ function.

Syntax:
DAYOFMONTH(date)
here date is the date for which the day is required.
EXAMPLE:-
SELECT DAY(‘2022-01-25’);
25
SELECT DAYOFMONTH(‘2022-01-25’);
25

Commonly Made Error: Students get confused in the Date format. Correct format is YYYY-MM-DD

Answering Tip: Student should learn all the date type functions with their syntax and example.

Section – C [4 Marks each]

Question 11.
Carefully observe the following table named ‘Teacher’:

Write SQL queries for the following:
(i) To display the records in decreasing order of Age.
Answer:
SELECT * FROM Teacher ORDER BY Age DESC;

(ii) To display Department and Department wise total number of teachers.
Answer:
SELECT Department, COUNT(TID) FROM Teacher GROUP BY Department;

(iii) To display the Department wise average Salary.
Answer:
SELECT Department, AVG(Salary) FROM Teacher GROUP BY Department;

(iv) To display the sum of maximum Salary and minimum salary with the heading Max_Min. [4]
Answer:
SELECT MAX(Salary)+MIN(Salary) AS ‘Max Min’ FROM Teacher;

Question 12.
Deepika, a database analyst has created the following table: Stock

She has written following queries:
(i) select Tr a nsaction Type ,sum(Amount) from Stock Group By Transaction Type;
(ii) select Avg(Amount) from Stock Group By Transaction_Type Having Amount> 15000 ;
(iii) select County) from Stock where Cname Like ‘A%’;
(iv) select Cname, length(Cname) from Stock where Transaction_Type = “Debit”;
Help her in predicting the output of the above given queries. [4]
OR
Based on the above given table named ‘Stock’, Deepika has executed following queries:
Select INSTR(Cname,”ltd”) from Stock Where Trans_Id=” TrOOl”;
Select SUBSTR(Cname,”ltd”) from Stock Where Trans_Id=” TrOOl”;
Predict the output of the above given queries.
Also give proper justifications of the output generated through each query. [4]
Answer:
(i) Credit 61000
Debit 59000

(ii) 23000
29500

(iii) 2

(iv) Zean lnfotech 13
APPcom 7

OR

Select INSTR(Cname,”ltd”) from Stock Where Trans_Id=” TrOOl”;
Output:-5
The INSTR() function returns the position of the first occurrence of a string in another string.
This function performs a case-insensitive search.
Syntax: INSTR(string 1, string2)

string 1 The string that will be searched
string 2 The string to be searched for in stringl. If string2 is not found, this function returns 0. Select SUBSTR(Cname/Ttd”) from Stock Where Trans Id=” TrOOl”;
Output:- This query will display Error because of the improper syntax of SUBSTR() function.
The SUBSTRO function extracts a substring from a string (starting at any position).
Note: The SUBSTRQ and MID() functions equals to the SUBSTRING() function.
Syntax: SUBSTR(string, start, length)

Question 13.
Quick Learn University is setting up its Academic blocks at Prayag Nagar and planning to set up a network. The university has 3 academic blocks and one Human Resource centre as shown in the diagram below : [4]

Center to centre distance between various blocks/ center is as follows:

Law block to Business block	40 mt
Law block to Technology block	80 mt
Low block to HR center	105 mt
Business block to Technology block	35 mt
Business block to HR center	35 mt
Technology block to HR center	15 mt

Number of computers in each of the blocks/center as :

Law Block	15
Technology Block	40
HR Cent	115
Business Block	25

(i) Suggest the most suitable place to install the server of this university with a suitable reason.
Answer:
The most suitable place to house the server of this organisation would be HR center as this place contains the maximum number of computers.

(ii) Suggest an ideal layout for connecting these blocks/center for a wired connectivity.
Answer:

(iii) Which device will you suggest to be placed/installed in each of these blocks/center to efficiently connect all the computers within these blocks/center ?
Answer:
There is no need for a repeater as the distance between two nodes is not much. But Hub/ switch would be required in all the blocks, to interconnect the computers in each block.

(iv) The university is planning to connect its admission office in the closest city which is more
than 250 km away from university, which type of network out of LAN, MAN or WAN will be formed ? Justify your answer.
Answer:
Since the distance between university and admission office is too large (250 kms), so WAN (Wide Area Network) would be used to connect university to admission office.