• +91 9971497814
  • info@interviewmaterial.com

Computer Interview Questions Answers

Ado.net Interview Questions Answers

Question - 21 : - What is the wildcard character in SQL?

Answer - 21 : -   Let’s say you want to query database with LIKE for all employees whose name starts with La. The wildcard character is %, the proper query with LIKE would involve ‘La%’. 

Question - 22 : - Why is ADO.NET serialization slower than ADO ?

Answer - 22 : - ADO uses binary serialization while ADO.NET uses text based serialization. Since the text takes more space, it takes longer to write it out.

Question - 23 : - What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

Answer - 23 : - SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix.  OLE-DB.NET is a .NET layer on top of the OLE layer, so it’s not as fastest and efficient as SqlServer.NET. 

Question - 24 : -   What does the Initial Catalog parameter define in the connection string?

Answer - 24 : - The database name to connect to.

Question - 25 : - How xml files and be read and write using dataset?.

Answer - 25 : - DataSet exposes method like ReadXml and WriteXml to read and write xml

Question - 26 : - Can you edit data in the Repeater control?

Answer - 26 : - NO.

Question - 27 : - What is Ref Cursor in .NET and how it is link with ExecuteReader ?

Answer - 27 : - Ref cursor play its role when doing with the oracle database these comes in ODP.NET. Ref Cursors are objects that link to Oracle server-side cursors.These Ref Cursor can be converted in oracle datareader with this Ref cursor we can get result with query written to pl/sql and the result can be get in .net.Now the question arise why we use Ref Cursor when we have an option of ExceuteReader reson is simple when we need more query in pl/sql means our work is done in pl/sql then we need this ref cursor for getting result set because doennot have direct connection to that table.Becasue advantage of pl/sql we can take two opertion in one query.

Question - 28 : - What are good ADO.NET object(s) to replace the ADO Recordset object?

Answer - 28 : - There are alot...but the base once are SqlConnection, OleDbConnection, etc...

Computer Contributors

krishan
Rajeev Katiyar
Yes Baroda

Share your email for latest updates

Name:
Email:

Our partners