Question 1

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

The answer of Which of the following statements will select...

Question 2

Write the statements to move the record pointer to the first and last records in the dataset for the Customer table.

Accepted Answer

The answer of Write the statements to move the record...

Question 3

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.

Accepted Answer

The answer of Write the code needed to include a...

Question 4

Write a LINQ statement to select all records.

Accepted Answer

The answer of Write a LINQ statement to select all...

Question 5

Write a LINQ statement to select the records in descending order by the Quantity field.

Accepted Answer

The answer of Write a LINQ statement to select the...

Question 6

Write a LINQ statement to select all bicycles with a price greater than $450.Arrange the bicycles in descending order by price.

Accepted Answer

The answer of Write a LINQ statement to select all...

Question 7

Write a LINQ statement to select all blue bicycles.Order the bicycles in ascending order by quantity.

Accepted Answer

The answer of Write a LINQ statement to select all...

Question 8

What are the advantages to storing data in a relational database?

Accepted Answer

The answer of What are the advantages to storing data...

Question 9

Write the statement needed to assign the contents of the records variable to the BindingSource object for the tblBicycle table.Explain why this should be done in an application.

Accepted Answer

The answer of Write the statement needed to assign the...

Question 10

Which of the following statements will calculate a total for all of the unpaid invoices?

Accepted Answer

The answer of Which of the following statements will calculate...

Question 11

What is the DataGridView control and how is it used?

Accepted Answer

The answer of What is the DataGridView control and how...

Question 12

Define the terms "record," "field," and "table." Provide examples of each term when you are defining them.

Accepted Answer

The answer of Define the terms "record," "field," and "table."...

Question 13

Write the statements to move the record pointer to the previous and next records in the dataset for the Vehicle table.

Accepted Answer

The answer of Write the statements to move the record...

Question 14

Write a LINQ statement to calculate the total value of the inventory.

Accepted Answer

The answer of Write a LINQ statement to calculate the...

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

The answer of Relational databases contain multiple tables that relate...

Question 16

You need to make sure the user of the application can add records but cannot delete any records.Which of the following needs to be performed?
A) Remove the Add new button from the TblCustomerBindingNavigator control.
B) Remove the Delete button from the TblCustomerBindingNavigator control.
C) Remove the Save button from the TblCustomerBindingNavigator control.
D) b and c

Accepted Answer

Removing the Delete button from the TblCustomerBindingNavigator control will prevent the user from being able to delete records, while still allowing them to add new records and save changes. Removing the Add new button or Save button would not address the issue of preventing record deletion.

Question 17

Write the code to calculate the average price of all of the bicycles in inventory.

Accepted Answer

The answer of Write the code to calculate the average...

Quiz 13: Working With Access Databases and Linq

Which of the following statements will select all invoices of $200.00 or more and arrange the invoices in ascending order by Customer number?

Write the statements to move the record pointer to the first and last records in the dataset for the Customer table.

Write a LINQ statement to select all records.

Write a LINQ statement to select the records in descending order by the Quantity field.

Write a LINQ statement to select all bicycles with a price greater than $450.Arrange the bicycles in descending order by price.

Write a LINQ statement to select all blue bicycles.Order the bicycles in ascending order by quantity.

What are the advantages to storing data in a relational database?

Write the statement needed to assign the contents of the records variable to the BindingSource object for the tblBicycle table.Explain why this should be done in an application.

Which of the following statements will calculate a total for all of the unpaid invoices?

What is the DataGridView control and how is it used?

Define the terms "record," "field," and "table." Provide examples of each term when you are defining them.

Write the statements to move the record pointer to the previous and next records in the dataset for the Vehicle table.

Write a LINQ statement to calculate the total value of the inventory.

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

You need to make sure the user of the application can add records but cannot delete any records.Which of the following needs to be performed?

Write the code to calculate the average price of all of the bicycles in inventory.