IT 505 QS

projection

A LINQ query that returns selected fields from the elements of a data source is also called a/n

modify selected data

A Select statement can do all but which of the following?

two or more users retrieve and then try to update data in the same row of a table at the same time

Concurrency occurs when

ADO.NET

DBConcurrencyException, ConstraintException and NoNullAllowedException are all examples of __________ exceptions.

date and time values are stored in special formats

Date and Time manipulation functions are particularly important because

you can change the string in just the configuration file if the connection changes

If you save the connection string in the application's configuration file,

BindingNavigator

One example of a ToolStrip control is the

the foreign key values in a foreign key table must have matching primary key values in the related table

Referential integrity insures that

a. IQueryable(Of T) Correct Answer b. IEnumerable(Of T) c. either a or b d. neither a nor b

To use LINQ with a data source, that data source must implement one of the following interfaces:

inner

Using the WHERE clause to specify which rows should be returned from two tables is the same as doing a/n __________ join.

primary key

What does a relational database use to uniquely identify each row in a table?

Connection and CommandText

What two properties of a command object do you always need to set before you call one of the methods of the command?

command

What type of object does ADO.NET use to store a SQL statement?

Direction

When a command uses a stored procedure, you must set all but one of the command properties that follow. Which one is it?

DataAdapter object

When you drag a data source onto a form, it adds a DataGridView control to the form and it adds all but one of the objects that follow to the Component Designer tray. Which object is it (i.e. which object is not added)?

the number of rows that were affected

When you execute a command that inserts, updates, or deletes the rows in a dataset, the method that you use returns a value that represents

update the related Insert, Update, and Delete statements

When you modify a Fill query so it gets data from two or more tables, you may not want Visual Studio to automatically

dataset

When you use a data adapter to retrieve data from a database, you store the data in an object called a

you can add controls for the query to a new or existing toolbar

When you use the Dataset Designer to create a new query,

can return a table, a single value, or no value

When you use the Dataset Designer to create a new stored procedure, the stored procedure

Customer

Which of the follow is not one of the example classes defined/described in Chapter 9?

From

Which of the following clauses would you use to identify the data source for a query?

Serialize

Which of the following is not a command associated with a transaction?

ExecuteActionQuery

Which of the following is not a method of a command object?

.UpdateAll

Which of the following is not a method of the BindingSource class?

Not Correct 1.to name a new calculated column 2.to rename a column whose name contains illegal characters 3.to rename a column whose name is ambiguous or easily misread Correct Answer all of the above are valid reasons

Which of the following is not a reason for using an alias?

repeated insert

Which of the following is not a type of concurrency problem?

attribute

Which of the following is not a type of report supported by Visual Studio?

it eliminates the need for concurrency control

Which of the following is not among the advantages of ADO.NET's disconnected architecture?

command type

Which of the following is not set in a connection string?

is executed automatically

A trigger is a special form of stored procedure that

virtual table

A view, which is a predefined query stored in the database, results (when referred to) in the creation of a

change the values in rows that contain nulls

Aggregate functions can be used to do all of the following except

DiffGram

An XML document that contains both the current and original version of the rows in a dataset is known as a/n

the generated SQL statements

Because Visual Studio uses a disconnected architecture when using data sources, optimistic concurrency is implemented by

the data context for the model

Before you can use LINQ to SQL to query an object model, you must create an instance of

SET

Changing the data in a row involves using both the UPDATE and __________ clauses.

NULL

Checking for whether a column contains no value involves using IS

expression

Code that's used in a report to change the contents of a cell is called a/n

string s = employeeReader[0].ToString;

Given a valid SqlDataReader object named employeeReader, which of the following statements retrieves the first column of the current row and stores it in a string variable named s?

determine the case of a text value

Grouping allows you to

a. pages b. the report c. neither a nor b Correct! d. both a and b

Headers and footers can be created for

by a named variable that begins with an at sign (@)

How is a parameter in a parameterized query for a SQL Server data adapter identified?

anonymous type

If a query returns more than one field, the query variable is defined as a/n

a unique number is generated for that column whenever a row is added to the table

If you define a column as an identity column,

@

In SQL Server a parameter is indicated by

foreign key

In a one-to-many relationship, the "many" table uses a/n _________ to relate back to the "one" table.

business rules

In a three-layer architecture, the middle layer contains the

business rules layer

In a three-layer architecture, the middle layer is also referred to as the

VALUES

Inserting a new row into a table involves using both the INSERT and __________ clauses.

comment

The <!-- notation is used to begin a/n

.NET data provider

The ADO.NET classes for working with a specific type of database are contained in the appropriate

cancel an update

The BindingNavigator control (toolbar) that's added to a form along with a DataGridView control can be used to do all of the following except

specify the inclusion of unique values only

The DISTINCT argument is used to

.Fill

The __________ method of the TableAdapter is used to load data into the DataSet.

a. they can appear in any order b. they don't require end tags c. neither a nor b Correct! d. both a and b

The advantage of using attributes over child elements is

locking

The basic way SQLServer deals with concurrency issues is through

table in the dataset

The binding source synchronizes the data between the bound controls and the

ASC

The default sort order when using ORDER BY is:

isolation level

The degree to which transactions interact with each other can be controlled by the

WHERE filters before grouping and HAVING filters after grouping

The difference between WHERE and HAVING is that

presentation

The form and bound controls in a three-layer architecture are part of the __________ layer.

Extensible Stylesheet Language (XSL)

The language used to control the display format of XML data is

their implementation differs greatly across DBMS systems

The main problem with SQL data manipulation functions is that

ConnectionString

The most important property of a connection object is:

simple data binding

The process of tying a text box to a field/column value is known as

extension

The query operators provided by LINQ are implemented as __________ methods.

a. Document Type Definition (DTD) b. XML Schema Definition (XSD) c. neither a nor b Correct! d. both a and b

The schema language supported by the XML standard is

Let

To avoid performing the same calculation multiple times, one can use the __________ clause.

BETWEEN

To check for a specific range of values you should use

position

To improve the efficiency of column lookups when using a data reader, you can retrieve each column's data by referring to the column by its __________ instead of by its name.

outer

To include rows that have no related rows (in the other table) one would use a/n __________ join.

provide a public method in one of the database classes that returns the connection object

To make it easy to change the connection for all of the database classes in an application when you use object data sources, it's best to

save

To rollback just part of a transaction, you can use __________ points

True: You have to write the code for populating the business objects. You can get the benefits of data binding. You have to write the code for inserting, updating, and deleting the records in a database. Not true: You have to write the code for populating the controls on a form with the database data.

Which of the following is not true about the use of object data sources?

they may not involve parameters

Which of the following is not true of stored procedures?

.CancelData

Which of the following items is not a property of a data bound combo box?

the date and time that the parameter is set

Which of the following properties can't be set for a SqlParameter object?

It can be used to update the data in a database.

Which of the following statements is not true about a data reader?

It manages the flow of data to and from the database.

Which of the following statements is not true about the LINQ to SQL runtime?

The command that creates the data reader also opens the connection

Which of the following statements is not true about the use of a data reader?

It can only get data from a single table.

Which of the following statements is not true for a stored procedure?

LIKE

Wildcard filtering typically involves the use of the ________ operator.

Extensible Markup Language

XML stands for

IN

You can specify a comma-delimited list of valid values in a WHERE clause using

update the data in a table in the database

You can use the Dataset Designer to start all but one of the following operations. Which one is it?