Question Code

Note:


System Engineering, VB/VB.Net

These questions are given only to indicate the nature of questions for the Final
D
Examination.

The Final examination questions will not be confined to the ones in this question bank.

The ATCs may prepare the Question Paper for the Model examination with the
questions from this Question Bank.
Time: 2 hours Maximum Marks: 100
Part - l Choose the most appropriate answer(Answer 15 out of 15 questions) (1 Mark each)
• …………………Returns a single value from a database query
a. ExecuteScalar b. ExecuteQuery c. ExecuteParameter d. ExecuteNonQuery
• Visual Basic is ……………. type of programming language.
a) Event driven b) Object oriented c) Menu driven d) None of these
• Visual basic comment starts with ………………..
a) // b) /* c) * d) ’
• …………………window lists all the forms which make up the VB project.
a) Property b) Tool box c) Project d) Coding
• ………………. will make program to exit Do Loop
a) Exit Do b) ExitDo c) Exit d) ExitLoop
• Program syntax for select case is………………..
a) CASE “A” : b) CASE A c) CASE “A” d)All the above
• Which is not a legal return value for MsgBox?
a) vbOK b) vbCancel c) vbExit d) vbAbort
• Which is not a legal return value for MsgBox?
a) vbOK b) vbCancel c) vbExit d) vbAbort
• …………………. function is used to display current date &time in VB.
a) now() b) time() c) date() d) none of these
• While creating a menu using a menu editor we can use a ……………. symbol to make hotkey character
(a) # (b) * (c) @ (d) &
• While creating a menu using a menu editor we can use a ……………. symbol to make hotkey
character.
a) # b) * c) @ d) &
• VB.NET comment starts with ………………..
a) // b) /* c) * d) ’
• A……………form is the first interface that appears on the screen, when an application is executed.
a. Startup b. Active c. Main d. Primary
• The ability to define properties, methods, or procedures that have the same name but use different data types is
called ………………..
a) Exception handling b) Overloading c) Constructors d) none of these
• The execution environment for all programs in the .NET Framework is …………………
a) CLS b) RMT c) CLR d) none of these
• In VB, ....... is the primary component of every GUI application.
(a) Controls (b) Frame (c) Form (d) None of the above
• In VB, variable name must be less than ...... characters.
 (a) 32,767 (b) 255 (c) 124 (d) No limit.
• A ...... consists of a collection of interrelated data and a set of programs to access the data.
(a)DBMS (b) SQL Server (c) ADO (d) None of the above
• ....... function is used as conditional operator in VB.NET.
(a)()?: (b) if() (c) IIf() (d) None of the above
• Visual Basic is an enhanced version of ........ programming language
(a)BCPL (b) BASIC (c) COBOL (d) None of the above
• ....window lists all the forms which make up the VB project
(a) Property (b) Tool box (c) Project (d) Coding
• The point where the cost of the candidate system and that of the existing system are equal is called …………
a) Least Cost Point b) Optimum Point c) Break Even Point d) Optional Point
• Visual Basic is ...... type of programming language.
a. event driven b. object oriented c. menu driven d. none of these
• The VB filenames have...... extension
a. .VBP b. .vb c. .vbr d. none of these
• ...... are the graphical objects that make up the application’s user interface.
a. Controls b. Frame c. Form d. None of the above
• …………………. function is used to display current date &time in VB.
a) Now() b) Time() c) Date() d) None of these
• In VB, the …………………. is the primary component of every GUI application.
a) Controls b) Frame c) Form d) None of these
• Which of the following can be called by reference?
a. Class b. Module c. Function d. Assembly
• ........ are the back bone of SQL.
(a) Database (b) Queries (c) Functions (d) None of the above
• The Visual Basic Compiler is:
a. vbcompiler.exe b. vb.exe c. vbc.exe
• Which one of the following is the correct syntax to make a control called Pic1 visible?
a) Pic1.Visible = True b) Visible.Pic1 = True c) Pic1.Invisible = False d) Pic1.Enabled = True
• --------- keyword refers the current instance of an object
a.This b. Me c. Myclass
• ---------is used to join strings in VB.NET
a. + b. & c. Both A&B
• The code that is used in a sub procedure to stop execution of a sub procedure is
a) Exit b) End With c) End d) End Sub
• VB.NET default value for Boolean variable is ---------
a True b. False c) none of these
• Which operator has the highest order of precedence in arithmetic expressions?
a) Multiplication b) Addition c) Exponentiation d) Modulus
• ---------is the lower bound value of array in VB.NET
a. 1 b. -1 c. 0 d) none of these
• VbOk,VbCancel,VbAbort are the enumerated members of ---------
a. MsgboxStyle Enumeration
b. MsgboxResult Enumeration
 c. CompareMethod Enumeration
