11 November 2012

Interview Question and Answer -- ADO.NET

1)Full form of ADO.NET?
     ADO.NET -- Activex Data Object.
2)Explain DataProviders Which are available with .Net Framework?
.NET provider for SQL Server
.NET provider for ODBC
.NET Framework Data Provider for Oracle
.NET Framework Provider for OLEDB

.NET provider for SQL Server:
    Enables .NET Application works with SQL Server 7.0 and latest Versions.
.NET provider for ODBC:
    Enables .NET Application works with ODBC.
.NET Framework Data Provider for Oracle:
      Enables .NET Application works with Oracle 8.1.7 and latest Versions.
.NET Framework Provider for OLEDB:
Enables .NET Application works with OLEDB Data Strcuture.

3) Properties of DataAdapter?
      SelectCommand,Insertcommand,Updatecommand, DeleteCommand.
4) what are the Disadvantages of ADO.NET?
      Managed Only Access.
      Only Three Managed Data Providers.
      Learning Curve
5) Difference between ADO Recordset and Dataset?
ADO Recordset :
   One Row at an instatnt.
   It needs an open connection to read the data from data source.
   able to load the structure and data of only one data at a time.
   It doesn't support constraints of Databases.
Dataset:
      data structure which repersents complete table data at same time.
      It needs connection only for retriving the data.After retrieve the data connection is not necessary.
      Capability to store the structure and data of multiple tales at a time.
      uses constraints object to enfoce data integrity by using contraints.



6)difference between Dataset and Datareader?

Dataset:
fetch data and appropriately store them in structured foramt.
use XML to repersent inline view of the relation data.
Single Object of dataset an biubd Multiple tables of a database.
disconnected architecture
Datareader:
     It doesn't use as much objects as used by Dataset.
     It doesn't present inline view of  relational data by using XML tags.
     single object of a datareader can access only one table at an instant.
     connected architecture


7) Explain ExecuteReader?
    ExecuteReader:
          This Method returns an abject of a data reader such as SQLDataReader.
          An Object of the Connection class must invoke open method to open the database before the object of command class can Execute "Executereader" method.

8) Explain ExecuteNonQuery?
ExecuteNonQuery:
        This method an integer which represents the number of rows that are effected by SQL Query executed by the object of commnd class.
9)Explain ExecuteScalar?
ExecuteScalar:
       This methnod returns a single value from a datasoruce.

10)Concepts of DataAdapter?
      Bridge between Dataset and Database.

11)Various methods provideed by the dataset object to generate XML?
ReadXML
GeTXML
WriteXML



No comments: