• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Ado.net Interview Questions Answers

Question - 11 : -   Explain ACID rule of thumb for transactions.

Answer - 11 : -   A transaction must be: 1.       Atomic - it is one unit of work and does not dependent on previous and following transactions. 2.       Consistent - data is either committed or roll back, no “in-between” case where something has been updated and something hasn’t. 3.       Isolated - no transaction sees the intermediate results of the current transaction). 4.       Durable - the values persist if the data had been committed even if the system crashes right after. 

Question - 12 : - Which one is better WebService and Remoting ?

Answer - 12 : - Both of these have little difference WebService helpfull where the user who is using WebService doesnot have the .NET plateform. On the otherside for remoting we need .Net plateform on the both side so from both of this remoting is faster then webservice.So keep in mind which of these are you using if you have .net plateform or other.

Question - 13 : - What is MARS support in ADO.NET ?

Answer - 13 : - What is MARS support in ADO.NET ? In First version of ADO.NET we only do is one connection on one result set. But the new feature allow us to do multiple commands on the same connection. And another feature is we can switch back and forth in command objects in connection.MARS means(Multiple Active ResultSets).

Question - 14 : - Data Provider

Answer - 14 : - Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-langua

Question - 15 : - Normal 0 f

Answer - 15 : - There is a method that helps in getting schema information that is GetSchema() and this method is called in three different ways first way when we call this method without any parameter its return the metadata(table, view, stored procedure.indexes etc).When method is called by passing metadata collection name and filter criteria returns the items from the collection after applying the filter criteria and last way is when we called by passing a metadata collection name returns information about items found in the specified collection.

Question - 16 : - What is the role of the DataReader class in ADO.NET connections?

Answer - 16 : - It returns a read-only, forward-only rowset from the data source.  A DataReader provides fast access when a forward-only sequential read is needed. 

Question - 17 : - What are the different rowversions available

Answer - 17 : -   There are four types of Rowversions. Current: The current values for the row. This row version does not exist for rows with a RowState of Deleted. Default : The row the default version for the current DataRowState. For a DataRowState value of Added, Modified or Current, the default version is Current. For a DataRowState of Deleted, the version is Original. For a DataRowState value of Detached, the version is Proposed. Original: The row contains its original values. Proposed: The proposed values for the row. This row version exists during an edit operation on a row, or for a row that is not part of a DataRowCollection

Question - 18 : - What is the significance of CommandBehavior.CloseConnection ?

Answer - 18 : - To avoid having to explicitly close the connection associated with the command used to create either a SqlDataReader or and OleDbDataReader, pass the CommandBehavior.CloseConnection argument to the ExecuteReader method of the Connection. dr= cmd.ExecuteReader(CommandBehavior.CloseConnection); The associated connection will be closed automatically when the Close method of the Datareader is called. This makes it all the more important to always remember to call Close on your datareaders.

Question - 19 : -   What connections does Microsoft SQL Server support?

Answer - 19 : -   Windows Authentication (via Active Directory) and SQL Server authentication (via Microsoft SQL Server username and password).

Question - 20 : - Whate are different types of Commands available with DataAdapter ?

Answer - 20 : - SqlDataAdapter has SelectCommand, InsertCommand, DeleteCommand and UpdateCommand

Computer Contributors

Rajeev Katiyar
Yes Baroda

Share your email for latest updates


Our partners