C# Chap 12-14
________ methods calculate a single value from a collection of values.
Aggregation
In SQL the ________ requires that both search criteria be TRUE in order for a row to be qualified as a match.
And operator
When specifying a data type for the columns in a database, the data types you can choose from are provided by the ________.
DBMS
When working with data-bound controls on multiple forms, you can make sure that a dataset contains a current copy of the data by calling the table adapter's ________ method.
Fill
LINQ stands for ________.
Language-Integrated Query
In SQL the ________ can be used to search for a substring.
Like operator
To use LINQ to query a database, you need to use a(n) ________.
Object Relational Mapping tool
If you wish to sort the results of a SQL Select query you can use the ________.
Order By clause
________ methods return true or false to indicate whether one or more elements in a collection match a condition
Quantifier
In SQL you use the ________ to retrieve rows in a table.
Select statement
________ methods perform a mathematical set operation on two collections of values.
Set
To create and use a delegate you must ________.
You must do all of these things.
When using LINQ to query a database, which of the following represents the database?
a data context object
To set up LINQ to SQL to work with a database, you must first ________.
add a connection to the database
When using LINQ to query a database, which of the following represents a row in a table?
an entity object
A ________ is a component that can connect user interface controls directly to a dataset.
binding source
Excel spreadsheets and databases are examples of ________ which contain data that the application can work with.
data sources
A ________ is a user interface control that is connected to a data source.
data-bound control
A DBMS stores data in a ________.
database
A(n) ________ is software specifically designed to store, retrieve, and manipulate large amounts of data in an organized and efficient manner.
database management system (DBMS)
A ________ gets a copy of a table from the table adapter and keeps the copy of the table in memory.
dataset
An object that works like a reference variable that refers to a method is known as a ________.
delegate
The type of method that returns a specific element from a collection is a(n) ________ method.
element
When you use query syntax, the C# compiler translates the queries into method calls that invoke ________ that are defined in the .NET Framework.
extension methods
A(n) ________ is a column that contains unique values generated by the DBMS, usually using a counter.
identity column
A method that has no name is ________.
known as an anonymous method
A shortcut technique for writing an anonymous method is known as a(n) ________.
lambda expression
You can use a delegate to reference a(n) ________.
method
Queries written in method syntax take the form of ________.
method calls
A delegate that references multiple methods is known as a(n) ________ delegate.
multicast
When using LINQ to query a database, which of the following represents a column in a table?
none of these
If a column contains no data, it is said to be ________.
null
To sort the results of a LINQ query, you can use the ________.
orderby clause
The type of method that divides a collection into two sections and returns one of the sections is a(n) ________ method.
partitioning
Most database tables have a(n) ________ which is a column that can be used to identify a specific row.
primary key
In SQL you use keywords to construct statements which are also known as ________.
queries
A ________ is a complete set of information about a single item in a table.
row
It is possible to write multiple statements in the body of a lambda expression so long as the ________.
statements are enclosed in curly braces
SQL, which stands for ________, is a standard language for working with database management systems.
structured query language
In a database, each ________ holds a collection of related data items.
table
A ________ connects to a data source and can retrieve and update data from a table in a data source.
table adapter
A(n) ________ is a SQL statement stored in a table adapter object which can be executed simply by calling a method.
table adapter query
Which of the following statements will sort the results of a LINQ query of the array shown below?int[] ages = { 12, 45, 16, 23, 57, 2, 19 };
var results = from item in ages orderby item select item;
Which of the statements below is comparable to the code shown here? This code searches for any item in an array of ints named ages that is between 10 and 20, inclusive.var results = from item in ages where item > 9 where item < 21 select item;
var results = from item in ages where item > 9 && item < 21 select item;
Given an array of integers named ages, which of the following will query this array to get all values less than 20 and store the result in teens?
var teens = from item in ages where item < 20 select item;
