Question 1

The ____ clause of LINQ is used to arrange the records in either ascending (the default)or descending order by one or more fields.
A)Order By
B)condition
C)query
D)Where

Accepted Answer

The Order By clause is specifically used for arranging the query results in ascending or descending order by one or more fields.

Question 2

The ____ object provides the connection between the DataSet and the bound controls on the form.
A)TableAdapter
B)DataGridView
C)BindingSource
D)BindingNavigator

Accepted Answer

BindingSource object provides the connection between the DataSet and the bound controls on the form, allowing for two-way data binding functionality. The TableAdapter object is used to retrieve data from the database into the DataSet, while the DataGridView object is a control that displays data in a tabular format. The BindingNavigator object is a control used to navigate through data in a bound control. Therefore, the best choice is the BindingSource object.

Question 3

The BindingSource object stores the position of the record pointer in its ____ property.
A)View
B)Position
C)Navigation
D)Cell

Accepted Answer

The Position property of the BindingSource object stores the position of the record pointer, indicating which record is currently being displayed or edited. The View property specifies the view currently displayed by a control bound to the BindingSource, while Navigation and Cell properties are not applicable in this context.

Question 4

Case 1 - MaidToOrder
The database for a cleaning service company contains the following table, named tblCustomer, that includes customer invoice data. The InvoiceNum, CustomerNum, and InvoicePaid fields contain text. The InvoiceDate field contains dates. The InvoiceAmt field contains numbers.
 $$\begin{array} { | l | l | l | l | l | } 
\hline \text { InvoiceNum } & \text { CustomerNum } & \text { InvoiceDate } & \text { InvoiceAmt } & \text { InvoicePaid } \
\hline 631 & 13020 & 01 / 15 / 2013 & 200.00 & \mathrm { Y } \
\hline 632 & 15411 & 01 / 20 / 2013 & 685.00 & \mathrm { Y } \
\hline 633 & 10002 & 01 / 23 / 2013 & 75.00 & \mathrm {~N} \
\hline 634 & 13104 & 01 / 23 / 2013 & 150.00 & \mathrm {~N} \
\hline 635 & 12124 & 01 / 26 / 2013 & 75.00 & \mathrm { Y } \
\hline 636 & 13328 & 02 / 02 / 2013 & 350.00 & \mathrm { Y } \
\hline 637 & 10206 & 02 / 02 / 2013 & 175.00 & \mathrm {~N} \
\hline 638 & 10334 & 02 / 07 / 2013 & 450.00 & \mathrm { Y } \
\hline
\end{array}$$
-To create a DataGridView control on the form,you would click on the ____ object in the Data Sources window and drag it to the form.
A)CustomerNum
B)InvoiceNum
C)CustomerDataSet
D)tblCustomer

Accepted Answer

The best choice would be to select the tblCustomer table from the Data Sources window, as this is the table containing the relevant invoice data needed to create the DataGridView control on the form. Selecting the CustomerNum or InvoiceNum fields would not provide all the necessary information needed for the DataGridView control, and selecting the CustomerDataSet may not be necessary as the tblCustomer table can be accessed directly.

Question 5

You can create a query in Visual Basic 2015 using a language feature called ____.
A)ASP
B)SQL
C)Java
D)Language-Integrated Query

Accepted Answer

Language-Integrated Query (LINQ) is a language feature in Visual Basic 2015 that allows developers to write queries against various data sources (such as databases, XML documents, and collections) using a common syntax. LINQ provides a strongly typed, compile-time checked way of interacting with data sources, and is much easier to use than traditional SQL queries. Therefore, LINQ is the best choice for creating queries in Visual Basic 2015.

Question 6

The ____ object can be used to save to the database any changes made to the data contained in the DataSet.
A)TableAdapter
B)TblEmployBindingSource
C)BindingSource
D)DataGridView

Accepted Answer

The TableAdapter object contains the necessary methods to interact with the database, including saving changes made in a DataSet. The TblEmployBindingSource and BindingSource objects are used for binding data to controls, and the DataGridView is a control used for displaying data.

Question 7

A label,text box,or button can be added to the BindingNavigator control by accessing the control's task box and clicking ____.
A)AddNewItem
B)Properties
C)Insert Standard Items
D)Edit Items

Accepted Answer

To add a label, text box, or button to the BindingNavigator control, you need to access the control's task box and click "Edit Items" to modify the items in the control.

Question 8

An error that occurs while an application is running is called a(n)____.
A)logic error
B)runtime error
C)exception
D)message

Accepted Answer

The answer of An error that occurs while an application...

Question 9

The BindingSource object's ____ methods move the record pointer to the first,last,next,or previous record in the dataset.
A)Position
B)View
C)Move
D)Navigation

Accepted Answer

The Move methods of the BindingSource class include MoveFirst(), MoveLast(), MoveNext(), and MovePrevious(). These methods allow the record pointer to be moved to the first, last, next, or previous record in the dataset.

Question 10

The tblItems table contains a numeric field named Price.Which of the following statements finds the lowest price for an item and assigns the result to the dblLowPrice variable?
A)Dim dblLowPrice As Double =Min item In Items.DataSet.tblItemsSelect item.Price
B)Dim dblLowPrice As Double =Aggregate item In Items.DataSet.tblItemsSelect item.Price Into Min()
C)Dim dblLowPrice As Double =Select Min item In Items.DataSet.tblItems
D)Dim dblLowPrice As Double =Select Aggregate item In Items.DataSet.tblItemsInto Min()

Accepted Answer

Option B uses the Aggregate function with the Min function to find the lowest price in the tblItems table and assign it to the dblLowPrice variable. Option A is not a valid syntax for finding the minimum value. Option C and D contain syntax errors.

Question 11

The intersection of a row and a column in a DataGridView control is called a ____.
A)cell
B)table
C)record
D)key

Accepted Answer

The intersection of a row and a column in a DataGridView control is called a cell. This is a common term used in database management and spreadsheet programs.

Question 12

The way Visual Basic saves changes to a local database file is determined by the file's ____ property.
A)BindingNavigator
B)Position
C)BindingSource
D)Copy to Output Directory

Accepted Answer

The "Copy to Output Directory" property determines how the local database file is copied when the project is built. It does not affect how changes are saved to the file during runtime. The other options (BindingNavigator, Position, BindingSource) are not relevant to the question of how changes are saved to the database file.

Question 13

The ____ object is responsible for retrieving the appropriate information from the database and storing it in the DataSet.
A)TableAdapter
B)TblEmployBindingSource
C)BindingSource
D)DataGridView

Accepted Answer

Based on the provided options, the TableAdapter is the only object that is responsible for retrieving and storing data from the database into the DataSet. The TblEmployBindingSource and BindingSource objects are used for data binding between the database and a UI control, and the DataGridView is a UI control used for displaying data.

Question 14

The ____ property (of the DataGridView)allows you to format a column's data,as well as change the column's width and alignment.
A)AutoSizeColumnsMode
B)DefaultCellStyle
C)BindingNavigator
D)DataGridView

Accepted Answer

The DefaultCellStyle property allows you to format a column's data and change its alignment, while AutoSizeColumnsMode only adjusts the width of the column to fit its content and BindingNavigator is a control used for navigating through data. Therefore, option B is the best choice for the given scenario.

Question 15

You can use a(n)____ to specify both the records to select in a dataset and the order in which to arrange the records.
A)condition
B)parameter
C)query
D)aggregate operator

Accepted Answer

A query can be used to specify both the records to select in a dataset through the use of conditions and to arrange the records in a specific order through the use of sorting. Parameters are inputs that can be passed into a query to customize its behavior, and aggregate operators are used to perform calculations on groups of records. Therefore, neither parameters nor aggregate operators are the best choice for this particular function.

Question 16

If a user is not allowed to add a record,you should deselect the ____ check box within the task list for the DataGridView control.
A)Enable Adding
B)Enable Deleting
C)Edit Items
D)BindingNavigatorAddNewItem

Accepted Answer

The "Enable Adding" check box within the task list for the DataGridView control determines whether the user can add new records. Deselecting this check box will disable the ability for the user to add new records. The other options listed are not relevant to this specific scenario.

Question 17

Case 1 - MaidToOrder
The database for a cleaning service company contains the following table, named tblCustomer, that includes customer invoice data. The InvoiceNum, CustomerNum, and InvoicePaid fields contain text. The InvoiceDate field contains dates. The InvoiceAmt field contains numbers.
 $$\begin{array} { | l | l | l | l | l | } 
