Question 1

A(n)____ is an electronic file that contains an organized collection of related information.

Accepted Answer

A) field 
B) computer database 
C) dataset 
D) exception 
A) field 
B) computer database 
C) dataset 
D) exception

Question 2

The field used to link a child table to a parent table is known as the ____ in the child table.

Accepted Answer

A) record 
B) foreign key 
C) cell 
D) primary key 
A) record 
B) foreign key 
C) cell 
D) primary key

Question 3

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

Accepted Answer

A) TableAdapter 
B) TblEmployBindingSource 
C) BindingSource 
D) DataGridView 
A) TableAdapter 
B) TblEmployBindingSource 
C) BindingSource 
D) DataGridView

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}$$
-Which of the following statements will calculate a total for all of the unpaid invoices?

Accepted Answer

A) Dim decTotalUnpaid =Aggregate customer In CustomerDataSet.tblCustomerSelect customer.InvoicePaid Into Sum() 
B) Dim decTotalUnpaid =Aggregate customer In CustomerDataSet.tblCustomerSelect customer.InvoiceAmt Into Sum() 
C) Dim decTotalUnpaid =Aggregate customer In CustomerDataSet.tblCustomerWhere customer.InvoicePaid.ToUpper = "N"Select customer.InvoiceAmt Into Average() 
D) Dim decTotalUnpaid =Aggregate customer In CustomerDataSet.tblCustomerWhere customer.InvoicePaid.ToUpper = "N"Select customer.InvoiceAmt Into Sum() 
A) Dim decTotalUnpaid =Aggregate customer In CustomerDataSet.tblCustomerSelect customer.InvoicePaid Into Sum() 
B) Dim decTotalUnpaid =Aggregate customer In CustomerDataSet.tblCustomerSelect customer.InvoiceAmt Into Sum() 
C) Dim decTotalUnpaid =Aggregate customer In CustomerDataSet.tblCustomerWhere customer.InvoicePaid.ToUpper = "N"Select customer.InvoiceAmt Into Average() 
D) Dim decTotalUnpaid =Aggregate customer In CustomerDataSet.tblCustomerWhere customer.InvoicePaid.ToUpper = "N"Select customer.InvoiceAmt Into Sum()

Question 5

If you do not take deliberate steps in your code to handle exceptions,Visual Basic "handles" them for you.

Accepted Answer

A) True 
 B)False

Question 6

A ____ is a single item of information about a person,place,or thing-such as a name,a salary amount,a Social Security number,or a price.

Accepted Answer

A) table 
B) record 
C) dataset 
D) field 
A) table 
B) record 
C) dataset 
D) field

Question 7

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

Accepted Answer

A) cell 
B) table 
C) record 
D) key 
A) cell 
B) table 
C) record 
D) key

Question 8

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.

Accepted Answer

A) DataSet 
B) BindingNavigator 
C) TableAdapter 
D) BindingSource 
A) DataSet 
B) BindingNavigator 
C) TableAdapter 
D) BindingSource

Question 9

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

Accepted Answer

A) Order By 
B) condition 
C) query 
D) Where 
A) Order By 
B) condition 
C) query 
D) Where

Question 10

Before an application can access the data stored in a database,you need to connect the application to the database.

Accepted Answer

A) True 
 B)False

Question 11

Write the code needed to include a Try...Catch statement that will handle an error that might occur while saving in an application.Use the following statements in the Try block,along with a message for the user of the Student Data Application that notifies the user the changes have been saved.Provide an error message if an exception occurs.
Me.Validate()
Me.TblStudentBindingSource.EndEdit()
Me.TableAdapterManager.UpdateAll(Me.StudentsDataSet)

Accepted Answer

Try
Me.Validate()
Me.TblStudentBindingSo

Question 12

List the five objects that are placed in the component tray when a table object is bound to a DataGridView control.

Accepted Answer

1.DataSet
2.BindingS

Question 13

A(n)____ is a group of related fields that contain all of the necessary data about a specific person,place,or thing.

Accepted Answer

A) object 
B) dataset 
C) record 
D) exception 
A) object 
B) dataset 
C) record 
D) exception

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.

Accepted Answer

A) AutoSizeColumnsMode 
B) DefaultCellStyle 
C) BindingNavigator 
D) DataGridView 
A) AutoSizeColumnsMode 
B) DefaultCellStyle 
C) BindingNavigator 
D) DataGridView

Question 15

Relational databases contain multiple tables that relate to each other in some way.How are primary and foreign keys used in such a database?

Accepted Answer

Each table in a relational database shou

