QUESTION 1
All of the following are true about standard modules except __________.
. A module is a file that contains code such as variable declarations and procedures
A public variable declared in a standard module may be used by other files in a project
Standard modules may contain event handlers
Standard modules are not associated with a particular form
QUESTION 2
Which type of loop is designed specifically to use a subscript to access the elements of an array?
. For Next
Do While
Do Until
For While
.
.
QUESTION 3
You use to provide multiple selection conditions in an SQL statement.
. relational operators
compound expressions
arithmetic operators
the & operator
.
.
QUESTION 4
The ___________ event occurs when a form is in the process of closing, but before it has closed.
. FormClosing
FormClosed
CloseForm
Close
.
.
QUESTION 5
A form's __________ event is triggered when the user switches to the form from another form or another application.
. form load
activated
got focus
click
.
.
QUESTION 6
Which of the following could be used to iterate through each element of a two-dimensional array.
. A single Do While loop
A single Do Until loop
A single For Next loop
Nested loops For Next loops
.
.
QUESTION 7
This key word is used to refer to properties and methods found in the base class.
. Base
Me.Base
MyBase
Base.Class
.
.
QUESTION 8
When a project executes, its __________ is automatically displayed.
. main sub
startup form
event procedure
form load event
.
.
QUESTION 9
Which of the following declares an array to contain the weekly sales of a group of salespeople for a year? (use the constant intNumSalesmen for the number of salesmen and 52 for the number of weeks)
. Dim decWeeklySalesTotal(intNumSalesmen - 1, 52 - 1) as Decimal
Dim decWeeklySalesTotal(intNumSalesmen - 1, 52) as Decimal
Dim decWeeklySalesTotal(intNumSalesmen - 1, 52 - 1)
Dim decWeeklySalesTotal(intNumSalesmen, 52) as Decimal
.
.
QUESTION 10
If the user should not be able to access an item that appears on a menu, set its _________ property to _______.
. Enabled, False
Disabled, True
Active, False
Hidden, True
.
.
QUESTION 11
When a menu control's _________ property equals True, a check appears next to the menu item.
. showCheck
Checked
Check
none of the above
.
.
QUESTION 12
In an SQL query, the _____ wildcard character, used with the LIKE operator, will match multiple unknown characters.
. &
#
*
%
.
.
QUESTION 13
The following statements are true about a data source except
. a data source is usually a database.
a data source can be a text file.
Data sets contain data retrieved from a data source.
Data can be retrieved from but not written back to a data source.
.
.
QUESTION 14
All of the following are browsers your Web pages should be tested with except __________.
. Chrome
WebPro
Safari
Firefox
.
.
QUESTION 15
Which of the following is not true about a Form's class declaration?
. It contains a detailed description of a form.
It's similar to a blueprint for a house.
It creates an instance of the form.
It contains the form's event handlers.
.
.
QUESTION 16
A postback occurs when the server processes the page contents and __________.
. does nothing when there are no changes to the page contents
sends an error when the requested page is not found
sends a different page that was requested by the user
resends a modified version of the same page currently displayed
.
.
QUESTION 17
What does the following section of code do? Dim intCount as Integer Dim intXXXX as Integer = intNumbers(0) For intCount = 1 to (inNumbers.Length - 1) If intNumbers(intCount) > intXXXX Then intXXXX = intNumbers(intCount) End If Next intCount
. Finds the first element of the array intNumbers
Finds the last element of the array intNumbers
Finds the Highest value in the array intNumbers
Finds the Lowest value in the array intNumbers
.
.
QUESTION 18
When changing the number of elements in an array at run-time with the ReDim statement, existing values in the array are destroyed unless the __________ keyword is used.
. Preserve
Reserve
ReDim
Protect
.
.
QUESTION 19
__________ is a general model of something - it captures the general characteristics of an object
. A constructor
A collection
An instance
An abstraction
.
.
QUESTION 20
Which of the following statements will remove an object referred to by the object variable NewStudent?
. NewStudent = String.Empty
NewStudent = Nothing
NewStudent.Delete
Remove.NewStudent
.
.
QUESTION 21
Which of the following is not a Web browser?
. Safari
Firefox
Windows Explorer
Internet Explorer
.
.
QUESTION 22
A context menu __________.
. is an alternative for buttons
is shown when the user right clicks a form or control
uses the MainMenu control
both a and c are correct
.
.
QUESTION 23
The __________ access specifier permits class members to be accessed only by statements inside the class.
. Public
Protected
Private
Friend
.
.
QUESTION 24
ASP.NET controls are more powerful than HTML controls because __________.
. more fonts are available
graphics can be embedded in them
they use event handlers to carry out actions at runtime
powerful hyperlinks can be embedded in them
.
.
QUESTION 25
Which of the following is not true about the ASP.NET development platform?
. Visual Basic code can be stored in a separate file from a web page's text and HTML.
It allows you to transfer much of your Visual Basic knowledge to Web applications.
It allows the use of object-oriented program code.
Visual Basic is the only programming language that may be used.
.
.
QUESTION 26
All of the following are true of the Show method of a form except:
. using the Show method allows other forms to receive the focus
the show method allows a calling program to continue to process statements
the displayed form must be closed before you can access other forms
the Show method displays a modeless form
.
.
QUESTION 27
Object oriented analysis starts with __________.
. declaring the member variables
finding the classes
describing attributes and operations
defining the property procedures
.
.
QUESTION 28
Which of the following statements defines a two-dimensional Integer array named intTwoDArray with 6 rows and 4 columns?
. Dim intTwoDArray(5, 3) As Integer
Dim intTwoDArray(3, 5) As Integer
Dim intTwoDArray(6, 4) As Integer
Dim intTwoDArray(4, 6) As Integer
.
.
QUESTION 29
A table adapter's _________ method is used to add a new row to a table.
. Add
Append
Insert
Update
QUESTION 30
A ________ statement in SQL retrieves data from a database.
. Select
Search
Find
SearchTable
.
.
QUESTION 31
What task is accomplished by the following code? Dim intFirstArray(2) As Integer Dim intSecondArray(2) As Integer intFirstArray(0) = 10 intFirstArray(1) = 19 intFirstArray(2) = 26 intSecondArray = intFirstArray
. Two distinct arrays are created in memory with the same values.
intFirstArray and intSecondArray reference the same array in memory
This code will generate a run-time error. You cannot assign the name of one array to another.
intFirstArray is initialized with values but intSecondArray contains no values
.
.
QUESTION 32
Which of the following is the correct definition for a procedure that accepts a String array as an argument?
. Private Sub ArrayParam(ByVal strStudents As String)
Public Sub ArrayParam(ByVal strStudents())
Sub ArrayParam(ByVal strStudents() As String)
Private Sub ArrayParam(ByRef strStudents As String)
.
.
QUESTION 33
The following statements apply to a Timer control, except _____________.
. it can be used to trigger tick events at regular intervals
the smallest possible interval between tick events is a microsecond
the timer can be disabled so it generates no tick events
it responds to Tick events only at run time
.
.
QUESTION 34
A __________ is automatically called when an instance of the class is created.
. Load method
constructor
instantiator
Initializer method
.
.
QUESTION 35
Choose the statement below that performs the comment found on line 2 of the following code segment. Dim newStudentForm As New frmNewStudent() 'Initialize AcademicYear text box on NewStudent form to 1 newStudentForm.ShowDialog()
. frmNewStudent.txtAcademicYear.Text = "1"
txtAcademicYear.Text.newStudentForm = "1"
newStudentForm.txtAcademicYear.Text = "1"
txtAcademicYear.frmNewStudent = "1"
.
.
QUESTION 36
Which of the following is true regarding ASP.NET?
. ASP.NET is a client-side programming technology.
ASP.NET is Microsoft's version of HTML and provides the same capabilities as HTML.
ASP.NET provides many controls that are similar to those used in Windows forms.
ASP.NET is the first generation of Web programming technology introduced by Microsoft.
.
.
QUESTION 37
What value should be placed in a Timer control's Interval property to trigger a Tick event every 10 seconds?
. 1000
10000
100
10
.
.
QUESTION 38
Which of the following SQL WHERE clauses will select all students whose last name begins with "S"?
. Where LastName Like "S%"
Where LastName Like "S"
Where LastName = "S%"
Where LastName = "S*"
.
.
QUESTION 39
A menu item may be executed by a user in each of the following ways except __________.
. by pressing access keys such as Alt-F
by pressing shortcut keys such as Ctrl-S
by clicking on the item
by hovering the mouse over the item
.
.
QUESTION 40
An instance of a class is also called ______________.
. a tangible entity
an object
a method
a property
.
.
QUESTION 41
The DetailsView control allows the user to do which of the following?
. display multiple rows of a database table at the same time
connect to a data source
view but not edit the rows of a database
all of the above are true
.
.
QUESTION 42
When using the Remove method of a collection, what happens if the argument provided is a string expression?
. The item at the index value represented by that string is removed if found in the collection.
The item with a key value that matches the string is removed if found in the collection.
A string expression may not be provided as an argument.
A syntax error occurs.
.
.
QUESTION 43
A function that is a member of a class is called __________ .
. a module
a method
a component
an element
.
.
QUESTION 44
The last form created for a Windows Forms application is designated as the startup form.
. True
False
.
.
QUESTION 45
Which statement is not true about the following array? Dim strFriends() As String = { "Rose", "Bud", "Flower", "Spring" }
. The String "Flower" is located at index position 2.
All elements have been assigned values.
The array has an unlimited number of elements.
All of the above are true statements about the array.
.
.
QUESTION 46
Assume the following table named Student exists in a database: Name Number Address GPA CumHrs
Adams, Carol 123 Redford Hall 3.6 67
Baker, Paul 345 Kingman Hall 2.1 34
Jones, Jill 456 Bassett Hall 3.2 89
Smith, Mary 887 Redford Hall 3.8 112
Taylor, Darren 987 Bassett Hall 3.7 55
Which of the following SQL statements will return only the student name and GPA from the Student table for all students having a GPA that is greater than or equal to 3.5?
. SELECT Name, GPA FROM Student WHERE GPA >=3.5
SELECT * FROM Student WHERE GPA >= 3.5
SELECT Name, Number, GPA, CumHrs FROM Student WHERE GPA >= 3.5
SELECT Student WHERE GPA >= 3.5 And Name, GPA
.
.
QUESTION 47
In order to add a menu to a form, you must place a __________ on the form.
. MenuCommand control
MenuItem control
MenuOption control
MenuStrip control
.
.
QUESTION 48
This was the first server-side web programming technology introduced by Microsoft.
. JavaScript
HTML
PHP
ASP
.
.
QUESTION 49
Which statement is the best solution for the following problem? Write a statement that initializes a two dimensional array of Integers named intGrades. The array will have 2 rows, with 93, 91, and 84 in the first row and 85, 89, and 91 in the second row.
. Dim intGrades(2,3) As Integer = { {93, 91, 84}, {85, 89, 91} }
Dim intGrades(,) As Integer = { {93, 91, 84}, {85, 89, 91} }
Dim intGrades() As Integer = { 93, 92, 84,85, 89, 91}
Dim intGrades(1, 2) As Integer = { {93, 91, 84}, {85,89, 91} }
.
.
QUESTION 50
You access public members of a class object with ___________.
. the getData method
the access operator
the dot operator
a public module
.
.
QUESTION 51
In the array declaration below, what is the significance of the number 7? Dim strNames(7) As String
. It indicates the number of elements in the array.
It's the upper bound (highest subscript value) of the array
It's the value assigned to the array elements.
It's one greater than the upper bound of the array.
.
.
QUESTION 52
All of the following statements are true about the Finalize method of an object except __________.
. the Finalize method is executed when it is called from the Main method
the Finalize method is automatically called just before an instance of the class is destroyed
you cannot predict exactly when the Finalize method will be executed
you are not required to define a Finalize method in your own class
.
.
QUESTION 53
Any form in a Windows Forms application can be designated as the startup form.
. True
False
.
.
QUESTION 54
Which of the following operators determines if two object variables reference the same object?
. =
IsEqual
Is
SameAs
.
.
QUESTION 55
Which of the following code segments will copy the values of a 5 element array named intOldValues into another 5 element array named intNewValues?
. intIndex = 1 Do While intIndex <=5 intNewValues(intIndex) = intOldValues(intIndex) intIndex = intIndex + 1 Loop
intIndex = 0 Do While intIndex < 5 intNewValues(intIndex) = intOldValues(intIndex) intIndex = intIndex + 1 Loop
For intIndex = 1 To 5 intNewValues(intIndex) = intOldValues(intIndex) Next intIndex
For intIndex = 0 To 4 intOldValues(intIndex) = intNewValues(intIndex) Next intIndex
.
.
QUESTION 56
All of the following are true about the Hide method of a form except:
. Using the Hide method removes the form from memory.
The Hide method makes the form invisible.
Once you have called the Hide method, the form can be redisplayed with the ShowDialog method.
Once you have called the Hide method, the form can be redisplayed with the Show method.
.
.
QUESTION 57
How many elements can be stored in the following array? Dim sngGrades (2, 3) As Single
. 6
5
12
cannot be determined
.
.
QUESTION 58
The GridView control provides all the following features except __________.
. it's designed to display single row at a time is displayed
you can sort on any column
you can select the order in which columns appear
you can format data within the columns
.
.
QUESTION 59
Which statement does NOT accurately describe a database row?
. A row contains related data about a single item such as a department.
A row contains one or more fields.
When discussing a table, we refer to the rows by name.
A row is part of a database table.
.
.
QUESTION 60
Which table adapter method reads data from the database into the dataset?
. Fill
Read
Select
Retrieve
.
.
QUESTION 61
The __________ control displays information from a dataset in row and column format.
. DataAware
DataGridView
DataListView
DataTableView
.
.
QUESTION 62
Which method allows the user to navigate to another Web page?
. Redirect.Response
Hyperlink.Redirect
Response.Redirect
Redirect.Hyperlink
.
.
QUESTION 63
An event handler for a menu item is created by __________ in design view.
. manually declaring the event handler
right-clicking the menu item
double-clicking the menu item
clicking the menu item
.
.
QUESTION 64
If there exists a class named People and one wants to create a new class named Student based on the People class, what code segment below shows the correct way to do so?
. Public Class Student Inherits People
Public Class Student Includes Class People
Public Class Student based on People
Public Class Student :People
.
.
QUESTION 65
Which of the following displays a message box saying "I have been created" every time a new instance of the class ShowMe is created?
. Public Class ShowMe MessageBox.Show("I have been created") End Class
Public Class ShowMe Public Sub Constructor() MessageBox.Show("I have been created") End Sub End Class
Public Class ShowMe Public Sub Create() MessageBox.Show("I have been created") End Sub End Class
Public Class ShowMe Public Sub New() MessageBox.Show("I have been created") End Sub End Class
.
.
QUESTION 66
A ________ is an in-memory copy of data read from database tables.
. data control
dataset
connection
data adapter
.
.
QUESTION 67
Web applications use the __________ control instead of the datasets used by desktop applications.
. Gridview
Datasource
Table
MS Access
.
.
QUESTION 68
What property must be set on a menu item to have the user activate that option by hitting Ctrl+C?
. ShortcutKeys
QuickKey
HotKey
ShowShortCut
.
.
QUESTION 69
Procedures can be written to handle arrays and do all of the following, except __________.
. store data in an array
sum or average the values
display the contents of the array
all of the above are correct
.
.
QUESTION 70
Which of the following will display the getStudentDataForm form such that the programming statements that follow will not execute until the getStudentDataForm is closed?
. getStudentDataForm.Open()
getStudentDataForm.Show()
getStudentDataForm.ShowDialog()
getStudentDataForm.OpenForm.Modal()
.
.
QUESTION 71
Which of the following is not a TextBox TextMode property choice?
. Sorted
SingleLine
MultiLine
Password
.
.
QUESTION 72
Which method is used to create a new item in a collection?
. Store
Insert
Add
Create
.
.
QUESTION 73
Every class you create in Visual Basic is automatically derived from this built-in class.
. Object
Base
Window
Application
.
.
QUESTION 74
What happens when an object variable goes out of scope?
. The object may be removed from memory by the garbage collector.
The object may be referred to using the dot operator.
An exception error will be generated.
The object becomes accessible again when the variable comes back into scope.
.
.
QUESTION 75
A variable is accessible to statements outside the form if declared __________.
. as Private and class-level
as Public
as Public and class-level
with a Dim statement
.
.
QUESTION 76
A is a column (or columns) that uniquely identifies each row of data in a database.
. selector
main key
identifier
primary key
.
.
QUESTION 77
What is the result of the following section of code? Private Sub btnExit_Click(ByVal sender As System.Object, _ ByVal e as System.EventArgs) Handles btnExit.Click Me.Close() End Sub
. Shut down the computer
Log off the current user
Close the current form
None of the above
.
.
QUESTION 78
A _______________ is the design of tables, columns and relationships between tables for the database.
. data table
database schema
data set
relational model
.
.
QUESTION 79
Object-oriented programming is a way of designing and coding applications such that interchangeable software can be used to build larger programs.
. controls
structures
components
languages
.
.
QUESTION 80
It's possible to access the items in a collection using __________.
. an integer index of the item to be retrieved
the Item method to retrieve an item with a specific key value
a For Each loop
all of the above
.
.
QUESTION 81
Web applications are designed around a __________ model, meaning the one computer produces data while another uses data.
. Client-Server
Peer-to-Peer
Master-Slave
Server-User
.
.
QUESTION 82
Client programs can query __________ to get values, but they cannot modify them.
. ReadOnly properties
Get/Set properties
Private methods
Public properties
.
.
QUESTION 83
What is the error in the following code, and when will it be caught? Dim intValues(5) As Integer Dim intIndex As Integer For intIndex = 0 To 10 intValues(intIndex) = 10 Next intIndex
. The For Next loop values for intIndex should range from 1 to 10. The error will occur at run time.
The loop should close with Next instead of Next intIndex. The error will occur at compile time.
An out of bounds error will occur. The error will occur at run time.
The For Next loop values for intIndex should range from 1 to 5. The error will occur at compile time.
.
.
QUESTION 84
The Where clause of an SQL statement specifies __________.
. the location of the database being queried
which fields are to be displayed
specifies the order in which the rows should appear
specifies which rows should be retrieved
.
.
QUESTION 85
A web form can be identified by its __________ filename extension.
. .asp
.aspx.vb
.aspx
.config
.
.
QUESTION 86
The SQL Select statement retrieves data from a database and returns it in a __________, a set of records matching the selection criteria.
. Subset
Dynaset
DataSource
Dataset
.
.
QUESTION 87
Which of the following statements is false?
. A database can store more data more efficiently than sequential text files.
When using a large amount of data, most developers prefer to use a DBMS.
Visual Basic is used to interface with the user and a DBMS works directly with the data.
Visual Basic statements can directly access database fields without using the DBMS.
.
.
QUESTION 88
When designing web forms, the Toolbox window contains all of the following groups of controls except:
. Login to authenticate users.
Data controls for connecting to data sources.
WebParts that let the user modify the content and behavior of the web pages.
Ftp controls for connecting to remote computers.
.
.
QUESTION 89
What is the simplest way to update a user's changes to the database?
. No need to save user changes as this occurs automatically
Use the Update method of a table adapter
Click the diskette icon to save the dataset to the database
Call the SaveDataset method of the table adapter
.
.
QUESTION 90
Which of the following is not true about the Form Activated event?
. It's executed when a form is initially displayed.
It's executed each time a form regains the focus.
It's executed each time the the user clicks a form that does not have the focus.
It's executed before the Load event procedure is processed.
.
.
QUESTION 91
When the Web form default.aspx is added to a project, another file named __________ is also created.
. default.asp
default.aspx.vb
default.config
default.vb
.
.
QUESTION 92
This property of a control allows it be positioned a specified distance from the outside edge of the form.
. dock
anchor
attach
secure
.
.
QUESTION 93
A database _____________is organized into rows and columns.
. grid
matrix
table
spreadsheet
.
.
QUESTION 94
The best approach to move a menu item with an existing click event to a new location is:
. cut the menu item from the old location and paste it into the new location.
click the menu item and drag it to the new location
delete the menu item from the old location and add it to the new location
none of the above
.
.
QUESTION 95
What is the best way to share functions across more than one project?
. Create the functions in one project, then copy and paste them into other projects that need them.
Place the code for the functions in a module and add that module to each project.
Place the code for the functions in the startup form of each project.
Place the code inside a Main procedure with a Public access specifier for each function.
.
.
QUESTION 96
Which Web control is similar to the Windows form ComboBox control?
. TextBox
DropDownList
CheckBoxList
ListBox
.
.
QUESTION 97
Which of the following statements sorts an array named intValues?
. Sort.Array(intValues)
Sort(intValues)
Sort.Array(intValues())
Array.Sort(intValues)
.
.
QUESTION 98
Which of the following outlines the proper order for connecting a web form to a database?
. Add a GridView control to the form Select the Data Source type Copy the database file to the App_Data folder Configure the SELECT statement for the database query
Copy the database file to the App_Data folder Add a GridView control to the form Select the Data Source type Configure the SELECT statement for the database query
Copy the database file to the App_Data folder Select the Data Source type Configure the SELECT statement for the database query Add a GridView control to the form
Configure the SELECT statement for the database query Copy the database file to the App_Data folder Select the Data Source type Add a GridView control to the form
.
.
QUESTION 99
When an ASP.NET application is created, it contains only one file named __________.
. Default.aspx
Index.aspx
Default.htm
Web.config
.
.
QUESTION 100
The following are true about a HyperLink control, except __________.
. its Text property is shown to the user at runtime
it generates an event
it allows the user to navigate to another Web page
its Target property controls whether new page will appear in a separate window
Need Solution https://gum.co/dGqZ
Need Solution https://gum.co/dGqZ