It 116 Vb.net

Front 1

ShowDialog()

Back 1

The method that displays a modal form is:

Front 2

The method that displays a modeless form is:

Back 2

Show()

Front 3

The Close method for a form removes the form from:

Back 3

Both screen and from memory

Front 4

You will designate the project's start-up object where?

Back 4

On the Project Property Pages dialog box

Front 5

A form can only be displayed after creating a new instance of that form using a Dim statement (True or False)

Back 5

True

Front 6

The statements that follow the modeless Show() method will continue to execute while the modeless form remains open (True or False)

Back 6

True

Front 7

The standard prefix for a form is

Back 7

frm

Front 8

What type of variables are accessible to all statements in the form file, but are not accessible by default to statements outside the form file.

Back 8

Class Level

Front 9

mnuCutEnabled = False is used to disable the menu element named "mnuCut" True or False

Back 9

True

Front 10

mnuSettings.Checked = True does what?

Back 10

Shows the menu element names "mnuSetting" as checked

Front 11

What is the lower subscript of an array?

Back 11

0 (zero)

Front 12

Individual elements of an array can be accessed by using a subscript (True or False)

Back 12

True

Front 13

A subscript of an array can be represented as a variable (True or False)

Back 13

True

Front 14

Dim days(30) holds how many elements?

Back 14

31

Front 15

What is missing in this code?
Dim number(4)

Back 15

Data type (integer)

Front 16

Which property is used to determine the number of elements in an array?

Back 16

Length

Front 17

Array.Length = 7 tells you what?

Back 17

The array will hold seven (7) elements.

Front 18

If Array.Length = 7, what will the upper subscript of the array be?

Back 18

6 (six)

Front 19

What command allows you to change the size of an array at runtime?

Back 19

ReDim

Front 20

Arrays can be sorted alphabetically (True or False)

Back 20

True

Front 21

What does the following command do?
Array.Sort(myArray)

Back 21

Sorts the elements in an array called myArray.

Front 22

The interval property for the Timer control holds the number in _____________between timer events.

Back 22

milliseconds

Front 23

A Timer control on a form responds to the _________events as the application runs.

Back 23

tick

Front 24

The randomize statement does what?

Back 24

Randomize initializes a sequence of random numbers using the system time.

Front 25

The Rnd function does what?

Back 25

Rnd returns a single precision random number between 0.0 and 1.0

Front 26

The StreamWriter object works with text and _______files.

Back 26

Binary

Front 27

If you want to add information to the end of an existing file, what method do you use?

Back 27

AppendText

Front 28

A file can be read if it is not opened first (True or False)

Back 28

False

Front 29

To write a line of data to a file terminating it with a newline character, you will use what method

Back 29

WriteLine

Front 30

To write a line of data to a file without a newline character, you will use what method

Back 30

Write

Front 31

OpenFile(FileName).Text does what?

Back 31

Opens a text file for reading.

Front 32

What method do you use to read one line of data from a file?

Back 32

ReadLine()

Front 33

What method do you use to determine the end of the file?

Back 33

Peek()

Front 34

When you add a dialog control to a form during design, the control appears in the component tray (True or False)

Back 34

True

Front 35

The filter property determines the types of file types that are displayed in an Open or Save As dialog box (True or False)

Back 35

True

Front 36

When a PrintDocument control's Print method is executed, what event is triggered?

Back 36

PagePrint

Front 37

The e.Graphics.DrawString method allows the font size, font face, and text color to be specified (True or False)

Back 37

True

Front 38

In a database, what is a field?

Back 38

An individual piece of information pertaining to an item. Each field represents a column in the database table.

Front 39

In a database, what is a record?

Back 39

A record is a complete set of data about a single item consisting of one or more fields. Each row represents a record in a database table.

Front 40

A collection of tables which hold related data is a _______.

Back 40

database

Front 41

What is a primary key?

Back 41

A field that uniquely identifies each row in a table (might be social security number, or part number)

Front 42

There are three steps to setting up a database to work with an application. These are what?

Back 42

Data connection
Data adapter
Dataset

Front 43

What is a dataset?

Back 43

An in memory cache of records that is separate from the data source and allows you to work with the data (obtained from a query)

Front 44

When your application manipulates data does it manipulate the data source or the dataset?

Back 44

dataset

Front 45

A data-aware control can do what?

Back 45

Automatically display data from a particular row and column of a table in a dataset.

Front 46

Before you bind a data-aware control to a dataset, you must first have configured what three things?

Back 46

data connection
data adapter
dataset objects

Front 47

A CurrencyManager object is added to a form when you connect the form to a _________

Back 47

data source

Front 48

The CurrencyManager object provides a way to navigate through the rows of a dataset (True or False)

Back 48

True

Front 49

ADO.NET is ___________

Back 49

a powerful data access component and stands for Active X Data Objects.

Front 50

The Server Explorer window is used to connect to a database during design (True or False)

Back 50

True

