
	Trending ▼ ICSE CBSE 10th ISC CBSE 12th CTET GATE UGC NET Vestibulares ResFinder

CBSE Class 12 Pre Board 2020 : Informatics Practices (Kendriya Vidyalaya (KV) Agra)

6 pages, 48 questions, 0 questions with responses, 0 total responses,

	CBSE 12 Pre Boards	+Fave Message
	Profile Timeline Uploads

Home > cbse12_pre_boards > F Also featured on: School Page cbse12

Formatting page ...

SET-H KENDRIYA VIDYALAYA SANGATHAN, AGRA REGION INFORMATICS PRACTICES - NEW (065) Pre-Board Examination- 2019-20 Max Marks: 70 Time: 3 hrs. General Instructions: All questions are compulsory. Question Paper is divided into 4 sections A, B, C and D. Section A comprises of questions from Data Hadling-2. Section B comprises of questions from Basic Engineering. Section C comprises of questions from Data Management-2 Section D comprises of questions from Society, Law and Ethics-2. Section A Answer the following questions: 1 a) The ________ function returns its argument with a modified shape, whereas the _______method modifies the array itself. i) Reshape, resize ii) Resize, reshape iii) Reshape2, resize iv) All of the mentioned b) What will be the output of following python script: 1 1 import numpy as np k= np.arange(20,50,3) q=k.reshape(5,2) c) print(q) Revathi is trying to draw a line chart for some sales figure of different product. She 1 wants to plot different type of lines such as solid, dashed, dotted etc. for lines of different product. Suggest her what argument should she use with the plot () function. d) Write a python program to extract all odd numbers from an array. 2 Input array: [0,1,2,3,4,5,6,7,8,9] and desired output: array([1,3,5,7,9]) e) Consider following commands >>> ary = np.arange (10) **3 >>> ary array ([0,1,8,27,64,125,216,343,512,729]) Write code to extract elements in reverse order from array. The extracted elements should skip two elements. (Output of code will be - ([729,216,27,0]) Page 1 of 6 2 f) Explain difference between creating array using arange() and linspace() with example 2 g) Write a NumPy program to create a 3 x 3 identity matrix, i.e. diagonal elements are 1, the rest are 0. Replace all 0 to random number from 10 to 20 OR Write a NumPy program to create a 4 x 4 identity matrix, i.e. diagonal elements are 1, 3 the rest are 0. Replace all 0 to random number from 1 to 10 Answer the following questions: 2 a) What is data visualization? b) 1 Find the output of following program: 1 import pandas as pd df = pd.DataFrame([[1, 2], [4, 5], [7, 8]], index=['cobra', 'viper', 'sidewinder'], columns=['max_speed', 'shield']) print(df.loc['cobra', 'shield']) c) If pivot() function is used with dataframes for a column and it raises an error one possible 1 reason of the error is (choose correct alternate out of following): i. Datatype error in the column specified ii. Duplicate values in the column specified iii. pivot() function can not be used for individual columns iv. pivot() function is not supported by dataframes d) Which of the following is not a valid dataframe function: 1 i. applymap() ii. pipe() iii. applyrow() iv. apply() e) What is the use of matplotlib and pyplot? 2 f) 2 Write a python code to fill in missing values in DataFrame DF1. g) What is pipe() function used for in python? What is difference between apply() and applymap()? Page 2 of 6 3 h) Find the output of the following code: 3 import pandas as pd data = [{'a': 1, 'b': 2},{'a': 5, 'b': 10, 'c': 20}] # With two column indices, values same as dictionary keys df1 = pd.DataFrame(data, index=['first', 'second'], columns=['a', 'b']) #With two column indices with one index with other name df2 = pd.DataFrame(data, index=['first', 'second'],columns=[ a , b1 ]) i) print(df1) print(df2) Find the output of the following code: 4 import pandas as pd import numpy as np s1 = pd.Series(['100', '200', 'python', '300.12', '400']) s2 = pd.Series(['10', '20', 'php', '30.12', '40']) print("Data Series:") print(s1) print(s2) df = pd.concat([s1, s2], axis=1) print("New DataFrame combining two series:") print(df) Section B 3 a) What is Software Engineering? b) 1 is the process of checkinq the developed software for its correctness and error free working Specification B. Design/Implementation C. Validation/Testing D. Evolution What is Git? 1 A. c) 1 d) Differentiate between a Commit and a Push request on a version control system. 2 OR List any two differences between Incremental model and Spiral model in developing complex software projects. e) What are the fundamental activities of a software process? Also Write the basic 3 principles of Water Fall Model. f) What is scrum? What are the responsibility of a scrum master? 3 g) Consider an online shopping portal of Acart India ltd. A customer can view the products 4 on the portal while browsing. He may register on the portal. For purchase he/she must Page 3 of 6 register on the portal. When he purchases any product after viewing it, his registration must be verified by the system. After successful verification the payment is processed and an external online payment service is used to process the payment. Draw a use case diagram for this scenario. OR Consider railways reservation system where a registered passenger can book a ticket. Passenger can also get himself registered if not registered. While booking a ticket system first checks the availability of births and optionally if passenger wants, may allot lower births. In booking process before payment and booking, registration is verified and payment is processed through external online payment service. Draw a use case diagram for this scenario. Section C 4 a) Write the Django command to start a new app named abc in an existing project? 1 b) The COUNT function in SQL returns the number of ______________ 1 c) i) Values ii) Distinct values iii) Group By iv) Columns Mandatory arguments required to connect any database from Python 1 i) ii) iii) iv) d) Username, Password, Hostname, Database Name, Port. Username, Password, Hostname Username, Password, Hostname, Database Name Username, Password, Database Name is_connected() is the MYSQL function to : 1 (i) establish a connection to a mysql database from python. (ii) verify whether the python application is connected to mysql database. (iii) traverse through records in mysql database. (iv) None of the above e) A connection is the session between . and .. 1 f) 3 In a school, a database named school is created in mysql whose password is cbse . Rahul is trying to create a new table Student as per following structure SNO Field Name Data type Size Constraints 1 Rno Number 3 Primary Key 2 Student_Name 3 Fname Varchar 30 4. Address Varchar 50 Varchar Page 4 of 6 30 Not Null g) On the basis of following table answer the given questions; 3 Table: CLUB COACH_ID COACHNAME AGE SPORTS DATOFAPP PAY SEX 1. KUKREJA 35 KARATE 27/03/1996 1000 M 2. RAVINA 34 SQUASH 20/01/1998 1200 F 3. KARAN 39 SWIMMING 19/02/1998 2000 M (i) Write the degree and cardinality of the above table. (ii) Write a query to add one more column Address VARCHAR (30) type. (iii) Write a query to increase the salary by 5% of all female coaches. h) Consider the following table named GARMENT . Write command of SQL for (i) to (iii) and output for (iv) and (v). Table: GARMENT GCODE GNAME SIZE COLOUR PRICE 111 TShirt XL Red 1400 112 Jeans L Blue 1600 113 Skirt M Black 1100 114 Ladies Jacket XL Blue 4000 115 Trousers L Brown 1500 116 Ladies Top L Pink 1200 4 i) To display names of those garments that is available in L size. ii) To display codes and names of those garments that has their names starting with Ladies . iii) To display garment names, codes and prices of those garments that have price in the range 1100 to 1600 (both 1100 and 1600 includes) iv) To display garment names, codes and prices of those garments that have price in the range 1100 to 1600 (both 1100 and 1600 includes) v) Select max(PRICE) from GARMENT; vi) Select count(*) from GARMENT where PRICE>1200; Section D 5 a) The creator of information is the real owner of the information. .. rights 1 protect his right on his creation. (Fill in the blanks) b) Expend the term GPL. 1 c) 1 What is Smart Mobs ? d) Anjali received an email stating that there is a problem with her account. The email 2 provides instructions and a link, by clicking on which she can logon to her account and Page 5 of 6 fix the problem. Help Anjali by telling her the precautions she should take when she receives these types of emails. e) What are the benefits of e-Waste recycling? 2 f) 3 What do you understand by Computer ethics? OR Explain the role of online social media campaigns, crowdsourcing and smart mobs in society. ***End of Paper*** Page 6 of 6

Formatting page ...

Tags : cbse pre boards, prelims 2015 - 2016, preliminary examinations, central board of secondary education, india schools, free question paper with answers, twelfth standard, xiith std, board exams, mock, model, sample, specimen, past, free guess papers.india, delhi, outside delhi, foreign, cbse class xii, cbse 12, 12th standard, cbse papers, cbse sample papers, cbse books, portal for cbse india, cbse question bank, cbse question papers with answers, pre board exam papers, cbse model test papers, solved board question papers of cbse last year, previous years solved question papers, free online cbse solved question paper, cbse syllabus, india cbse board sample questions papers, last 10 years cbse questions papers, cbse important questions, specimen / mock papers.

cbse12_pre_boards chat

Horizontal lines at:
Guest Horizontal lines at:
AutoRM Data:
Box geometries: