Code: DC-16 Subject: VISUAL BASIC & APPLICATIONS

Time: 3 Hours Max. Marks: 100

 

NOTE: There are 11 Questions in all.

 

      Question 1 is compulsory and carries 16 marks. Answer to Q.1 (A) must be written in the space provided for it in the answer book supplied and nowhere else.

      Answer any THREE Questions each from Part I and Part II. Each of these questions carries 14 marks.

      Any required data not explicitly given, may be suitably assumed and stated.

 

 

 

Q.1 Choose the correct or best alternative in the following: (2 x 8)

 

a. What will be the output of the following code segment?

Print Format (17.66698, ##.##)

Print Format (Basic, &&&&&&&&)

(A) 17.6 and bbBasic (B) 17.69 and Basicbbb

(C) 1.690 and bbBasicb (D) 17.690 and bbbBasic

 

(b~ blanks)

 

b. What are the different types of Record Sets that Visual Basic can have?

 

(A)     Table, Dynaset & Snapset

(B)     Tables, Records & Views

(C)     Networked, hierarchical & Object based

(D)    SQL, Oracle & Access

 

c. Which shortcut key usually trigger an event?

(A) Mouse (B) Control

(C) Form (D) Text Box

 

d. <a href = abc.htm> <img src = home.gif></a> in HTML

 

(A)     makes a hyperlink only.

(B)     includes an image in a web page.

(C)     embeds a hyperlink inside an image.

(D)    includes a hyperlink inside a list.

 

e. Meta Data is included inside a HTML document in _____________.

 

(A) <TD></TD> (B) <TABLE></TABLE>

(C) <HEAD></HEAD> (D) <TR></TR>

 


f. What are the different ASP objects that Online enterprise solutions use?

 

(A)     Request, Response, Application, Session & Server.

(B)     Request, Application, Response, Session & Server.

(C) Initialise, Read, Resize, Write, Terminate.

(D) Create, Execute & Destroy.

 

g. What would be the output of the following piece of code?

Dim k

Dim a as Integer

K=27/4

A=K

Print K

 

(A) 6 (B) 7

(C) 6.5 (D) 6.25

 

h. ASP code executes at the ________ side.

 

(A) Client Frontend. (B) Middle-tier.

(C) Server Backend. (D) Network router.

 

PART I

Answer any THREE Questions. Each question carries 14 marks.

 

Q.2 a. What are different Controls in Integrated Development Environment (IDE)? (7)

 

b. What are ActiveX Controls? How can a user hide it inside the application? (7)

 

Q.3 a. What is the Life Cycle of a Data Control? Explain its need. (4)

 

b. How can Database Connectivity be done using Text Box Data Control? Write code segments for addition, deletion, save, exit, movefirst & movenext of the records using Data Control click events? (10)

 

Q.4 a. What is the difference between passing by value & passing arguments by reference in Visual Basic 6 Procedures? How declaration is done in either case? (4)

b. What are Dynamic arrays? Illustrate using code segments how it can be managed? (6)

 

c. Write a function in Visual Basic to test whether a string is a palindrome (reads same back to front)? (4)

 

 

 

 

Q.5 a. Differentiate between Empty, Null & Nothing Value with declarations. (6)

 

b. Give the outputs of the code segments:

 

(i) Dim k as Variant

k=75/4

Print k

K=Hello

Print k

 

 

(ii) Dim S

For I=1 to 5

For J=1 to I

Print *

Next J

Next I

 

(iii)Dim A(4) as Integer

Dim X

For I=0 to 4

A(I)=I

Next I

X=0

For J=0 to 4

If A(J)>X Then X=A(J) End IF

Next J

Print X

 

(iv)Function Text() as Integer

Dim K

K=0

Do While K<4

K=K+1

Print K

Loop (4 x 2)

Q.6 a. What do you mean by event-driven programming in Visual Basic? (4)

 

b. How is error trapping done in database programming? (4)

 

c. How is password field added in Visual Basic? How can a user execute SQL SELECT WHERE & ORDER BY queries from inside a form? (6)


 

PART II

Answer any THREE Questions. Each question carries 14 marks.

 

Q.7 a. Create a web document in HTML that displays on the browser window the following TRAIN TIME TABLE: (8)

2004 New Delhi Lucknow Shatabdi Express

Station

Arrival

Departure

New Delhi

-

0620

Ghaziabad

0655

0657

Kanpur Central

1100

1115

Lucknow

1200

 

 

b. How can a hyperlink link to an internal link in the same page? Explain with an example. (6)

 

Q.8 a. Create a web document in HTML that displays on the browser window the following e-CATALOGUE: (8)

ONLINE FAST FOOD SHOP

SNACKS BAR

1.      BURGER

2.      PIZZAS

DRINKS

1.      COKE

2.      LASSI

b. Write Short Notes on the following:

(i) Web Server

(ii)                Web URL (Uniform Resource Locator)

(iii)               Home Page. (6)

 

Q.9 a. Design a form-using HTML with text boxes, radio buttons, check boxes, drop-down menus with submit & reset buttons. (10)

 

b. What is Dynamic HTML (DHTML)? How is it different from HTML? (4)

 

Q.10 a. How do you create an OLE object? (6)

 

b. Write a code in ASP to display date/time on the client side browser window. (8)

 

Q.11 a. What are the intrinsic Objects present in ASP? (6)

 

b. How we can access a database inside ASP application? (8)