Question 1

A ____ object is a temporary cache storage for data retrieved from a data source.

Accepted Answer

A)  Database 
B)  DataSet 
C)  DataSource 
D)  DataRecord 
A)  Database 
B)  DataSet 
C)  DataSource 
D)  DataRecord

Question 2

The number of rows or columns in the DataTable can be computed using the ____ property.

Accepted Answer

A)  Total 
B)  Sum 
C)  Count 
D)  Aggregate 
A)  Total 
B)  Sum 
C)  Count 
D)  Aggregate

Question 3

The Data Source Configuration Wizard uses the ____ method to populate a DataSet object with table rows and columns from a selected table within a database.

Accepted Answer

A)  Populate 
B)  Fill 
C)  Arrange 
D)  Cache 
A)  Populate 
B)  Fill 
C)  Arrange 
D)  Cache

Question 4

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-To keep the maximum number of these available for use,the program should keep one open only as long as necessary

Accepted Answer

A) Binding Navigator 
B) Data Source Configuration Wizard 
C) Data Table 
D) Data Sources 
E) Fill
F)initialize
G)connection
H)data binding
I)Count
J)table 
A) Binding Navigator 
B) Data Source Configuration Wizard 
C) Data Table 
D) Data Sources 
E) Fill
F)initialize
G)connection
H)data binding
I)Count
J)table

Question 5

Critical Thinking Questions
Case 10-2
Melissa helps you figure out how to use the OleDbDataAdapter to make a connection to a database for you. But in order to help you learn as much as you can, she wants you to begin to figure out things on your own.
-Which of the following is NOT a true statement Melissa can make to you about filling the DataTable object you have created?

Accepted Answer

A)  As soon as you connect to the database and fill the DataTable object, the next statement should disconnect the application from the database. 
B)  To keep the maximum number of connections available, you should keep connections open only as long as necessary. 
C)  After the DataTable is initialized, it must be filled using the Populate command with the data from the selected table. 
D)  By using the database in disconnected form, the system resources of the computer and network are not overloaded. 
A)  As soon as you connect to the database and fill the DataTable object, the next statement should disconnect the application from the database. 
B)  To keep the maximum number of connections available, you should keep connections open only as long as necessary. 
C)  After the DataTable is initialized, it must be filled using the Populate command with the data from the selected table. 
D)  By using the database in disconnected form, the system resources of the computer and network are not overloaded.

Question 6

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Used to generate the connection information required for a program to access a database

Accepted Answer

A) Binding Navigator 
B) Data Source Configuration Wizard 
C) Data Table 
D) Data Sources 
E) Fill
F)initialize
G)connection
H)data binding
I)Count
J)table 
A) Binding Navigator 
B) Data Source Configuration Wizard 
C) Data Table 
D) Data Sources 
E) Fill
F)initialize
G)connection
H)data binding
I)Count
J)table

Question 7

Data binding can only be accomplished by writing code.

Accepted Answer

A) True 
 B)False

Question 8

The only valid source for a database is a local hard drive.

Accepted Answer

A) True 
 B)False

Question 9

You cannot complete data binding by coding.

Accepted Answer

A) True 
 B)False

Question 10

A user cannot delete a record from a database table using the BindingNavigator control.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following must be installed on your computer before you can incorporate databases with ADO.net?

Accepted Answer

A)  Data Source Manager 
B)  ADO 2013 
C)  Database Grid v.4 
D)  Access 2013 
A)  Data Source Manager 
B)  ADO 2013 
C)  Database Grid v.4 
D)  Access 2013

Question 12

A database should be used in ____________________ form,with the procedure shown in the accompanying figure,in order to minimize the use of computer and network resources.

Accepted Answer

The answer of A database should be used in ____________________...

Question 13

A ____ contains a specific piece of data within a record in a database table.

Accepted Answer

A)  field 
B)  file 
C)  query 
D)  row 
A)  field 
B)  file 
C)  query 
D)  row

Question 14

The prefix ____________________ is used when naming an OleDbDataAdapter in code.

Accepted Answer

The answer of The prefix ____________________ is used when naming...

Question 15

A DataSet permanently stores database data in the application.

Accepted Answer

A) True 
 B)False

Question 16

