H.S.E. (II)

June 2005

                             Computer Application

I.   Choose and write the correct answers from questions 1 to 10 ,each carrying one mark

                                                                                                                                      10X1=10

  1. The property used to display multiple lines of text in a textbox control is ..............

      a)    Text        b)  name            c) caption    d)  multiline

  2.   ................ tag encloses the heading cells in a table.

    a) <table>   b)  <tr>   c)  <th>  d)  <td>

  3. a set of instructions to the computer is ....................

     a)   algarithm      b)  statement      c)  program       d)   language

  4.  meta data is stored in ............. of the database .

      a)  data file            b)  data dictionary            c)   field             d)   record

5.   ............... control structure checks for the multiple values of an expression

      a)  if ............. else        b)  select case    c)  while wend    d)  go to

6.  which of the following is an essential clause used with select command ?

   a)   group by      b)   order by           c)   where        d)  from

7.  a key which uniquely identifies the record is............

  a)  alternate key       b)  foreign key     c)  primary key   d)  super key

8.  the number of tuples in a relation is called ..............

    a)  cardinqality        b)  attribute        c)  records    d)   UNION

9. the default align value for a table is ......

  a)  left        b) right            c ) center     d)   justify

10.  ............. is a chart listing all the logical condition and actions

      a)  disign tree           b)  decision table           c)  DFD         d)  data dictionry 

                                           part B

II.Answer any five question from 11 to 17 in two to four sentences each carries two markes

11.write short note on XML.

12. what is meant by  system design?

13. what is the output of the following code?

private sub cmdl-click( )

dim a,b,cas integer

a=5,b=8 for c= 1 to b-7 a=a + b

print a

next c

end sub

14. explain the syntax of INSERT INTO command.

15.state the difference between UNIQUE and DISTINCT commands

16.    Differentiate between <td> and <th> tags.

17.    What is Meant by view in SQL.

PART  3  Answer any 10 questions from 18 to 30 in four to six sentences. Each carries 3 marks

18Explain the applications of HTML.

19.    What is the purpose of select case statement in VB.

20.    Give the syntax rules related to For... Next statement

21.    Explain the functioning of Modem.

22    What do you mean by Select operation.

23.    Define the terms 1)Relation    2)Tuple 3) cardinality

24    Explain the keys : Primary key, Alternate Key and Super key

25    What is meant by transmission through serial communication.

26.    What is the main function of an integrated work station

27    What is the use of HEAD, TITLE and BODY in HTML?

28    Compare ASP and JSP.

29    Differentiate between empty and container tags

30.    What are the 3 types pf system maintenance?

PART 4   Answer any 4 questions from 31 to 36 in 10 to 12 sentences. Each carries 5 marks

31     Write the VB program to find the greatest of N given numbers.

32     Describe the main text formatting tags wit h examples.

33    Explain any 5 SQL commands  with examples.

34    What are the different media used for communication. Explain any 2.

35    Explain the role of personal computer in office

36    What is the role of decision table and decision tree in system analysis.