Interview Questions.

Question 1. What Is Ado.Net?

Answer :

ADO.NET is part of the Microsoft .NET Framework. This framework provides the set of lessons that address records communique between various layers of the software program structure and the database. It provides a continuous get right of entry to to distinct statistics source types together with SQL Server versions 7, 2000, 2005. It additionally offers connectivity options to statistics resources thru OLE DB and XML. Connectivity may be mounted with different databases like Oracle, MySQL and so on. As well.
ADO.NET has the ability to split information get admission to mechanisms, information manipulation mechanisms and information connectivity mechanisms.
ADO.NET introduces together with it the disconnected architecture. In a disconnected structure, facts may be saved in a DataSet. It carries providers for connecting to databases, commands for execution and retrieval of consequences.
The training for ADO.NET are saved inside the DLL System.Data.Dll.

Question 2. What Is The Meaning Of Object Pooling?

Answer :

Object pooling is a idea of storing a pool (organization) of objects in memory that can be reused later as needed. Whenever, a brand new object is required to create, an item from the pool can be allocated for this request; thereby, minimizing the item creation. A pool can also check with a group of connections and threads. Pooling, therefore, allows in minimizing the use of system resources, improves machine scalability, and overall performance.

VB.NET Interview Questions
Question 3. Which Properties Are Used To Bind A Datagridview Control?

Answer :

The DataSource assets and the DataMember assets are used to bind a DataGridView manage.

Question 4. What Property Must Be Set And What Method Must Be Called In Your Code To Bind The Data From Some Data Source To The Repeater Control?

Answer :

You ought to set the DataSource belongings and get in touch with the DataBind() technique.Mention the namespace that is used to include .NET Data Provider for SQL server in .NET code.The System.Data.SqlClient namespace.

VB.NET Tutorial
Question five. What Is The Difference Between Oledb Provider And Sqlclient?

Answer :

With admire to utilization, there's no difference among OLEDB Provider and SqlClient. The difference lies of their performance. SqlClient is explicitly used to attach your application to SQL server without delay, OLEDB Provider is accepted for numerous databases, along with Oracle and Access such as SQL Server.Therefore, there could be an overhead which ends up in performance degradation.

C#. NET Interview Questions
Question 6. How Can We Load Multiple Tables In To Dataset?

Answer :

DataSet ds=new DataSet();
SqlDataAdapter dap=new SqlDataAdapter(Select * from ,);
dap.Fill(ds,”TableOne”);
SqlDataAdapter dap1=new SqlDataAdapter(Select * from ,);
dap1.Fill(ds,”tableTwo”);

Question 7. What Is Partial Class?

Answer :

A Partial class is a class that may be break up into two or greater classes. This means that a category may be physically separated into different components of the elegance inside the identical namespace. All the components must use the partial keyword. All the alternative classes ought to additionally have the same get right of entry to modifier. At the compile time, all of the partial lessons can be handled as a unmarried class. Let us listing a few benefits of getting partial lessons.

C#. NET Tutorial ASP.NET Interview Questions
Question eight. What Is The Role Of The Dataset Object In Ado.Internet?

Answer :

One of the fundamental factor of ADO.NET is the DataSet item, which continually stays disconnected from the database and reduces the burden on the database.

Question 9. What Is A Datareader Object?

Answer :

The DataReader object enables in retrieving the statistics from a database in a ahead-handiest, read-handiest mode. The base class for all the DataReader gadgets is the DbDataReader magnificence.
The DataReader object is again because of calling the ExecuteReader() method of the Command item. The DataReader item enables quicker retrieval of data from databases and complements the performance of .NET programs by way of offering speedy records access velocity. However, it's far much less desired as compared to the DataAdapter object because the DataReader object wishes an Open connection till it completes studying all the rows of the required table. 
An Open connection to examine statistics from massive tables consumes maximum of the system assets. When more than one client packages concurrently get admission to a database by way of the usage of the DataReader item, the overall performance of facts retrieval and other associated approaches is extensively decreased. In one of these case, the database may refuse connections to different .NET applications till different clients loose the resources.

Windows Presentation Foundation(WPF) Interview Questions
Question 10. How Can You Identify Whether Or Not Any Changes Are Made To The Dataset Object Since It Was Last Loaded?

Answer :

The DataSet object presents the subsequent two strategies to music down the adjustments: 
The GetChanges() approach - Returns the DataSet item, which is modified because it changed into loaded or since the AcceptChanges() method changed into achieved.
The HasChanges() approach - Indicates if any adjustments came about because the DataSet object became loaded or after a call to the AcceptChanges() technique changed into made.
If you want to revert all adjustments for the reason that DataSet object become loaded, use the RejectChanges() method.

ASP.NET Tutorial
Question 11. What Are The Various Methods Provided By The Dataset Object To Generate Xml?

Answer :

The numerous strategies provided by the DataSet object to generate XML are:

ReadXml() - Reads XML record right into a DataSet item.
GetXml() - Returns a string containing an XML report.
WriteXml() - Writes an XML information to disk.
Windows CE .NET Interview Questions
Question 12. What Is Connection Pooling?

Answer :

Connection pooling refers back to the mission of grouping database connections in cache to make them reusable because establishing new connections whenever to a database is a time-eating technique. Therefore, connection pooling enables you to reuse already existing and active database connections, each time required, and increasing the performance of your utility.
You can enable or disable connection pooling on your utility by using setting the pooling assets to either real or false in connection string. By default, it is enabled in an application.

VB.NET Interview Questions
Question thirteen. What Are The Pre-requirements For Connection Pooling?

Answer :

The conditions for connection pooling are as follows:

There need to be a couple of strategies to proportion the equal connection describing the same parameters and security settings.
The connection string should be identical.
Windows Presentation Foundation(WPF) Tutorial
Question 14. What Are The Usages Of The Command Object In Ado.Internet?

Answer :

The following are the usages of the Command object in AD0.NET:
The Command item in AD0.NET executes a command towards the database and retrieves a DataReader or DataSet item.

It also executes the INSERT, UPDATE, or DELETE command towards the database.
All the command objects are derived from the DbCommand magnificence.
The command item is represented by two training: SqlCommand and OleDbCommand.
The Command object affords three methods to execute instructions at the database:
The ExecuteNonQuery() method executes a Transact-SQL declaration against the relationship and returns the variety of rows affected.
The ExecuteScalar() technique returns a single price from a database question.
The ExecuteReader() method returns a result set by means of the usage of the DataReader item.
Question 15. Explain The Architecture Of Ado.Internet In Brief.

Answer :

AD0.NET includes  fundamental additives:

The DataSet, which is disconnected from the data supply and does not want to understand where the facts that it holds is retrieved from.
The .Net records provider, which allows you to attach your software to the information source and execute the SQL instructions against it.
The information provider contains the Connection, Command, DataReader, and DataAdapter items.The Connection item offers connectivity to the database. The Command item presents get right of entry to to database instructions to retrieve and control data in a database. The DataReader item retrieves information from the database in the readonly and forward-best mode. The DataAdapter item makes use of Command objects to execute SQL instructions. The DataAdapter item loads the DataSet item with records and also updates adjustments that you have made to the statistics within the DataSet object again to the database.

Dot Net Framework Interview Questions
Question sixteen. Describe The Disconnected Architecture Of Ado.Internet's Data Access Model?

Answer :

ADO.NET continues a disconnected database get right of entry to version, this means that, the application never remains related constantly to the records supply. Any changes and operations done at the records are stored in a nearby replica (dataset) that acts as a records source. Whenever, the connection to the server is re-mounted, those modifications are despatched lower back to the server, in which these adjustments are saved within the actual database or statistics source.

Question 17. What Is The Difference Between The Clone() And Copy() Methods Of The Dataset Class?

Answer :

The Clone() method copies best the shape of a DataSet. The copied shape consists of all the relation, constraint, and DataTable schemas used by the DataSet. The Clone() method does now not copy the records, that is saved inside the DataSet. 
The Copy() technique copies the shape as well as the records stored within the DataSet.

Asp Dot Net Mvc 4 Interview Questions
Question 18. What Is The Use Of Dataview?

Answer :

User-defined view of a desk is contained in a DataView. A whole desk or a small segment of desk relying on a few criteria may be presented via an item of the DataView class. You can use this class to kind and find information inside DataTable.
The DataView elegance has the subsequent methods:
Find() - Finds a row in a DataView by means of using kind key cost.
FindRows() - Uses the type key price to match it with the columns of DataRowView items. It returns an array of all of the corresponding items of DataRowView whose columns in shape with the kind key price.
AddNew() - Adds a new row to the DataView item.
Delete() - Deletes the specified row from the DataView object consistent with the specified index.

C#. NET Interview Questions
Question 19. What Are The Parameters That Control Most Of Connection Pooling Behaviours?

Answer :

The parameters that manipulate maximum of connection pooling behaviors are as follows:

Connect Timeout
Max Pool Size
Min Pool Size
Pooling
Question 20. How Can You Add Or Remove Rows From The Datatable Object Of Dataset?

Answer :

The DataRowCollection magnificence defines the gathering of rows for the DataTable object in a DataSet. The DataTable magnificence offers the NewRow() method to add a brand new DataRow to DataTable. The NewRow technique creates a brand new row, which implements the identical schema as carried out to the DataTable. The following are the techniques provided by using the DataRowCollection object:
Add() - Adds a brand new row to DataRowCollection.
Remove()- Removes a DataRow item from DataRowCollection.
RemoveAt() - Removes a row whose area is precise through an index variety.

Asp Dot Net Mvc Interview Questions
Question 21. Explain In Brief Dataadapter Class In Ado.Net?

Answer :

The DataAdapter elegance retrieves records from the database, shops data in a dataset, and reflects the modifications made within the dataset to the database. The DataAdapter magnificence acts as an middleman for all of the conversation among the database and the DataSet item. The DataAdapter Class is used to fill a DataTable or DataSet Object with records from the database using the Fill() technique. The DataAdapter class applies the adjustments made in dataset to the database by way of calling the Update() technique. 
The DataAdapter elegance affords 4 houses that represent the database command: 
SelectCommand, InsertCommand, DeleteCommand, and UpdateCommand.

Question 22. What Are Different Layers Of Ado.Net?

Answer :

There are three special layers of ADO.Net:

Presentation Layer
Business Logic Layer
Database Access Layer
Question 23. What Are The Data Providers In Ado.Net?

Answer :

Following are the Data Providers utilized in ADO.Net:.

MS SQL Server.
OLEDB.
ODBC.
Question 24. What Are The Uses Of Stored Procedure?

Answer :

Following are makes use of of Stored Procedure:

Improved Performance.
Easy to apply and hold.
Security.
Less time and effort taken to execute.
Less Network site visitors.
ASP.NET Interview Questions
Question 25. What Is The Default Time Out For Sql Command.Commandtimeout Property?

Answer :

The default timeout of Sqlcommand. CommandTimeout property is 30 Seconds.

Question 26. What Are The Classes In System.Records.Commonplace Namespace?

Answer :

There are two classes involved in System.Data.Common Nameapce:

DataColumnMapping.
DataTableMapping.
Question 27. What Is Linq?

Answer :

Language Integrated Query or LINQ provides programmers and testers to query information and it uses strongly type’s queries and effects.

Windows Presentation Foundation(WPF) Interview Questions
Question 28. What Are Typed And Untyped Dataset?

Answer :

Typed datasets use specific names and information kinds for their participants however untyped dataset uses desk and columns for their participants.

Question 29. How To Stop Running Thread?

Answer :

Thread.Abort() feature stops the thread execution at any time.

Question 30. Which Method Is Used To Sort The Data In Ado.Internet?

Answer :

Sort() technique of GridViewControl is used to kind the records in a datatable.

Question 31. Which Object Is Used To Add Relationship Between Two Datatables?

Answer :

DataRelation item is used to feature dating between  or extra datatable items.

Question 32. Which Is The Best Method To Get Two Values From The Database?

Answer :

ExecuteNonQuery is the high-quality approach to get  values from the database.

Question 33. What Are All The Classes That Are Available In System.Records Namespace?

Answer :

Following are the classes which might be to be had in System.Data Namespace:

