STD XII

MULTIMEDIA ANDWEBTECHNOLOGY

SAMPLE PAPER-3

1.(a)ObservethetableCompFest ofaDatabasenamedEventsgiven below carefully

andanswerthequestionsthatfollow:3

DataType

!'EventiDNumber

iEventNameMemo

!EventDateDate/Time

; EventVenueText

EventTlmeDzte7Time

EventExpenditureCurren

(i)Nametheviewinwhichthetableisshown-DesignorDatasheet.

(ii)WhatdoesthekeysymbolnexttotheEventlDfieldnamedesignate?

(iii)TheEventNamefieldhastobemaximum30characterslongbuthasbeen wronglygiventheMemodatatype.Suggestthecorrectdatatypeforthisfield.

(iv)WhatwillbetheimpactofchangingthedatatypeoftheEventldfieldtoAutoNumber?

(v)Canthisviewbeusedtoaddanewfieldtotheabovetable?

(vi)Whatisthedegreeoftheabovetable?

(b)ThetableFreeAppisusedtomaintaindatarelatedtothefreemobileapplicationsdesigned byaCompany.Studythetableandanswerthefollowingquestions

AppID / AppName / AppUtility / AppVersion / AppIntroDate
FA100 / Locklt / LockMessages / 1.0.2 / 01-01-2013
FAl01 / Chat-O / ChatMessenger / Beta / 01-01—2013
FAlG3 / FreeChat / ChatMessenger / 1.0.3 / 04-I l-2013
FA104 / Pixe1I1 / ImageEditor / Beta / 1 1-12-2013

(i)NamethetwofieldsthatcanactascandidatekeysinthetableFrceApp.2

(ii)Ifanew fieldnamed ApplntroTime isaddedtotheabovetablethatwillstore the introduction Time, then name the appropriate data type thatshouldbcused forthisnewfield.

(c)FatimaispreparingforherMedicalentranceexamsandwantstobeabletoconductliveconfcrcncewithtwoofherclassmateslocatedindifferentareasof"thecity.Whichofthefollowingmoderntechnologywillhelp her avail thisservice?

(a)VideoTelephony

(b)VideoConferencing

(c)VideoonDemand

(d)WhichimagefileformatoutofGIF,JPEGandBMPisthemostsuitableforstoringcompressedgraphicswithlotsofcolours?

Answer the following questions based on HTML :

a. Name the attribute of the <EMBED> tag to be used in the following situations :

b. to hide the sound control box

c. to play the sound track repeatedly for four times

4. Answer the following questions based on ASP :

(a)lnwhichofthefollowingsituation(s)isitessentialtouseaserversidescript

such as ASP ? JustifY.

(i) Display a welcome message when a page loads

(ii) Displaybanneradvertisements

(iii) Display an error message when a user leaves a mandatory field in a form

emPtY

(iv) Authenticate a password entered by a user

(b) What is the use ofthe querystring and cookies collection of the response object?

(c) Name the object or component used for the following:

(i) To send a redirect message to the browser to connect to a different URL

(ii) To show the number of visitors visiting a webpage

(iii) To manage information related to a user session

(d) Give the output of the following statements:

(i)Response.write (12-5+3) \ 4)

(ii) Response.write(MONTH(DATE0)*5)

(iii) Response.write(STRREVERSE(MONTHNAME(4)))

(e) Study the code given below and answer the questions that follow :

BannerAd.asp
<HTML>
<HEAD<title> City Guide</TITLE/HEAD>
<Hl align= center>The BEST Guide to your City</H 1>
<%
Set showAD=Server.Create("MSWC.Adrotator")
Response.write(showAD.Advertisement("ads.txt")
%>
</BODY>
</HTML>
ads-txt
REDIRECT change.asp
WIDTH 5OO
HEIGHT 3OO
BORDER 5
Yummyfood.gif
http ://
Order readymade healthy snacks
100
gifts.gif
http ://www. gift gallery.com
One stop shop for gifts
200

(i) The script in the file BannerAd.asp is used to display the content from the

ads.txt file. Remove the errors in the code given above so as to get thedesired result. 1

(ii) Which of the ads would be displayed most often and why ?1

(iii) If a new advertisement is to be displayed using the Ad Rotator to display

an image named "Moviesjpg" for an advertisement for the website

with description "Most reliable movie reviews",

then give the lines that need to be added to the file content.txt.1

(d) Study the code given below:4

<% Set FileObj=______("Scripting.FileSystemObject")

Set mfile: FileObj. ______("d:\contentvnlths.txt")

Do UNTIL newsfile______

ch= newsfile.Read(1)

If ch=". " Then

Ch=" ;"

end if

Response.Write(ch)

Loop

Newsfile_____

%>

(i)Fill in the blanks to complete the above code fragment that reads the textin the file Headlines.txt and displays the same on the web page afterconverting all full stops (.) to semi-colons (;).
(ii) Rewrite the code for the loop using DO WHILE instead of DO UNTIL.
(iii) How would the output of the above script change if we used the Readlinemethod instead ofRead(l) ?

6. Answer the following questions based on VBSCRIPT :
(a) Explain the concept of local and global variable with the help of a suitable example. 2
(b) Study the code given below and answer the questions that follow : 4

<HTML>

<HEAD<TITLE> Board Question </TITLE>

<SCRIPT LANGUAGE ="VBScript">

Sub Display (Message) 'Beginning of Subroutine

Document.Write (Message)

End Sub

</SCRIPT>

</hEAD

<BODY>

<SCRIPT LANGUAGE = "VBScript">

Display "Hello! Welcome to VBScript."

Call Display ("Have a nice day.")

<SCRIPT>

</BODY>

</HTML>

i.Identify and name the argument used in the above code segment.

ii. What is the usage of the '(single quote), characler in the above code

segment ? What is the alternate way of achieving the same effect inVBScript?

iii. How many times will the subroutine Display be executed?

iv What will be the output of the above code ?

(c) Write the HTML code to generate a form and write the VBScript code to display the message "Number is even" if the numberis even or 'Number is odd" otherwise on the click of the CHECK button. Themessage should be displayed in the message box.

7.(a) Name the free and open source office suite.

(b) Dhirendra wants to transfer a document stored on his mobile to his sister'smobile. They both are sitting in different rooms of their house. Choose the kindof network being formed in this case from the following :

(i) PAN

(iD MAN

(iii) wAN

(c) Soma has entered a computer network without having authorized access to checkthe security of her office. On the other hand, Promila has entered a computernetwork without having authorized access with the intent of stealing documents.

Who among them will be called a hacker and who will be known as a cracker ?

Also mention who among them is doing an ethical job ?

(d)Differentiate between E-mail and chat.

d.Write the HTML code to generate a Web Page in the format given below. 8
Use the following instructions for writing the code.

a. Background colour of the page is “magenta”.
b. Title of the page is “Special Days”.
c. Main heading –Font-“Broadway”, size-7, colour-“cyan”.
d. Horizontal line-colour –“yellow”, width-80% and size-20.
e. Fonts used for the text- “Arial”, size-6, colour-“blue”.
f. Pictures used-“Nature.jpg”, “Wishes.jpg”.

g. Use concept of numbered list for the last paragraph.

h. Earth Day is linked to the file “Earth.html”.

------