A table's ____________________ represents the identifying field used to uniquely identify each record in the table.

Accepted Answer

The answer of A table's ____________________ represents the identifying field...

Question 17

To view the data available in the source database,you need to click Show Data Sources on the VIEW menu.

Accepted Answer

A) True 
 B)False

Question 18

Data from a database is available for dragging onto a Windows form from the Data ____________________ window.

Accepted Answer

The answer of Data from a database is available for...

Question 19

A ____ in a database structures data into rows and columns.

Accepted Answer

A)  file 
B)  query 
C)  report 
D)  table 
A)  file 
B)  query 
C)  report 
D)  table

Question 20

To support databases using Visual Basic 2012,a library called ____ Data Objects works within all Windows,Office,and Web applications.

Accepted Answer

A)  Indexed 
B)  Basic 
C)  ActiveX 
D)  Virtual 
A)  Indexed 
B)  Basic 
C)  ActiveX 
D)  Virtual

A ____ object is a temporary cache storage for data retrieved from a data source.

The number of rows or columns in the DataTable can be computed using the ____ property.

The Data Source Configuration Wizard uses the ____ method to populate a DataSet object with table rows and columns from a selected table within a database.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To keep the maximum number of these available for use,the program should keep one open only as long as necessary

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used to generate the connection information required for a program to access a database

Data binding can only be accomplished by writing code.

The only valid source for a database is a local hard drive.

You cannot complete data binding by coding.

A user cannot delete a record from a database table using the BindingNavigator control.

Which of the following must be installed on your computer before you can incorporate databases with ADO.net?

A database should be used in ____________________ form,with the procedure shown in the accompanying figure,in order to minimize the use of computer and network resources.

A ____ contains a specific piece of data within a record in a database table.

The prefix ____________________ is used when naming an OleDbDataAdapter in code.

A DataSet permanently stores database data in the application.

A table's ____________________ represents the identifying field used to uniquely identify each record in the table.

To view the data available in the source database,you need to click Show Data Sources on the VIEW menu.

Data from a database is available for dragging onto a Windows form from the Data ____________________ window.

A ____ in a database structures data into rows and columns.

To support databases using Visual Basic 2012,a library called ____ Data Objects works within all Windows,Office,and Web applications.

Introduction to Visual Basic 2012 Programming

Program and Graphical User Interface Design

Program Design and Coding

Variables and Arithmetic Operations

Decision Structures

Loop Structures

Using Procedures and Exception Handling

Using Arrays and File Handling

Creating Web Applications

Multiple Classes and Inheritance

Windows Store Apps

Filters

Exam 10: Incorporating Databases with ADO.NET

A ____ object is a temporary cache storage for data retrieved from a data source.

The number of rows or columns in the DataTable can be computed using the ____ property.

The Data Source Configuration Wizard uses the ____ method to populate a DataSet object with table rows and columns from a selected table within a database.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -To keep the maximum number of these available for use,the program should keep one open only as long as necessary

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Used to generate the connection information required for a program to access a database

Data binding can only be accomplished by writing code.

The only valid source for a database is a local hard drive.

You cannot complete data binding by coding.

A user cannot delete a record from a database table using the BindingNavigator control.

Which of the following must be installed on your computer before you can incorporate databases with ADO.net?

A database should be used in ____________________ form,with the procedure shown in the accompanying figure,in order to minimize the use of computer and network resources.

A ____ contains a specific piece of data within a record in a database table.

The prefix ____________________ is used when naming an OleDbDataAdapter in code.

A DataSet permanently stores database data in the application.

A table's ____________________ represents the identifying field used to uniquely identify each record in the table.

To view the data available in the source database,you need to click Show Data Sources on the VIEW menu.

Data from a database is available for dragging onto a Windows form from the Data ____________________ window.

A ____ in a database structures data into rows and columns.

To support databases using Visual Basic 2012,a library called ____ Data Objects works within all Windows,Office,and Web applications.

Introduction to Visual Basic 2012 Programming

Program and Graphical User Interface Design

Program Design and Coding

Variables and Arithmetic Operations

Decision Structures

Loop Structures

Using Procedures and Exception Handling

Using Arrays and File Handling

Creating Web Applications

Multiple Classes and Inheritance

Windows Store Apps

Filters