# Class 12 Informatics Practices Sample Paper

Please refer to Class 12 Informatics Practices Sample Paper with solutions provided below. All sample papers for Informatics Practices Class 12 have been designed as per the latest paper pattern issued by CBSE for the current academic year. Students should practice these guess papers for Class 12 Informatics Practices as it will help them to gain more understanding of the type of questions that are expected to be asked in upcoming Class 12 Informatics Practices exams. Please click on the links below to access free CBSE Sample Papers for Class 12 Informatics Practices

Class 12 Informatics Practices Sample Paper Term 2 Set A

Section –A

1. Alisha needs a network device that should regenerate the signal over the same network before the signal becomes tool weak or corrupted.
Chris needs a network device to connect the different networks together that work upon different networking models so that the two networks
can communicate properly.
Chirs → Gateway
OR
A Say, “In this network topology, one malfunctioning node don’t not affect that rest of the network and it is easy to add and remove nodes.”
B Say, “In this network topology, cable length required is less but if the main cable encounters some problem, whole network break down”
B→Bus Topology

2. I : ? am a technology that allow you to make voice calls using a broad band internet connection.
? If you are calling a regular phone number, the signal is converted to regular telephone signal before it call directly from a computer.
Who am I?
(ii) Name any two popular Email Sever name.
(ii) Gmail, Yahoo

3. Predict the output of the following queries:
i. Select round(15.789);
ii. Select mod(15,3);
OR
Briefly explain the purpose of the following SQL functions:
i. power()
ii. instr()

OR
Answer: (i) Power(m,n) function is used to calculate raise to the power of given two parameter, here m is base of number and n is raise to the power of m.
Example – SELECT POWER(2,3); → OUTPUT 8
(ii) INSTR() – Function search the substring in given string and return the value in Numeric.
Example – SELECT INSTR(‘Welcome’, ‘come’);
Output – 4

4. Sahil, a class X student, has just started understanding the basics of Internet and web technologies. He is bit confused in between the terms ‘World Wide Web’ and ‘Internet’. Help him in understanding both the terms with the help of suitable example of each.
Word Wide Web is a set of program standard and protocols that allows the multimedia and hypertext files t be created, displayed and linked on the internet.
eg www.microsoft.com , www.amazon.com etc.
INTERNET is a computer based world wide communications network, whichi is composed of large number of smaller interconnected netoworks.
Eg Web Email, social media etc.
While internet is a collection of computers or networking devices connected together, WWW is a collection of documents, linked via special links called hyperlinks. WWW form a large part of Internet but is not the Internet.

5. Help Reshma in predicting the output of the following queries:
i) select round(8.72,3);
ii) select round(9.8);
i) 102000
ii)

6 .Rohan, is a student of class 12 learning MySQL, he wants to remove leading and training spaces from a character expression X, where X= ‘LEARNING ###MYSQL####’ (#denotes a blank space) and also give the output of X help him with an example.
TRIM function is used to remove all leading and trailing spaces from the given character expression
>EXAMPLE
SELECT TRIM(‘#######LEARNING MY SQL######’)
OUTPUT- LEARNING MY SQL

SECTION – B

8. Predict the output of the following queries:
i. select instr(‘Informatics Practices@2022′,’@’);
ii. select mid(‘Informatics Practices@2022’,6,5);
iii. select left(‘ Informatics Practices@2022’,6);
i. 22
ii. matics
iii. Inform
OR
Ms.Anjali is working on a MySQL table named ‘Payment’ having following structure:

he need to perform following task on the table:
i. To fetch First 5 characters from the EMP_NAME column.
ii. To display the Annual Salary with Emp_Name.
iii. To display EmpID with Name .
Suggest suitable SQL function for the same. Also write the query to achieve the desired task.
OR
i. left()
select left(EMP_NAME,5) from payment;
ii. select EMP_NAME, Salary*12 ‘Annual Salary from
Payment;
iii. SELECT EMPID,
EMP_NAME from Payment;

9. Ritu is working with functions of MySQL. Explain her following:
i. To display the name of the month of the current date.
ii. To remove spaces from beginning and end of the string “ Panaroma ”
iii. To compute the remainder of division between two numbers n1 and n2
ii. SELECT TRIM(‘ Panaroma ’);
iii. SELECT MOD(n1,n2);

10.What are the aggregate function SQL, Explain 2 aggregate function with an example?
Answer: Aggregate Function works on multiple row and return a Single row as a output it is also known as group function.
SELECT SUM(SALARY) FROM PAYMENT;
Count() – Its count number of rows/records for specific condition
SELECT COUNT(*) FROM PAYMENT WHERE
DEPARTMENT = ’HRD ’;

Section – C

11. Consider the table FANS.

Write MySQL queries for the following questions.
(a) To display the details of fans in descending order of their DOB.
(b) To display the details of FANS who does not belong to AJMER.
(c) To count the total number of fans of each fan mode
(d) To display the DOB of the youngest fan.
Answer:  (a) SELECT * FROM FANS ORDER BY
DOB DESC;
(b) SELECT * FROM FANS WHERE
FAN_CITY <> ‘AJMER’;
(c) SELECT FAN_MODE, COUNT(*)
FROM FANS GROUP BY
FAN_MODE;
(d) SELECT MAX(FAN_DOB) FROM
FANS;

12. Reena, a database analyst has created the following tables
TABLE : EMP

TABLE : DEPARTMENT

She has written following queries :
(a) SELECT COUNT(*), DEPTCODE FROM EMP GROUP BY DEPTCODE HAVING COUNT>1;
(b) SELECT COUNT(DISTINCT DEPTNAME) FROM DEPARTMENT;
(c) SELECT ENAME,DEPTNAME FROM EMP E, DEPARTMENT WHERE E.DEPTCODE=D.DEPTCODE AND EMPNO<104;
(d) SELECT MIN(DOJ), MAX(DOB) FROM EMP; Help her to predict the output of the above given queries
OR
Identify the above both the Table Primary Key and Foreign Key.
What are the cardinality and degree of the above both tables.

(b)

(c)

(d)

OR
EMP TABLE – Primary Key→ EMPNO
FOREIGN KEY → DEPTCODE
DEPT TABLE – Primary Key – DEPTCODE
CARDINALTY OF EMP TABLE→  07, DEPT TABLE→ 05
DEGREE OF EMP TABLE→ 06, DEPT TABLE→ 03
Answer: EMP TABLE – Primary Key EMPNO
FOREIGN KEY DEPTCODE
DEPT TABLE – Primary Key – DEPTCODE
CARDINALTY OF EMP TABLE 07, DEPT TABLE05
DEGREE OF EMP TABLE06, DEPT TABLE03

13. Bhartiya Connectivity Association is planning to spread their offices in four major cities of India to provide regional IT infrastructure support in the field of education and culture.
The company has planned to setup their head office in New Delhi in three locations and have named their New Delhi offices as Front office, Back Office and Work Office. The company has three regional offices as three major cities of India. A rough layout of the same is as follows:

Approximate distance between these offices as per network survey team is as follow :

In continuation of the above, the company experts have planned to install the following number of computers in each of their offices.

(i) Suggest the network type (out of LAN,MAN,WAN) for connecting each of the following set of the their offices.
(a) Back office and work office
(b) Back office and south office
(ii) Which device will you suggest to be procured by the company for connecting all the computers with each of their offices out of the following devices?
(a) Switch/Hub
(b) Modem
(c) Telephone south office, East Office and West Office located in New Delhi
(iii) Suggest the cable/wiring layout for connecting the compnay’s local offices located in New Delhi. Also, suggest an effective method for connecting the company’s regional office with offices located in New Delhi.
Answer: (i) (a) The Type of network between the Back Office and the Work Office is LAN (Local Area Network)
(b) The type of network between the Back office is WAN (Wide Area Network).
(ii) (a) The suitable device for connecting all the computers in each of their office is switch/hub.
iii)The suggested layout for connection is as follows :