Question 16

What is the DataGridView control and how is it used?

Accepted Answer

The DataGridView control allows you to v

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}$$
-Which of the following statements will select all invoices of $200.00 or more and arrange the invoices in ascending order by Customer number?

Accepted Answer

A) Dim records =From customer In CustomerDataSet.tblCustomerWhere customer.InvoiceAmt > 200Order By invoice.CustomerNumSelect customer B) Dim records =From customer In CustomerDataSet.tblCustomerWhere customer.InvoiceAmt > 200Order invoice.CustomerNum AscendingSelect customer C) Dim records =From CustomerDataSet.tblCustomerWhere customer.InvoiceAmt > 200Order invoice.CustomerNumSelect customer D) Dim records =From customer In CustomerDataSet.tblCustomerWhere customer.InvoiceAmt < 200Order By invoice.CustomerNumSelect customer A) Dim records =From customer In CustomerDataSet.tblCustomerWhere customer.InvoiceAmt > 200Order By invoice.CustomerNumSelect customer B) Dim records =From customer In CustomerDataSet.tblCustomerWhere customer.InvoiceAmt > 200Order invoice.CustomerNum AscendingSelect customer C) Dim records =From CustomerDataSet.tblCustomerWhere customer.InvoiceAmt > 200Order invoice.CustomerNumSelect customer D) Dim records =From customer In CustomerDataSet.tblCustomerWhere customer.InvoiceAmt < 200Order By invoice.CustomerNumSelect customer

Question 18

When you drag an object from a dataset to an empty area on the form,the computer creates a control and automatically binds the object to it.

Accepted Answer

A) True 
 B)False

Question 19

Writing LINQ Statements
The tblBicycle table contains five fields: ItemNum, ItemName, Color, Price, and Quantity. The Price and Quantity fields are numeric; all other fields are text. The dataset name is BicycleDataSet.
-Write the code to calculate the average price of all of the bicycles in inventory.

Accepted Answer

Dim dblAverage As Double
Dim intTotalQua

Question 20

A database file contained in a project is referred to as a logic database file.

Accepted Answer

A) True 
 B)False

A(n)____ is an electronic file that contains an organized collection of related information.

The field used to link a child table to a parent table is known as the ____ in the child table.

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

If you do not take deliberate steps in your code to handle exceptions,Visual Basic "handles" them for you.

A ____ is a single item of information about a person,place,or thing-such as a name,a salary amount,a Social Security number,or a price.

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

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.

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

Before an application can access the data stored in a database,you need to connect the application to the database.

List the five objects that are placed in the component tray when a table object is bound to a DataGridView control.

A(n)____ is a group of related fields that contain all of the necessary data about a specific person,place,or thing.

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

Relational databases contain multiple tables that relate to each other in some way.How are primary and foreign keys used in such a database?

What is the DataGridView control and how is it used?

When you drag an object from a dataset to an empty area on the form,the computer creates a control and automatically binds the object to it.

A database file contained in a project is referred to as a logic database file.

An Introduction to Visual Basic 2015

Designing Applications

Using Variables and Constants

The Selection Structure

More on the Selection Structure

The Repetition Structure

Sub and Function Procedures

String Manipulation

Arrays

Structures and Sequential Access Files

Classes and Objects

Web Applications

Access Databases and SQL

Filters

Exam 13: Working With Access Databases and Linq

A(n)____ is an electronic file that contains an organized collection of related information.

The field used to link a child table to a parent table is known as the ____ in the child table.

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

If you do not take deliberate steps in your code to handle exceptions,Visual Basic "handles" them for you.

A ____ is a single item of information about a person,place,or thing-such as a name,a salary amount,a Social Security number,or a price.

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

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.

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

Before an application can access the data stored in a database,you need to connect the application to the database.

List the five objects that are placed in the component tray when a table object is bound to a DataGridView control.

A(n)____ is a group of related fields that contain all of the necessary data about a specific person,place,or thing.

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

Relational databases contain multiple tables that relate to each other in some way.How are primary and foreign keys used in such a database?

What is the DataGridView control and how is it used?

When you drag an object from a dataset to an empty area on the form,the computer creates a control and automatically binds the object to it.

A database file contained in a project is referred to as a logic database file.

An Introduction to Visual Basic 2015

Designing Applications

Using Variables and Constants

The Selection Structure

More on the Selection Structure

The Repetition Structure

Sub and Function Procedures

String Manipulation

Arrays

Structures and Sequential Access Files

Classes and Objects

Web Applications

Access Databases and SQL

Filters