CBSE Class 12 Multimedia And Web Technology Worksheet

Database concepts

1. Define the term foreign key with the help of an example.

2. What do you understand by the term primary key?

3. What is a tuple?

4. Define alternate key with the help of an example..

5. Define Candidate key.

6. What is the relation between a candidate key and a primary key with respect to a database ?

7. What is DBMS? Give an example of a DBMS.

8. What is a Database? What is a DBMS?

9. What do you understand by the degree of a table?

10. Explain the concept of foreign key with the help of an example.

11. Explain the terms tuple and cardinality with the help of an example.

CH 2 – Starting MS – Access

1. What is the difference between Text and Memo data types used in MS- Access?

2. What is the difference between the Number and Auto Number data types in Access?

3. Name any two types of relationships that can be set between two tables in MS-Access.

4. Differentiate between the design view and datasheet view in Access.

5. Identify the most suitable data type for the following data items:

i) Age of a person.

ii) An address

6. Name the following :

i. An attribute which is capable of becoming a primary key.

ii. The MS access view in which we can add define the fields , the data types and their input masks.

iii. The extension of an Access database file.

iv. The view in which we can add, edit and view records in MS-access.

v. A data type which can be used to automatically store monetary values with appropriate sign, commas and decimals.

vi. A part of the Microsoft office suite that is used to create and manage databases.

1. What are the functions of a computer?

2. Differentiate between Hardware and software?

3. What is the difference between RAM and ROM?

4. What is MIC?

5. What is the difference between flatbed plotter and drum plotter?

6. What are the two categories of printers?What type of printer is found to be more speedy?

7. Differentiate between online and offline UPS?

8. Define Joystick?

9. What is digital Camera?

10. Write down the short notes on the following.

(i)Zip Drive (ii) DAT Drive

11. What is the use of mouse?

12. Define an operating System? Give an example of single user, multitasking operating system?

13. Explain the three language translators.

14. What are utilities? Name some utilities?

15. What is word processing? Explain with example?

16. What is presentation package? Name some presentation packages?

17. What is the significance of the following?

(i)Windows explorer (ii)Recycle Bin (iii)Task Bar (iv)Start menu

18.What is the difference between moving and copying file/folder?

1. Name the web server required to execute ASP on Windows Operating system.

2. What is an Expression tag?

3. What is ASP language directive?

4. What is web server?

5. Mention any two features of ASP.

6. Differentiate between HTML and ASP?

7. Differentiate between Client side and Server side Scripting?

8. What is the purpose of using ‘global.asa’ file?

9. What do you mean by ASP Object Model?

10. What is ODBC?

11. Name any four methods of Recordset object.

12. What do you understand by ASP object? Name different ASP objects.

13. Name any two technologies that are equivalent to ASP.

14. What is the importance of GETAdvertisement method of ADrotator component?

16. Use the following script to answer the questions that follow:
<%
DIM X
X = 10
Sub result()
SID
Y = 20
SID
End Sub
Sub SID
X=X+6
Y=Y+5
End SUB
%>
(i) What is the scope of variable X and Y in the above script?
(ii) What is the value of X and Y before the subroutine SID ends?

17.Observe the following script:
<SCRIPT LANGUAGE = “VBSCRIPT” RUNAT=”SERVER”>
DIM A, B
A=0; B=1;I=1
Do while I <= 5
C= A*B
RESPONSE.WRITE C
A=B
B=C
LOOP
</SCRIPT>
Whenever this script is executed, the programmer finds that it runs continuous infinite time. Identify the error and write the corrected code.

18. Find the output
1. Response.write(ucase(mid(“we become leaders and innovators by performing leading and innovating actions.”,2,13))
2. Response.write(instr(“My India My Pride...” , “ia”)
3. Response.write( Right (“Different Shades of Patriotism” , 4)

19. a. Predict the output of the following ASP code.
<html>
<body>
<% dim a,b
a=1
b=10
do while a<40
response.write(a*b)
a=a+8
b=b-3
loop%>
b. <%
Dim A,B,C,D,MyCheck
A = 10: B = 8: C = 6: D = 0
MyCheck = A > B Imp B > C
Response.write(“Always”)
Response.write(MyCheck)
Response.write(2^3 < 5 AND 8 * 5 / 2 > 21) %>
b) Convert the following coding in to for....next
<html>
<body>
<%
s=array(10,30,50,70,90,110)
max=ubound(s)
i=1
do while i<5
s(I) = 10*s(I)
response.write (s(I) & “<br>”)
i=i+2
loop %>
</body>
</html>
Write the ASP code that will read the text file called multi.txt , and display only the line that start with “W”.
 

20.Give the uses and syntax of the following In-built functions.
1) Mid ( )
2) CDbl( )

