COMPUTER APPLICATION (SAY)  - 2008

1.   VB IDE displays the various forms and modules in   ...............            (1 score)

2.   .........  key word indicates that all variables used in the program must be declared  

                                                                                                               (1 score)

3.  What is the out put of the following command?   (1 score)

4.  Write any two form methods    (1 score)

5.  Which properties of record set is used to detect end of  record set and beginning     of  record  set ?                                                                                                             (1 score)

6.   The software used to view web page is called   ..............                   (1 score)

7.   Name the person who has central control over the database and programs in DBMS

     (a) Naive User

     (b) Programmer

     (c) Database Administrator

     (d) System Analyst                                                                             (1 score)

8.   Name two scripting languages                                                            (1score)

9.   Duplication of data is called..............                                                 (1score)

10. Which command is used to remove a table from a database?              (1score)

11. Ravi wants to get a number from key board to a variable NUM

      while displaying the message "Enter a number". How it is possible?      (2score)

12.Consider the following program code :

      private sub command 1-click( )

      picture 1.picture= load picture       ("sample.gif") 
end sub

      (1) what is the purpose of above code?

      (2) name two controls that must be placed on the form                        (2score)

13.what is variable? How much storage size is needed if variable

     is declared as follows?

     Dim A as Double                                                                                 (2score)

14.Write VB code to find out how many days are remaining to

     complent this year and display it in a text box                                        (2score)

15.Classify the following HTML related words:

     aling, frame, href, front.                                                                         (2score)

16.Suresh is designing a web page.He wants to display an image in the

     right side of text .Write HTML code for it.                                            (2score)

17.Expand the following :

    ASP,JVM,HTML,CGI

18.View can be used just like atable.Then what is the purpose of               (2score)

     creating view ?

19.Discuss the advantages of using Optical Fiber for transmitting data.        (2score)

20.Paralell Communication method is not used  for long distances.Justify.    (2score)

21.Write short note on Synchronous transmission.                                      (2score)

22.Write any four Aggregate functions in SQL and it's use                          (2score)

23.Devolop a program to enter register number and marks of 3                  (3score)

    subjects.Calaulate Total mark and Disply "Pass" if total mark>

   50 otherwise Print "fail.

24.Anil wants to input a number in a text box .A procedure  to check a number      (3score)

    is ODD or EVEN should be called while he clicks

    command button . Write VB program for this.

25.Develop a program to store names of 10 students in an array.               (3score)

26.JAVA is a platform independent Language.Justify.                                (3score)

27.Anu develops a project in VB to manage employee details.What

     control she can use to connect VB to Database? What record set

     methods she can use to search data in the database?                             (3score)

28.A company wants to creat a table to store it's employee's details.

    Write SQL Commands for the following.

(1)     Create a table with EMP table having fields EMPNO primary key

    varchar (10),salary number(6),Department varchar (3) EMPNO varchar

   (10), name varchar(20),salary number (6),Department Varchar (3)        (1score)

(2)    Insert values to table                                                                        (1score)

(3)   List all employees whose salary>10,000                                           (1score)

(4)   Display name and salary in the order of  name.                                  (1score)

29.A software company wants to develop a software for a shop. In

     what ways the information about existing  system can be collected ?     (5score)

30.Aji wants to create a form in HTML to do the following :

(1)Input Name using text box.

(2)Two Radio Buttons to select Male or Female.

(3)Input Address.

(4)Sumit Button with caption 'OK'.                                                           (5score)