Deck 11: Introduction to Linq

Question 1

You can chain LINQ queries by having one query operate on the results of another.

Answer 1

True

Question 2

Which of the following returns the number of items in LINQ query result q?

A)q.Length
B)q.Size
C)q.getUpperBound
D)q.Count

Answer 2

q.Count

Question 3

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

Answer 3

True

Question 4

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

A)merge
B)total
C)sort
D)search

Question 5

In a LINQ query,the Where clause specifies .

A)the data source
B)where to put the data
C)the condition(s)for including the item
D)the data type

Question 6

Types that implement interface IComparable provide a CompareTo method that returns a negative,zero or positive value indicating whether one value is greater than,equal to or less than another value,respectively.

Question 7

LINQ works with arrays because they implement the IEnumerable interface.

Question 8

Selecting elements that satisfy a set of conditions is known as __________.

A)distilling
B)filtering
C)purifying
D)refining

Question 9

The For Each…Next statement is useful for iterating over IEnumerable objects.

Question 10

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

Question 11

The __________extension method returns the number of elements in an IEnumerable object.

A)Count
B)Size
C)Length
D)Total

Question 12

___________ is an international standard used with relational databases to perform queries and to manipulate data.

A)APL
B)RDB
C)LDL
D)SQL

Question 13

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

A)ICountable
B)IEnumerable
C)IRepeatable
D)ICompare

Question 14

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.

Question 15

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.

Question 16

The Visual Studio IDE provides IntelliSense support for LINQ queries.

Question 17

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

Question 18

A LINQ query returns an IEnumerable object.

Question 19

LINQ's Order By clause supports values of any type that implements the interface__________,such as the primitive numeric types and String.

A)ICompare
B)ICompareTo
C)IComparable
D)ISort

Question 20

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

A)Where,Put
B)From,Put
C)From,Select
D)Where,Select
E)In,For Each

Question 21

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

Question 22

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

Question 23

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.

A)late binding
B)dynamic binding
C)iteration delay
D)deferred execution

Question 24

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

Question 25

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

A)Unique
B)Exclusive
C)Different
D)Distinct

Question 26

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

Question 27

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

A)Front
B)StartsWith
C)First
D)Leading

Question 28

String method __________ returns a String with uppercase letters.

A)Upper
B)Uppercase
C)ConvertToUpper
D)ToUpper

Question 29

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