21. Rewrite the following code after removing errors with each correction underlined.
<Body>
The Login Name entered by the user is :
< % pass = Response.Querystring(“Password”) %>
The password is :
<%
If pass < > “enter” then
Request.write(Invalid)
Otherwise
Response.write(“Valid”)
End
%>
</Body>

22.ABC Ltd. is publishing company which uses banner advertisements to fund their web site as shown below :
Create an ASP file “Greeting.asp” to display different banner advertisement on the webpage. The ads to be displayed are stored in the file myads.txt.\

23. Use the following script to answer the questions that follow: 2
<%
DIM X
Sub result()
SID
Y = 20
SID
END SUB
SUB SID
X=X+5
END SUB
%>
(i) What is the scope of variable X and Y in the above script?
(ii) How many times will the subroutine SID be executed in the above script?

24.Observe the following script:
<SCRIPT LANGUAGE = “VBSCRIPT” RUNAT=”SERVER”>
OPTION EXPLICIT
DIM A, B
A=0;B=1
Do while I <= 5
C= A*B
RESPONSE.WRITE C
A=B
B=C
LOOP
</SCRIPT>
Everytime this script is executed, the programmer receives an error as soon as the DO WHILE is reached. Identify the error and write the corrected code.

25. Find output for the following.
1. Response.write( LTRIM(LEFT(“SAARC MODEL CONFERENCE” , 7)))
2. Response.write(ucase(mid(“Park Mediclaim”,2,abs(15 mod 4))
3. Response.write(instr(“The new age has begun” , “ge”)

26.
a) 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. 3
<%
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
%>

27. Find the output of the following ASP coding
<html>
<body>
<%
s=”mistrust or distrust”
m=len(s)
for k =1 to m step 2
n=mid(s, k,2)
response.write (n)
response.write (“<br>”>
next %>
</body>
</html>

28. Convert the following coding in to do while ------loop 2
<html>
<body>
<%
s=array(12,45,87,54,90,76)
max=ubound(s)
for I = max to 1 step -2
s(I) = 10*s(I)
response.write (s(I) & “<br>”)
next %>
</body>
</html>

29. Write ASP code to read the contents of file and print the count of the word “the” as an independent word in a text file “story.txt”.
For example , if the content of the file story.txt is
There was a monkey in the zoo. The
Monkey was very naughty.
Then the output of the program should be 2.

30. What is Client Side Scripting? Give two examples.

31. Differentiate between Client Side scripting and Server-side scripting with examples.

32. What are server variables of Request Object. Explain one of them

33. Give name of object to which the following methods/properties belong: (i) Form
(ii) Binarywrite
(e) Give output of the following statements:
1. Response.Write(UCASE (LEFT (“Times Of India”, 4)))
2. Response.write((5-3)*(4/2-3))
3. Response.Write(MONTHNAME (MONTH (CDATE (“23/08/2012”))),Yes)

34. (a) Differentiate between an Read and ReadLine methods of the TextStream .
(b) What is PWS ? What is the role of ADO on OLEDB connection?
(c) Rewrite, the following code after removing errors with each correction underlined.
<%
dim num =25
b = 2
do num > 0 step 7
b = num mod 10
num = num - 2
next loop
document.write b
%>
(d) Give the output for the following code segment:
<%
Y = 15
FOR X = 1 TO 4
IF X < Y THEN
Document.Write (Y)
ELSE
Document.Write (X)
END IF
Y = Y -6
NEXT
%>
(e) An e-Learning Company Future Learning wishes to design an ASP coded web page with the following specifications:
• The company wish to display time(without date) and the logo of the company on the landing page.
• To display a greeting message “ Welcome to Virtual Classroom “ if the user accesses the website. Write the ASP code for the above details.