Previous Year Question Paper

Previous Question Papers

February 2009

1.      State true or false. Array defined as dim a(10) as integer will contain 10 elements.

2.      Which of the following is not browser software? a) MOSAIC, b) Windows Explorer, c) Internet Explorer, d) Netscape Navigator

3.      The defaults align value for a table is.................. (Left, Right, Top, Bottom)

4.      .......................is the smallest unit of data.

5.      The.................operator of SQL is used to match a pattern with the help of %.

6.      Name the special purpose device that allows communication between dissimilar networks.

7.      Name the method used for investigation and fact recording when the volume of transaction is very large.

8.      Predict the output of the following code

a)  Name= “Sourav Ganguly”

Print left (Name,6)

b)  Private sub cmd_click()

Dim a, b, c as integer

a = 5, b = 8

For p=1 to b-7

a=a + b

Print a

Next p

End sub

9.      Librarian in your school library is in needed of calculating the fine for books returned. Can you suggest a date library function in VB to calculate the number of days for which the fine needs to be calculated? Justify with an example.

10. Write the suitable data type for the following data items a) False, b) 100, c) Commerce, d) 10000

11. Explain the working of a modem, when you send an email from your computer to your friend’s computer.

12. Write query on the CUSTOMER table whose output will exclude all customers with RATING<=100, unless they are located in Cochin.

13. The following code intends to centralize the image ‘mypic.gif’ in browser window

<IMG src= “mypic.gif” align = “centre”> However the desired result is not coming. Can you point out the reason for it and a solution for it?

14. Given two strings string1 and string2, write VB statements to determine the longest.

15. Write the syntax and give an example for an entry controlled loop

16. Write VB code to produce the following output

1

1                   3

1       3       5

1       3       5       7

17. “Java script is platform independent” Comment on this statement

18. What is the roll of system analyst in a business system

19. Sita wants to create a table for a new inventory application. It contains the details of products in a shop. The details are item code, description, stock quantity, reorder level write SQL commands to create this table with necessary constraints.

a)  Item code should not be empty for any row and it must be primary key

b)  Description should have some value

c)   The reorder level should be at least 10

20. Martin friend of you is going to be posted as a system analyst. Can you suggest him the tools he can use in order to make his work easier.

21. Develop a VB program to enter register number and marks for 6 subjects of students in your class. Calculate the total mark and display “Passed” if total mark>240 otherwise print “Failed”.

22. How VB script is differs from Java script.

23. Match the following

Group1	Group2
The capacity of a medium to transmit a signal	Repeater
Device that amplifies a signal being transmitted on a network	Topology
A computer attached to a network	Server
A computer that facilitates resource sharing on a network	Node
The pattern of interconnection of nodes in a network	Protocol
The set of rules that govern the way a service is provided	Bandwidth

24. Explain two unary operations in RDBMS using an example

25. What are the objectives of system designing? What elements must be provided in the design of any office information system?

26. Name the different data models available for data base systems. Which of them is the most preferred one? Briefly explain with a suitable example.

27. Design a VB application to enter the name and marks scored in 3 subjects of a student in an examination. Calculate percentage and grade. Grade is awarded as the table given below. The minimum mark required to pass in each subject is 40 and maximum is 100

Total Mark	Grade
>=225	A
180-224	B
160-179	C
120-159	D

28. Following are some areas where data communication system has been implemented.

a)  Local telephone networks spreads over an area of 50 square meter

b)  A cable TV network in small village that handles less number of channels

c)   A television network in a country which deals with a number of channels requiring high speed data transmission

Answer the following

a)  Suggest most appropriate channels or media of communication that can be used for setting up the above networks

b)  Justify your answer in each case