ADO.NET Interview Questions

List of ADP.NET Interview Questions. Get the answers of these ADO.NET Interview Questions here.
Protected by Copyscape Duplicate Content Protection Tool
  1. Can you edit data in Repeater control?
  2. Which ADO.NET object is very fast in getting data from database?
  3. Can you edit data in the Repeater control?
  4. Diff Data Grid and Repeater
  5. What is the purpose of connection pooling in ADO.NET?
  6. If you have more than one lakh rows in database table,while printing that table in frontend performence will be degraded.

    for that what do you do to improve the performence?
  7. What is a Linked Server?
  8. Can DataAdapter object accept DataTable as parameter in Fill method?
  9. How to create a DataView from DataTable?
  10. Name some of the top level objects which ADO consists?
  11. Explain about the relationship of XML and ADO.NET?
  12. Explain about Data access objects or DAO?
  13. What are the advantage of ADO.Net?
  14. Difference between OLEDB Provider and SqlClient ?
  15. How to add a new row in DataTable?
  16. How to create a column in the DataTable?
  17. How to add auto increment column in the DataTable?
  18. Best Method to retrieve two values from Database (SQL Server)
  19. Which method is used to create a new row in a Table
  20. Which method is used to commit all changes in the DataSet or DataTable?
  21. Which method is used to Gets the name of the specified column using DataReader?
  22. Which method is used to Get a value indicating whether the column contains non-existent or missing values
  23. To improve the performance and scalability of your .NET application. Which one of the following techniques would help?.
  24. Which is the base class for TypedDataset
  25. You are working with a DataSet and want to be able to display data, sorted different ways. How do you do so?
  26. To perform asynchronous data access, what must be added to the connection string?
  27. Which ADO.NET Object's fill method is used to fill the data from database into either DataSet or DataTable?
  28. Which is the default Provider Name of the Providers used to access the DataBase?
  29. Name the classes are found in System.Data.Common NameSpace?
  30. Name the classes that are contained in System.Data NameSpace?
  31. Stored procedure return more than one resut set and datareader used to fetch record, how you fetch second result set using datareader?
  32. What is Dataview in ADO Dot Net ?
  33. How can you update the records in database using datareader?
  34. What are the differences between ADO and ADO.NET?
  35. What are the components of .NET DataProvider?
  36. What are the benefits of ADO.NET?
  37. What is the use of DataSet?
  38. How to fill DataSet with data?
  39. What is a DataSet?
  40. How to convert a DataSet to a DataReader?
  41. Give Expansions of ODBC,OLE,OLE DB,ADO?
  42. Components of data providers in ADO.NET?
  43. What are the different DataAdapter Object properties present?
  44. Define connected and disconnected data access in ADO.NET?
  45. Describe Command Type property of a SQLCommand in ADO.NET?
  46. What is the role of data provider?
  47. What is DataViewManager?
  48. What is Connection Pooling ?
  49. What is the use of SqlParameter.Direction Property?
  50. Can you enforce constraints and relations on tables inside a DataSet?
  51. What happens when you apply AcceptChanges() method on a DataSet?
  52. What is the use of DataSet.HasChanges() Method?
  53. What happens when you apply RejectChanges method on a DataSet?
  54. How to access database using ADO.Net
  55. What is the Use of Connection Object ?
  56. Which of these ADO.NET classes is an abstract class ?
  57. Which event of the SqlConnection class can be used to retreive error information



    from a database ?
  58. Which of these is the fastest way of returning the total number of

    sales figures from a database table?
  59. From which Interface the sqlconnetion class is derived
  60. What type of Architecture is a Dataset in .Net Framework
  61. What is the use of SqlCommandBuilder?
  62. Differences between SqlCommand and SqlDataAdapter.
  63. What are the Differences between OleDb and SqlClient ?
  64. ADO.NET uses a disconnected architecture, where users work on the dataset rather than the database.



    What do you think are the advantages of this architecture?
  65. What is the difference between Typed and UnTyped DataSets?
  66. What is the difference between a toolstrip drop-down button and a toolstrip split button? What is the use of toolstrip container?
  67. Which of these is a connected architecture?
  68. Differences between DataSet and DataReader
  69. Which provider ADO.NET uses by default?
  70. Difference between LINQ to SQL and ADO.NET
  71. ADO.NET uses a disconnected architecture, where users work on the dataset rather than the database.



    What do you think are the advantages of this architecture?



    1. Scalability

    2. Data source and dataset independence

    3. Strong typing

    4. Ability to read both SQL and Oracle databases
  72. What are the advantages of integrating ADO.NET with XML?





    Options:



    1. A disconnected architecture

    2. An improvement of processing time

    3. Bypassing of firewalls
  73. How can you sort a DataSet?
  74. Which of these namespaces deals with SQL Server mobile databases?
  75. Which of these objects must be there when storing data in a disconnected state?
  76. Which parameters define the database server in the connection string?
  77. What is the name of the data source when we use SQL Server Express Edition?
  78. Which data-related class do you use to help prevent SQL injection attacks?
Protected by Copyscape Duplicate Content Check
Get the answers of these ADO.NET Interview Questions here.
Labels: