1.

a)

What is a tuple in a table of a database?             

1

b)

Name any two types of relationships that can be set between two tables.             

1

c)

Study the following data and answer the questions given below:

                     Table : Student

1. Suggest the datatypes that should be used for each of the fields in the above table.

2. Suggest a field from the above table, which can be set as the primary key                 

2

1

d)

Give the full forms and a difference between .DAT and a .GIF file with respect to multimedia.

2

e)

Give two differences between AVI and MPEG file formats.

2

f)

Name the extension of the file created when a Flash movie is published using a Macintosh projector.    

1

2.

Answer the following questions based on Macromedia Flash:

a)

What is a key frame?

1

b)

Define the term stage.

1

c)

Explain the terms Shape Tweening and Motion Tweening with the help of an example.

2

d)

Explain the usage of Timeline.

2

e)

Observe the figure given below and do as directed:

Flash

Flash

• The text on the left hand side shows the position and size for frame 1. The colour of the text is black.
• The text on the right hand side shows the position and size for frame 20. The colour of the text is grey.

Write the procedure and property settings for animating the above scenario.

4

3.

Answer the following questions based on HTML:

a)

Specify the tag and attributes used to create a textbox which can accept  maximum of 20 characters with a default value “Enter Name”.

2

b)

Write the HTML code to generate a Web Page in the format given below:

Consider the following while writing the HTML code:

1. Background colour of the page should be “Cyan”.
2. Text style should be Comic Sans MS and colour should be Red.
3. Picture used in the page is the file “activity.jpg”
4. Table should have a border of color blue.
5. Use the concept of nested lists for creating the list given in the web page with specified bullets.
6. Pages linked to :
   • Indoor Activities            as   “in.html”
   • Outdoor Activities         as   “out.html”
7. Bottom message should be of size 2.
8. 
   

8

4.

Answer the following questions based on ASP:

a)

Mention any two features of ASP.

2

b)

What is the purpose of the HOUR( ) function? Explain with the help of an example.

2

c)

Explain with examples the difference between implicit and explicit declaration of variables.

2

d)

Write a command to remove the leading and trailing spaces from a character variable NAME, where NAME = “##Smriti# Malhotra###” (where # denotes a blank space).             

1

e)

Give the output for the following :

1. Response.Write(LTRIM(LEFT("####Congratulations", 7))              (where # denotes a blank space)         
2. Response.Write((3 *5 > 4 + 5) AND (2 ^ 3 + 9 2))
3. Response.Write(ABS(3 – 11 * 4))

5.

Answer the following questions based on ASP:

a)

Name and specify the usage of any two ASP components.

1

b)

Differentiate between Properties and Methods with the help of an example.

2

c)

Underline the errors in the following code and write the corrected script.

<%

dim fname
fname=Request.Query("fname")
If fname<>"" Then
      Response.Output("Hello "   fname "!<br />")
      Response.Output("How are you today?")
End
%>

2

d)

Give the output for the following code segment:

<%
Arr=Array(25,14,20,45,25,4,1,31)

max=ubound(Arr)

For i=max to 1 step -2
Arr[i]= 10*Arr[i]

Response.write (Arr(i) & "<BR>") 

next 

%>

2

e)

Green Environment Club is a company, which aims at creating an awareness among the people about the ill-effects of pollution. The company wishes to create a web site, which provides information about all their activities. Write the ASP coding for the home page with the following specifications:

• To display links to other pages. The links Reuse Recycle, Activities, Join Us link to the files Reuse.ASP, Activity.ASP and Join.ASP respectively.

• To display the number of times the page has been visited.

The suggested format of the page is shown below:

3

Environment Club

Welcome to the green world. Click the links below to know more about us.

Reuse Recycle

Activities

Join Us

This page has been viewed 2163 times

6.

Answer the following questions based on VBScript:

a)

Differentiate between IF…THEN..ELSE and SELECT…CASE statements with the            help of an example.

2

b)

Write the equivalent script for the following code using DO..WHILE without effecting the output:

<SCRIPT LANGUAGE="VBScript">

DIM arr(5)

counter=1

DO UNTIL counter > 5

arr(counter) = counter *counter

counter =counter + 1

loop

</SCRIPT>

2

c)

Give the output for the following script:

<Script Language="VBScript">

B=10

For A=1 to 12 step 3

  C=A+B

Document.Write(C)

B=B-1

   Document.Write(“<BR>”)

Next

</Script>

2

d)

Write an HTML code for creating a form, which accepts the birth date from the user in a textbox and displays the day of the week in a message box on the click of a

button.

4

7.

Answer the following questions based on Communication and network concepts:

a)

Name any two units to measure data transfer rate.

1

b)

Write one difference between a Hub and a Gateway.

2

c)

Explain the following terms:

1. Telnet
2. CDMA
3. Hackers

3

d)

The Cyber Mind Organisation has set up its new Branch at Mizoram for its office and web based activities. It has 4 Wings of buildings as shown in the diagram:

X

Y

Z

U

Center to center distance between various blocks

Number of computers

4

(i)

Suggest a most suitable cable layout of connections between the Wings and topology.

(ii)

Suggest the most suitable place (i.e, Wing) to house the server of this organization with a suitable reason with justification.             

(iii)

Suggest the placement of the following devices with justification:                                                       

• Repeater
• Hub/Switch

(iv)

The organization is planning to link its head office situated in Delhi with offices at Mizoram. Suggest an economic way to connect it; company is ready to compromise on the speed of connectivity. Justify your answer.