TARTAR wage ms ame] & t | mat oi f Qr.coie OL & i e SERRE ERR EERE COMPUTER SCIENCE 4, 6 Phase chuck that this question paper cotins 15 printed pg. a ‘ a F 6 cap con inn on hit hank he tion papers be Frnt pa the stoner heat & f : 4 6 Ps ch ha i qin roti 8 oon 4 ‘ 2 Pome wre down ie sr umber ofthe guetonin th ane soak fies s * s Ee 15 minute time har bon alte to wea this queition pager. The ‘ £ ution pape edd 1018408 Frm 10180 121090 i al yan wl at we mses id ine a an nt ae |B snranener onthe ane ek inet i a “1 : smasanssassussasassnsise} Baum Be <—> @orro. Thus yuri paper conan Futons, Section Ato (AM esesins ot sont {iy Section have 1 gens crying ¥ mark each {3 Steton has 7 Coy Sort Nearer pe gerne crying F mark {ct Section Dhar Lang Annu ne sunt sing marks ch {Sty Steen Bhar 2 guste rin mos eae One ir Oe ‘on n @. 3 and 38 aia ot oy (isa ragromming gc arto Beans ming PthonZangnoee SECTION ‘State rao Fae Seer ae Sees dt ety a rib nein i prog Whi of the lowing all ewan in Phan? a) tae ‘re en 2 mm Wh how tates wile in ee pei tt 00 (Or tap insert (243) @ Prine enpiian @ prvsatieninp) rc 0) Fatee omWhich of ee illowing odo hp he le fit posto a th ond fhe io ow: o® @ Piste tank 1 “ston owed to rang th een @ weno ‘om (6) Seoendinge @ scored) Which fhe wing operator wil tr ithe Trae Fale? 1 oe oo @ > on Which ft flowing tenets) woul gw an ree er exaing Statement Steet 3 (@ Bent and 4 Pin he lank 1 ere tambo apes ina lain eee TD) cosroe © Sinaia (@) coratnasey ES dbjace aeestostset’-roteronon point)? ‘Whatie the dean aso saSerance poste? oo wt a2 ca tin th an. : "than rand with SELECT statement dpa data inetd ‘em with nop ton opi cam, ieee i) onan sv (ol tases (@) srsriuer > vse 6 iin tbe ane ‘usd fr paint pint commoniaion oF wkat communition ‘Sacha ada and aalit, (G) steranso wins 0) surrcore (© srcrounves @ saoroaes Wat wi te fing grin brat in Pon? @ as ® 80 @ 102 @ 1.0 Wich funciona he allcomente ot? (® couneo) Cy © tuo) @ sn {ital eto Steel roms rel st end ours a (@ pie of Liste @) Lise of tonier (Lise of stctnae @ Tople of eeeiege 17 and 1 are ASSERTION (and REASONING GO based comin Mark the ure ices (a) Bn (A ad are ra athe correct explanation be (2) Both A) and ve kv a (nt She coe explanation fo o ©) ietrctar iste CO) fale doe lates, “Austin (A): To we a foto fom spatula ale, wend to ‘ipo the modal Ronson import statement ca be wet anywhere in the POET, "more ning fein fo ant mal [Assertion ():A sack LIPO sre ‘Remon (8): Any now slement puoed int dhe sack svar te “Seamed the nr he nt xing lament oe tok, a &sera trie re i ‘hee ae i he eb fet ncaat (@) Diderot between URL and ota ae with the ep of a rprepete crap (2) Given ina Phen at lation, 1 (0) Consider te fatlowing tuple decoration 1 xplin the cocet of "Akersto Rey’ inn Relational Detsase ‘name Suen nits an appropele sua 2 (a) We to fl ame of the allowing 2 ti ter (oy Whartethe ned Prose? (a) Write the ouput ofthe de given below 2 tne tinsdet(atetaetid oa (0) Write he oat fhe cea bo 2 (a) tecsint twin CHAR and VARCHAR data fp in SOL with ypepite xm 2 (4) Name ans tm DDL and any two DMI mma, 2 seenioN-c (a) Consider te fooning abe - LAN and BORROWER ase i WAN TOAN.NO | B.NAME [AMOUNT | teim_—| eta 3000 Laan KANPUR oo ‘ale. BORROWER CUT NAME_ LOAN NO SOHN erin “xnst —Tu20, ceava—_lieavo ow meny rors a ane wil be Ue inthe natura in of hone wea(Write the utr of the quiron 1) te Gx) as on the table, [WOHKER shen tw | (van esa Tusawe [ory [arare 2 [sam aiaN | kaPOR | Saati [PARIKH | ROOP NAGAR | FUNSA any |aones [peu [peu [STHARWA[RILAKOWAd| DKA [pate 1 Lae (i) seuber oxsriner cexre1 Fen wenn (iy soxecr raw, STAT ra MOREE WERE NOE (2) Write the sf of » Python fenton named tongines\ | ich reas thy couse fs tt fle named “L900 980" nd {Eo Gt ne ti le sh 1 i ‘nee upon te here was «woodcut ‘re tved ine ile howe ia beue,green wood. ‘One day, he was merrily hopping some woud. Ie saw lit eel skipping through the woods whit hep ‘The srl was followed by a big gray wo ‘Then the fantom sh apa output: Te ive in hile hour in beautiful teen wood He maw litle gel shipping throvah the woods whiting hep (0) Write a funtion count_beorés() in Python to eount the woede sing witha dita va lo eet Brame {the le conte lows ‘ment VPI wl oe and ‘meat VVIPE willbe siting ote willbe Naser worsening witha dig ae 4 (Wit tha tps fhe $01 quero to ed onthe eatin ‘COMPUTHR und SALES een bom ‘Tobie: COMPUTER PROD_ID (@) SELECT WIN (PRICE), MAK(PRICE) FROM COMPUTER: Go suace comma, comme) ro coMTRER Oar (ip seiner enoo kav, OTF SOLD FROM CUREVTER Cy 34:83 (Ov) SELECT FROD_NAME, COMPRITY, QUARTER FROM COMPUTER (4) Wek the coon to vow al database. @o &‘29, Write function BORepnceD in Python which scope a fiat 1 of Dpumbers Therenfer ft inrementa all cron numbers by tan decrement (Meda umber by a a Bump Scene input data othe it EeptoedoNordbraey 58h Ost te SS aa 38, 50) 20. a) Alistcontin ling reed af eter: ussonet name Boom Hel Wee the flowing wer defined functions to perform ginen rato on the srk ned evel" (Oy tune cust {| To Push canter! names of ow users ‘who are seg in Dea’ Hoo Type (6) Top sase() To Pop the mero caromers fom he wack Sn pay them. Abo, iny "Unde wes there ae 0 [ther withestomer eta ae tis: Tere n os ln ym ait vn i Tensei he oma ce Se ce ee a hn Rsmachdomtte eircksack™™ cee Soscnwntlona a > i pro. oo SECTION -D ickdes, an TT base Gm, tonto in Dui ix planing to setup & ‘two fo iter branches within iy with i Martin dopartanect ‘in Kanpur. Ara setwork profane solutions the ston) (©), afer eine through the branshe losons and ther dete which ave sven below ELAM BRANCH KANPUR BRANCH (awanewx) — [oRaNCHB |) [MARKETING DEPT.) [BRANCH C | Distance between varius tranches ia fl = aie Branch Ato ranch) 0m Branch Ato ranch D__| 65m ih Branch ©) 0 ranch Bes Branch Dam Braneh Co Bch D 15m eth Beanch to Kanpur 300 km ‘Number of computers in each fhe braces RR Natieey ot Sarsouters Basch A a Branch Bo) 2 Branch € 0 Branch D ns (©) Sogetst dhe moet suitable place to neal the server fr the Det ‘ranch with a sultable renee, a a(3) agp a el yon fo mat al th rane iin oo 1 (4) Which devie wil ou mugen, that should be ple in eat ofthe branche to eicienly sande all the computers within thee ‘ranches? 1 (Go) ath Sem i planning to conoa ois Mackting department in ‘Kanpur which appeal 300 aay. Woh type tor out f LAN, WAN or MAN wl befrmed ? Just your taewers 1 (©) Surgest a proto hat shall be aseded to provide Belp fr ‘uanfersng of Sle bxoneen Deh abd Kapur bran 1 8% (@) What pose cops) are expected be payed on geen tthe a ‘ne of cation th ling prota no(5y 045,26 25,20) random. sands (3,6)~ 2 eine [Firat] Msec], third), sapm! © fonsns ‘a s#2si20 in so4z0420 (oy) 10n5e254 (8) The coe vento dels th crt frm the tabla epee whic ‘ones th filowing roe secre cose = ting Enaee String Sal later hey Sting [Note the filing etal omni between Phan and M9 SQL 2 eename ier 2 panned oot 1 Thetable eran MySQL detabase nated exe {Tho dtale (22code, sane, 941, city! are he aetna the ea => Bom Write te falowinr tatements te comple the de ‘Statemeat 1-10 \nport the dea rary. Satomeot 2—t execute the command ha ee the rece with ‘Statement 3-1 dette red permanently rm the database, (0) Pret the outpace gan bo a> &(8) The coe given blow ras the illowing rms fom the ele srolcyce and dpinge only thow re who have amps coming fo ity Deh code Sting ane Sting uty Sting Note the falling to slab connatviy tween Pon and ys + Username root + Theta sna in ApS Stan aap obeubl Write ong statements compte the cole ‘a Stanwnt2~ terete the ey tha cos rc the mses “ming frm ty Del Satement 3 to red the compl at ho query co whos ity ‘ath it hej aed e's om the eble ome Ah date. nyoureoenyd.cureor() . pro. (©) Wet one rans bteen CS apd eat len Wrst spregram in Python tt defines ils the lowing wset {)"Sooniee ADDU): I ken the values fom the seer and ada ‘he dts own le cous ee soy" Hack ol cet "tet with ellen ak sic spans conte Sepsinaticn to tre Courier TD, Seder Fame Sourer td estnatn nes rope GEORTER SEARCH Tao the dewinaton athe inp and ‘ela al the oir corde ng ns desontio on ‘oy i important cla le ef exting? ‘Wete a progam n Python hat dene and le the lowing wer (6) Add Book: Takes tbe desi of he bck and adds the oa Sey Ble "Bok.e?” ack soo sot of» lat wi eld tlements an book 1b, 8 nave ahd puso or bo ID, bok ‘ume and pabihir nape Search Bert: Tae ple name a input and oun and ‘Sepa number tne pbc ten, SECTION - ‘The school hat asad the state misager Mr, Ratt omits the sts all labs in tale LAB Rahul bas rented tbe an eae tg fab ® | EAINO [LAB NAME. [INGHARGE CAPACITY | FLOOR} ra iy im To. ony a 08 Pree t Lens AGE 6 1005 COMPUTER [Mary Koa s7 ny ‘Basdom the data give above anewer the owing qT ("entity the satu whieh ean bcnaer os Candidate koe, (i) Write the degree and early of he ae (iy Write theta (a) Insert a new row with appropiate data, (8) Ince the capacity oll he abs by 10 stdents which at 1, on ‘ (Option for par only) Gi Write the tents te (9) Ada cnsrat PRIMARY KEY tothe ohn LABNO i abe (©) Deletes able LA <>Sri mer Bae Tro tom op 9 “ctf. br cee Westen ey ha 8. Caan a ees in Stet 9 ee dao ic et na ts rer pone sai th oe mere ore or opin fon pr ion) ena sia St Ree eh te my te at bar Write te seit he da wy _ &