1. The core classes available with each data provider include all of the followi
ID: 3674802 • Letter: 1
Question
1. The core classes available with each data provider include all of the following except:
a. Connection
b. DataAdapter
c. Command
d. DataSet
e. DataReader
2. Each data provider class is a grouped and accessible through its:
a. namespace
b. database
c. datagrid
d. provider
e. system
3. Which of the following is a valid SQL statement that retrieves all four columns from the customer table?
a. SELECT ALL FROM customer
b. SELECT * FROM customer
c. SELECT customer
d. SELECT...FROM customer
e. SELECT @@@@FROM customer
4. Parameters for SQL Server SQL statements are written slightly different from those written for an Access database. With SQL Server, a parameter is indicated using:
a. @ followed by an identifier
b. @ without an identifier
c. ? followed by an identifier
d. @ without an identifier
e. a params keyword
5. The SQL clause that can be added to a SELECT statement to retrieve data from multiple tables is:
a. BETWEEN
b. INNER JOIN
c. CROSS CONNECTION
d. WHERE
e. UPDATE
6. The following namespaces (System.Data.OleDB, System.Data.SqlClient, System.Data.Odbc, System.Data.OracleClient) include classes for different:
a. data providers
b. file streams
c. ADO.NET applications
d. databases
e. data readers
7. For read-only access to databases, which ADO.NET class is used?
a. DataSet
b. DataAdapter
c. CommandBuilder
d. Connection
e. DataReader
8. To avoid writing additional SQL statement to update a live database, you instantiate an object of which class?
a. DataAdapter
b. DataReader
c. Connection
d. CommandBuilder
e. DataGrid
Explanation / Answer
Answer for Question 1:
Command is not a data provider classes set.
Answer for Question 2:
Using System . we can access of data provider classes
Answer for Question 3:
Select * FROM Customer
Answer for Question 4:
@ followed by an identifier is used to indicaed.
Answer for Question 5:
INNER JOIN are used to retrieve the data from multiple tables.
Answer for Question 6:
These are used to provide the Data Providers
Answer for Question 7:
by using DataReader provide the only read only access to data bases.
Answer for Question 8:
DataAdapter is used to updates
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.