Question 1

The LINQ ____ operator returns a single value from a group of values.

Accepted Answer

A)  collect 
B)  collapse 
C)  integrate 
D)  aggregate 
A)  collect 
B)  collapse 
C)  integrate 
D)  aggregate D

Question 2

The basic syntax to use the LINQ to select and arrange records in a data set is ____.

Accepted Answer

A)  Dim variableName = In dataset.table From elementName 
B)  Dim variableName = From elementName In dataset.table 
C)  Dim In dataset.table From elementName = variableName 
D)  Dim From elementName In dataset.table = variableName 
A)  Dim variableName = In dataset.table From elementName 
B)  Dim variableName = From elementName In dataset.table 
C)  Dim In dataset.table From elementName = variableName 
D)  Dim From elementName In dataset.table = variableName B

Question 3

If you are sorting records in ascending order, you need to include the keyword Ascending in the Order By clause.

Accepted Answer

A) True 
 B)False  False

Question 4

The basic syntax for assigning a LINQ variable's contents to a BindingSource object is ____.

Accepted Answer

A)  DataSource.bindingSource = AsDataView.variableName 
B)  DataSource.bindingSource = variableName.AsDataView 
C)  bindingSource.DataSource = AsDataView.variableName 
D)  bindingSource.DataSource = variableName.AsDataView 
A)  DataSource.bindingSource = AsDataView.variableName 
B)  DataSource.bindingSource = variableName.AsDataView 
C)  bindingSource.DataSource = AsDataView.variableName 
D)  bindingSource.DataSource = variableName.AsDataView

Question 5

A dataset is stored in the computer's internal memory while the application is running.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)  Integrated Language Query 
B)  Language Query 
C)  Structured Language 
D)  Language Integrated Query 
A)  Integrated Language Query 
B)  Language Query 
C)  Structured Language 
D)  Language Integrated Query

Question 7

The syntax for LINQ requires you to specify the variable's data type.

Accepted Answer

A) True 
 B)False

Question 8

The ____ operator returns the smallest value in the group.

Accepted Answer

A)  Max 
B)  Smallest 
C)  Min 
D)  Minimum 
A)  Max 
B)  Smallest 
C)  Min 
D)  Minimum

Question 9

In addition to using LINQ to sort and select the records in a dataset, you also can use it to perform arithmetic calculations on the fields in the records.

Accepted Answer

A) True 
 B)False

Question 10

In a query, the ____ clause is used to limit the records you want to view.

Accepted Answer

A)  Select 
B)  From 
C)  Where 
D)  Order 
A)  Select 
B)  From 
C)  Where 
D)  Order

Question 11

A dataset is a copy of the fields and records the application can access from a database.

Accepted Answer

A) True 
 B)False

Question 12

You 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)  query 
B)  question 
C)  inquiry 
D)  access 
A)  query 
B)  question 
C)  inquiry 
D)  access

Question 13

The LINQ statement merely selects the records but does not assign them to the records variable.

Accepted Answer

A) True 
 B)False

Question 14

The following syntax selects all of the records in the dataset:
Dim records = From employee In EmployeesDataSet.tblEmploy
Select employee

Accepted Answer

A) True 
 B)False

Question 15

In a query, the Where and Order By clauses are optional parts of the syntax.

Accepted Answer

A) True 
 B)False

Question 16

Similar to the condition in If…Then…Else and Do…Loop statements, the ____ clause specifies a requirement that must be met for a record to be selected.

Accepted Answer

A)  Select 
B)  Where 
C)  From 
D)  Order By 
A)  Select 
B)  Where 
C)  From 
D)  Order By

Question 17

The only calculations that are performed using the LINQ aggregate methods are Average and Count.

Accepted Answer

A) True 
 B)False

Question 18

The Total operator returns the sum of the values in the group.

Accepted Answer

A) True 
 B)False

Question 19

In a query, the ____ clause is used to sort the records in either ascending (the default) or descending order by one or more fields.

Accepted Answer

A)  Order By 
B)  Select 
C)  From 
D)  Where 
A)  Order By 
B)  Select 
C)  From 
D)  Where

Exam 25: The Missing Linq Querying a Database

The LINQ ____ operator returns a single value from a group of values.

The basic syntax to use the LINQ to select and arrange records in a data set is ____.

If you are sorting records in ascending order, you need to include the keyword Ascending in the Order By clause.

The basic syntax for assigning a LINQ variable's contents to a BindingSource object is ____.

A dataset is stored in the computer's internal memory while the application is running.

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

The syntax for LINQ requires you to specify the variable's data type.

The ____ operator returns the smallest value in the group.

In addition to using LINQ to sort and select the records in a dataset, you also can use it to perform arithmetic calculations on the fields in the records.

In a query, the ____ clause is used to limit the records you want to view.

A dataset is a copy of the fields and records the application can access from a database.

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

The LINQ statement merely selects the records but does not assign them to the records variable.

The following syntax selects all of the records in the dataset: Dim records = From employee In EmployeesDataSet.tblEmploy Select employee

In a query, the Where and Order By clauses are optional parts of the syntax.

Similar to the condition in If…Then…Else and Do…Loop statements, the ____ clause specifies a requirement that must be met for a record to be selected.

The only calculations that are performed using the LINQ aggregate methods are Average and Count.

The Total operator returns the sum of the values in the group.

In a query, the ____ clause is used to sort the records in either ascending (the default) or descending order by one or more fields.

I Am Not a Control Freak Control Structures

First You Need to Plan the Party Problem-Solving Process

I Need a Tour Guide Introduction to Visual Basic 2010

Do It Yourself Designing Designing Interfaces

The Secret Code Assignment Statements

Where Can I Store This Variables and Constants

Whats Wrong With It Syntax and Logic Errors

Decisions, Decisions, Decisions Selection Structure

Time to Leave the Nest Nested Selection Structures

So Many Pathsso Little Time Multiple-Alternative Selection Structures

Testing, Testing1,2,3 Selecting Test Data

How Long Can This Go on Pretest Loops

Do It, Then Ask Permission Posttest Loops

Let Me Count the Ways Counter-Controlled Loops

Im on the Inside; Youre on the Outside Nested Loops

I Hear You Are Breaking up Sub Procedures

Talk to Me Function Procedures

A Ray of Sunshine One-Dimensional Arrays

Parallel and Dynamic Universes More on One-Dimensional Arrays

Table Tennis, Anyone Two-Dimensional Arrays

Building Your Own Structure Structures

Im Saving for the Future Sequential Access Files

The String Section String Manipulation

Im Suffering From Information Overload Access Databases

I Love This Class Creating a Class

Getting Web-Ified Web Applications

Filters