Series : %BAB% SET-4 Fa Fs QP.Code 90 ise Candidates must write the QP. Code om NO on the title page of the answer-book. eianiinsineineineinineaensanineimaniinsaneneaamaneensmanimanenaneanes Please check that this question paper contains 8 printed pages. QP. Code given on the right hand side of the question paper should be written on the title page of the answer-book by the candidate. Please check that this question paper contains 13 questions. Please write down the Serial Number of the question in the answer-book before attempting it. 15 minutes, time has been allotted to read this question paper. The question paper will be distributed at 10.15 a.m. From 10.15 a.m. to 10.30 a.m., the candidates will read the question paper only and will not write any answer on the answer-book during this period. * {SAGOPA H ENGI AEONE HGH I COMEH HORII pone ERR RRR RE RSME RE REMMI i INFORMATICS PRACTICES ||| Time allowed : 2 hours Maximum Marks : 35 90 Page 1 P.T.O.General Instructions () This question paper is divided into 3 Sections — A, Band C. (ii) Section A, consists 7 questions (1-7). Each question carries 2 marks. (iii) Section B, 3 marks. (iv) Section ©, 4 marks. consists 3 questions (8-10). Each consists 3 questions (11-13). Each question carries question carries (v) Internal choices have been given for question numbers — 1, 3, 7, 8 and 12. SECTION- A (Each question carries 2 marks) 1. Rushil thought “WWW” and “Internet” are synonyms ic., they meant same and can be used interchangeably. But the teacher said that they are not same. Help him to understand the meaning of both the terms with the help of a suitable example of each. OR What are Cookies ? How can we disable Cookies ? 2. (i) What is the function of a Gateway ? (i) Give examples of any two plug-ins. 3. Find the output of the following SQL Queries () | SELECT ROUND (7658.345,2); (i) SELECT MoD(ROUND (13.9,0),3); OR Give any two differences between the POWER( ) and SUM( ) SQL. functions. 4. Give one advantage and disadvantage each of Bus and Star topology. 5. Find the output of the following SQL queries @ SELECT suBsTR(‘FIT INDIA MOVEMENT’,5); (i) SELECT INsTR(‘ARTIFICIAL INTELLIGENCE’, “IA”); oo MIN Page 2Srikanth created the following table STUDENT in his database. 2 ‘Table : STUDENT RollNo Name Class | Marks 1 Ritika 2 2 | Angad 12 3 | Kaveri ray 4 [Lalitha | 12 21 | 5 | Daniel ray 44 6 Rabindra ul 39) 7 |Rabia i 28 He now wants to count number of students in each class where the number of students is more than 3. He has executed the following query SELECT MAX(Marks) FROM STUDENT WHERE COUNT(*)>3 GROUP BY Class; But, he got an error. Identify the error(s) and rewrite the query. A underline the correction(s) done. 7. Ms. Mohini is working in a school and stores the details of all students in a table SCHOOLDATA. 2 TABLE : SCHOOLDATA Admno Name Class | House | Percent |Gender| Deb 20150001 | Aditya Das 10 | Green 86 [Male —_ | 2006-02-20 20140212 |HarshSharma| 11 | Red 75 |Male — | 2004-10-05 20090234 | Swapnil Pant | 10 | Yellow| 84 | Female | 2005-11-21 20130216 | Soumen Rao 9 | Red 91 |Male | 2006-04-10 20190227 | Rahil Arora 10 | Blue 70 2005-05-14 20120200 | Akasha Singh | 11 | Red 64 [Female | 2004-12-16 Write SQL statements from the above given table to (i) To remove leading spaces from the column Name. (i) Display the names of students who were born on Sunday. OR oo MIN Page 3 P10.9. 90 Predict the output of the following SQL queries from the given table : SCHOOLDATA (@) SELECT MAX(Percent) FROM SCHOOLDATA; (i) seLEcr LEFT(Gender,1)Name FROM SCHOOLDATA WHERE YEAR (Dob)=2005; SECTION - B (Each question carries 3 marks) Predict the output of the following SQL queries @) senecr TRIM(’ ALL THE BEST ”); (i) SELECT POWER(5,2); (ii) SELECT UPPER (MID(‘start up india”,10)) OR Consider a table “MYPET” with the following data : Table : MYPET Pet_id | Pet_Name Breed LifeSpan | Price | Discount 101 _| Rocky Labrador Retriever 12 16000 5 202 | Duke German Shepherd 13 22000 10 303 _| Oliver Bulldog 10 18000 7 404 | Cooper Yorkshire Terrier 16 20000 12 505__| Oscar Shih Tzu NULL _| 25000 8 Write SQL queries for the following () Display the Breed of all the pets in uppercase. (i) Display the total price of all the pets. (ii) Display the average life span of all the pets. Write the names of SQL functions to perform the following operations (Display name of the Month from your date of birth. (i) Convert email-id to lowercase. ii) Count the number of characters in your name. NUE Page 410. Consider the following table : PRODUCT 3 PID QUANTITY P1001‘ | Eraser 5 P1002 ‘| Ball Pen 15.00 2 P1003 | Gel Pen 25.10 3 P1004 | Ruler 5.00 1 Find the output of the following SQL queries : () SELECT 10+MoD(QUANTITY,3) FROM PRODUCT WHERE PNAME = “Eraser”; (i) SELECT ROUND(PRICE,2)*QUANTITY FROM PRODUCT WHERE QUANTITY > 2; (ii) SELECT UCASE(RIGHT(PNAME,2)) FROM PRODUCT; SECTION - C (Each question carries 4 marks) 11. Consider the table : TEM 4 ‘Table : ITEM SNo | Itemname Type Price Stockdate 1 | Chaises Living 11500.58. 2020-02-19 2 | Accent Chairs | Living 31000.67 2021-02-15 3 |BakerRacks |Kitchen | 25000.623 | 2019-01-01 4 | Sofa Living 7000.3 2020-10-18 5 [Nightstand [Bedroom | NULL 2021-07-23, Write SQL queries for the following (Display all the records in descending order of Stockdate. (i) Display the Type and total number of items of each Type. (ii) Display the least Price. (iv) Display the Itemname with their price rounded to 1 decimal place. oo MIN Page 5 P10.12. 13, 90 Consider the following table : ‘Table : SALESMAN Scode| Sname Area Qtysold | Dateofjoin Soo1 | Ravi North. 120 2015-10-01 $002 [Sandeep | South 105 2012-08-01 $003 | Sunil NULL 68 2018-02-01 $004 | Subh West 280 2010-04-01 $005 | Ankit East 90) 2018-10-01 S006 [Raman North. NULL 2019-12-01 Predict the output for the following SQL queries : () SELECT MAX(Qtysold), MIN(Qtysold) FROM SALESMAN; Gi) SELECT CouNT (Arca) FROM SALESMAN; (ii) SELECT LENGTH (Sname) FROM SALESMAN WHERE MONTH Dateofjoin)=10; (iv) SELECT Sname FROM SALESMAN WHERE RIGHT(Scode, 1) OR Based on the given table SALESMAN write SQL queries to perform the following operations : (i) Count the total number of salesman. (i) Display the maximum qtysold from each area. (ii) Display the average qtysold from each area where number of salesman is more than 1 (iv) Display all the records in ascending order of area. ABC International School, Delhi has different wings Administrative Wing (WI), Primary Wing (W2), Middle Wing(W3) and Secondary Wing(W4) as shown in the diagram a™. % ~y 1UMB, BRANCH SECONDARY WING (Wa) ‘The school also has a branch in Mumbai, The school management wants to connect all the wings as well as all the computers of each wing (W1, W2, W3, W4) NUE Page 6ee Distance between the wings are as follows : W3 to W1 85m W1 to W2 W2 to W4 W4 to W3 W3 to W2 W1 to W4 Number of computers in ving Wi 125 w2 40 wa. 42 wa 60 Based on the above specifications, answer the following questions : () Suggest the topology and draw the most suitable cable layout for connecting all the wings of Delhi branch. (i) Suggest the kind of network required (out of LAN, MAN, WAN) for connecting (@) Administrative Wing (W1) with Middle Wing (W3) () Administrative Wing (W1) with the Mumbai branch. (ii) Suggest the placement of the following devices with justification : (a) Repeater () Switch/Hub (iv) Due to pandemic school had to adopt Online classes. Suggest the protocol that is used for sending the voice signals over internet. Also, give an example of an application of WWW that helped the teachers to send messages instantly to the students. oo MIN Page 7ae oo MIN Page 8