ADO.NET Interview Questions and Answers (445) - Page 18

Latest and authentic Interview questions. You can also post an interview question and win monthly prizes as well as gain community credit points.

445 records found.

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Get 650+ Questpond's Interview videos on discount

You use SqlDataAdapter to load a DataTable with rows from a Microsoft SQL Server database table. The table includes an identity column that is the primary key. You configure the adapter's InsertCommand to call a stored procedure that adds a new row that includes all table values except the identity column. You configure the adapter's UpdateCommand to call a stored procedure that updates a row based on the primary key column value. When testing, you find that you can successfully call the adapter's Update method to add new DataTable rows to the database table. However, you find that when you then modify a column in one of these added DataTable rows and attempt to update the database table a second time, an exception is thrown. The exception indicates that the provided primary key column value was not found in the database. You must fix the problem. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You are implementing a method that creates Entity Framework self-tracking entities. The method submits these entities to a WCF Service method that uses Entity Framework to add the entities to a data source. After you submit the entities, you need to ensure that the entity state indicates no changes. Which entity method should you call?

NOTE: This is objective type question, Please click question title for correct answer.

Your application uses the following code to query Entity Framework objects returned by the ObjectContext named context: var result = from product in context.Products where product.ProductID == productID select product; You need to add code to see the commands that the query will execute against the data source. Which code segment should you use?

NOTE: This is objective type question, Please click question title for correct answer.

Your application uses Entity Framework to retrieve and update a SQL Server database. Some operations against the data source take several seconds to execute. You need to examine the SQL commands that Entity Framework executes against the database. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

Your application uses LINQ to SQL to retrieve and update a data source. You need to trace the SQL commands that LINQ to SQL executes against the database. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

Your application uses LINQ to SQL to retrieve and update a data source. To debug, you want to be able to write all SQL commands to a window in a stand-alone WPF application. You need to access DataContext SQL commands and write to a custom file. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

Your application connects to a Microsoft SQL Server database. You must log warnings or errors returned by SQL Server when a connection attempt fails. Which exception type should you catch?

NOTE: This is objective type question, Please click question title for correct answer.

Your application uses the Microsoft .NET Framework Data Provider for SQL Server to access a Microsoft SQL Server database. You want to log all detailed information about database errors, including such information as line number and severity level. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You use a SqlCommand instance named command to execute the following query: AsyncCallback callback = new AsyncCallback(HandleCallback); command.BeginExecuteNonQuery(callback, command); private void HandleCallback(IAsyncResult result) { ... } You must detect whether the query causes a database error. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You use SqlDataAdapter to load a DataTable from a Microsoft SQL Server database table. Your code makes several changes to the DataTable and then calls SqlDataAdapter.Update to update the database. You want to ensure that if a call to the InsertCommand, UpdateCommand, or DeleteCommand throws an exception, the update continues. What should you do ?

NOTE: This is objective type question, Please click question title for correct answer.

You use DataAdapter to load a DataTable from a Microsoft SQL Server database table. Your code makes several changes to the DataTable and then calls Update to update the database. The UpdateCommand calls the following stored procedure: CREATE PROCEDURE dbo.UpdateAnnotation ( @strAnnotation VARCHAR(200), @dtDate DATETIME ) AS SET NOCOUNT ON ... GO Calling the Update method throws a DBConcurrencyException. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You use DataAdapter to load a DataTable. Your code makes several changes to the DataTable, sets ContinueUpdateOnError to True, and then calls Update to update the database. You must log all errors thrown by a row update failure. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You use DataAdapter to load a DataTable. Your code makes several changes to the DataTable, sets ContinueUpdateOnError to True, and then calls Update to update the database. You must identify all rows that failed to update. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

Your code calls the Update method of a DataAdapter to update a database with changes made to a DataTable. You must ensure that all row updates are attempted before Update returns. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You are implementing a banking application. The application stores and uses sensitive customer information. You need to save the data securely. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You are implementing an application that requires users to log on with a user name and password. You need to meet the following requirements when you store the password: * The application can authenticate a user by comparing a provided password against the stored password. * A malicious user cannot read or otherwise use the original plaintext password. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You are implementing a banking application. The application stores and uses sensitive customer information. You need to encrypt the data to save it to the data store. Which class should you use to encrypt data?

NOTE: This is objective type question, Please click question title for correct answer.

You are implementing an application that requires users to log on with a user name and password. You need to choose a class to create a hash of the user's password. Which class should you use ?

NOTE: This is objective type question, Please click question title for correct answer.

You are implementing a distributed application that will use encrypted customer information. You need to choose between public-key encryption and secret-key encryption. Which of the following is a requirement that should cause you to choose public-key encryption?

NOTE: This is objective type question, Please click question title for correct answer.

You are implementing an application that will use encrypted customer information. You need to choose between public-key encryption and secret-key encryption. Which of the following is a requirement that should cause you to choose secret-key encryption?

NOTE: This is objective type question, Please click question title for correct answer.

1
...
11
12
13
14
15
16
17
18
19
20
21
22
23

More ADO.NET Exclusive Interview Questions & Answers here

Found this useful, bookmark this page to the blog or social networking websites.

GooglePlus

StumbleUpon

Delicious

Reddit

Email

Bookmark It

Interview Questions and Answers Categories

.NET Certifications

ASP.NET Web API

Data Structures & Algorithms

Design Pattern & Practices

DotNetFunda.Com

Entity Framework

Error and Solution

Function Points (FPA)

Interview Questions

Mobile Development

MSBI (SSIS, SSRS, SSAS)

News and Community

Product Reviews

Project Management

Regular Expressions

Web Services, Remoting