Multimedia and Web Technologies Sample Question Paper : Plus Two 12th Std +2 www.cbse.nic.in

**mariammal** · February 17th, 2012, 04:42 PM

Document Described : Multimedia and Web Technologies Question Paper, CBSE Question Paper

SAMPLE QUESTION PAPER 1
MULTIMEDIA & WEB TECHNOLOGIES (Code 067)
Class XII
Max. Marks : 70 Duration : 3 hrs.

1. a) Define the term foreign key. 1
b) Name the following : 1
i) An attribute which is capable of becoming a primary key.
ii) The MS-Access view in which we can define the fields, their data types and their input masks.

http://www.cbse.nic.in/curric~1/sample2012.htm
http://www.cbse.nic.in/curric~1/sqp2012/SQP%20OPTIONAL%20SUBJECTS%20Class%20-%20XII%202012.pdf

c) What is the full form of MPEG? What kinds of files are stored using the MPEG file format? 1
d) Study the following data and answer the questions given below :
Table: Sales
Sale_Date Item_name Bill_No Item_Price Quantity_Sold
11/12/2003 Pen 101 20.50 5
09/10/2003 Pencil 212 5.00 12
09/10/2003 Eraser 203 8.25 10
08/12/2003 Pencil 113 5.00 3
07/11/2003 Stapler 126 30.00 15
07/11/2003 Pen 254 20.50 8
i. If the Item details have to be stored in a separate table (named ITEMS), 1 then identify the two fields from the above table which should be included in the table ITEMS.
ii. Suggest the data types that should be used for each of the fields in the 2 above table.
e) Differentiate between a GIF and a JPEG image. 2
f) Explain the term “Publishing a Flash Movie”? Name any two formats in 2 which a Flash movie can be published.
2. Answer the following questions based on Macromedia Flash :
a) Define the term Timeline. 1
b) What is a symbol? 1
c) Differentiate between a Key Frame and a Blank Key Frame. 2
d) Explain tweening with the help of an example? Name the two kinds of tweening. 2
e) Observe the figure given below and do as directed : 4
yellow blue
The box on the right hand side shows the position, size and colour of the image for frame 1.
The box on the left hand side shows the position, size and colour of the image for frame 20.
The box has to move from frame 1 to frame 20 over a period of time.
Write the procedure and property settings for animating the above scenario.
3. Answer the following questions based on HTML:
a) Differentiate between HIDDEN and PASSWORD interface elements of a form. 1
b) Explain with the help of an example how ‘intrafile’ linking is done. 1
c) Write the HTML code to generate a Web Page in the format given below: 8
Consider the following while writing the HTML code
1. Background colour of the page should be “Gray” and visited link colour should be “Green”.
2. Font face of text in the page should be “Arial”
3. Text colour of main heading should be “Maroon”
4. Picture used in the page is the file “map.jpg”
5. The text “Ghumo Phiro Travels” should be in “Red” colour and in “Bold”
6. Pages linked to:
Rajasthan Packages as “raj.html”
Kerala Packages as “kerala.html”
7. The table should have a caption “Tarriff”.
8. Bottom message should be of size 2.
4. Answer the following questions based on ASP :
a) What is the basic difference between a HTML file and an ASP file? 1
b) Identify the following:
(i) The collection used to retrieve the values of form elements sent using the POST method.
(ii) The alternate command for <% =”HELLO” %> 2
c) What is a sub-routine? What are arguments? Explain with an example. 2
d) Use the following script to answer the questions that follow : 2