d. none of these
• ……………. are the back bone of SQL.
a) Database b) Queries c) Functions d) None of the these
• Which of the following is the valid method of command object
a. ExecuteNonQuery & ExecuteScalar b. ExecuteQuery & ExecuteScalar
c. ExecuteParameter
• Which of the following does not denote a data type in VB.Net?
a. Decimal b. Byte c. Boolean d. None of the Above
• Which of the following notation is used to expand a single statement on to multiple lines in VB.NET?
a. .(underscore) b. & c. : d. #
• .........is the shortcut for menu editor in VB.
a. ctrl+C b) ctrl+E c) ctrl+D d) ctrl+T
• ----------function returns the number of characters specified by a number from the right end of string.
(a) InStr (string1, string2) (b) UCase(string) (c) Right(string,number) (d) Len (string)
• Which operator has the highest order of precedence in arithmetic expressions?
[a] multiplication and division [b] addition and subtraction
[c] exponentiation [d] Modulus
• ……………. keyword refers the current instance of an object.
a) This b) Me c) Myclass d) None of these
• ……………. is used to join strings in VB.
a) + b) & c) Both a&b d) None of these
• Variables declared within a Click-event procedure are ..... variables.
[a] general [b] module-level [c] global [d] local
• Image controls hold a graphic, which is assigned to the:?
[a] image property [b] text property [c] picture property
[d] caption property
• The code that is used in a sub procedure to stop execution of a program is:?
[a] Exit [b] End With [c] End [d] End Sub
• If you encounter a run-time error or you pause the program execution, you are in:?
[a] compile time [b] break time [c] run time [d] design time
• Which one of the following is the correct syntax to make a control called Pic1 visible?
[a] Pic1.Visible = True [b] Visible.Pic1 = True [c] Pic1.Invisible = False [d] Pic1.Enabled = True
• What would be the result of Val(Text1.Text) if you entered in ?: $3,000
[a] 3000 [b] 3 [c] 0 [d]Run-Time Error
• What would be the result of CInt(Text1.Text) if you entered in ?: 50000
[a] 0 [b] 50000 [c] 50,000 [d] Run-Time Error
• What would be the result of Val(Text1.Text) if you entered in ?: 34.567m
[a] 34.567 [b] 35 [c] 0 [d] Run-Time Error
• The ability to define properties, methods, or procedures that have the same name, but use different data types is
called ………………..
a) Exception handling b) Overloading c) Constructors d) None of these
• What would be the result of CInt(Text1.Text) if you entered in ?: 20,000
[a] 20,000 [b] 20 [c] Run-Time Error [d] 20000
Part - ll Fill in the blanks (Answer any 10 out of 15 questions) (1 Mark each)
• ……………. window contains the list of all forms which make up the VB project
• The project file extension for VB6 is…………..
• …………..is a flag at a given point in code, where program execution will be suspended.
• Classes derived from base classes are called…………………
• The storage size for the data type integer is …………..bytes
• The …………….operator takes two or more boolean expressions and returns true value, if both
expressions are true.
• Each while loop must be terminated by ……………..
• The statement used to exit the DO loop is………….
• The statement used to exit the For-Next loop is……………….
• Parameters are also called as………….
• …………function is used as conditional operator in VB.NET.
• IDE stands for……………………..
• The ……..function returns the length of a string.
• In Visual Basic, ……….is the primary component of every GUI application.
• The ………… identifier in VB is similar to “this” identifier in C and JAVA
• …………… function returns the string converted to lower-case.
• ……………. is a part of record that defines a specific information.
• …………… loop always execute atleast once.
• ………….is a file where all the information is written in the order, beginning to end
• The …….function determines if the end of the specified file has been reached.
• ADO stands for…………
• Event-driven programming is often termed as ……………programming.
• The null value can be checked using …………….function.
• …………………… is used to display static text, titles and screen output from operations.
• To save the current record to a database …………method is used.
• A …………..is a flag at a given point in code, where program execution will be suspended.
• The ……..function returns the length of a string.
• In VB.Net, the …………… statement always check the condition before it begins the loop.
• ……………function returns the string converted to lower-case.
• In VB.Net, the declaration statement for variables is the …………… statement.
• In VB.Net, …………… control allows to add web-style links to windows forms application.
• In VB.Net, …………...textbox enables to accept data in a specific format like date, time, currency etc.
• The ……………… function can be used to check whether the value is numeric or not.
• In VB.Net, …………. is a component that raises an event at regular intervals in the windows form.
• In VB.Net, …………… component displays text when the user points at controls.
• In VB.Net, ………….. control provides a managed wrapper for the web browser ActiveX control.
• In VB.Net, …………… controls are used to provide an identifiable grouping for other controls.
• DLL stands for ……………….
• ………………. is the ability to contain and control access to a group of associated items.
• …………. is a program at the application level, not tied to any specific event.
 • …………control raises an event at regular intervals.
