Page 1 :
Sample Question Paper, COMPUTER SCIENCE (Code: 083), Maximum Marks: 35, , Time: 2 hours, , General Instructions, , , , , , , Q., No, 1., 2., , 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 7, 8 and 12., Section -A, Each question carries 2 marks, Question, , Part, No., , Marks, , Give any two characteristics of stacks., , (2), , (i), , Expand the following:, SMTP , XML, , (1), , (ii), , Out of the following, which is the fastest wired and wireless medium, of transmission?, , (1), , Infrared,, coaxial, cable,, microwave, Ethernet cable, , optical, , fibre,, , 3., , Differentiate between char(n) and varchar(n) data types with respect (2), to databases., , 4., , A resultset is extracted from the database using the cursor object, (that has been already created) by giving the following statement., Mydata=cursor.fetchone(), (a), (b), , How many records will be returned by fetchone(), method?, What will be the datatype of Mydata object after the, given command is executed?, [1], , (2)

Page 2 :
5., , Write the output of the queries (a) to (d) based on the table,, Furniture given below:, , (2), , Table: FURNITURE, FID, , NAME, , DATEOFPURCHASE, , COST, , DISCOUNT, , B001, , Double, Bed, Dining, Table, Single, Bed, Long, Back, Chair, Console, Table, Bunk, Bed, , 03-Jan-2018, , 45000, , 10, , 10-Mar-2020, , 51000, , 5, , 19-Jul-2021, , 22000, , 0, , 30-Dec-2016, , 12000, , 3, , 17-Nov-2019, , 15000, , 12, , 01-Jan-2021, , 28000, , 14, , T010, B004, C003, , T006, B006, , (a), , SELECT SUM(DISCOUNT), FROM FURNITURE, WHERE COST>15000;, , (b), , SELECT MAX(DATEOFPURCHASE), FROM FURNITURE;, , (c), , SELECT * FROM FURNITURE, WHERE DISCOUNT>5 AND FID LIKE "T%";, , (d) SELECT DATEOFPURCHASE FROM FURNITURE, WHERE NAME IN ("Dining Table", "Console, Table");, , 6., , 7., , (i), , Which command is used to view the list of tables in a database?, , (1), , (ii), , Give one point of difference between an equi-join and a natural join., , (1), , Consider the table, MOVIEDETAILS given below:, , (2), , Table: MOVIEDETAILS, MOVIEID TITLE, , M001, M004, , LANGUAGE RATING PLATFORM, , Minari, Korean, MGR Magan Tamil, [2], , 5, 4, , Netflix, Hotstar

Page 3 :
M010, M011, , M015, M020, , Kaagaz, Harry, Potter, and the, Chamber, of, Secrets, Uri, Avengers:, Endgame, , Hindi, English, , 3, 4, , Zee5, Prime, Video, , Hindi, English, , 5, 4, , Zee5, Hotstar, , (a) Identify the degree and cardinality of the table., (b) Which field should be made the primary key? Justify your, answer., OR, (a) Identify the candidate key(s) from the table MOVIEDETAILS., (b) Consider the table SCHEDULE given below:, Table: SCHEDULE, SLOTID, S001, S002, S003, S004, , MOVIEID, M010, M020, M010, M011, , TIMESLOT, 10 AM to 12 PM, 2 PM to 5 PM, 6 PM to 8 PM, 9 PM to 11 PM, , Which field will be considered as the foreign key if the tables, MOVIEDETAILS and SCHEDULE are related in a database?, SECTION – B, Each question carries 3 marks, 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:, ● Push the keys (name of the student) of the dictionary into a, stack, where the corresponding value (marks) is greater than, 75., ● Pop and display the content of the stack., For example:, If the sample content of the dictionary is as follows:, [3], , (3)

Page 4 :
R={"OM":76, "JAI":45, "BOB":89, "ALI":65, "ANU":90,, "TOM":82}, The output from the program should be:, TOM ANU BOB OM, OR, 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., ● Traverse the content of the list and push the even numbers, into a stack., ● Pop and display the content of the stack., For Example:, If the sample Content of the list is as follows:, N=[12, 13, 34, 56, 21, 79, 98, 22, 35, 38], Sample Output of the code should be:, 38 22 98 56 34 12, , 9., , (i), , A table, ITEM has been created in a database with the following, fields:, , (1), , ITEMCODE, ITEMNAME, QTY, PRICE, , (ii), , Give the SQL command to add a new field, DISCOUNT (of type, Integer) to the ITEM table., Categorize following commands into DDL and DML commands?, , (2), , INSERT INTO, DROP TABLE, ALTER TABLE,, UPDATE...SET, 10., , Charu has to create a database named MYEARTH in MYSQL., (3), 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:, Table: CITY, FIELD NAME, , DATA TYPE, , REMARKS, , CITYCODE, , CHAR(5), , Primary, Key, , CITYNAME, , CHAR(30), , SIZE, , INTEGER, [4]

Page 6 :
(c) To display the names of employees whose salary is not known, in, alphabetical order., (d) To display DEPTID from the table EMPLOYEE without repetition., 12., , (i), , Give two advantages and two disadvantages of star topology, , (2), , OR, Define the following terms:, www , web hosting, (ii), 13., , How is packet switching different from circuit switching?, , (2), , BeHappy Corporation has set up its new centre at Noida, Uttar, Pradesh for its office and web-based activities. It has 4 blocks of, buildings., , (4), , BeHappy Corporation, Block B, Block A, , Block D, , Block C, , Distance between the various blocks is as follows:, A to B, 40 m, B to C, 120m, C to D, 100m, A to D, 170m, B to D, 150m, A to C, 70m, Numbers of computers in each block, Block A - 25, [6]

Page 7 :
Block B - 50, Block C - 125, Block D - 10, (a) Suggest and draw the cable layout to efficiently connect, various blocks of buildings within the Noida centre for, connecting the digital devices., (b) Suggest the placement of the following device with, justification, i., Repeater, ii., Hub/Switch, (c) Which kind of network (PAN/LAN/WAN) will be formed if the, Noida office is connected to its head office in Mumbai?, (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?, , [7]