<!- - Start the script - - >
<%
DIM A
StartSub
Sub StartSub
Work
B = 20
Work
END SUB
SUB Work
A=A+5
END SUB
%>
(i) What is the scope of variables A and B in the above script?
(ii) How many times will the subroutine Work be executed in the above
script?
e) Give output of the following statements : 3
i) Response.Write(INSTR(LTRIM(“ WebTech”), “Tech”))
ii) Response.Write(UCASE(RIGHT(“Multimedia”,5)))
iii) Response.Write(ABS(4 – 10 * 3))
5. Answer the following questions based on ASP:
a) Explain briefly the usage of the Application object. 1
b) Underline the errors in the following code and write the corrected script.
<HTML>
<BODY>
<% for a = 1 To 4 %>
<FONT SIZE= <% a %>>
Hello World !<BR>
< Next>
</BODY>
</HTML>
c) Give the output for the following code segment: 2
<%
Arr=Array(25,14,20,45)
max=UBOUND(Arr)
FOR i=max TO 1 STEP -1
Arr(i)= 100-Arr(i)
NEXT
FOR i=0 TO max
RESPONSE.WRITE (Arr(i) & “<BR>”)
NEXT
%>
d) Observe the program segment given below carefully and fill the blanks marked as Line 1 and Line 2 using methods of the RecordSet object for performing the required task. 2
<%
DIM objConn, strConn, objRS
SET objConn = Server. CreateObject(“ADODB.Connection”)
strConn = “DSN=exam”
objConn. Open strConn
SET objRS = Server.CreateObject(“ADODB.RecordSet”)
objRS.Open “Student”, objConn, 2, 2
objRS.MoveLast ‘Move the cursor to the end of file
______________ ‘Line 1 to Add a new blank record
objRS(“AdmNo”) = Request.Form(“AdmNo”)
objRS(“Name”) = Request.Form(“Name”)
______________ ‘Line 2 to save the record in the database
objRS.Close
objConn.Close
SET objRS = Nothing
SET objConn = Nothing
%>
e) Online Bazaar uses its website to make money through banner advertisements. Create an ASP file “online.asp” that uses the AdRotator component to display the advertisements stored in the file “ads.txt” 3
6. Answer the following questions based on VBScript :
a) Define the term event. Name the events to be used in the following situations : 2
(i) To display a message every time the viewer closes a web page.
(ii) To deactivate a particular textbox in a form
b) Write the equivalent script for the following code using DO.. WHILE loop without affecting the output : 2
<SCRIPT LANGUAGE=”VBScript”>
DIM sum
sum=0
FOR a= 1 TO 10 STEP 3
sum=sum + a*a
document.write(a)
NEXT
document.write(sum)
</SCRIPT>
c) Give the output of the following code segment: 2
<Script Language=”VBScript”>
Dim A , B
A = 1
B = 10
Do While A < 5
Document.Write(A+B)
A = A + 1
B = B - 2
Loop
</Script>
d) Write an HTML code for creating a form, which contains three textboxes as shown below. The first two textboxes accept two numbers as input from the user and the third textbox displays the sum of these two numbers. Include the VBScript code which contains a user-defined function required to be called when the user changes the values in any of the first two text boxes. 4
7. Answer the following questions based on Communication and network
concepts:
(a) Define the term protocol. 1
(b) Aleena is interested in transferring few Songs from her mobile phone to Sanyan’s mobile phone. Suggest two suitable wireless options she may opt for to do the same. 1
(c) Differentiate between a Hub and a Switch. (Give one point) 2
(d) Explain the following terms: 2
i. Firewall
ii. Cracker
e) Knowledge Supplement Organisation has set up its new center at Mangalore for its office and web based activities. It has 4 blocks of buildings as shown below:
Center to center distances between various blocks
Block A to Block B 50 m
Block B to Block C 150 m
Block C to Block D 25 m
Block A to Block D 170 m
Block B to Block D 125 m
Block A to Block C 90 m
Number of Computers
Block A 25
Block B 50
Block C 125
Block D 10
(i) Suggest a cable layout of connections between the blocks.
(ii) Suggest the most suitable place (i.e. block) to house the server of this organisation with a suitable reason.
(iii) Suggest the placement of the following devices with justification
Repeater
Hub/Switch
(iv) The organization is planning to link its front office situated in the city in a hilly region where cable connection is not feasible, suggest an economic way to connect it with reasonably high speed?

Doc file is for Attachment only.To know full details see the PDF link.