{"id":1805,"date":"2022-01-14T19:54:37","date_gmt":"2022-01-14T14:24:37","guid":{"rendered":"https:\/\/cbsepython.in\/?p=1805"},"modified":"2022-06-12T13:18:49","modified_gmt":"2022-06-12T07:48:49","slug":"computer-science-sample-paper-term-2","status":"publish","type":"post","link":"https:\/\/cbsepython.in\/computer-science-sample-paper-term-2\/","title":{"rendered":"Solved Computer Science Sample Paper Term 2 Class 12"},"content":{"rendered":"<h2><span style=\"color: #000000;\">Computer Science Sample Paper Term 2 Class 12<\/span><\/h2>\n<p><span style=\"color: #000000;\">Sample Question Paper<\/span><\/p>\n<p><span style=\"color: #000000;\">COMPUTER SCIENCE (Code: 083)<\/span><\/p>\n<p><span style=\"color: #000000;\">Maximum Marks: 35 \/Time: 2 hours<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">General Instructions<\/span><\/p>\n<p><span style=\"color: #000000;\">*\u00a0 The question paper is divided into 3 sections \u2013 A, B and C<\/span><\/p>\n<p><span style=\"color: #000000;\">* Section A, consists of 7 questions (1-7). Each question carries 2 marks.<\/span><\/p>\n<p><span style=\"color: #000000;\">* Section B, consists of 3 questions (8-10). Each question carries 3 marks.<\/span><\/p>\n<p><span style=\"color: #000000;\">* Section C, consists of 3 questions (11-13). Each question carries 4 marks.<\/span><\/p>\n<p><span style=\"color: #000000;\">* Internal choices have been given for question numbers 7, 8 and 12.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">Section -A<\/span><\/strong><\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">Each question carries 2 marks<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong>1. Give any two characteristics of stacks.<\/strong><\/span><\/p>\n<p><span style=\"color: #000000;\">Ans: Characteristics of Stacks:<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; It is a LIFO data structure<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; The insertion and deletion happens at one end i.e. from the top of the stack<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">2. (i) Expand the following: SMTP , XML<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans: SMTP : Simple Mail Transfer Protocol<\/span><br \/>\n<span style=\"color: #000000;\">XML: Extensible Mark Up Language<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(ii) Out of the following, which is the fastest wired and wireless medium of transmission?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Infrared, coaxial cable, optical fibre, microwave, Ethernet cable<\/span><\/p>\n<p><span style=\"color: #000000;\">Ans: Wired- optical fibre<\/span><br \/>\n<span style=\"color: #000000;\">Wireless \u2013 microwave<\/span><\/p>\n<p>&nbsp;<\/p>\n<h1><span style=\"color: #ff0000;\">Also Check:<\/span><\/h1>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/term-2-sample-paper-class-12-computer-science\/\">Computer Science Sample Paper Class 12 Term 2 Set 1<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/class-12-term-2-sample-paper-computer-science-set-2\/\">Computer Science Sample Paper Class 12 Term 2 Set 2<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/class-12-term-2-sample-paper-computer-science-set-3\/\">Computer Science Sample Paper Class 12 Term 2\u00a0Set 3<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/class-12-term-2-sample-paper-computer-science-set-4\/\">Computer Science Sample Paper Class 12 Term 2\u00a0Set 4<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/class-12-term-2-sample-paper-computer-science-set-5\/\">Computer Science Sample Paper Class 12 Term 2 Set 5<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/class-12-term-2-sample-paper-computer-science-set-6\/\">Computer Science Sample Paper Class 12 Term 2 set 6<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/important-computer-network-class-12-question-answer\/\">Computer Networking Question and Answer<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/important-question-answer-class-12-computer-science\/\">Important Question Answer for Term 2 Exam<\/a><\/span><\/h2>\n<h2><a href=\"https:\/\/cbsepython.in\/database-questions-for-class-12\/\"><span style=\"text-decoration: underline;\">Database Management System Questions with Answer<\/span><\/a><\/h2>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">3. Differentiate between char(n) and varchar(n) data types with respect to databases.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans: <\/span><\/p>\n<p><strong><span style=\"color: #000000;\">char(n):<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">&gt; stores a fixed length string between 1 and 255 characters<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; if the value is of smaller length, adds blank spaces<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; some space is wasted<\/span><\/p>\n<p><strong><span style=\"color: #000000;\">varchar(n) :<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">&gt; stores a variable length string<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; no blanks are added even if value is of smaller length<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; no wastage of space<\/span><\/p>\n<p><strong><span style=\"color: #000000;\">4. A resultset is extracted from the database using the cursor object (that has been already created) by giving the following statement.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Mydata=cursor.fetchone()<\/span><\/p>\n<p><strong><span style=\"color: #000000;\">(a) How many records will be returned by fetchone() method?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans: One record<\/span><\/p>\n<p><strong><span style=\"color: #000000;\">(b) What will be the datatype of Mydata object after the given command is executed?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans: tuple<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">5. Write the output of the queries (a) to (d) based on the table, Furniture given below:<\/span><\/strong><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">Table: FURNITURE<\/span><\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">FID<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">NAME<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">DATEOFPURCHASE<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">COST<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">DISCOUNT<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">B001<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">Double Bed<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">03-Jan-2018<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">45000<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">10<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">T010<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">Dining Table<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">10-Mar-2020<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">51000<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">5<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">B004<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">Single Bed<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">19-Jul-2021<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">22000<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">0<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">C003<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">Long Back Chair<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">30-Dec-2016<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">12000<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">3<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">T006<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">Console Table<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">17-Nov-2021<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">15000<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">12<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">B006<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">Bunk Bed<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">01-Jan-2021<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">28000<\/span><\/td>\n<td style=\"width: 20%;\"><span style=\"color: #000000;\">14<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(a) SELECT SUM(DISCOUNT) FROM FURNITURE WHERE COST&gt;15000;<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans: 29<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(b) SELECT MAX(DATEOFPURCHASE) FROM FURNITURE;<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans: 19-Jul-2021<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(c) SELECT * FROM FURNITURE WHERE DISCOUNT&gt;5 AND FID LIKE &#8220;T%&#8221;;<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans:<\/span><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 18.3333%;\"><span style=\"color: #000000;\">T006<\/span><\/td>\n<td style=\"width: 19.5455%;\"><span style=\"color: #000000;\">Console Table<\/span><\/td>\n<td style=\"width: 20.2727%;\"><span style=\"color: #000000;\">17-Nov-2019<\/span><\/td>\n<td style=\"width: 19.2879%;\"><span style=\"color: #000000;\">15000<\/span><\/td>\n<td style=\"width: 22.5606%;\"><span style=\"color: #000000;\">12<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(d) SELECT DATEOFPURCHASE FROM FURNITURE WHERE NAME IN (&#8220;Dining Table&#8221;, &#8220;Console Table&#8221;);<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans:\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">10-Mar- 2020<\/span><br \/>\n<span style=\"color: #000000;\">17-Nov-2019<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">6. (i) Which command is used to view the list of tables in a database?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans: SHOW TABLES;<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(ii) Give one point of difference between an equi-join and a natural join.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans:<\/span><\/p>\n<p><strong><span style=\"color: #000000;\">Equi- join:<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">&gt; The join in which columns from two tables are compared for equality<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; Duplicate columns are shown Natural Join<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; The join in which only one of the identical columns existing in both tables is present<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; No duplication of columns <\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">7. Consider the table, MOVIEDETAILS given below:<\/span><\/strong><\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">Table: MOVIEDETAILS<\/span><\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%; height: 168px;\">\n<tbody>\n<tr style=\"height: 24px;\">\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">MOVIEID<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">TITLE<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">LANGUAGE<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">RATING<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">PLATFORM<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">M001<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">Minari<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">Korean<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">5<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">Netflix<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">M004<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">MGR Magan<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">Tamil<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">4<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">Hotstar<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">M010<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">Kaagaz<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">Hindi<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">3<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">Zee5<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">M011<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">Harry Potter<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">English<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">4<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">Prime Video<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">M015<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">Uri<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">Hindi<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">5<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">Zee5<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">M020<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">Avengers: Endgame<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">English<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">4<\/span><\/td>\n<td style=\"width: 20%; height: 24px;\"><span style=\"color: #000000;\">Hotstar<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(a) Identify the degree and cardinality of the table.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans: Degree: 5, Cardinality: 6<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(b) Which field should be made the primary key? Justify your answer.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans: MOVIEID should be made the primary key as it uniquely identifies each record of the table.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">OR<\/span><\/p>\n<p><strong><span style=\"color: #000000;\">(a) Identify the candidate key(s) from the table MOVIEDETAILS.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans: MOVIEID and TITLE<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(b) Consider the table SCHEDULE given below:<\/span><\/strong><\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">Table: SCHEDULE<\/span><\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">SLOTID<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">MOVIEID<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">TIMESLOT<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">S001<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">M010<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">10 AM to 12 PM<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">S002<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">M020<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">2 PM to 5 PM<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">S003<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">M010<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">6 PM to 8 PM<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">S004<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">M011<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">9 PM to 11 PM<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">Which field will be considered as the foreign key if the tables MOVIEDETAILS and SCHEDULE are related in a database?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans: MOVIEID<\/span><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">SECTION \u2013 B<\/span><\/strong><\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">Each question carries 3 marks<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #000000;\">8. Julie has created a dictionary containing names and marks as key value pairs of 6 students. Write a program, with separate user defined functions to perform the following operations:<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">&gt; Push the keys (name of the student) of the dictionary into a stack, where the corresponding value (marks) is greater than 75.<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; Pop and display the content of the stack.<\/span><\/p>\n<p><span style=\"color: #000000;\">For example:<\/span><\/p>\n<p><span style=\"color: #000000;\">If the sample content of the dictionary is as follows:<\/span><\/p>\n<p><span style=\"color: #000000;\">R={&#8220;OM&#8221;:76, &#8220;JAI&#8221;:45, &#8220;BOB&#8221;:89, &#8220;ALI&#8221;:65, &#8220;ANU&#8221;:90, &#8220;TOM&#8221;:82}<\/span><\/p>\n<p><span style=\"color: #000000;\">The output from the program should be:<\/span><\/p>\n<p><span style=\"color: #000000;\">TOM ANU BOB OM<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">Ans:\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">R={&#8220;OM&#8221;:76, &#8220;JAI&#8221;:45, &#8220;BOB&#8221;:89,<\/span><br \/>\n<span style=\"color: #000000;\">&#8220;ALI&#8221;:65, &#8220;ANU&#8221;:90, &#8220;TOM&#8221;:82}<\/span><br \/>\n<span style=\"color: #000000;\">def PUSH(S,N):<\/span><br \/>\n<span style=\"color: #000000;\">S.append(N)<\/span><br \/>\n<span style=\"color: #000000;\">def POP(S):<\/span><br \/>\n<span style=\"color: #000000;\">if S!=[]:<\/span><br \/>\n<span style=\"color: #000000;\">return S.pop()<\/span><br \/>\n<span style=\"color: #000000;\">else:<\/span><br \/>\n<span style=\"color: #000000;\">return None<\/span><br \/>\n<span style=\"color: #000000;\">ST=[]<\/span><br \/>\n<span style=\"color: #000000;\">for k in R:<\/span><br \/>\n<span style=\"color: #000000;\">if R[k]&gt;=75:<\/span><br \/>\n<span style=\"color: #000000;\">PUSH(ST,k)<\/span><br \/>\n<span style=\"color: #000000;\">while True:<\/span><br \/>\n<span style=\"color: #000000;\">if ST!=[]:<\/span><br \/>\n<span style=\"color: #000000;\">print(POP(ST),end=&#8221; &#8220;)<\/span><br \/>\n<span style=\"color: #000000;\">else:<\/span><br \/>\n<span style=\"color: #000000;\">break <\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"color: #000000;\">OR<\/span><\/p>\n<p><strong><span style=\"color: #000000;\">Alam has a list containing 10 integers. You need to help him create a program with separate user defined functions to perform the following operations based on this list.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">&gt; Traverse the content of the list and push the even numbers into a stack.<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; Pop and display the content of the stack.<\/span><\/p>\n<p><span style=\"color: #000000;\">For Example:<\/span><\/p>\n<p><span style=\"color: #000000;\">If the sample Content of the list is as follows:<\/span><\/p>\n<p><span style=\"color: #000000;\">N=[12, 13, 34, 56, 21, 79, 98, 22, 35, 38]<\/span><\/p>\n<p><span style=\"color: #000000;\">Sample Output of the code should be:<\/span><\/p>\n<p><span style=\"color: #000000;\">38 22 98 56 34 12<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">Ans:<\/span><\/p>\n<p><span style=\"color: #000000;\">N=[12, 13, 34, 56, 21, 79, 98, 22,<\/span><br \/>\n<span style=\"color: #000000;\">35, 38]<\/span><br \/>\n<span style=\"color: #000000;\">def PUSH(S,N):<\/span><br \/>\n<span style=\"color: #000000;\">S.append(N)<\/span><br \/>\n<span style=\"color: #000000;\">def POP(S):<\/span><br \/>\n<span style=\"color: #000000;\">if S!=[]:<\/span><br \/>\n<span style=\"color: #000000;\">return S.pop()<\/span><br \/>\n<span style=\"color: #000000;\">else:<\/span><br \/>\n<span style=\"color: #000000;\">return None<\/span><br \/>\n<span style=\"color: #000000;\">ST=[]<\/span><br \/>\n<span style=\"color: #000000;\">for k in N:<\/span><br \/>\n<span style=\"color: #000000;\">if k%2==0:<\/span><br \/>\n<span style=\"color: #000000;\">PUSH(ST,k)<\/span><br \/>\n<span style=\"color: #000000;\">while True:<\/span><br \/>\n<span style=\"color: #000000;\">if ST!=[]:<\/span><br \/>\n<span style=\"color: #000000;\">print(POP(ST),end=&#8221; &#8220;)<\/span><br \/>\n<span style=\"color: #000000;\">else:<\/span><br \/>\n<span style=\"color: #000000;\">break <\/span><\/p>\n<p><strong><span style=\"color: #000000;\">9. (i) A table, ITEM has been created in a database with the following fields:<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">ITEMCODE, ITEMNAME, QTY, PRICE<\/span><\/p>\n<p><span style=\"color: #000000;\">Give the SQL command to add a new field, DISCOUNT (of type Integer) to the ITEM table.<\/span><\/p>\n<p><span style=\"color: #000000;\">Ans: ALTER TABLE Item<\/span><br \/>\n<span style=\"color: #000000;\">ADD (Discount INT);<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(ii) Categorize following commands into DDL and DML commands?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">INSERT INTO, DROP TABLE, ALTER TABLE, UPDATE&#8230;SET<\/span><\/p>\n<p><span style=\"color: #000000;\">Ans:\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">DDL: DROP TABLE, ALTER TABLE<\/span><br \/>\n<span style=\"color: #000000;\">DML: INSERT INTO, UPDATE, SET<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">10. Charu has to create a database named MYEARTH in MYSQL.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">She now needs to create a table named CITY in the database to store the records of various cities across the globe. The table CITY has the following structure:<\/span><\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">Table: CITY<\/span><\/strong><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">FIELD NAME<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">DATA TYPE<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">REMARKS<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">CITYCODE<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">CHAR(5)<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">Primary Key<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">CITYNAME<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">CHAR(30)<\/span><\/td>\n<td style=\"width: 33.3333%;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">SIZE<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">INTEGER<\/span><\/td>\n<td style=\"width: 33.3333%;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">AVGTEMP<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">INTEGER<\/span><\/td>\n<td style=\"width: 33.3333%;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">POLLUTIONRATE<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">INTEGER<\/span><\/td>\n<td style=\"width: 33.3333%;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">POPULATION<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">INTEGER<\/span><\/td>\n<td style=\"width: 33.3333%;\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">Help her to complete the task by suggesting appropriate SQL commands.<\/span><\/p>\n<p><span style=\"color: #000000;\">CREATE DATABASE MYEARTH;<\/span><br \/>\n<span style=\"color: #000000;\">CREATE TABLE CITY (CITYCODE CHAR(5)PRIMARY KEY,<\/span><br \/>\n<span style=\"color: #000000;\">CITYNAME CHAR(30),<\/span><br \/>\n<span style=\"color: #000000;\">SIZE INT,<\/span><br \/>\n<span style=\"color: #000000;\">AVGTEMP INT,<\/span><br \/>\n<span style=\"color: #000000;\">POPULATIONRATE INT,<\/span><br \/>\n<span style=\"color: #000000;\">POPULATION INT,);<\/span><\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">Section C<\/span><\/strong><\/p>\n<p style=\"text-align: center;\"><strong><span style=\"color: #000000;\">Each question carries 4 marks<\/span><\/strong><\/p>\n<p><strong><span style=\"color: #000000;\">11. Write queries (a) to (d) based on the tables EMPLOYEE and DEPARTMENT given below:<\/span><\/strong><\/p>\n<p style=\"text-align: center;\"><span style=\"color: #000000;\">Table: EMPLOYEE<\/span><\/p>\n<table style=\"border-collapse: collapse; width: 100%; height: 144px;\">\n<tbody>\n<tr style=\"height: 24px;\">\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">EMPID<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">NAME<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">DOB<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">DEPTID<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">DESIG<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">SALARY<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">120<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">Alisha<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">23-Jan-1978<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">D001<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">Manager<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">75000<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">123<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">Nitin<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">10-Oct-1977<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">D002<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">AO<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">59000<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">129<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">Navjot<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">12-Jul-1971<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">D003<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">Supervisor<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">40000<\/span><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">130<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">Jimmy<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">30-Dec-1980<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">D004<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">Sales Rep<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><\/td>\n<\/tr>\n<tr style=\"height: 24px;\">\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">131<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">Faiz<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">06-Apr-1984<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">D001<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">Dep Manager<\/span><\/td>\n<td style=\"width: 16.6667%; height: 24px;\"><span style=\"color: #000000;\">65000<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p style=\"text-align: center;\"><span style=\"color: #000000;\">Table: DEPARTMENT<\/span><\/p>\n<table style=\"border-collapse: collapse; width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">DEPTID<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">DEPTNAME<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">FLOORNO<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">D001<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">Personal<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">4<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">D002<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">Admin<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">10<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">D003<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">Production<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">1<\/span><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">D004<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">Sales<\/span><\/td>\n<td style=\"width: 33.3333%;\"><span style=\"color: #000000;\">3<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(a) To display the average salary of all employees, department wise.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans: SELECT AVG(SALARY)<\/span><br \/>\n<span style=\"color: #000000;\">FROM EMPLOYEE<\/span><br \/>\n<span style=\"color: #000000;\">GROUP BY DEPTID;<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(b) To display name and respective department name of each employee whose salary is more than 50000.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans:<\/span><\/p>\n<p><span style=\"color: #000000;\">SELECT NAME, DEPTNAME<\/span><br \/>\n<span style=\"color: #000000;\">FROM EMPLOYEE, DEPARTMENT<\/span><br \/>\n<span style=\"color: #000000;\">WHERE<\/span><br \/>\n<span style=\"color: #000000;\">EMPLOYEE.DEPTID=<\/span><br \/>\n<span style=\"color: #000000;\">DEPARTMENT.DEPTID<\/span><br \/>\n<span style=\"color: #000000;\">AND SALARY&gt;50000;<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(c) To display the names of employees whose salary is not known, in alphabetical order.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans:SELECT NAME FROM EMPLOYEE<\/span><br \/>\n<span style=\"color: #000000;\">WHERE SALARY IS NULL<\/span><br \/>\n<span style=\"color: #000000;\">ORDER BY NAME;<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(d) To display DEPTID from the table EMPLOYEE without repetition.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans:<\/span><\/p>\n<p><span style=\"color: #000000;\">SELECT DISTINCT DEPTID<\/span><br \/>\n<span style=\"color: #000000;\">FROM EMPLOYEE;<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">12. (i) Give two advantages and two disadvantages of star topology<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans: <\/span><\/p>\n<p><strong><span style=\"color: #000000;\">Advantages<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">&gt; Ease of service<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; Centralized control<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; Easy to diagnose faults<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; One device per connection<\/span><\/p>\n<p><strong><span style=\"color: #000000;\">Disadvantages<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">&gt; long cable length<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; difficult to expand<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; central node dependency<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\">OR<\/span><\/p>\n<p><strong><span style=\"color: #000000;\">Define the following terms:<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">www , web hosting<\/span><\/p>\n<p><span style=\"color: #000000;\">Ans:\u00a0<\/span><\/p>\n<p><span style=\"color: #000000;\">www: a set of protocols that allow you to access any document on the internet through the naming systems based on URLs<\/span><\/p>\n<p><span style=\"color: #000000;\">Web hosting: Web hosting is a service that allows organizations and individuals to post a website or web page onto the server, which can be viewed by everyone on the Internet.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(ii)\u00a0How is packet switching different from circuit switching?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans:<\/span><\/p>\n<p><strong><span style=\"color: #000000;\">Packet switching:<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">&gt; uses store and forward concept to send <\/span><span style=\"color: #000000;\">messages<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; no physical path is actually establishes<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; message is divided into smaller parts, known <\/span><span style=\"color: #000000;\">as packets and then sent forward<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; tight upper limit on block size<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; Each data unit knows only the final <\/span><span style=\"color: #000000;\">receiver\u2019s address<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">Circuit switching<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">&gt; physical connection is established between <\/span><span style=\"color: #000000;\">sender and receiver<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; Each data unit knows the entire path from <\/span><span style=\"color: #000000;\">sender to receiver<\/span><\/p>\n<p><span style=\"color: #000000;\">&gt; It does not follow store and forward <\/span><span style=\"color: #000000;\">concept<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">13.\u00a0BeHappy Corporation has set up its new centre at Noida, Uttar Pradesh for its office and web-based activities. It has 4 blocks of buildings.<\/span><\/strong><\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-medium wp-image-1819\" src=\"https:\/\/cbsepython.in\/wp-content\/uploads\/2022\/01\/CS13-300x202.png\" alt=\"\" width=\"300\" height=\"202\" title=\"\" srcset=\"https:\/\/cbsepython.in\/wp-content\/uploads\/2022\/01\/CS13-300x202.png 300w, https:\/\/cbsepython.in\/wp-content\/uploads\/2022\/01\/CS13.png 332w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p><strong><span style=\"color: #000000;\">Distance between the various blocks is as follows:<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">A to B 40 m<\/span><\/p>\n<p><span style=\"color: #000000;\">B to C 120m<\/span><\/p>\n<p><span style=\"color: #000000;\">C to D 100m<\/span><\/p>\n<p><span style=\"color: #000000;\">A to D 170m<\/span><\/p>\n<p><span style=\"color: #000000;\">B to D 150m<\/span><\/p>\n<p><span style=\"color: #000000;\">A to C 70m<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">Numbers of computers in each block<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Block A &#8211; 25<\/span><\/p>\n<p><span style=\"color: #000000;\">Block B &#8211; 50<\/span><\/p>\n<p><span style=\"color: #000000;\">Block C &#8211; 125<\/span><\/p>\n<p><span style=\"color: #000000;\">Block D &#8211; 10<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(a) Suggest and draw the cable layout to efficiently connect various blocks of buildings within the Noida centre for connecting the digital devices.<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans: Block B&gt;Block A&gt;Block C&gt;Block D<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(b) Suggest the placement of the following device with justification<\/span><\/strong><\/p>\n<ol>\n<li><span style=\"color: #000000;\">Repeater<\/span><\/li>\n<li><span style=\"color: #000000;\">Hub\/Switch<\/span><\/li>\n<\/ol>\n<p><span style=\"color: #000000;\">Ans: Repeater : between C and D as the distance <\/span><span style=\"color: #000000;\">between them is 100 mts.<\/span><\/p>\n<p><span style=\"color: #000000;\">Hub\/ Switch : in each block as they help to share <\/span><span style=\"color: #000000;\">data packets within the devices of the network in <\/span><span style=\"color: #000000;\">each block<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(c) Which kind of network (PAN\/LAN\/WAN) will be formed if the Noida office is connected to its head office in Mumbai?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans: WAN<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #000000;\">(d) Which fast and very effective wireless transmission medium should preferably be used to connect the head office at Mumbai with the centre at Noida?<\/span><\/strong><\/p>\n<p><span style=\"color: #000000;\">Ans: <\/span><span style=\"color: #000000;\">Satellite<\/span><\/p>\n<p>&nbsp;<\/p>\n<h1><span style=\"color: #ff0000;\">Also Check:<\/span><\/h1>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/term-2-sample-paper-class-12-computer-science\/\">Computer Science Sample Paper Class 12 Term 2 Set 1<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/class-12-term-2-sample-paper-computer-science-set-2\/\">Computer Science Sample Paper Class 12 Term 2 Set 2<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/class-12-term-2-sample-paper-computer-science-set-3\/\">Computer Science Sample Paper Class 12 Term 2\u00a0Set 3<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/class-12-term-2-sample-paper-computer-science-set-4\/\">Computer Science Sample Paper Class 12 Term 2\u00a0Set 4<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/class-12-term-2-sample-paper-computer-science-set-5\/\">Computer Science Sample Paper Class 12 Term 2 Set 5<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/class-12-term-2-sample-paper-computer-science-set-6\/\">Computer Science Sample Paper Class 12 Term 2 set 6<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/important-computer-network-class-12-question-answer\/\">Computer Networking Question and Answer<\/a><\/span><\/h2>\n<h2><span style=\"text-decoration: underline;\"><a href=\"https:\/\/cbsepython.in\/important-question-answer-class-12-computer-science\/\">Important Question Answer for Term 2 Exam<\/a><\/span><\/h2>\n<h2><a href=\"https:\/\/cbsepython.in\/database-questions-for-class-12\/\"><span style=\"text-decoration: underline;\">Database Management System Questions with Answer<\/span><\/a><\/h2>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Computer Science Sample Paper Term 2 Class 12 Sample Question Paper COMPUTER SCIENCE (Code: 083) Maximum Marks: 35 \/Time: 2 hours &nbsp; General Instructions *\u00a0 The question paper is divided into 3 sections \u2013 A, B and C * Section A, consists of 7 questions (1-7). Each question carries 2 marks. * Section B, consists [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-1805","post","type-post","status-publish","format-standard","hentry","category-cbse-sample-papers-class-12"],"_links":{"self":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/1805","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/comments?post=1805"}],"version-history":[{"count":0,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/1805\/revisions"}],"wp:attachment":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/media?parent=1805"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/categories?post=1805"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/tags?post=1805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}