Exam 11: Introduction to Linq

LINQ enables you to write queries,similar to SQL,that retrieve information from a wide variety of data sources,but LINQ's syntax is built into Visual Basic.

In a LINQ query,the Where clause specifies .

The Order By clause sorts the query results in descending order by default.

LINQ to Objects works with objects that implement the __________ interface,which enables a program to iterate over a collection of data.

In a LINQ query,the From clause specifies a range variable and the data source to query.The range variable represents each item in the data source.

LINQ infers the type of a range variable based on the query's data source.

The range variable is implicitly defined in the _____ clause and used to produce results in the ______ clause

Most LINQ capabilities are defined as constructor methods for the IEnumerable interface.You can call these on any IEnumerable object.

A LINQ query returns an IEnumerable object.

LINQ's Order By clause can __________ objects in the result according to multiple properties specified in a comma-separated list.

If the condition in the Where clause evaluates to True,the element is selected (included in the query results).

With LINQ,the IDE provides full IntelliSense support for the anonymous types generated by the compiler.

String method __________determines whether a String starts with the String in the method's argument.

The __________ clause prevents duplicate values from appearing in the query results.

With LINQ any Integer expression can be used in a Where clause.

LINQ works with arrays because they implement the IEnumerable interface.

LINQ uses a technique called __________-a query executes only when you iterate over the results,not when the query is defined.This allows you to create a query once and execute it many times.

The Select clause can be used to transform the values in a query result.

String method __________ returns a String with uppercase letters.

A database management system (DBMS)provides mechanisms for storing,organizing,retrieving and modifying data contained in the database.