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.
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”
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?
(ii) Name any two popular Email Sever name.
Q.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 ()
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.
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.
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’;
(ii) select Department, Count (*) from Doctor Group By Department;
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.
(ii) To display the name of each department along with total salary being given to doctors of that department.
SECTION B
Q.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);
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.
(ii) To display the Annual Salary with Emp_Name.
(iii) To display EmpID with Name.
Q.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
Q.10. What are the aggregate function SQL, Explain 2 aggregate function with an example?
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
(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
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;
(b) SELECT COUNT (DISTINCT DEPTNAME) FROM DEPARTMENT;
(c) SELECT ENAME, DEPTNAME FROM EMP E, DEPARTMENT D
WHERE E.DEPTCODE=D.DEPTCODE AND EMPNO<104;
(d) SELECT MIN(DOJ), MAX(DOB) FROM EMP;
OR
Identify the above both the Table Primary Key and Foreign Key. What are the cardinality and degree of the above both tables?
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
(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 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.