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.

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).
Can you edit data in the Repeater control ?

No, it just reads the information from its data source.
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.
why is sql considered by most of the developers for connecting through databsae Oracle is one of the best rdbms product with more features

Due to its free access mysql is mostly used in developement as Oracle software is very costly.
what is the Advantage of writing a query String in App_Code folder?

so that it can be accessed any where in entire application
Manage provider for SqlServer is _________

NOTE: This is objective type question, Please click question title for correct answer.
Manage provider for Oracle is _________

NOTE: This is objective type question, Please click question title for correct answer.

More C# Interview Questions & Answers here

Found this useful, bookmark this page to the blog or social networking websites. Page copy protected against web site content infringement by Copyscape

 Exclusive Interview Questions and Answers Categories