computer applications

computer applications (commerce)-march 2008

1.the style argument used with show method in VB will have a value 0if the form is..................and one of the form is ..............

2. ..............property of data control is used to select the name of a table used by data control.

a) Database name b) Record source c) Recordset type

3.Bhagya designed a form in VB .A data control is used in it. It is required to view and update data from a single table . Which Recordset type property she will choose ?

4. ................. is the Add_in tool available in VB for the creation of access style database.

5.Name a Language which is commonly used for developing .NET application.

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

7. the columns used in a table are called.................

8. Name any two aggregate functions.

9. The key word.................. is used in a SELECT statement to avoid duplicate rows.

10. Name the application level protocol with lightness and speed necessary for distributed, collaborative, hypermedia information systems.

11. The................. waves use line of site propagation and they are used for TV, Mobile phone, paging, Microwave links etc.

12.Name two light sources for optical fiber

13. Give the use of the key words private, sub in the following code:

Private Sub command5- click( )

- - - - -

End Sub

14. Akhil wants to perform some operation in a form while he moves mouse over a command button named 'Finish'. Which event he should

select for the operation?

15. Give the use of Exit statement in VB

16. What is the use of key word Optional with variable names in the argument list used with subrotine ?

17. What is a router?

18. Write the data types for the following data:

(a) False

(b) 50

(d) 95000

19. Explain the functions of USART

20. List and give syntax of two methods which are common to all objects in VB

21. List any three any advantages of ASP.

22. Manju wants to create a table for a new inventory application.The table contains the details of products in a shop, The details are item code,

description, stock quantity, recorder level. Write SQL commands to create these table with necessary consstraings

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

(b) Description should have some value.

23. Rewrite the following code segment using select case:

Colorcode = u case (text 1. text)

If color code = "W" then msgbox "selected color is white"

else

if color code = "O" then msgbox "selected color is orange"

else

if color code = "G" then msgbox "selected color is green"

else

if color code = "B" then msgbox "selected color is violet"

else

msgbox "wrong color selection"

end if

24. what will be the out put of the following?

(a) ACS ("A")

(b) Format ( 585)

(d) I = Instr ( " This is plus two examination", Two)

25. Yusaf is developing an Airline Reservation System in VB. A form is designed by him for inputting flight number, description and destination

A data control is used in these form. Write the recordset object method a control required to

(a) add a new record

(b) delete a record

(e) search the first and last record matching some criteria

26. Abhijith wishies to submit the data entered by him using a form. The amount of data is less and security of data is not a prime factor

Which method he may select to submit the data? Justify your answer.

27. write the HTML code required to display the following in a web page

(use appropriate lists tags):

List Box

A list box control displays a list of items from which a user can select one

Combo Box

A combo box control combines the features of a text box and list box

Frame

A frame provides grouping for control

28. Explain the components of DBMS?

ANSWERS

1. Standered, Graphical

2. Record Source

3. Table or Dynaset

4. VIS- Data or visual data Manger

5. C#

6. Sampling or questionnaire

7. Attributes or Fields

8. Sum( ), Average( ), Max( ), Min( )

9. DISTINCT

10. Hyper Text Transfer Protocol (HTTP)

11. UHF or VHF

12. LED (Light Emitting Diode) ILD (Injection Laser Diode) , Laser

13. Private - Scope of procedure or it indicates access is private Sub -Sub Procedure or Subroutine

14. Mouse Move

15. Exit statement is used to exit from a loop structure or Subroutine. That is to terminate a loop structure or used to take control out

of the Subroutine

16. Optimal key word is used to make the argument optimal it allows the user to call the subroutine with our arguments.

17. Router is device which is used to connect different networks with different protocols. Router behave like a bridge with different protocols.

18. (a) Boolean or String or Char or Varchar or Variant

(b) Integer or Number or Decimal or Byte or Long

(d) Long Integer or Number or Decimal or Variant

19. Universal Synchronous A synchronous Receiver transmitter (USART) convert data from parallel to serial at transmitter end and serial to parallel

at receiver end. It is responsible for generating the SYN character at the beginning of the data blocks

20.Move, Refresh and Set focus are the methods which are common to all objects.

21. ASP Stands for Active Server Page. The advantages of ASP are:

(a) ASP code is written in text mode

(b) ASP can be modified without affecting the server function

22.. CREATE TABLE INVENTORY

(ITEMCODE CHAR(10) NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR (15) NOT NULL, STOCKQUANTITY

INTEGER, REORDERLEVEL INTEGER CHECK REORDERLEVEL >=10);

23. Color code = (Text1.Text)

Select Case color

Case"W"

Msgbox "Select color is White"

Case"O"

Msgbox "Select color is Orange"

Case"G"

Msgbox "Select color is Green"

Case "V" "Select color is Violet"

Case Else

Msgbox "Wrong Color Selection"

End Select

24. (a) 65 or ASCII value of A

(b) 585

(d) 1

25. (1)Data Control Name.Recordset.AddNew

(2) Data Control Name. Recordset.Delete

(3) Data Control Name. Recordset.Find.First

26. Get method - Data is passes along with the URL of server side program

27. <HTML>

<HEAD>

<TITLE>Definition List </TITLE>

</HEAD>

<BODY>

<DI>

<DT>List box control displays a list of items from which a user can select List Box

<DT>Frame</DT/

<DD>A frame provides grouping for controls.

</DL>

</BODY>

<HTML>

28. Data base management System is a computer based record keeping system for sharing of data and for controlled access to different

users of the database.

The components of DBMS are :

(1) Data base :A shared collection of logically related data designed to meet the information needs of multiple users in an organization is

called database.

(2) Data Manipulation Language (DML) : The data manipulation language is a language that enables users to access or manipulate data organized

by data model

(3) Data Definition Language (DDL): The data base scheme is defined by a set of definitions expressed by a special a language called

data definition languages. The result of compilation of DDL statements is a set of tables that is stored in a special file called data dictionary.

(4) Users :user inters interact with the DBMS indirectly via application programs or simply query language