ADO.NET Interview Questions

.NET FAQs Unleashed!

Home

Articles

SQL Interview Questions

Whats the difference between

Questions on OOPS

Questions on .NET Framework

ASP.NET Interview Questions

ASP.NET 2.0 Interview Questions

C# Interview Questions

ADO.NET Interview Questions

ASP.NET Security Questions

.NET Interview One Liners

Ajax Interview Questions

Design Pattern Questions

Acronyms in .NET

SQL Connection Strings

Open Source

Discussion Board

About

SQL Interview Questions for Review

What is SQL?

Syntax to Create a Table

What are DDL Commands? Create, Alter, Drop

What are DML Commands? Select, Insert, Update, Delete

What is a database? Syntax to create a database

What are the ACID rules of a transaction in SQL

What is a Dual table in Oracle

What is NULL in SQL?

What is a Join in SQL? What are the different types of joins

What is the difference between Table, View, Synonym in SQL?

How to run a stored procedure in SQL?

Write the syntax to create a function in SQL

What is a Stored Procedure in SQL?

Write the syntax to create a Stored Procedure in SQL

Whats the main difference between a Stored Procedure and Function?

Classic ASP & ASP.NET

ADO & ADO.NET

Structure, Class & Enum

Abstract Claress & Interface

Public, Private, Protected, Friend & Internal

Overriding & Shadowing

Class & Object

Shared & Static

Value Type & Reference Type

MSIL & CIL

DLL & EXE

Class Library & Namespace

String & StringBuilder

Web Service & Remoting

Public Assembly & Private Assembly

Trace & Debug

Server.Transfer & Response.Redirect

Server.Transfer & Server.Execute

Authentication & Authorization

ExecuteScalar & ExecuteNonQuery

DataReader & DataSet

System.Array.CopyTo & System.Array.Clone

Thread & Process

What is OOPS?

What is a Class? Base class?

What do you mean by Encapsulation?

What do you mean by Inheritance?

What is a Class member? What is an object?

What do you mean by Polymorphism?

What is a property? What is an event?

What is an access modifier? Different types of access modifiers?

What is Overloading? Overloads, Overload?

What is the shared keyword used for? What is static?

What is the virtual keyword used for?

Explain overridable, overrides, notoverridable,mustoverride

What is the shadowing? What is shadows keyword used for?

What is a constructor? Explain the new keyword. Whats a private constructor?

What is a static constructor?

Explain serialization? What is serializable attribute used for?

What is a delegate? Whats a Multicast Delegate

What is an abstract class? Why do we use it?

What is an interface? When & how do we implement it?

Is multiple inheritance possible in .NET?

What is .NET?

Which languages can be used to program for .NET?

Which versions of .NET have been released so far?

What tools can be used for .NET Development?

Explain CLI, CIL, CTS, Metadata, CLS, IL and VES

What is CLR?

What is a class library?

Explain managed code, managed data, managed class

What is an assembly? What is ILDASM?

What is Reflection?

What are the different types of assemblies? Satellite assembly?

How do we share an assembly? How do we make it strongly named? SN.EXE?

What is GAC?

Can the Garbage Collector control activities of a thread?

For what do we use the IDisposable interface?

What is Serialization? SoapFormatter, BinaryFormatter, XmlFormatter?

What is CAS?

What is a class attribute?

What is a thread? How do we create and use it?

What is globalization?

What are generations in .NET?

How to use COM components in .NET?

How to redirect a user to a new page?

How to pass values between pages?

What is the role of the ASP.NET worker process?

Explain the page life cycle in ASP.NET 2.0

How to store global variables?

How to store values between postbacks?

What is a server control?

What is viewstate?

How to send an email using ASP.NET?

Which namespace does a webpage belong?

How to store information about a user's locale?

How to add an event handler for a server control?

What are validation controls? How do validation controls work?

What is global.asax? Application_start, Session_start?

What is an HTTP handler? Can we use it to upload files?

What is a session? Different ways to maintain session?

What is a cookie? Limitations of cookie? Permanent cookie?

How to set view state for a server control? Enableviewstate property?

What is smart navigation?

How to implement a web farm and a web garden?

Can dataset be stored in a viewstate?

What is the @Register directive used for?

Can we bind data to a server control without writing code in .NET?

How to use Masterpages and Contentpages using ASP.NET 2.0?

What is a nested Masterpage in ASP.NET 2.0?

What is a SiteMap control in ASP.NET 2.0? Can we have multiple sitemaps for a site using .NET?

How to sort data in a Gridview in .NET? Gridview Paging in .NET? Maximum records in gridview?

What does the Hotspot class in .NET do? What is an ImageMap in ASP.NET?

How do we update and delete data in a gridview? Datakeynames property in .NET?

Describe the accessibility modifier "protected internal"

Can multiple data types be stored in System.Array?

How to sort array elements in descending order?

Whats the use of "throw" keyword?

Can we put multiple catch blocks in a single try statement?

How to achieve polymorphism in C#?

How to achieve inheritance in C#?

Compare Session state and Viewstate?

How to add gridview/datagrid columns manually? Autogenerate?

How to add a ReadOnly property in C#?

How to prevent a class from being inherited? Sealed?

How to inherit the class, but not the method inside it?

Can we inherit multiple interfaces?

What are the different ways a method can be overloaded?

How to call a specific base constructor?

What are generics in C#?

What is the use of the main() function in C#?

Are C# Keywords in lowercase or uppercase?

What is the use of Console.Readline() in C#?

Can we set the specifier of the main() method in C# as private?

Can we set different types of parameters & return-types in main() method

What is the use of GetCommandLineArgs() method

What is the use of System.Environment class?

Why is the new keyword used for instantiating an object in .NET?

Default values of bool, int, double, string, char, reference-types?

Why does the compiler throw an error when variables are declared with initial value?

How to declare a constant variable in C#?

In C#, can we create an object of reference type using const keyword

What is the difference between const and readonly in C#?

What are the different parameter modifiers available in C#

What is the difference between out and ref in C#?

What is an interface in C#?

Dynamically finding the interface reference, is and as keyword

What are the different classes and interfaces inside System.Collection

What is ADO.NET?

Whats a connection object? How to connect to a database?

What is a command object? How to use it?

What is SelectCommand?

What is a SqlCommandBuilder in ADO.NET?

What is a DataView?

How to use a DataRelation between two columns?

What is Diffgram? When do we use Diffgram?

What is a Typed Dataset? Why do we use it?

How to run a Stored Procedure from .NET code?

Describe the security authentication process in aspnet

What is the Website Administrative Tool in Visual Studio 2005?

What is Authentication in ASP.NET?

What is Authorization in ASP.NET?

What is IIS Metabase?

What is mixed mode Authentication in ASP.NET?

What is Provider Model and Personalization in Aspnet 2.0?

Short Answer .NET Interview Questions Page 1

Short Answer .NET Interview Questions Page 2

Short Answer .NET Interview Questions Page 3

Short Answer .NET Interview Questions Page 4

Short Answer .NET Interview Questions Page 5

MY ARCHIVED SITES
Moredotnet
Aspnetinfo

Click to join dotnetuncle

walkin interviews | IT Walkin Interviews | IT Igreat free widgetsWidgetboxMore info

ADO.NET Interview Questions

What is ADO.NET?
Whats a connection object? How to connect to a database?
What is a command object? How to use a command object in ADO.NET?
What is SelectCommand in ADO.NET?
What is a SqlCommandBuilder in ADO.NET?
What is a DataView in ADO.NET?
How to use a DataRelation between two columns?
What is Diffgram? When do we use Diffgram?
What is a Typed Dataset? Why do we use a Typed DataSet?
How to run a Stored Procedure from .NET code?

More Interview Questions...

Design Patterns

Ajax

Security

ASP.NET

ASP.NET 2.0

Articles

SQL

OOPs

Framework

ADO.NET

100 Short Q-As

Difference Between Q-As

.NET Acronyms

Discussions

Super Mario Gamegreat free widgetsWidgetboxMore info

Know Your Breath, Know Your Life!!!