CBSE Multimedia Media & Web Technology sample paper1 class XII 2011

http://www.cbseguess.com/-------------------------------------------------------------------------------------------------------www.cbseguess.com Other Educational Portals www.icseguess.com | www.ignouguess.com | www.dulife.com | www.magicsense.com Sample Paper – 2011 Class – XII Subject – Multimedia & Web Technology M.M: 70 TIME : 3 HRS. TOPICS: MSACCESS-15 ASP-30 NETWOEKING-15 VBSCRIPT-10 INSTRUCTIONS: ATTEMPT ALL THE QUESTIONS. LEAVE TWO BLANK LINES AFTER EACH ANSWER ATTEMPT ALL THE PARTS TOGETHER. Q1. Answer the following questions on the basis of Ms-Access: (15) 1) What do you mean by Data Redundancy? How Ms-Access help to reduce it? 2 2) What is Foreign key? Explain by taking an example. 2 3) What is the difference in number and currency format? 2 4) Explain One to Many relationship by taking an example. 2 5) What is the extension of Microsoft Access database file? 2 6) Suggest the data types for the following Teacher Table: 5 T_Code -Teacher’s Code generated Automatically T_Name -Teacher’s Name DOB -Date of Birth Basic_Sal -Basic Salary Qualification -Qualification of a teacher (List should appear like-M.A., B.A, ….) Photo -Photograph of a teacher Bio-Data -Ms-Word file. Blog -Teacher’s Blog on Internet Q2. Answer the following questions on the basis of ASP: (10) 1) What is ASP? How it is different from HTML? 1 2) What is the difference in PWS and IIS? 1 http://www.cbseguess.com/-------------------------------------------------------------------------------------------------------www.cbseguess.com Other Educational Portals www.icseguess.com | www.ignouguess.com | www.dulife.com | www.magicsense.com 3) What is the difference in Byte and Integer data type? 1 4) Explain EQV and IMP operators. 1 5) Name any two ASP Components. 1 6) Name any two Objects in ASP. 1 7) Name objects required to manage database through ASP. 1 8) Write any two Server Variables. 1 9) What is the full form of ODBC? 1 10) What is the use of Response.Redirect? 1 Q3. Answer the following questions on the basis of ASP: (10) 1) Give the output: 2 a) Response.Write(Round(234.543,2)) b) Response.Write(ASC(“A”) c) Response.Write(SQR(25)) d) Response.Write(Len(LTRIM(“###Hello”))) # stands for space 2) Change the following script using FOR…NEXT without affecting the output: 2 <% DIM A(5), C C=1 DO UNTIL C>5 A(C) =C*C C=C+2 LOOP %> 3) Give the usage of 2 a) CSTR b) CLNG 4) Create the following form and Print the data in deired manner: 4 Please fill the data Name http://www.cbseguess.com/-------------------------------------------------------------------------------------------------------www.cbseguess.com Other Educational Portals www.icseguess.com | www.ignouguess.com | www.dulife.com | www.magicsense.com Favourite Car Volvo Saab Bmw Hobby Reading Gardening Output should be Your name is _____________ You like _____________ car. ____________ is your hobby. Q4. Answer the following on the basis of ASP: (10) 1) Differentiate ASP Application and Session objects. 2 2) Explain the structure of Global.asa file. 2 3) Name any two collections of Request Object. 1 4) What is the use of GetAllContent method in Content Rotator? 1 5) Write a program to read a text file named abc.txt and print the contents of the file on the screen replacing all spaces in the file by # symbol. 4 Q5. Answer the following questions on the basis of VBScript: (10) A) 2 http://www.cbseguess.com/-------------------------------------------------------------------------------------------------------www.cbseguess.com Other Educational Portals www.icseguess.com | www.ignouguess.com | www.dulife.com | www.magicsense.com B) Write command t appropriate places to print the table of 5. 2 C) What is the difference in OnLoad and OnUnload Events? 2 D) Write the code to display the following form and add the vbscript to display the results as written when user enter no. of days that he has worked and wages per day and clicks on calculate button. (total salary=No. of days*Wages per day) 4 Q5. Answer the following questions on the basis of Networking: (15) 1) Write the full forms 2 a) CDMA b) WLL c) OSS d) FTP 2) Write short note on the following: 2 a) Cyberlaw b) OpenOffice c) Digital Library d) Virtual Reality Current Date Current Time No. of days Wages per day Total Salary Clear Calculate http://www.cbseguess.com/-------------------------------------------------------------------------------------------------------www.cbseguess.com Other Educational Portals www.icseguess.com | www.ignouguess.com | www.dulife.com | www.magicsense.com 3) What is the difference in Hub and Switch? 2 4) What is the difference in Freeware and Proprietry software? 2 5) What is Python? 2 6) Answer the following questions: 5 An Organization has its offices in building A, B, C and D. The details are as follows: Centre to Centre distances between different buildings are as follows: Block A to Block B 100 m Block A to Block C 70 m Block A to Block D 20 m Block B to Block C 150 m Block B to Block D 120 m Block C to Block D 140 m Each of the above buildings has following number of computers A 65 B 30 C 25 D 40 (i) Suggest and draw the layout for a network, with proper justification to connect all the office (ii) Where would the following preferably be placed • Repeater (iii) Suggest the most suitable place to house the server for the organization with proper justification. (iv) If the organization needs to link up to a branch office which is in a neighboring city, (around 100 km distant) suggest the best type of cabling connection, from the building hosting the server, provided price is not a factor. Paper Submitted by: Name: RAJNI AHUJA Email: rajniahujas@gmail.com Phone No. 01732-226539