25. What is connection pooling?
Connection pooling refers to the task of grouping database connections in cache to make them reusable because opening new connections every time to a database is a time-consuming process. Therefore, connection pooling enables you to reuse already existing and active database connections, whenever required, and increasing the performance of your application. You can enable or disable connection pooling in your application by setting the pooling property to either true or false in connection string. By default, it is enabled in an application.
26. What are the various methods provided by the DataSet object to generate XML?
The various methods provided by the DataSet object to generate XML are:
- ReadXml() - Reads XML document into a DataSet object.
- GetXml() - Returns a string containing an XML document.
- WriteXml() - Writes an XML data to disk.
27. Out of Windows authentication and SQL Server authentication, which authentication technique is considered as a trusted authentication method?
The Windows authentication technique is considered as a trusted authentication method because the username and password are checked with the Windows credentials stored in the Active Directory.
The SQL Server Authentication technique is not trusted as all the values are verified by SQL Server only.
28. How would you connect to a database by using .NET?
The connection class is used to connect a .NET application with a database.
29. Which adapter should you use, if you want to get the data from an Access database?
OleDbDataAdapter is used to get the data from an Access database.
30. What are different types of authentication techniques that are used in connection strings to connect .NET applications with Microsoft SQL Server?
.NET applications can use two different techniques to authenticate and connect with SQL Server. These techniques are as follows:
- The Windows Authentication option
- The SQL Server Authentication option