SAMPLE QUESTION PAPER (2021-22)
INFORMATICS PRACTICES (065)
TERM II
CLASS 12
Time: 2 Hrs Max. Marks: 35
GENERAL INSTRUCTIONS
• The question paper is divided into 3 sections – A, B and C
• Section A has 7 Questions (1-7). Each question carries 2 marks.
• Section B has 3 Questions (8-10). Each question carries 3 marks.
• Section C has 3 case-based Questions (11-13). Each question carries 4 marks.
• Internal choices have been given for question numbers 1, 3, 8 and 12.
SECTION A
Q.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.
Ans. Alisha à Repeater
Chris à 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”
Ans. A à Star Topology
B à Bus Topology
Q.2. (i) 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?
Ans. VOIP
(ii) Name any two popular Email Sever name.
Ans. Gmail, Yahoo
Q.3. Predict the output of the following queries:
i. SELECT ROUND (15.789);
Ans. 16
ii. SELECT MOD (15, 3);
Ans. 0
OR
Briefly explain the purpose of the following SQL functions:
i. POWER ()
Ans. 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 ()
Ans. INSTR () – Function search the substring in given string and return the value in Numeric.
Example – SELECT INSTR (‘Welcome’, ‘come’); Output – 4
Q.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.
Ans. 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 worldwide communications network, which is composed of large number of smaller interconnected networks.
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.
Q.5. Help Reshma in predicting the output of the following queries:
i) SELECT ROUND (8.72, 3);
ii) SELECT ROUND (9.8);
Q.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.
Ans. 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
Q.7. Mr. Rohan, a HR Manager in a Vedanta Hospital has created the following table to store the records of Doctor:
He has written following queries. Predict the output.
(i) select SUM(Salary) from Doctor where Department =’Surgery’;
Ans. 102000
(ii) select Department, Count (*) from Doctor Group By Department;
Ans.
OR
Based on the table given above, help Mr. Rohan writing queries for the following task:
(i) To display the names and salaries of doctors in descending order of salaries.
Ans. SELECT DOCName, Salary FROM DOCTOR ORDER BY SALARY DESC;
(ii) To display the name of each department along with total salary being given to doctors of that department.
Ans. SELECT DEPARTMENT, SUM(SALARY) FROM DOCTOR GROUP BY DEPARTMENT;
SECTION B
Q.8. Predict the output of the following queries:
i. SELECT instr (‘Informatics Practices@2022′,’@’);
Ans. 22
ii. SELECT mid (‘Informatics Practices@2022’,6,5);
Ans. matics
iii. SELECT left (‘ Informatics Practices@2022’,6);
Ans. Inform
OR
Ms. Anjali is working on a MySQL table named ‘Payment’ having following structure:
She need to perform following task on the table. Suggest suitable SQL function for the same. Also write the query to achieve the desired task.
(i) To fetch First 5 characters from the EMP_NAME column.
Ans. left ()
select left(EMP_NAME,5) from payment;
(ii) To display the Annual Salary with Emp_Name.
Ans. select EMP_NAME, Salary*12 ‘Annual Salary from Payment;
(iii) To display EmpID with Name.
Ans. SELECT EMPID, EMP_NAME from Payment;
Q.9 Ritu is working with functions of MySQL. Explain her following
i. To display the name of the month of the current date.
Ans. SELECT MONTH (NOW ());
ii. To remove spaces from beginning and end of the string “Panaroma”
Ans. SELECT TRIM (‘ Panaroma ’);
iii. To compute the remainder of division between two numbers n1 and n2
Ans. SELECT MOD(n1, n2);
Q.10. What are the aggregate function SQL, Explain 2 aggregate function with an example?
Ans. Aggregate Function works on multiple row and return a Single row as a output it is also known as group function.
Sum () – It is return Total of Given particular numeric Column.
SELECT SUM(SALARY) FROM PAYMENT;
Count () – Its count number of rows/records for specific condition
SELECT COUNT(*) FROM PAYMENT WHERE DEPARTMENT = ’HRD ’;
SECTION C
Q. 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
Ans. SELECT * FROM FANS ORDER BY DOB DESC;
(b) To display the details of FANS who does not belong to AJMER
Ans. SELECT * FROM FANS WHERE FAN_CITY <> ‘AJMER’;
(c) To count the total number of fans of each fan mode
Ans. SELECT FAN_MODE, COUNT (*) FROM FANS GROUP BY FAN_MODE;
(d) To display the DOB of the youngest fan
Ans. SELECT MAX(FAN_DOB) FROM FANS;
Q.12. Reena, a database analyst has created the following tables
She has written following queries. Help her to predict the output of the above given queries
(a) SELECT COUNT (*), DEPTCODE FROM EMP GROUP BY DEPTCODE HAVING COUNT>1;
Ans.
(b) SELECT COUNT (DISTINCT DEPTNAME) FROM DEPARTMENT;
Ans.
(c) SELECT ENAME, DEPTNAME FROM EMP E, DEPARTMENT D
WHERE E.DEPTCODE=D.DEPTCODE AND EMPNO<104;
Ans.
(d) SELECT MIN(DOJ), MAX(DOB) FROM EMP;
Ans.
OR
Identify the above both the Table Primary Key and Foreign Key. What are the cardinality and degree of the above both tables?
Ans. 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
Q.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 their offices.
(a) Back office and work office
Ans. The Type of network between the Back Office and the Work Office is LAN (Local Area Network)
(b) Back office and south office
Ans. The type of network between the Back office is WAN (Wide Area Network).
(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
Ans. The suitable device for connecting all the computers in each of their office is 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 company’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.
Ans. The suggested layout for connection is as follows:
