Exam 10: Incorporating Databases with ADO.NET

The SQL statement: ____________________ * FROM ApprovedTravelRequests is a query statement that requests that the entire table named ApprovedTravelRequests is opened for use by the application.

Free

(Short Answer)

4.9/5

(36)

Question 1

Correct Answer:

Verified

SELECT

A database can contain only one record.

Free

(True/False)

4.8/5

(28)

Question 2

Correct Answer:

Verified

False

The ToolStrip control used for navigating through database records is called the BindingToolStrip._________________________

Free

(True/False)

4.9/5

(40)

Question 3

Correct Answer:

Verified

False

Explain OleDbDataAdapter and what it consists of,and provide its general form.

(Essay)

4.7/5

(45)

Question 4

In a database,a(n)____________________ is referred to as a record.

(Short Answer)

4.8/5

(34)

Question 5

To fill a ComboBox object with data from a field in a database,the ComboBox object must be bound to that field.

(True/False)

4.8/5

(28)

Question 6

A ____ is a field in a table that contains unique values in each record.

(Multiple Choice)

4.8/5

(38)

Question 7

Once you have configured a DataSet with the Data Source Configuration Wizard,what is the next step? Be sure to include the term data binding in your response.

(Essay)

4.7/5

(36)

Question 8

You create a connection to a database by specifying a(n)____________________ from the Windows application to the database source.

(Short Answer)

4.8/5

(31)

Question 9

Use the Next Record button on the navigation toolbar of an application to move through records in a database.

(True/False)

4.7/5

(36)

Question 10

A column in a database table is referred to as a ____.

(Multiple Choice)

4.8/5

(39)

Question 11

The process of defining a(n)____________________ to a database is the same for all types of databases.

(Short Answer)

4.8/5

(30)

Question 12

As shown in the accompanying figure,when you want to select which database objects you want in the DataSet,____ next to the Tables option.

(Multiple Choice)

4.8/5

(41)

Question 13

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A DataTable object contains this command that is used to fill the data table with data from the selected database table

(Multiple Choice)

4.9/5

(33)

Question 14

A(n)____ string contacts the data source and establishes a connection with the database using the Data Source Configuration Wizard.

(Multiple Choice)

4.9/5

(37)

Question 15

The first step in accessing database information is to establish a ____ with the database.

(Multiple Choice)

4.8/5

(41)

Question 16

You can run an application by tapping or clicking the ____ button on the Standard toolbar.

(Multiple Choice)

4.7/5

(38)

Question 17

LINQ makes it easy to query data using SQL commands within the Visual Basic code window._________________________

(True/False)

4.7/5

(32)

Question 18

If you are using ADO.NET 4.5 in Visual Basic 2012,you must create a coded connection for the Windows form.

(True/False)

4.8/5

(29)

Question 19

The OleDbDataAdapter consists solely of a path statement to connect to the database to fill the DataSet.

(True/False)

4.7/5

(44)

Question 20

Showing 1 - 20 of 112

The SQL statement: ____________________ * FROM ApprovedTravelRequests is a query statement that requests that the entire table named ApprovedTravelRequests is opened for use by the application.

A database can contain only one record.

The ToolStrip control used for navigating through database records is called the BindingToolStrip._________________________

Explain OleDbDataAdapter and what it consists of,and provide its general form.

In a database,a(n)____________________ is referred to as a record.

To fill a ComboBox object with data from a field in a database,the ComboBox object must be bound to that field.

A ____ is a field in a table that contains unique values in each record.

Once you have configured a DataSet with the Data Source Configuration Wizard,what is the next step? Be sure to include the term data binding in your response.

You create a connection to a database by specifying a(n)____________________ from the Windows application to the database source.

Use the Next Record button on the navigation toolbar of an application to move through records in a database.

A column in a database table is referred to as a ____.

The process of defining a(n)____________________ to a database is the same for all types of databases.

As shown in the accompanying figure,when you want to select which database objects you want in the DataSet,____ next to the Tables option.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A DataTable object contains this command that is used to fill the data table with data from the selected database table

A(n)____ string contacts the data source and establishes a connection with the database using the Data Source Configuration Wizard.

The first step in accessing database information is to establish a ____ with the database.

You can run an application by tapping or clicking the ____ button on the Standard toolbar.

LINQ makes it easy to query data using SQL commands within the Visual Basic code window._________________________

If you are using ADO.NET 4.5 in Visual Basic 2012,you must create a coded connection for the Windows form.

The OleDbDataAdapter consists solely of a path statement to connect to the database to fill the DataSet.

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