CIS400 Visual Basic Programming for the Windows Environment

Multiple Choice Questions

Each of the following questions has only one correct answer. Circle the choice that is the best answer to each question.

1. When you design and develop business classes for an application, your

goal is to:

A). allow development to be spread among members of a development

team.

B). separate the business rules from the presentation and database logic.

C). make the application easier to develop and maintain.

D). all of the above.

2. When debugging an application, you can use the Step Out command to:

A). execute all statements in the rest of the application without

interruption.

B). execute all statements in the rest of the current procedure without

interruption.

C). execute all statements in the next procedure without interruption.

D). execute all statements up to the next breakpoint.

3. To generate the starting code for a new member of a class, you can use:

A). the Solution Explorer

B). the Class Details window

C). a class diagram

D). the CodeLens feature

4. Suppose that your application throws a format exception and enters

break mode with the statement that caused the exception highlighted.

What is the quickest way to find the bug?

A). Use the Autos window to review the data in the variables in the

highlighted statement.

B). Use the Locals window to review the data in the variables in the

highlighted statement.

C). Add the variables in the highlighted statement to a Watch window

and review the data.

D). Use data tips to review the data in the variables in the highlighted

statement.

5. Suppose that your application uses a loop that isnt producing the

intended results. The best way to analyze whats going on in the loop is

to set a breakpoint at the start of the loop, step through the loop, and

monitor the changes in the variables within the loop by using:

A). data tips

B). the Visualizer feature

C). a Watch window

D). the Autos window

E). the Immediate window

6. Which of the following does a relational database use to uniquely

identify each row in a database table?

A). indexes

B). foreign keys

C). non-primary keys

D). primary keys

7. A join that returns records from related tables only if their related fields

match is called ___________________________.

A). an outer join

B). an inner join

C). a cross join

D). a data join

8. Consider the Select statement given below. Assuming that the Accounts

table has 5 columns, the result set retrieved by the Select statement

contains rows that have _____________________.

Select Balance, Number

From Accounts

Where Balance < 0

A). all the columns from the Accounts table

B). three of the columns from the Accounts table

C). all the columns from the Accounts table where Balance is less

than 0

D). two of the columns from the Accounts table where Balance is less

than 0

9. Concurrency occurs when __________________________________.

A). an update or delete operation is refused

B). two or more users retrieve and then try to update data in the same

row of a table at the same time

C). an update or delete operation is resubmitted to the database

D). a program checks if a row has changed before updating or deleting it

10. If a row in one table is related to one or more rows in another table, the

tables are said to have a __________________________________.

A). one-to-many relationship

B). one-to-one relationship

C). many-to-many relationship

D). none of the above

11. A system that divides the processing between the clients and the server is

called ___________________________.

A). a server-based system

B). an enterprise system

C). a client/server system

D). a mainframe system

12. What does a relational database use to relate tables in the database to

each other?

A). indexes

B). foreign keys

C). non-primary keys

D). primary keys

13. Which of the following is the primary function of a data adapter?

A). To define the connection to a database.

B). To manage the flow of data between a client program and a database.

C). To convert data to the format required by an application.

D). To define a SQL operation to be performed.

14. When you use a data source to get data from a database, you can:

A). select just one table with all its columns.

B). select one or more tables with all their columns.

C). select just one table and just the columns that you want.

D). select one or more tables with just the columns that you want from

each table.

15. When a DataGridView control raises a DataError event, the event

handler should ___________________________________.

A). display a message that gives the row and column of the field that

caused the error.

B). disable the UpdateAll method so that the row wont be updated.

C). refresh the DataGridView control so that the user can re-enter the

data for the current row.

D). set the Cancel property of the EventArgs to True

16. Consider the statement given below. What does the UpdateAll method

accomplish?

Me.ProductsTableAdapter.UpdateAll(Me.MMABooksDataSet)

A). It updates all the tables in the dataset with data from the database.

B). It updates all the tables in the table adapter with data from the

database.

C). It updates the database with data from all the tables in the dataset.

D). It updates the database with data from all the tables in the table

adapter.

17. When you bind a combo box to a table in one data source, you can

display the data from one column of that table in the list of the combo

box and use the selected value to ____________________________.

A). update another column in that table

B). update a column in a table of another data source

C). update another column in that table OR a column in a table of

another data source

D). update another column in that table AND a column in a table of

another data source

18. When you add a parameterized query to a table adapter, Visual Studio

automatically adds a toolbar to the form that lets you ______________.

A). navigate from one parameter to the next

B). navigate from one parameter value to the next

C). enter the parameter names and values that are needed by the query

D). enter the parameter values that are needed by the query

19. Which of the following is NOT a reason why you would want to edit the

code that Visual Studio generates for a parameterized query?

A). To make sure the query works right.

B). To make the code easier to read and understand.

C). To improve the error handling provided by the code.

D). To compile and debug the query.

20. Which of the following cannot be done when you edit the properties or

columns of a DataGridView control?

A). Disable row navigation.

B). Change column headers.

C). Reorder the columns.

D). Disable row additions.

21. Two objects created from the same class can have different _________.

A). fields

B). methods

C). data

D). properties

22. To begin the declaration for a constructor, you code the keywords

Public Sub followed by which of the following?

A). the keyword New.

B). the data type of the class.

C). the name of the class.

D). the arguments provided to the class.

23. The live code analysis feature allows you to generate a code stub for a

class or member from which of the following?

A). The Solution Explorer

B). The Exception Assistant

C). The Generate From Usage wizard

D). the Error Correction Options window

24. One benefit of the Edit and Continue feature is that it lets you _______.

A). find more than one bug in a single test run

B). find and fix more than one bug in a single test run

C). find more than one bug in a test run without exiting from break

mode.

D). find and fix more than one bug in a single test run without exiting

from break mode

25. The Locals window displays information about which of the following?

A). Variables used by the current statement and the previous statement.

B). Variables within the scope of the current method.

C). Expressions used by the current statement and the previous

statement.

D). Expressions you have added to the Locals window.