• The high level language provided by DBMS is called ………………..
• Data Manipulation Language is also called ………………..
• A …………. is a statement in the DML that request the retrieval of data from the database.
• An entity set that does not have sufficient attributes to form a primary key is known as ………………
• In DBMS, ……………. is a pool of values from which the actual values appearing in a given column are
drawn.
• Each if statement must be terminated by …………statement.
• ……………… are the backbone of SQL.
• The ……………… function can be used to check whether the value is numeric or not.
• In VB, each while loop must be terminated by ……………..
• The null value can be checked using …………….function
• …………… statements are used to declare variables.
• VB variable names can have a maximum of …………….characters.
• Long datatype is ……………….. bytes long.
• ……………… property of DataGridView control is set to specify the data source.
• In VB.NET the ...... control is used to display graphics in bitmaps, GIF or JPEG.
• Structured exception handling is.......
• By default, all VB graphic measurements are in …………
• ...... control raises an event at regular intervals.
• ……………..control indicates the progress of a process.
• ...... is the short cut key for running a program in VB.NET.
• Classes derived from base class are called.......

Part - llI State whether true or false(Answer any 10 out of 10 questions) (1 Mark each)
• The picture box control and image control are very similar in operation.
• Inheritance cannot extend the base class functionality.
• Visual Basic allows to manage databases created with different database program
• ADO can work in different computers and different programming languages
• In VB, Subroutines can return a value.
• Parameters cannot be sent to a subroutine By reference or By value
• Events cannot be initiated by the user
• An array is an indexed variable.
• Common Language Runtime is the heart of .NET frame work.
• Sub query cannot be performed inside an existing query
• In DBMS, the basic objective of normalization is to reduce redundancy.
• Database does not facilitate sharing of data.
• A module is similar to a class, but with some important distinctions
• Visual Basic classes cannot inherit and extend the characteristics of other classes.
• In VB.Net, the appearance of tabs in windows forms can be changed using properties of tab control and
tab page objects.
• Visual Indicators or special graphical elements are called widgets.
• The key method of Timer component is start and stop
 • Classes are symbolic representation of objects
• Visual Basic is an Event Driven Programming Language.
• In VB we can declare variables Explicitly only
• Boolean is not a data type in VB
• In VB, Subroutines can return a value
• Parameters, also called Arguments, are variables that can be passed into a subroutine.
• The property window is used to view and change the design time properties.
• To hide a control, visible property is set to false.
• JIT stands for justify in time.
• SOAP is the .NET protocol.
• Common Language Runtime is the heart of .NET frame work.
• Inheritance cannot extend the base class functionality.
• In VB, we can declare variables Explicitly only.
• A Dataset can hold any number of tables
• A procedure can never return a value.
• LCase(string) function returns string converted to lower-case.
• In VB.NET the connection object creates the connection to the database.
• A ‘Stack’ Collection provides ‘first-in-first-out’ functionality.
• Trim () is used to remove the space from both side of string.
• A ‘Queue’ Collection provides ‘first-in-first-out’ functionality.
• A DataSet can hold any number of tables
• In msgbox the value of VB OK is 1
• Trim() is used to remove the space from both side of string.
• Boolean is not a data type in VB
• To hide a control visible property is set to false.
• Byte is not a data type in VB.
• SOAP is the .NET protocol.
• Equality operator is denoted by! = sign.

Part - lV Give expansion for the following (Answer any 10 out of 15 questions) (1 Mark each)
• IDE
• 1NF
• JIT
• BCNF
• MSIL
• DBMS
• RAD
• MSDN
• CLR
• DAO
• ISAM
• COM
• SQL
 • ODBC