Dataset.
DataTable.
DataColumn.
DataRow.
DataRelation.
Constraint.
Windows CE .NET Interview Questions
Question 34. What Are All Components Of Ado.Internet Data Provider?

Answer :

Following are the additives of ADO.Net Data issuer:
Connection item – Represents connection to the Database
Command item – Used to execute stored technique and command on Database
ExecuteNonQuery – Executes command but doesn’t return any fee
ExecuteScalar – Executes and returns single price
ExecuteReader – Executes and returns end result set
DataReader – Forward and study simplest recordset
DataAdapter – This acts as a bridge among database and a dataset.

Question 35. What Are The Differences Between Oledb And Sqlclient Providers?

Answer :

OLEDB provider is used to access any database and affords flexibility of converting the database at any time. SQLClient issuer is used to get admission to simplest SQL Server database however it provides excellent overall performance than OLEDB company even as connecting with SQL Server database.

Question 36. What Are The Different Execute Methods Of Ado.Net?

Answer :

Following are exceptional execute strategies of ADO.Net command object:
ExecuteScalar – Returns single fee from the dataset
ExecutenonQuery – Returns resultset from dataset and it has multiple values
ExecuteReader – Forwardonly resultset
ExecuteXMLReader – Build XMLReader item from a SQL Query

Dot Net Framework Interview Questions
Question 37. What Are All The Commands Used With Data Adapter?

Answer :

DataAdapter is used to retrieve records from a records source .Insertcommand, UpdateCommand and DeleteCommand are the instructions object used in DataAdapter to control replace at the database.

Question 38. What Are All The Different Methods Under Sql Command?

Answer :

There are one-of-a-kind techniques underneath SqlCommand and they're:
Cancel – Cancel the question
CreateParameter – returns SQL Parameter
ExecuteNonQuery – Executes and does no longer return end result set
ExecuteReader – executes and returns statistics in DataReader
ExecuteScalar – Executes and returns unmarried price
ExecuteXmlReader – Executes and return records in XMLDataReader object
ResetCommandTimeout – Reset Timeout property

Question 39. What Is The Difference Between Dataset.Clone And Dataset.Copy?

Answer :

Dataset.Clone object copies structure of the dataset together with schemas, members of the family and constraints. This will not replica information in the desk.
Dataset.Copy – Copies both structure and records from the table.

Question forty. What Is The Difference Between Command And Commandbuilder Object?

Answer :

Command is used to execute all sort of queries like DML and DDL. DML is not anything but Insert, Update and Delete. DDL are like Create and drop tables.
Command Builder object is used to construct and execute DML queries like Create and Drop Tables.

Asp Dot Net Mvc 4 Interview Questions
Question forty one. Is It Possible To Load Multiple Tables In A Dataset?

Answer :

Yes, it's miles viable to load more than one tables in a single dataset.

Question forty two. Which Provider Is Used To Connect Ms Access, Oracle, Etc…?

Answer :

OLEDB Provider and ODBC Provider are used to connect with MS Access and Oracle. Oracle Data Provider is likewise used to connect solely for oracle database.

Asp Dot Net Mvc Interview Questions
Question forty three. Do We Use Stored Procedure In Ado.Net?

Answer :

Yes, saved methods are utilized in ADO.Net and it may be used for commonplace repetitive functions.

Question forty four. What Are The Methods Of Xml Dataset Object?

Answer :

There are numerous strategies of XML dataset object:
GetXml() – Get XML facts in a Dataset as a unmarried string.
GetXmlSchema() – Get XSD Schema in a Dataset as a single string.
ReadXml() – Reads XML information from a file.
ReadXmlSchema() – Reads XML schema from a file.
WriteXml() – Writes the contents of Dataset to a document.
WriteXmlSchema() – Writes XSD Schema right into a record.

Question 45. What Are All The Different Authentication Techniques Used To Connect To Ms Sql Server?

Answer :

SQL Server have to authenticate before appearing any interest in the database. There are  forms of authentication:
Windows Authentication – Use authentication using Windows area accounts simplest.
SQL Server and Windows Authentication Mode – Authentication furnished with the aggregate of each Windows and SQL Server Authentication.