Front 51

You can also initialize an array of strings with empty strings. True or False.

Back 51

True.

Hint 51

Page 479

Front 52

What DataGrid control property do you set to associate the control with a dataset?

Back 52

The DataSource property

Hint 52

pg 672

Front 53

When your application manipulates data, does it perform the manipulation on the dataset or the data source?

Back 53

The Dataset

Hint 53

pg 608

Front 54

What is the debugging command that causes a Sub procedure or function to execute without single-stepping through the procedure's or function's code.

Back 54

Step-Over

Hint 54

pg 374

Front 55

The procedure____is simply the name of the procedure that is to be executed.

Back 55

Call

Front 56

The data adapter's Fill method is used to fill a datasource with data from a dataset. True or False?

Back 56

False

Hint 56

Pg 636, Chapter 10 Summary

Front 57

What is the purpose of DataGrid control

Back 57

Create a data grid

Hint 57

pg. 663

Front 58

What method do you use to determine if a file exists?

Back 58

System.IO.File.Exists

Hint 58

Pg. 552

Front 59

what is the class implemetation

Back 59

the portion of a class that is hidden from client programs

Hint 59

chapter 12

Front 60

What are the two broad categories of procedures?

Back 60

Sub procedures and function procedures.

Hint 60

They both end in procedure.

Chapter 6, page 347, 1st para.

Front 61

how do you remove a member from a collection

Back 61

with the remove method

Hint 61

chapter 12

Front 62

What is the difference between a modal form and a modeless form?

Back 62

When a modal form displayed, no other form in the application can recieve the focus until the modal form is closed. In addition, no other statements in the procedure that displayed the modal form will execute until modal form is closed. A modeless form allows the user to switch focus to another form while it is displayed. The statements that follow the modeless Show method call will continue to execute after the modeless form is displayed. Visual Basic will not wait until the modeless form is closed to execute these statements.

Hint 62

One can do something the other one cant do.

Front 63

With what file extension are standard modules saved?

Back 63

.VB

Hint 63

dot_ _

Front 64

How do you configure a data adapter at design time to execute an SQL command?

Back 64

In the CommandText subproperty of the SelectCommand property, click the ellipses to open the query builder and Enter an SQL statement.

Hint 64

pg. 656

Front 65

You can access the Count property with an expression in the following format:

DataSet.Table.Count

Back 65

True

Hint 65

pg 660 Testing for an Empty Dataset

Front 66

what is a collection of code that performs a specific task and does not return a value

Back 66

Sub Procedure

Hint 66

6.2

Front 67

What is a select statement

Back 67

Its used to find records in a table.

Front 68

This type of statement causes a procedure to execute.

Back 68

Procedure call

Hint 68

Found on Pg. 392
Question 2.

Front 69

In Access a column represents a _____________

Back 69

field

Front 70

A ______________is a field or combination of fields that uniquely identifies each row in each table

Back 70

Primary Key

Front 71

The ______________is the object that provides the required methods for retrieving from the data source and updating after the application has made a change to it

Back 71

data adaptor

Front 72

The _____________is an in-memory cache of records retrieved from the data source.

Back 72

dataset

Front 73

a _____________control that after having been bond to a dataset can automatically display data from a particular row and column from that ADO.NET dataset.

Back 73

data-aware

Front 74

The Currency Manager of ADO>NET is used for displaying the data retrieved from a database, in the format of a 2 decimal place and a dollar sign.

Back 74

False

Front 75

Microsoft Jet is the provider you select when working with Microsoft Access.

Back 75

True

Front 76

To add a new record to the table, use the ____________method.

Back 76

AddNew

Front 77

The code ______________is the format that would be used to assign the number 65 to a field named fldMyNumber.

Back 77

newDataRow.item("fldMyNumber") = 65

Front 78

To mdoify a record in the table the _____________method is used.

Back 78

Update

Front 79

To delete a record at a specified row within the table the __________method is used.

Back 79

RemoveAt

Front 80

In the SQL statemetn "Select* from table" the * represents all ________.

Back 80

fields

Front 81

The SQL statement ____________will retrieve all records which contain the string Jeffrey in the field named Name from the table Friends.

Back 81

Select * from Friends where Name = 'Jeffrey'

Front 82

SQL supports Logical operators such as AND and OR

Back 82

True

Front 83

IT is possible to retrieve a single field from a table.

Back 83

True

Front 84

When searching for records based on criteria, the _________clause is used

Back 84

Where

Front 85

Multiple criteria can be set when selecting which records to return from a search.

Back 85

True

Front 86

The SQL statement ____________ will insert a record which contains the string Alexis into the field named Name contained within the table Friends

Back 86

Insert into Friends (Name) Values (`Alexis`)

Front 87

The SQL statement "Delete from Friends" will delete all records in the table named Friends

Back 87

True

Front 88

When the ReadOnly property is set to true, the data in the data grid cannot be edited, deleted, or added to.

Back 88

True