• API
• MDI
• OLE
• SDLC
• DDL
• DML
• DDE
• OLE
• DLL
• EOF
• ADO
• SOAP
• GUID

Part - V Answer the following (Answer any 11 out of 14 questions) (5 Marks each)
• Anomalies in database.
• Explain in detail about System Development Life Cycle.
• Namespaces.
• Modules in VB.NET.
• Write a VB program to print numbers from 1 to 100 using for loop.
• Explain the Core Objects of DOT Net Framework Data Provider.
• Explain Cost-Benefit evaluation methods.
• Operators in VB.net
• Difference between Gotfocus and Lostfocus.
• Key design goals of common language runtime (CLR).
• Explain any three mouse events in vb.
• Mention the rules for declaring variable names in VB.
• Define Encapsulation.
• Define polymorphism
• Difference between a local and a global variable?
• Define DDL and DML.
• Explain the need of Normalization.
• Differentiate between Message Box and Input Box.
• What is ADO.NET?
• What is a primary key?
• What are the features of SQL?
• Write down the syntax of Do loops and Do While loops with example.
• Define the following terms.
• (a) Record (b) Field (c) Sequential file (d) Random file
• Explain any four string functions?
• Write a VB program to print numbers from 1 to 100 using for loop.
• What is Class? Differentiate between Class and Object.
• Write down the syntax of Do loops and Do While loops with example.
• Write a VB program to illustrate error trapping.
• In a form,command button CmdNext is used to move to the next record in the database when the button is
clicked. Write the code for this button. Add lines of code to prevent moving beyond the last record in the
database table(table name isstudRec)
• Name and briefly explain any five mouse events.
• Write down the syntax of For….Next loop and explain with an example to print even number less than 20.
th
• Write a program to input 3 numbers from 3 text boxes and to print the biggest number in the 4 textbox.
• Write a note on a Label and Textbox control with any two properties each.
• Write a VB.NET application for input 3 numbers through text box and find biggest number using IF().
• Write a note on Code window, Property window, Project explorer window and solution explorer window.
• Write a program to find the factorial of a number less than 10.
• Write a VB.NET program to display records through DataGridView control. (Data base name ‘SudentDb’,
Table name ‘StudentRec’).
• Write program code to navigate (Move to first, last, next and previous of record set) across a data control
(Name: data1).
• Write a program to accept two numbers through text box and perform the basic mathematical operations.
• Write notes on procedure and functions with syntax.
• Difference between Gotfocus and Lostfocus.
• Describe Windows Form and Web Form.
• Write a note on Event Driven programming.
• Draw the diagram of Microsoft.Net Framework.
• Describe the difference between Overloading and Overriding.
• Explain the steps for creating a Menu.
• Explain the difference between Byref and Byval.
• Explain the different types of files in VB.NET.
• The structure and data of a table named ‘Product’ in given below. (Answer any five questions)

ProductID ProductName Price Tax

1200 Apple 75 5%

1201 Orange 65 3%

1202 Pineapple 80 5%

1203 Banana 50 2%

1204 Plum 85 5%

1205 Strawberry 120 3%

1206 Cherry 110 6%

1207 Mango 85 8%

1208 Papaya 55 5%

1209 Broccoli 65 2%

The structure and a few rows of a data table are shown above.
Write SQL Queries for
 a) To add a new record (assume suitable values)
b) To delete the record with ProductID=1202
c) List all products having tax of 5%
d) To revise the price of product having ProductID 1203 to 63
e) Count the number of products having tax 5%
f) To list product names in alphabetical order.
g) To change all ProductName to UPPER CASE.
h) To add one more column named ID as Primary Key and make it Auto-increment
• Any five string functions in VB.
• Describe the difference between inner join and outer join with suitable examples.
• Explain Key Design Goals for .NET frame work.
• Briefly explain System Design objectives.
• Distinguish between EXIT statement and END statement.
• Read the table given below and answer the following questions

No Name Designation Sale Price

1 John Manager DOG 250

2 Amal Clerk CAT 300

3 Ali Manager HOTDOG 230

Write Queries
a. to add one record.
b. to delete the second record.
c. to select names in ascending order.
d. to change the name in the third record to ’Alibaba’.

• Write the VB.NET code to add new records to an existing table named ‘Product’ in a Database named
‘Shop’.The data to be inserted is obtained from a Form as shown in the picture .

Add Record

Product Name

Price

Tax

Add Record