70-561CSharp Exam

Quality and Value for the 70-561CSharp Exam

ultraexam Practice Exams for Microsoft 70-561CSharp are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your 70-561CSharp Exam

Microsoft 70-561CSharp Downloadable

70-561CSharp Downloadable, Interactive Testing engines

Ultraexam.com 70-561CSharp free web demo:
　
　
Exam : Microsoft 70-561Csharp
Title : TS: MS .NET Framework 3.5, ADO.NET Application Development


1. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The application connects to a Microsoft SQL Server 2005 database.
You write the following code segment.
string queryString = "Select Name, Age from dbo.Table_1";
SqlCommand command = new SqlCommand(queryString,
(SqlConnection)connection));
You need to get the value that is contained in the first column of the first row of the result set returned by the query.
Which code segment should you use?
A. var value = command.ExecuteScalar();
string requiredValue = value.ToString();
B. var value = command.ExecuteNonQuery();
string requiredValue = value.ToString();
C. var value = command.ExecuteReader(CommandBehavior.SingleRow);
string requiredValue = value[0].ToString();
D. var value = command.ExecuteReader(CommandBehavior.SingleRow);
string requiredValue = value[1].ToString();
Answer: A

2. You create an application by using the Microsoft .NET Framework 5 and Microsoft ADO.NET. The application connects to a Microsoft SQL Server 2005 database.
You need to separate the security-related exceptions from the other exceptions for database operations at run time.
Which code segment should you use?
A. catch (System.Security.SecurityException ex)
{
//Handle all database security related exceptions.
}
B. catch (System.Data.SqlClient.SqlException ex)
{
for (int i = 0; i < ex.Errors.Count; i++){
if (ex.Errors[i].Class.ToString() == "14") {
//Handle all database security related exceptions.
}
else{
//Handle other exceptions
}
}
}
C. catch (System.Data.SqlClient.SqlException ex)
{
for (int i = 0; i < ex.Errors.Count; i++){
if (ex.Errors[i].Number == 14){
//Handle all database security related exceptions.
}
else{
//Handle other exceptions
}
}
}
D. catch (System.Data.SqlClient.SqlException ex)
{
for (int i = 0; i < ex.Errors.Count; i++){
if (ex.Errors[i].Message.Contains("Security")){
//Handle all database security related exceptions.
}
else{
//Handle other exceptions
}
}
}
Answer: B

3. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The application connects to a Microsoft SQL Server 2005 database.
The application throws an exception when the SQL Connection object is used.
You need to handle the exception.
Which code segment should you use?
A. try
{
if(null!=conn)
conn.Close();
// code for the query
}
catch (Exception ex)
{
// handle exception
}
finally
{
if(null==conn)
conn.Open();
}
B. try
{
conn.Close();
// code for the query
}
catch (Exception ex)
{
// handle exception
}
finally
{
if(null!=conn)
conn.Open();
}
C. try
{
conn.Open();
// code for the query
}
catch (Exception ex)
{
// handle exception
}
finally
{
if(null!=conn)
conn.Close();
}
D. try
{
conn.Open();
// code for the query
}
catch (Exception ex)
{
// handle exception
}
finally
{
if(null==conn)
conn.Close();
}
Answer: C

4. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET.
You need to ensure that the application can connect to any type of database.
What should you do?
A. Set the database driver name in the connection string of the application, and then create the connection object in the following manner.
DbConnection connection = new OdbcConnection(connectionString);
B. Set the database provider name in the connection string of the application, and then create the connection object in the following manner.
DbConnection connection = new OleDbConnection(connectionString);
C. Create the connection object in the following manner.
DbProviderFactory factory =
DbProviderFactories.GetFactory("System.Data.Odbc");
DbConnection connection = factory.CreateConnection();
D. Create the connection object in the following manner.
DbProviderFactory factory =
DbProviderFactories.GetFactory(databaseProviderName);
DbConnection connection = factory.CreateConnection();
Answer: D

5. You create an application by using the Microsoft .NET Framework 3.5 and Microsoft ADO.NET. The application connects to a Microsoft SQL Server 2005 database.
You write the following code segment. (Line numbers are included for reference only.)
01 using (SqlConnection connection = new
SqlConnection(connectionString)) {
02 SqlCommand cmd = new SqlCommand(queryString, connection);
03 connection.Open();
04
05 while (sdrdr.Read()){
06 // use the data in the reader
07 }
08 }
You need to ensure that the memory is used efficiently when retrieving BLOBs from the database.
Which code segment should you insert at line 04?
A. SqlDataReader sdrdr =
cmd.ExecuteReader();
B. SqlDataReader sdrdr =
cmd.ExecuteReader(CommandBehavior.Default);
C. SqlDataReader sdrdr =
cmd.ExecuteReader(CommandBehavior.SchemaOnly);
D. SqlDataReader sdrdr =
cmd.ExecuteReader(CommandBehavior.SequentialAccess);
Answer: D