Question 1

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

Accepted Answer

A)  Try...Catch 
B)  LINQ 
C)  Order By 
D)  aggregate 
A)  Try...Catch 
B)  LINQ 
C)  Order By 
D)  aggregate

Question 2

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 3

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 4

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 5

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 6

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

Accepted Answer

A)  logic error 
B)  runtime error 
C)  exception 
D)  message 
A)  logic error 
B)  runtime error 
C)  exception 
D)  message

Question 7

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

Accepted Answer

A)  condition 
B)  parameter 
C)  query 
D)  aggregate operator 
A)  condition 
B)  parameter 
C)  query 
D)  aggregate operator

Question 8

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 9

When you drag an object from the Data Sources window to an existing control,the computer does not create a new control;rather,it merely binds the object to the existing control.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)  Position 
B)  View 
C)  Move 
D)  Navigation 
A)  Position 
B)  View 
C)  Move 
D)  Navigation

Question 11

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 12

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?

Accepted Answer

The answer of The tblItems table contains a numeric field...

Question 13

Write a LINQ statement to select all records.

Accepted Answer

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

Question 14

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

Accepted Answer

A)  AddNewItem 
B)  Properties 
C)  Insert Standard Items 
D)  Edit Items 
A)  AddNewItem 
B)  Properties 
C)  Insert Standard Items 
D)  Edit Items

Question 15

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 16

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 17

Connecting an object to a control is called ____.

Accepted Answer

A)  linking 
B)  Order By clause 
C)  LINQ 
D)  binding 
A)  linking 
B)  Order By clause 
C)  LINQ 
D)  binding

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

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

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

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

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

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

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

When you drag an object from the Data Sources window to an existing control,the computer does not create a new control;rather,it merely binds the object to the existing control.

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

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.

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?

Write a LINQ statement to select all records.

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

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

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

Connecting an object to a control is called ____.

An Introduction to Visual Basic 2012

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

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

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

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

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

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

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

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

When you drag an object from the Data Sources window to an existing control,the computer does not create a new control;rather,it merely binds the object to the existing control.

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

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.

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?

Write a LINQ statement to select all records.

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

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

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

Connecting an object to a control is called ____.

An Introduction to Visual Basic 2012

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