Question 1

The AutoSizeColumnsMode property has ____ different settings that control the way the column widths are sized in the DataGridView control.

Accepted Answer

The AutoSizeColumnsMode property has seven different settings, namely None, AllCells, AllCellsExceptHeader, ColumnHeader, DisplayedCells, DisplayedCellsExceptHeader, and Fill.

Question 2

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
-An intersection of a row and column in a DataGridView.

Accepted Answer

The answer of Match each item with a statement below.
a.LINQ
f.primary...

Question 3

Exception handling in your code takes the form of the ____ statement.

Accepted Answer

Exception handling in code is typically implemented in a Try...Catch block. The code between the try and catch statements is executed normally, but if an exception is thrown during this execution, the catch block is executed to handle the exception. Thus, Try...Catch is the most appropriate choice for the given question.

Question 4

In a two-table database, one of the tables is referred to as the parent table and the other is referred to as the ____________________ table.

Accepted Answer

The answer of In a two-table database, one of the...

Question 5

The ____ object provides the connection between the DataSet and the bound controls on the form.

Accepted Answer

The BindingSource object is used to provide the connection between the DataSet and the bound controls on the form. It allows for navigation and editing of the data in the DataSet through the bound controls. The other choices are not directly involved in binding data to controls in this way.

Question 6

The _________________________ Wizard lists a connection to the database file in the Server Explorer window and adds a dataset's name to the Data Sources window.

Accepted Answer

The answer of The _________________________ Wizard lists a connection to...

Question 7

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
-An electronic file that contains an organized collection of related information.

Accepted Answer

The answer of Match each item with a statement below.
a.LINQ
f.primary...

Question 8

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
-A database that stores information in tables composed of columns and rows.

Accepted Answer

The answer of Match each item with a statement below.
a.LINQ
f.primary...

Question 9

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
-A field in the child table that is used solely to link information to an appropriate record in the parent table.

Accepted Answer

The answer of Match each item with a statement below.
a.LINQ
f.primary...

Question 10

If a table object's control type is changed from DataGridView to ____________________, the computer automatically provides the appropriate controls when you drag the table object to the form.

Accepted Answer

The answer of If a table object's control type is...

Question 11

You can create a query in Visual Basic 2012 using a language feature called ____.

Accepted Answer

Visual Basic 2012 supports the Language Integrated Query (LINQ) feature, which allows developers to easily create queries against various data sources, including databases, XML documents, and in-memory data structures. LINQ provides a consistent syntax for querying data, and it integrates seamlessly with the rest of the Visual Basic language. Therefore, the best choice for creating queries in Visual Basic 2012 is D) Language Integrated Query.

Question 12

The way Visual Basic saves changes to a local database file is determined by the file's _________________________ property.

Accepted Answer

The answer of The way Visual Basic saves changes to...

Question 13

A ____ specifies the fields and records to retrieve from the database, as well as the order in which to arrange the fields and records.

Accepted Answer

A query is a specific request for information from a database. It specifies the fields and records to retrieve, as well as any criteria for filtering the data and the order in which to sort the results. A dataset is a collection of related data stored in a database, but it is not the same as a query. A database builder is a tool for creating and managing databases, while a component tray is a feature of software development environments.

Question 14

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
-A product for creating computer databases.

Accepted Answer

The answer of Match each item with a statement below.
a.LINQ
f.primary...

Question 15

The BindingSource object stores the position of the record pointer in its ____________________ property.

Accepted Answer

The answer of The BindingSource object stores the position of...

Question 16

A(n) ____ operator returns a single value from a group of values.

Accepted Answer

An aggregate operator performs a calculation on a set of values and returns a single value, such as sum, average, minimum, maximum, or count. Group and convert operators do not necessarily return a single value, and single operator applies a condition and returns a single element if it exists.

Question 17

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
-A language feature in Visual Basic 2012 that can be used to create a query.

Accepted Answer

The answer of Match each item with a statement below.
a.LINQ
f.primary...

Question 18

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
-A copy of the data (fields and records) the application can access from the database.

Accepted Answer

The answer of Match each item with a statement below.
a.LINQ
f.primary...

Question 19

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
-Database field(s) that uniquely identifies each record.

Accepted Answer

The answer of Match each item with a statement below.
a.LINQ
f.primary...

Question 20

Match each item with a statement below.
a.LINQ
f.primary key
b.relational database
g.exception
c.dataset
h.cell
d.computer database
i.foreign key
e.database management system
-An error that occurs while an application is running.

Accepted Answer

The answer of Match each item with a statement below.
a.LINQ
f.primary...

Quiz 12: Access Databases and Linq

The AutoSizeColumnsMode property has ____ different settings that control the way the column widths are sized in the DataGridView control.

Match each item with a statement below. a.LINQ f.primary key b.relational database g.exception c.dataset h.cell d.computer database i.foreign key e.database management system -An intersection of a row and column in a DataGridView.

Exception handling in your code takes the form of the ____ statement.

In a two-table database, one of the tables is referred to as the parent table and the other is referred to as the ____________________ table.

The ____ object provides the connection between the DataSet and the bound controls on the form.

The _________________________ Wizard lists a connection to the database file in the Server Explorer window and adds a dataset's name to the Data Sources window.

Match each item with a statement below. a.LINQ f.primary key b.relational database g.exception c.dataset h.cell d.computer database i.foreign key e.database management system -An electronic file that contains an organized collection of related information.

Match each item with a statement below. a.LINQ f.primary key b.relational database g.exception c.dataset h.cell d.computer database i.foreign key e.database management system -A database that stores information in tables composed of columns and rows.

Match each item with a statement below. a.LINQ f.primary key b.relational database g.exception c.dataset h.cell d.computer database i.foreign key e.database management system -A field in the child table that is used solely to link information to an appropriate record in the parent table.

If a table object's control type is changed from DataGridView to ____________________, the computer automatically provides the appropriate controls when you drag the table object to the form.

You can create a query in Visual Basic 2012 using a language feature called ____.

The way Visual Basic saves changes to a local database file is determined by the file's _________________________ property.

A ____ specifies the fields and records to retrieve from the database, as well as the order in which to arrange the fields and records.

Match each item with a statement below. a.LINQ f.primary key b.relational database g.exception c.dataset h.cell d.computer database i.foreign key e.database management system -A product for creating computer databases.

The BindingSource object stores the position of the record pointer in its ____________________ property.

A(n) ____ operator returns a single value from a group of values.

Match each item with a statement below. a.LINQ f.primary key b.relational database g.exception c.dataset h.cell d.computer database i.foreign key e.database management system -A language feature in Visual Basic 2012 that can be used to create a query.

Match each item with a statement below. a.LINQ f.primary key b.relational database g.exception c.dataset h.cell d.computer database i.foreign key e.database management system -A copy of the data (fields and records) the application can access from the database.

Match each item with a statement below. a.LINQ f.primary key b.relational database g.exception c.dataset h.cell d.computer database i.foreign key e.database management system -Database field(s) that uniquely identifies each record.

Match each item with a statement below. a.LINQ f.primary key b.relational database g.exception c.dataset h.cell d.computer database i.foreign key e.database management system -An error that occurs while an application is running.