Page 1 :
MARKING SCHEME, INFORMATICS PRACTICES (Code: 065), Maximum Marks: 35, , Time: 2 hours, , General Instructions, , , , , , , Q., No, 1., , 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, Each question carries 2 marks, Question, , Part, No., , Differentiation between static and dynamic web pages:, Static Web page, 1. Content of this type of, webpage cannot be changed, at run time., 2. No, interaction, with, server’s, database, is, possible in case of static, web pages., , Dynamic Web page, 1. Content of this type of, webpage can be changed at, run time., 3. Interaction with server’s, database is possible in case of, dynamic web pages., , 1 mark each for each correct differentiation mentioned above, or any other relevant point of differentiation., OR, The difference between a website and a web page is that a, website is a collection of different web pages containing, information on a particular topic. A web page is an individual, page of a big website usually containing more specific, information. If we compare a website with a book, then a, webpage can be compared with a single page of that book., 2 marks for correct answer, [1], , Marks, (2)

Page 2 :
2., , (i), , (ii), , 3., , Cookies, , (1), , 1 mark for correct answer, Name of any two popular web browsers:,  Mozilla firefox,  Google Chrome, OR, Any other correct name, ½ mark each for each correct browser name, Output:, i. 125, ii. 2, , (1), , (2), , 1 Mark for each correct answer, OR, i. power(): It returns the value of a number raised to the power, of another number., For example:, Select power(5,3);, Output: 125, ii. mod(): It returns the remainder of a number divided by, another number., For example:, Select mod(5,3);, Output: 2, , 4., , 1 Mark for each correct answer, Role of web server in hosting a website:, A web server is the main centralized computer system that hosts, and runs the websites. It has a computer program that distributes, web pages as they are requisitioned. The basic role of the web, server is to store, process and deliver the web pages to the users, as and when required., , 2 Marks for correct answer, , [2], , (2)

Page 3 :
5., , 6., , Output:, i) 8.720, ii) 10, , (2), , 1 Mark for each correct answer, Having clause is used to further filter those groups of records (2), which will be generated through group by clause., For example:, Select max(marks) from student group by classes having classes, in (10,12);, Above given query will arrange records in groups according to, the classes. Further filtering on these groups will happen, through having clause, which will finally display the highest, marks from classes 10 and 12., , 7., , 1 Mark for correct clause, 1 Mark for correct example, Mr. Som, a HR Manager in a multinational company “Star-X (2), world” has created the following table to store the records of, employees:, Table: Emp, Eid, EName Department DOB, DOJ, Star1, Ivan, Sales, 1994-08-28 2020-02-14, Star2, Melinda IT, 1997-10-15 2021-11-19, Star3, Raj, Accounts, 1998-10-02 2019-04-02, Star4, Michael Sales, 2000-02-17 2020-05-01, Star5, Sajal, IT, 2001-12-05 2018-06-13, Star6, John, Accounts, 1995-01-03 2019-07-15, Star7, Julia, Sales, 1985-11-13 2020-08-19, Output:, i) 2001, ii) Melinda, 1 Mark for each correct answer, OR, Queries:, [3]

Page 4 :
i) select ENAME,min(year(DOB)) from emp;, ii) select ENAME from emp where month(DOJ)=5;, , 8., , 1 Mark for each correct answer, SECTION – B, Each question carries 3 marks, Output:, i. 11, ii. cbse, iii. exams, , (3), , 1 Mark for each correct answer, OR, i., right(), select right(user_id,2) from hotel;, ii., lower(), select lower(name) from hotel;, iii., mid()/substr()/substring(), Select mid(city,3,3) from hotel;, , 9., , 10., , ½ Mark for suggesting each correct function name, ½ Mark for writing each correct query, i., It returns the current date and time., (3), ii., None, iii., The return type for NOW() function is either in ‘YYYYMM-DD, HH:MM:SS’, format, or, YYYYMMDDHHMMSS.uuuuuu format, depending on, whether the function is used in a string or numeric, context., 1 Mark for each correct answer, i. To remove leading space characters: ltrim(), ii. To remove trailing space characters: rtrim(), iii. To remove both type of space characters: trim(), MySQL Queries:, Select ltrim(‘ Hello ’);, Select rtrim(‘ Hello ’);, Select trim(‘ Hello ’);, Output:, [4], , (3)

Page 5 :
Hello, , 11., , 12., , ½ Mark for suggesting each correct function name, ½ Mark for writing each correct MySQL query, Section C, Each question carries 4 marks, (a) select * from stock order by price desc;, (4), (b) select category, sum(qty) from stock group by category;, (c) select category,avg(price) from stock group by category;, (d) select category, max(price) from stock group by category;, 1 Mark for each correct query, Output:, (a), (b), (c), (d), , (4), , 193, 194, 93.75, 6, , 1 Mark for each correct output, OR, , First query will produce the output 7., Justification: count (*) will count and display total number of, rows (irrespective of any null value present in any of the, column)., Second query will produce the output 6., Justification: count (col_name) will count and display total, number of not null values in the specified column., , 13., , 1 Mark each for each correct output, 1 Mark each for each correct justification, (a) LAN, (4), As computers are placed with-in the same campus within a small range., ½ Mark for correct answer, ½ Mark for correct justification, (b) Star topology, ½ Mark for correct answer, [5]

Page 6 :
Cable Layout:, , ½ Mark for correct cable layout, (c), i. Repeater should be placed in between Block, ‘D’ (Design) and Block ‘P’ as distance is more., ii., Hub/Switch should be placed in each, building to connect various computers, together., ½ Mark for each correct answer, (d) Video Conferencing software: Teams, Zoom, Skype etc., (Any one), Protocol of Video Conferencing software: VOIP, ½ Mark for each correct answer, , [6]