C# Exclusive Interview Questions and Answers (453) - Page 8

A joint initiative from DotNetFunda.Com and Questpond.
A one stop place on the internet to get trusted and proven Interview Questions (based on more than a decade of experience in this field) to ensure the success of the candidates.
You will find almost all Interview questions from Questpond here and this list is growing day by day with all latest and updated interview questions.

453 records found.

Post Interview |

Interview Experiences |

Interview FAQs |

Online Interviews |

Interviews Home

Get 650+ Questpond's Interview videos on discount

_____________________ manage provider can be used for any database which has Oledb provider

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

_____________________ manage provider for Odbc drivers

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

Connection object encapsulates the functionality of establishing a ______________ over the sockets.

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

Command object can be used for execution of

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

The cursor and pointers functionality is encapsulated by the ___________ object in the front end

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

The cursor managed by Data Reader is _______________

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

__________________ is a disconnected object model for working with the data fetched from database.

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

Which Managed Provider provides least performance?

ODBC managed provider gives least performance.

How the RDBMS products(Oracle,SqlServer) differ?

These are differed by their respective managed providers. Also the scale of applications they can support differs. For eg: for small and medium size applications, SQL Server is enough where as for large enterprise application where data is huge to maintain Oracle server is useful.

What happens internally if the statement cmd.Prepare() is executed in the Frontend?

The sql statements will be compiled and a cache copy of the same will be created so that next time the result can be given using the cache copy for different parameters

Which is the top layer in the ADO.NET Entity Framework?

Answer:

Object Services Explanation: Object Services is the top layer in the ADO.NET Entity Framework. This framework is made up of three layers: EDM (Entity Data Model), Mapping and Source. Object Services falls under the EDM layer. Figure 4 in the article referenced below gives the overall ADO.NET Entity Framework Architecture. Ref: Achieve Flexible Data Modeling With The Entity Framework - http://msdn.microsoft.com/en-us/magazine/cc700331.aspx Courtesty: Internet

What is MARS ? What is the importance of it?

MARS - Multiple Active Result Set. If it is set to true than morethan one datareader is opended at a time with single connection object.

Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?

Valid answers are:

• A DataSet can represent an entire relational database in memory, complete with tables, relations, and views.

• A DataSet is designed to work without any continuing connection to the original data source.

• Data in a DataSet is bulk-loaded, rather than being loaded on demand.

• There's no concept of cursor types in a DataSet.

• DataSets have no current record pointer You can use For Each loops to move through the data.

• You can store many edits in a DataSet, and write them to the original data source in a single operation.

• Though the DataSet is universal, other objects in ADO.NET come in different versions for different data sources.