\hline \text { InvoiceNum } & \text { CustomerNum } & \text { InvoiceDate } & \text { InvoiceAmt } & \text { InvoicePaid } \
\hline 631 & 13020 & 01 / 15 / 2013 & 200.00 & \mathrm { Y } \
\hline 632 & 15411 & 01 / 20 / 2013 & 685.00 & \mathrm { Y } \
\hline 633 & 10002 & 01 / 23 / 2013 & 75.00 & \mathrm {~N} \
\hline 634 & 13104 & 01 / 23 / 2013 & 150.00 & \mathrm {~N} \
\hline 635 & 12124 & 01 / 26 / 2013 & 75.00 & \mathrm { Y } \
\hline 636 & 13328 & 02 / 02 / 2013 & 350.00 & \mathrm { Y } \
\hline 637 & 10206 & 02 / 02 / 2013 & 175.00 & \mathrm {~N} \
\hline 638 & 10334 & 02 / 07 / 2013 & 450.00 & \mathrm { Y } \
\hline
\end{array}$$
-You are responsible for connecting the Access database that contains the tblCustomer table to an application.You must first use the Data Source Configuration Wizard to ____.
A)test to see if the database is connected to the application
B)add a new data source
C)preview the contents of the dataset
D)bind the controls to the dataset

Accepted Answer

The prompt states that the task is to connect the Access database to an application. In this case, the first step would be to add a new data source using the Data Source Configuration Wizard. This will allow the application to access the data in the tblCustomer table. The other options listed (A, C, and D) are not the appropriate first step in this process.

Question 18

The ____ statement is used for exception handling in a procedure.
A)Try...Catch
B)LINQ
C)Order By
D)aggregate

Accepted Answer

The Try...Catch statement is used for exception handling in a procedure by allowing the code to try executing a block of code and catch any exceptions that are thrown during execution. This helps to ensure that the program continues to run without crashing or causing errors for the user.

Question 19

When an application is running,you can use the ____ control to move from one record to the next in the dataset,as well as to add or delete a record and save any changes made to the dataset.
A)DataSet
B)BindingNavigator
C)TableAdapter
D)BindingSource

Accepted Answer

The BindingNavigator control provides navigation and editing functionality for data-bound controls. It allows you to move between records, add or delete records, and save changes to the underlying data source. The DataSet, TableAdapter, and BindingSource are all used in data binding scenarios but do not provide the same navigation and editing functionality as the BindingNavigator control.

Question 20

Which of the following statements selects all of the records in the tblStudents table?
A)Dim records =Select student In tblStudents
B)Dim records =Select student From StudentsDataSet.tblStudents
C)Dim records =From student In StudentsDataSet.tblStudentsSelect student
D)Dim records =Select student In StudentsDataSet.tblStudentsFrom student

Accepted Answer

Option C uses LINQ syntax to select all records from the tblStudents table. It starts with "From student In StudentsDataSet.tblStudents" to specify the data source, and ends with "Select student" to select all fields/records. The other options have syntax errors or incorrect use of LINQ.

Quiz 13: Working With Access Databases and Linq

The ____ clause of LINQ is used to arrange the records in either ascending (the default) or descending order by one or more fields.

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

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

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

The ____ object can be used to save to the database any changes made to the data contained in the DataSet.

A label,text box,or button can be added to the BindingNavigator control by accessing the control's task box and clicking ____.

An error that occurs while an application is running is called a(n) ____.

The BindingSource object's ____ methods move the record pointer to the first,last,next,or previous record in the dataset.

The tblItems table contains a numeric field named Price.Which of the following statements finds the lowest price for an item and assigns the result to the dblLowPrice variable?

The intersection of a row and a column in a DataGridView control is called a ____.

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

The ____ object is responsible for retrieving the appropriate information from the database and storing it in the DataSet.

The ____ property (of the DataGridView) allows you to format a column's data,as well as change the column's width and alignment.

You can use a(n) ____ to specify both the records to select in a dataset and the order in which to arrange the records.

If a user is not allowed to add a record,you should deselect the ____ check box within the task list for the DataGridView control.

The ____ statement is used for exception handling in a procedure.

When an application is running,you can use the ____ control to move from one record to the next in the dataset,as well as to add or delete a record and save any changes made to the dataset.

Which of the following statements selects all of the records in the tblStudents table?