C# Exclusive Interview Questions and Answers (453) - Page 7

A joint initiative from DotNetFunda.Com and Questpond.
A one stop place on the internet to get trusted and proven Interview Questions (based on more than a decade of experience in this field) to ensure the success of the candidates.
You will find almost all Interview questions from Questpond here and this list is growing day by day with all latest and updated interview questions.

453 records found.

Post Interview |

Interview Experiences |

Interview FAQs |

Online Interviews |

Interviews Home

Get 650+ Questpond's Interview videos on discount

Are the Datatype in backend equals to frontend?

No the Datatype in backend are not equal to the datatypes in frontend.We need to explicitly map the datatypes i.e., we have to map the backend data types with front end datatypes.

What is the difference between 2-Tier architecture and 3-Tier architecture

2-tier - also called client/server applications which consist of two separate applications, one server application (typically a database server like Oracle, MSSQL or any other standalone database) and a client application. suppose you want to have many different clients for front- end would be unwise to copy all the business logic (all the rules of your application) to each client app.,. so its better to create a middle layer containing the business logic, and then let the clients talk with this middle layer. Thus the clients can relatively easily be changed for other types of clients, without need for remembering how was the business logic put together. 3-tier architeture where one tier is the backend database engine, one is the front end client and one is just in between them, also named the application server or business logic node. its uses mainly Load balancing and Fault tolerance.

What is the wildcard character in SQL?

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%’.

Explain ACID rule of thumb for transactions

A transaction must be: 1. Atomic - it is one unit of work and does not dependent on previous and following transactions. 2. Consistent - data is either committed or roll back, no “in-between” case where something has been updated and something hasn’t. 3. Isolated - no transaction sees the intermediate results of the current transaction). 4. Durable - the values persist if the data had been committed even if the system crashes right after.

What connections does Microsoft SQL Server support?

Windows Authentication (via Active Directory) and SQL Server authentication (via Microsoft SQL Server username and password).

Which method do you invoke on the DataAdapter control to load your generated dataset with data?

The Fill() method.

Can you edit data in the Repeater control ?

No, it just reads the information from its data source.

Which template must you provide, in order to display data in a Repeater control?

ItemTemplate.

What property must you set, and what method must you call in your code, in order to bind the data from a data source to the Repeater control?

You must set the DataSource property and call the DataBind method.

Why is "Connecting to SQL Server using Integrated Security" considered a best practice?

Connecting to SQL Server using integrated security instead of using an explicit user name and password, helps avoid the possibility of the connection string being compromised and your user ID and password being exposed.

What is Script injection?

A script injection attack attempts to send executable script to your application with the intent of having other users run it. A typical script injection attack sends script to a page that stores the script in a database, so that another user who views the data inadvertently runs the code.

What is SQL injection?

A SQL injection attack attempts to compromise your database by creating SQL commands that are executed instead of, or in addition to, the commands that you have built into your application.

What are the steps to follow to avoid SQL Injection attacks?

Always use parameterized queries or stored procedures instead of creating SQL commands by concatenating strings together.

Can we add relations between the tables in dataset?

Yes we can It is done using DataRelation Object

what are the fundamental objects in ADO.NET

The following are the core objects :

Connection------->

IDbConnection----->

Provides the ability to connect to or disconnect from datastore.

Command-------->

IDbCommand------>

Represents a sql query or Stored Procedure

Data Reader------->

IDataReader,IDataRecord---->

Provides a forward-only read only access to data using a server side Cursor.

DataAdapter------>

IDataAdapter,IDbDataAdapter--->

Transfers datasets between the caller and data store.

Parameter----------->
IDataParameter,IDbDataParameter--->

Represents a named parameter with a parameterized query.

Transaction--------->

IDbTransaction----------->

Encapsulates a Db Transaction.

Can we enable or diasble the connection pool?

By default Connection is enabled.If we explicitly want to enable or disable connection pooling we should set Pooling=true/false in your connection string.