SET i KENDRIYA VIDYALAYA SANGATHAN, ERNAKULAM REGION INFORMATICS PRACTICES (065) SAMPLE QUESTION PAPER - (2022 - 23) Class XII Max Marks: 70 Time: 3 hrs General Instructions: 1. This question paper contains five sections, Section A to E. | 2. All questions are compulsory. | Section A have 18 questions carrying 01 mark each. Section B has 07 Very Short Answer type questions carrying 02 marks each. Section C has 05 Short Answer type questions carrying 03 marks each Section D has 03 Long Answer type questions carrying 05 marks each. Section E has 02 questions carrying 04 marks each. One internal choice is given in Q35 against part C only. | 8. All programming questions are to be answered using Python Language only. PARTA Given a Pandas series called S, the command which will display the last 4 rows is print(S.tail(4)) print(s.Tail()) print(s.tails(4)) print(s.tail(4)) are messages that a web server transmits to a web browser so that the web server can keep track of the user's activity on a specific website a text b. cookies c. email d. chat 3. | The trim(function in MySql is an example of. a. Math function ; NAUELN leva poop 0 b. Text function c. Date Function d. Aggregate Function 4 | The__command can be used to insert a new row in a table in SQL. a. add() b. append c. insert into d. alter table. 3 | State whether True or False i. Copying and pasting data from internet or other ii, E-waste is very hazardous if not handled carefully. 6 [Rohan wants to print the row labels of the dataframe, He should use the attribute of a dataframe. ital resources is ethical, 157a. column b. columns c. index d, rowname Write the output of the following SQL command. select pow(2,-2); a -4 b. 4 ©. 0.25 d. -0.25 What is e-waste? (a) electronic waste (b) environmental waste (©) earth waste (d) energy waste What will be the output of the following code? mysql> Icase (INFORMATICS PRACTICES CLASS 12TH), 10 "Which of these is not an example of unguided media? (i) Optical Fibre Cable (ii) Radio wave (iii) Bluetooth (iv) Satellite i Stealing someone’s intellectual work and representing it as your own is known as. a. Phishing b. Spamming . plagiarism hacking 12 Which of the following is not the correct aggregate functions in SQL. (a) AVERAGEQ. (bs) MAX()_—(c) COUNT) (d) TOTALO 13 A URL can specify the IP address of the Web that houses a Web page? a) server b) client c) e-mail recipient d) None 14 ; Tare the records and traces that are left behind while internet is used. a) Digital data b) Digital Footprint ©) Data Protection d) Plagiarism 15 Clause is used. To mention conditions along with group by function..... a)Where b)having c)distinct __d)select. 16 Thilmalini has stolen a credit card, She used that credit card to purchase a laptop. What type of offence has she committed? a. online fraud b. cyber bullying 158©. cyber stalking d. All of the above 17 QI7 and 18 are ASSERTION AND REASONING based questions. Mark the correct choice as i Both A and R are true and R is the correct explanation for A ii. Both A and R are true and R is not the correct explanation for A iii A is True but R is False iv. _Ais false but R is True ae Assertion (A): import matplotliblib pyplot as pit is used to import pyplot Reason (R) ‘It is python library so it is imported for using its function 18 | Assertion (A):- Series store data row wise. | Reasoning (R): - A Series is a one-dimensional labelled data structure, SECTION B 19 | Consider a given Series , TI | SUB1 45 SUB2 suB3 ‘'SUB4 89 | Write a program in Python Pandas to create the series: OR Define Series. Write a python statement to create an empty statement. 20] Rohit writes the following commands with respect to a table student having fields, Sno, | name, Age, fee. Command] : Select count(*) from student, ‘Command2: Select count(name) from employee; he gets the output as 6 for the first command but gets an output 5 for the second command. Explain the output with justification 0 21 Consider the following Series object, C_amt Mouse 135 Keyboard 260 Pen drive 80 cD 155 i. Write the command which will display the name of the items having amount <100. ii, Write the command to name the series as comp_items. v 22 Consider the following DataFrame, Student Rolino Name Class Section Marks is)i, Add a new column ‘Percentage’ to the Data frame. = ii. Add a new row with values (5, Rohit XI, A ,98,Science) Expand the following terms related to Computer Networks: a. HTTP b. POP3 core | 4.VolP OR Differentiate between static and dynamic web pages | Considering the same string “Computer” | Consider the following SQL string: “Computer” Write commands to display: OR Write SQL commands to display a, The position of the substring ‘ter’ in the string “Computer”. b.The first 5 letters of the string. 25 List any two health problems related to excessive use of Technology. I 0] SECTION C Cconsider two objects s and t.s is alist whereas tis a Series. Both have values 20,40, | 90, 110. What will be the output of the following two statements considering that the above objects have been created already a. print (s*2) b. print(t*2) Justify your answer. 27 Consider the Table “Infant” shown below. ‘Table: Infant [xtemcode | item DatePurchase |unitPrice|Discount | 102 Frock 2016-01-23 [700 10 Cot 2015-09-23 [5000 \25, Bott Toy [2016-06-17 [800 20 2014-10-16 : NOTE: Discount column stores discount %. Write SQLcommands to: a. To displays the number of items that have more than 10% as discount. b. To display the highest unit price of items. c. To display the names of items that has “Baby” anywhere in their item names. 28 Write a Python code to create a DataFrame with appropriate column headings from the list 160iven below {[21101 'MANJUSH’,S8},{21 102, AKSHAY',60},[21103,'ANN’ ,76] [21104,NITHYA’48]] What are the different ways in which authentication of a person can be performed? OR |_ Describe measures to recycle your e-waste. 30| Predict the output of the following queries 3 D _ SELECT INSTR (‘Very good’, 'good’); T) SELECT MID(Quadratically’,5,6); M1) SELECT RIGHT (*Command’ 3); | OR Explain the following SQL functions using suitable examples. a) INSTRO b) MIDQ) c) RIGHT() SECTION D | 31 | Consider the following graph. Write the code to plot it. 3 32| A company AST Enterprises has 4 wings of buildin; Cesc Coat Sansea baess Wine Eee nn te nara T3 to Tl - 50m Tl w T2 - 60m T2 w T4 - 25m T4 to T3- 170m T3 w 12 - 125m 161TltoT4-90m Number of computers in each of the wing: Tl - 140, T2-15 13-15 4-25 Computers in EXoH WINE ATE HENVOTRET DUT WINGS Are TOT METWorked The company has now decided to connect the wings also i. Suggest a most suitable cable layout for the above connections. ii. Suggest the most appropriate topology of the connection between the wings. ifi, ‘The company wants internet accessibility in all the wings. Suggest a suitable technology. iv. Suggest the placement of the following devices with justification if the company wants minimized network traffic a) Repeater b)Hub / switch ¥. The company is planning to link its head office situated in Pune with the offices in hilly areas. Suggest a way to connect it economical! 33 ‘Write the SQL functions which will perform the following operations i) To display the current date i) To display the substring “earn” from the whole string ‘LearninglsFun’. iii) To round the number 76.384 up to 2 place after decimal point. iv) _ To find the position of first occurrence of ‘R’ in string INFORMATION FORM’ v) To find out the result of 9. OR Consider a table Order with the following data: Write SQL queries using SQL functions to perform the following operations: i) To count the number of orders booked by Salespersons with names starting with “R’. ii) Display the position of occurrence of the string “an” in SalesPerson names, iii) Display the four characters from SalesPerson name starting from second character. 162iv) To find the average of order amount. |) Display the month name for the Order date. SECTION 34] A relation Vehicles is given below Write SQL commands to a. Count the type of vehicles manufactured by each company. b. Display the total price of all the types of vehicles. c. Display the average price of each type of vehicle having quantity more than 20. OR (Option for part iii only) Write a query to display type and price * quantity with title TOTAL PRICE company wise 35 | A dataframe faf stores data about passengers, Flights and Years as given below. S_NO Year Months MalePassengers | FemalePassengers 1 2009 January 90 30 2 2009 February | 100 18 3 2009 March 98 22 4 2009 April 110 30 1) Write python code to create the dataframe. Perform the following operations on the DataFrame 2) Add both the male and female passengers and assign to column “Total_ passengers” 3) Display the maximum passengers in male passengers and maximum passengers in female passengers of the Data Frame. OR (Option for part ili only) Predict the output of the following python statement: /ear’:’MalePassengers’)