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?