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

CBSE Class 12 Pre Board 2021 : Informatics Practices - with ANSWERS / MARKING SCHEME (Kendriya Vidyalaya (KV), Kanpur Cantt)

12 pages, 73 questions, 25 questions with responses, 26 total responses,

	CBSE 12 Pre Boards	+Fave Message
	Profile Timeline Uploads

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

Formatting page ...

KENDRIYA VIDYALAYA KANPUR CANTT Pre- Board Examination-I (2020-2021) Class- XII Subject- Informatics Practices Time Allowed: 3 Hours Maximum Marks: 70 General Instructions: 1. This question paper contains two parts A and B. Each part is compulsory. 2. Both Part A and Part N have choices. 3. Part-A has 2 sections: a. Section-I is short answer questions, to be answered in one word or one line. b. Section-II has two case studies questions. Each case study has 4 case based sub-parts. An examinee is to attempt any 4 out of the 5 subparts. 4. Part-B is descriptive paper. 5. Part-B has 3 sections: a. Section-I is short answer questions of 2 marks each in which two questions have internal options. b. Section-II is long answer questions of 3 marks each in which two questions have internal options. c. Section-III is very long answer questions of 5 marks each in which one question has internal option. Q.No Marks Allocated PART -A SECTION-I Select the most appropriate option out of the options for each question. Attempt any 15 questions from question no 1 to 21. 1 2 3 4 5 6 7 Which of these is not a communication channel? (i) Satellite (ii) Microwave (iii) Radio wave 1 (iv) Wi-Fi Which of the following methods should be used in the code to display a graph? (i) Show() (ii) display() (iii) execute() (iv) plot() Write the output of the following SQL command. SELECT TRUNCATE(345.79) (i) 345.79 (ii) 345.0 (iii) 346 (iv) 345.8 Axes of a plot can be labelled using _____ and ______ functions. In a dataframe, axis-0 is for (i) columns (ii) rows (iii) rows and columns both (iv) None of these Which function is used to rename the existing column or index? (i) std() (ii) hist() (iii) groupby() (iv) rename() The term Intellectual Property Rights covers: (i) Copyrights (ii) Trademarks (iii) Patents (iv) All of these 1 1 1 1 1 1 8 9 10 11 12 13 14 15 16 Missing data in Pandas series and dataframes can be filled with a value. Which of the following is not a type of network? (i) PAN (ii) VAN (iii) MAN (iv) LAN What type of information a web page can contain? (i) Text (ii) Images (iii) video (iv) All of these The max() function in MYSQL is an example of (i) String function (ii) Math function (iii) Date function (iv) Aggregate function Discarded electrical or electronic devices are known as Which of the following statements is false? (i) Dataframe is size-mutable. Dataframe is values-mutable. (ii) (iii) Dataframe is immutable (iv) Dataframe is capable to hold multiple types of data Define the term cookies . Which of the following is not a type of cybercrime? (i) Data theft (ii) Forgery (iii) Damage to data (iv) Installing antivirus A mail or message sent to a large number of people indiscriminately without their consent is called 1 1 1 1 1 1 1 1 1 17 18 The command is used to see the structure of a table. Define the term Cyber Crime 1 1 19 20 Write the SQL command to delete a table STUDENT along with its structure. A device used to connect dissimilar network is called 1 1 1 21 Which of the following is not a topology? (i) Star (ii) Moon (iii) Mesh (iv) Ring SECTION-II Both the case study based questions are compulsory. Attempt any 4 sub parts from each question. Each question carries 1 mark. 22 A company, Sunrise Ltd. is considering to manage the records of their employees using SQL to store the data. As a database administrator, Harish has decided that: Name of the database: Employee Name of the table : Empl The attributes of Empl are as follows: EmpId - Numeric Empname - character of size 20 Salary - Numeric Date_of_Joining - Date EmpId 1001 1002 1004 1008 1006 1005 Empname Mr. Khanna Mr. Roy Ms. Sehgal Mr. Pahwa Ms. Sharma Mr. Bhalla Salary 50000 35000 25000 30000 20000 25000 Date_of_Joining 23-10-2018 22-04-2017 23-08-2016 15-10-2019 14-12-2019 12-09-2020 1 23 (a) Identify the attribute best suitable to be declared as a primary key. (b) Write the degree and cardinality of the table Empl. (c) Harish wants to delete all the records of the table Empl. Structure of the table should not be removed. Write the query for the same. (d) Write a query to increase the salary of all the employees by 5000. (e) Harish wants to see the structure of the table Empl . Help him to do the same. Consider the following DataFrame df and answer any four questions from (i) to (v) Rollno Name Eng Hindi Maths Science 1 Harish Kumar 50 47 45 40 2 Guneet Arora 49 46 47 48 3 Naysha Singh 40 45 50 49 4 Vasu Kaur 43 46 48 44 5 Divya Nagar 43 38 42 41 Output 1 1 1 1 1 Output 2 (i) Write down the command that will give the output 1 : (a) for i in df.iterrows(): print(i) (b) for i in df.iterrose(): print(i) (c) for i in df.iteritem(): print(i) (d) for i in df.iteritems(): print(i) 1 (ii) Write down the command that will give the output 2 : (a) for i in df.iterrose(): print(i) (b) for i in df.iterrow(): print(i) (c) for i in df.iteritem(): print(i) (d) for i in df.iteritems(): print(i) 1 iii) Which of the following statement(s) will give the exact number of values in each column of the dataframe? i. print(df.count()) ii. print(df.count(0)) iii. print(df.count) iv. print(df.count(axis= index )) Choose the correct option: (a) both (i) and (ii) (b) only (ii) (c) (i), (ii) and (iii) (d) (i), (ii) and (iv) (iv) Which of the following command will display the column labels of the DataFrame? (a) print(df.columns()) (b) print(df.column()) (c) print(df.column) (d) print(df.columns) 1 1 (v) Ms. Pathak, the class teacher wants to add a new column, the total of 4 subject marks, named as Total to the DataFrame. Help her to write the command to do so. 1 PART-B Section-I 24 Consider a given Series, S1: index 2 Salary January 20000 February 30000 March 40000 Write a program in Python Pandas to create the series. 25 Differentiate between Degree and Cardinality of a table with suitable example. OR Differentiate between Primary Key and a Candidate Key with example. 2 26 What will be the output of the following commands in Mysql: (i) SELECT MID( INFORMATICS PRACTICES , 3, 7); (ii) SELECT REVERSE( STRING FUNCTION ); 2 27 Consider the following Series Object, Ser1: 2 28 (i) Write the command which will display the name of the item having price >70. (ii) Write the command to name the series as ITEM. Priyansha writes the following commands with respect to a table CABs having fileds: Cabno, CabName, Color, Capacity, Charges. Command1: Command2: 29 Pen 50 Pencil 100 Eraser 70 Sharpener 80 2 SELECT COUNT(COLOR) FROM CABS; SELECT COUNT(DISTINCT COLOR) FROM CABS; She gets the output as 4 for the first command but gets an output 3 for the second command. Explain the output with justification. Consider the following SQL string : Examination Write commands to display: a. min b. nation OR Consider the same string Examination Write SQL commands to display: a. The position of the substring min in the string Examination b. The last 5 letters of the string 2 30 31 32 33. Consider the following DataFrame, student: Rollno Name Class S1 1 Akash XI S2 2 Divya XII S3 3 Radha XI S4 4 Ekta XII S5 5 Palak XII 2 Marks 250 300 347 390 400 Write commands to: (i) Add a new column Grade to the DataFrame. To display the records of Class XII students. (ii) Expand the following terms related to Computer Networks: a. ARPANET b. ISP c. TCP/IP d. URL List any 2 ways related to e-waste management. 2 2 Ankita received an SMS, from her bank querying a recent transaction asking her pin number. Answer the following questions as what she should do upon receiving the SMS: a. Should she SMS her pin number to the given contact number? b. Should she call the bank helpline number to recheck the validity of the SMS received? 2 SECTION-II 34 Consider the two objects s1 and s2. s1 is a list whereas s2 is a Series. Both have values 10, 20, 30, 40, 50. What will be the output of the following two statements considering that the above objects have been created already a. print(s1 * 2) b. print(s2 * 2) 3 Justify your answer. 35 3 What do you mean by Cyber Crime? Explain with the help of an example. OR How the excessive use of Technology affected the health of human beings? Explain. 36 Write the outputs of the SQL queries (i) to (iii) based on the following table CABHUB : VCODE 100 102 104 105 108 VNAME INNOVA SX4 C CLASS A-STAR INDIGO MAKE TOYOTA SUZUKI MERCEDES SUZUKI TATA COLOR WHITE BLUE RED WHITE SILVER CAPACITY 7 4 4 3 3 CHARGES 15 14 35 14 12 (a) To display the names of all the white colored vehicles. (b) To display name of vehicle, make and capacity of vehicles in ascending order of their seating capacity. (c) To display the highest charges at which a vehicle can be hired from CABHUB. 3 37 Consider the following graph. Write the code to plot it. 3 OR Draw the following bar graph representing the Sales of each month. SECTION-III 38 Write a program in Python Pandas to create the following DataFrame DEPT from a dictionary: DeptId DeptName Income Location 10 Sales 85660 New Delhi 20 Purchase 86780 Kolkata 30 Personnel 87600 Haryana 40 Research 89990 Bengaluru Perform the following operations of the DataFrame: i. Display the highest income from the DEPT. ii. Add a new Column Commission that will have the values as 15% of the Income. iii. Display the DataFrame. 5 39 Consider the following tables STORE and SUPPLIERS and answer the following parts of the questions: 5 Table: Store ITEMNO 2005 2003 2002 2006 2001 2004 2009 ITEM Sharpener Classic Ball Pen 0.25 Gel pen premium Gel Pen Classic Eraser Small Eraser Big Ball Pen 0.5 SCODE 23 22 21 21 22 22 21 QTY 60 50 150 250 220 110 180 RATE 8 25 12 20 6 8 18 LASTBUY 31-6-2009 1/2/2010 24-02-2010 11/3/2009 19-1-2009 2/12/2009 3/11/2009 Table: Suppliers SCODE 21 23 22 SNAME Premium Stationers Soft Plastics Tetra Supply a. To display details of all the items in the Store table in ascending order of LastBuy. b. To display itemno ItemName of those items from Store Table whose rate is more than 15 rupees. c. To display the details of those items whose Suppliers code(Scode) is 22 or Quantity in Store(Qty) is more than 110 from the table Store. d. To display minimum rate of Items for each Supplier individually as per Scode from the table Store. e. To increase the Rate of all the items by Rs. 10 40 Sanskar University of Himachal Pradesh is setting up a secured network for its campus at Himachal Pradesh for operating their day-to-day office & web based activities. They are planning to have network connectivity between four buildings. Answer the question (i) to (v) after going through the building positions in the campus & other details which are given below: 5 Number of computers:Building Main Admin Finance Academic No. of Computers 150 75 50 60 As a network expert, you are required to give best possible solutions for the given queries of the university administration: (a) Suggest cable layout for the connections between the various buildings, (b) Suggest the most suitable building to house the server of the network of the university, (c) Suggest the placement of following devices with justification: 1. Switch/Hub 2. Repeater (d) Suggest the technology out of the following for setting-up very fast Internet connectivity among buildings of the university 1. Optical Fiber 2. Coaxial cable 3. Ethernet Cable (e) The University is planning to connect its admission office in Haryana, which is more than 1000 KM from University. Which type of Network out of LAN, MAN or WAN will be formed? Justify your answer. KENDRIYA VIDYALAYA KANPUR CANTT Pre- Board Examination-I (2020-2021) Class- XII Subject- Informatics Practices MARKING SCHEME SECTION-I Select the most appropriate option out of the options for each question. Attempt any 15 questions from question no 1 to 21. xlabel(), ylabel() ! ! !" # $ " ! %% % # & ' ( * 1 $ ) &/ # + + (( % # * '2 3 ' & ( 30( & / & *# + & + 4# & ( 45'2!4 6 ' #+ 7 # 8 0 # ( * & 0 & *# % )* & ) +& * + + / , - & 0 / # - .* +/ + 0 * & &# & *# #+/ &0( (# 0 % + 0+% & 9 SECTION-II Both the case study based questions are compulsory. Attempt any 4 sub parts from each question. Each question carries 1 mark. 22 2 *1+ ( + % & ' 6 4# & + 5:' 42 2 ' & ( 2 6 ' &2 * +& + 2 * 0 ( 2 * * 24 * 0; 0< ! + * = + = "# ! + $# 1 * % % & % % + / % + ! ) * ' * , , + >?4 % + ( + & # , '. 1 % ( % + ' / 0 * ?@;+ >?A + ?@<+ >?2 %?@<+ >?9 + ?@<+ >? & 1 % - 1 ! & ?@ 2 & ;*+ ' + ( ' ( ;+ & / + );>?B ?/? (?/?9 & ?@ ' % +3 + 0 ( 3 : 0C 0 + 3 ++ C 0 679 41 !6143!58 8!174 * > D @ ;?1 ? 67 ?1 ? $ ( ,' 2E234 91' F2) 2E234 718A4 F2) $ G/ / G/ 3 & 1 2E234 1! 47 F2) 2E234 718A4 F2) G/ / G/ # ) ( * ) * & + 9 & & * #+>?8 + ?@;>?H?/? ?/? ?/? ?/? ?@ #+> #+ 3 ;;?I11?@ 2)* + % + 3 *# ! -= 7: !24 J + & + 7 & : K & % &0 ! 1 :J1 & : + 43:L1: J 4 3 : & L1 : & 57E J 5 7 #& E & 0 0 + % &0& L 7 * L 7 # * 9 .: & ! / #+ 9 * # ( % & & M / #+& ( - * # ( & &7 & + ( & + E 7 ( 45 a. b. # ( + 0 9 63 66 [20, 30, 40, 50, 20, 30, 40, 50, 20, 30, 40, 50] 0 60 1 90 2 120 3 150 1 E 1 N * + 0 # # + & & & * (0 30( 3 * ** + O 2)* " & 6* * ) * & 3 A )& 36 # 4 & %0 & + 2E234 "! 92 769 3 HA5H "! 92 # ( % O 2)* A272 36E67;G A142GP 1!!6" 4 7 ' 2E234 "! 92/ 9 C2/ 3 : 314M 769 3 HA5H 67'27 HM 3 : 314MP "! 92 9 C2 3 : 314M 4 7 1!'186 I 5Q5C1 4 4 5Q5C1 3 3E 92732'2 1!!6" 46M64 2E234 9 I 3A 782 9 I 3A 782 769 3 HA5H 3 9 & * * ( *0* );> / / / / / @ 0;> / / / / / @ * * )/0 * * 3 * * I; ?K ?/? (?/? M; / * ( I/M * ( *0* ?/? * ? / / * 45 * * + + & ;R?' * 1+?=> / / '2:4;*+ ' * '2:4 *+ / / / @/?' * ! ?=>? / $$$ @/?E & ?=>?! +& * '2:4 1 & '2:4>F3 * '2:4 $ 63 666 ' ) G@;'2:4 1 & ?/?:# & ?/?: ?/?C - ?/?A 0 ?/?7 & ?@/?1 & ?/?H % # #?@S N 2E234 N 769 67'27 HM E H#0P ' 2E234 /1 769 A272 D P 2E234 N 769 A272 & + ; 67 T 0 D P 2E234 36'2/ 91! 769 67'27 HM & + P 5:' 42 24 ; < P 3 ( 0 # = 4 74 * 7 ) " ( 9 H# + % & & LA#( J 7 * JH + 6* & ( !/ & %0 7 ) (# + % 9 H# + % C9 + & H# + % & & $ ?=>

Formatting page ...

Top Contributors
to this ResPaper
(answers/comments)

B K Birla Centr...
(15)

Raj Mrittik
(11)

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: