ADO.NET FAQs & Interview Questions
Description
To introduce ADO.NET and to describe how to make connections to databases and run stored procedures and SQL statements in a connected design
1. Which of the following statements about stored procedures are true?
Choose more than one option.
1. They reside on the client
2. They reside on the server True
3. You can encapsulate multiple SQL statements in a stored procedure True
4. You encapsulate a single SQL statement in each stored procedure
Topic title: Architecture of ADO.NET
2. Which of the following fully qualified names describes the data adapter for a SQL 2000 server?
Choose an option.
System.Data.SqlClient.DataAdapter
System.Data.SqlClient.SqlDataAdapter True
System.Data.SqlDataAdapter
System.Xml.SqlDataAdapter
Topic title: Working with ADO.NET connections in VB.NET
3. Assuming that ReadNextOrder expects one parameter, which options accurately describe this code?
Dim cnnOrders As SqlConnection
Dim cmd As SqlCommand, drOrders As SqlDataReader
cmd = New SqlCommand ("ReadNextOrder", cnnOrders)
drOrders = cmd.ExecuteReader ()
Choose more than one option.
The connection must be opened explicitly True
The CommandType property must be set to StoredProcedure True
The ExecuteNonQuery method should be used for all stored procedures
The ExecuteReader method call will fail because no parameter has been added to the Parameters collection True
Topic title: Distributed data-access requirements
4. Which of the following attributes in a ConnectionString specifies the SQL Server server used when a connection is open?
Choose an option.
Initial Catalog
Provider
Data Source True
ConnectionTimeout
Topic title: Distributed data-access requirements
5. Connected data-access applications are generally ___________ more than disconnected data-access applications.
Choose an option below to fill in the blank.
complicated
distributed
scalable
secure True
suited to the Internet
Topic title: Pooling ADO.NET connections in VB.NET
6. Which of the following statements about the DataReader object are true?
Choose more than one option.
The DataReader points to the first row of the result set after Read is first called True
You create a new DataReader using one of several overloaded constructors
You use the ExecuteScalar method of the Command object to obtain a DataReader
You use the NextResult method on the DataReader to get the next result set True
Topic title: Pooling ADO.NET connections in VB.NET
7. Which of the following methods of a DataReader enable you to obtain column metadata?
Choose more than one option.
GetString
GetName True
GetOrdinal True
GetSchemaTable True
GetDateTime
Topic title: Defining an ADO.NET Connection object in VB.NET
8. Which of the following are implementations of Command classes for .NET data providers?
Choose more than one option.
OdbcCommand objects True
OleDbCommand objects True
SqlCommand objects True
XMLCommand objects
Topic title: Defining an ADO.NET Connection object in VB.NET
9. Which of the following SqlConnection.ConnectionString attributes determines the number a seconds a connection can stay in a pool?
Choose an option.
Connection Duration
Connection Lifetime True
Connection TimeOut
Connection Reset
Topic title: Pooling ADO.NET connections in VB.NET
10. To specify the name of a stored procedure in .NET code, you use a _____________ object.
Choose an option below to fill in the blank.
DataSet
SqlCommand True
SqlConnection
SqlDataAdapter
Topic title: Architecture of ADO.NET
Which of the following objects exclusively contains metadata about tables?
Choose an option.
The DataColumn object True
The DataRow object
The DataView object
The SqlDataAdapter object
Topic title: Distributed data-access requirements
11. Which of these namespaces do you need to reference to connect to a SQL database using the .NET provider for OLEDB?
Choose more than one option.
System.Data True
System.Data.Connect
System.Data.Oledb True
System.Data.SqlClient
Topic title: Architecture of ADO.NET
13. What happens when you try to make the following assignment to an OleDbConnection.ConnectionString property and then try to open that connection?
cnNew.ConnectionString = "Data Source=8044DYSZ033R\SQLLOCAL; Initial" & _ "Catalog=Northwind; User ID=sa;"
cnNew.Open()
Choose an option.
It fails to compile
It compiles and runs correctly
It compiles but throws an ArgumentException because no Provider is included True
It compiles but throws an OleDbException when you attempt to open it
Topic title: Architecture of ADO.NET
14. What happens when you try to make the following assignment to an OleDbConnection.ConnectionString property and then try to open that connection?
cnNew.ConnectionString = "Data Source=8044DYSZ033R\SQLLOCAL; Initial" & _ "Catalog=Northwind; User ID=sa;"
cnNew.Open()
Choose an option.
It fails to compile
It compiles and runs correctly
It compiles but throws an ArgumentException because no Provider is included True
It compiles but throws an OleDbException when you attempt to open it
Topic title: Working with ADO.NET connections in VB.NET
15. Which combination of classes do you use when passing arguments to a stored procedure through the SQL .NET Data Provider?
Choose an option.
Argument and SqlCommand
Parameter and SqlCommand
SqlArgument and SqlCommand
SqlParameter and SqlCommand True
Topic title: Working with ADO.NET connections in VB.NET
16. A Command object's property indicates whether an object encapsulates a stored procedure or a SQL statement, or is requesting a full table.
Choose an option below to fill in the blank.
Connection
CommandType True
CommandText
Parameters
Topic title: Architecture of ADO.NET
Which method releases unmanaged resources when a connection is closed?
Choose an option.
Delete
Dispose True
Open
Topic title: Working with ADO.NET connections in VB.NET
17. You use Visual Studio .NET's ___________ to create sequences of SQL commands.
Choose an option below to fill in the blank.
Toolbox
Query Analyzer tool True
Properties window
Topic title: Distributed data-access requirements
18. Which of the following attributes in a ConnectionString sets the name of the OLE DB or SQL database?
Choose an option.
Initial Catalog True
Provider
Data Source
ConnectionTimeout
Topic title: Architecture of ADO.NET
19. If a connection has a nonfatal error, the ____________ event is thrown.
Incorrect. The correct option is as follows
InfoMessage True
OleDbException
SqlException
StateChange
Topic title: Distributed data-access requirements
20. _______________ eliminates the need for database locks and protracted database connections and facilitates data exchange between tiers.
Choose an option below to fill in the blank.
A 2-tier application architecture
The use of in-memory data caches True
The use of strongly typed data
XML messaging
Topic title: Defining an ADO.NET Connection object in VB.NET
21. If both the ________________ of a client's Connection object match those of a dormant connection in a pool, the client can obtain a connection in that pool.
Choose an option below to fill in the blank.
connection context and database context
connection context and security context
security context and pooling context
security context and transaction context True
Topic title: Defining an ADO.NET Connection object in VB.NET
22. Which of the following SqlConnection.ConnectionString attributes specifies the number of connections that are automatically allocated to a new pool when it's created by a unique connection?
Choose an option.
Init Pool Size
Max Pool Size
Min Pool Size True
Start Pool Size
Topic title: Working with ADO.NET connections in VB.NET
23. When you are stepping through a stored procedure, which of the following types of information are displayed in the Autos window?
Choose more than one option.
Debug information
The contents of the call stack
The types of the procedure's variables True
The values of the procedure's variables True
Topic title: Defining an ADO.NET Connection object in VB.NET
24. Which of the following elements is always incorporated in a Command object?
Incorrect. The correct option is as follows
A Connection object True
A database table name
A set of parameters
A SQL statement string
The name of a stored procedure
Topic title: Pooling ADO.NET connections in VB.NET
25. The Read method returns the value _____________ when there is no more data to be read in a DataSet.
Choose an option below to fill in the blank.
Null
0
-1
False True
Topic title: Defining an ADO.NET Connection object in VB.NET
26. In which of the following situations is the use of a connected strategy always necessary?
Choose more than one option.
When you're using a web application that uses ASP.NET
When you're modifying database structure True
When you're performing operations directly on a database True
When you need to read data as XML
Topic title: Pooling ADO.NET connections in VB.NET
27. What is the default setting of the ParameterDirection property of a stored-procedure parameter?
Choose an option.
Input True
InputOutput
Output
ReturnValue
Topic title: Architecture of ADO.NET
28. Which of the following collections are encapsulated in the DataSet object?
Choose an option.
Adapters and Views
Commands and Connections
Rows, Columns, and Constraints
Tables and Relations True
Topic title: Distributed data-access requirements
29. In a tiered data-access application, each tier comprises a discrete ____________________.
Choose an option below to fill in the blank.
application server
group of users separated logically
section of application functionality True
set of application data
Topic title: Working with ADO.NET connections in VB.NET
30. The __________________ method returns the number of rows affected by the execution of a DDL command.
Choose an option below to fill in the blank.
ExecuteScalar
ExecuteReader
ExecuteXMLReader
ExecuteNonQuery True
Post a Comment