Before Applying job posting in any websites or recruiting agencies or sending resumes to job recruiters or any other employment website you need to improve your skills on general knowledge, Aptitude, Puzzles, logical reasoning, general english, database, programming as per your job profile. Job recruiters or mostly preferring job candidates who are having more stuff in those categories mentioned above. So improving more skills on your job profile always boost up your career and your performance. Even hiring companies and job recruiters who are looking for many job posting websites actually they are looking and filtering on these activities. In these Ado.net section you need to update more questions to perform well in front of job recruiters and companies. Ado.net Interview questions are most important to score in interview, Update all questions to score well in all rounds in job interview.

ADO.Net interview questions and answers

11)
Can you explain the difference between an ADO.NET Dataset and an ADO Record set ?

There two main basic difference between record set and dataset :

  • With dataset you can retrieve data from two databases like oracle and sql server merge them in one dataset , with record set this is not possible
  • All representation of Dataset is using XML while record set uses COM.
  • Record set cannot be transmitted on HTTP while Dateset can be.

12)
How can do pessimistic locking?

Pessimistic locking is done by using transaction isolation levels like read committed, read uncommitted repeatable read and serializable.

13)
What’s difference between “Optimistic” and “Pessimistic” locking?

In optimistic locking there is no locking actually . It only checks if the old values are changed , in case they are changed it means somebody has changed the data, so it raises expection.
In pessimistic locking you actually lock the record, depending on the type of lock no other process can make modifications to the record.

14)
What is difference between dataset and data reader?

Following are some major differences between dataset and data reader :

  • Dataset is a disconnected architecture while data reader is connected architecture.
  • Data Reader provides forward-only and read-only access to data, while dataset moves back as well as forward.
  • Datasetobject is an in-memory database with tables, row and columns while datareader is just simple table which can be read only in a forward direction.
  • Dataset can persist contents while data reader cannot persist contents, they are read only and forward only.

15)
What is the use of command objects?

Command objects helps to execute SQL statements Following are the methods provided by command object :

  • Execute NonQuery : Executes insert, update and delete SQL commands . Returns an Integer indicating the number of rows affected by the query.
  • Execute Reader : Executes select SQL statements which can either be in your .Net code or in a stored procedure, Returns a “Datareader” object.
  • ExecuteScalar : Executes SQL command and returns only a single value like count, sum, first record etc.