ADO.Net

Remoting 2.0

SQL Server

How to group based on multiple columns?
example : number of orders each employee has taken for customers with CustomerIDs between A and AO
SELECT CustomerID, EmployeeID, COUNT(*) FROM Orders WHERE CustomerID BETWEEN 'A' AND 'AO' GROUP BY CustomerID, EmployeeID

What happens if we use aggregate functions with out using group by?
Aggregates the entire result -- only one result is returned

Difference between these 2 queries:
SELECT COUNT(*) FROM Customers   -- gives total row count
SELECT COUNT(Fax) FROM Customers    -- ignores null values for Fax column

Difference between coalsce() and isnull
Select Avg(salary) from Employee  ---  What is the result of this query if some rows contains null for salary?
Difference between where and having clause
Discuss for xml, for xml raw, for xml auto
What is identity column? How to set the start value and increment value?
Example of insert into using select statement
Compare Delete and truncate statements
Is it possible to delete rows from multiple tables using delete statement?
Explain inner join, left, right and full outer joins
Explain null value comparsion when query uses join?
Output of this query:
IF (NULL= NULL)
PRINT 'It Does'
ELSE
PRINT 'It Doesn''t'

Explain this query:
SELECT DISTINCT c.CustomerID, c.CompanyName FROM Customers c INNER JOIN Orders o ON c.CustomerID = o.CustomerID

Union vs Union All
Union vs Inner Join

Does foreign key allows null values? Can we have foreign key constaint referring to a unique key in parent table?
Do we have cascade update / cascade delete in SQL Server? Where is it specified? In child tables only
Example of self referencing columns  like - employee having manager

Primary key vs unique key (alternate key) vs rowguid column vs identity column
How many null values a unique constraint column allows? - only one
Default values  -- they are applied only for insert -- not applicable for update / delete
Disabling constraints -- how to disable a constraint? Is it possible to disable primary or unique constraint?
How to add a constraint where data exists, and existing data should not be enforced by constraint ? Use NoCheck option
How to create a rule?
rule vs constraint  -- rule is exist to provide backward compatibility only
constraint vs default vs trigger
join vs sub query
sub query and correlated sub query
Use of exists, any, some, all, not exists operators
Exists vs IN  -- when writing a sub query?
Whether IN returns duplicate rows?
Exists Vs inner join -
CAST vs CONVERT
sub query vs join  and correlated query vs join?
explain Normalization
Why de normalizatin is requied?
How to enforce one to one relationship in SQL Server? It is not possible as such ( you can achieve this by taking care of insert thru stored procedures etc.)
Extent and data page
How many rows a data page can contain?
What is a page split?
Explain B-Trees and how SQL Server finds records in tables?
What if the clustered index is not unique?
Explain SysIndexes? What it contains and  in which database is it stored?
Covered Queries - Index include option
What are xml indexes? (new in sql server 2005)
Usage of DBCC -- Database Consistency Checker
DATEADD function
View can have triggers? What type?
Can views have relationships?
How to get last error, last inserted identity column value? No. of rows returned? -- @@ERROR,  @@IDENTITY, @@ROWCOUNT
Explain SQL CMD?
How to execute dynamic sql ? Exec or Execute
Stored Procedures Vs User Defined Functions?
Give an example of using CASE
How to handle erros? How to raise an error manually?
RAISEERROR and sp_addmessage
Describe Extended Stored Procedures?
What are lockable resources? Database, table, extent, page, row
Locks - shared , exclusive locks, Update Locks
Discuss different isolation levels:  READ COMMITTED (the default), READ UNCOMMITTED, REPEATABLE READ, SERIALIZABLE
What is deadlock? what is your aprroach to avoid deadlocks?
What is trigger? How many types of triggers are there? Explain in detail
Instead Of ,  For / After triggers
How many instead of triggers a table can have and how many after triggers a table can have? Explain
Is it possible for an instead of insert trigger to have insert statement?
Use of inserted and deleted tables in  after triggers
When a transaction is committed? Before firing after triggers or after firing 'after triggers'?   --- after firing 'after triggers'
Trigger timing and check constraint checking order --   check constraint are validated only after instead of triggers
Explain Recursive triggers?
Specifying trigger orders
How to find out whether a column is updated or not? -- UPDATE() Function
For XML RAW, AUTO , EXPLICIT
OpenXML

ASP.Net

Discuss Projectbased development vs Projectless development  -- deploying , debugging, adding assembly references etc...
Can we have a web site having different language code behinds for pages? One page C# , another one VB.Net?
Code behind model in .Net 1.1 and 2.0   -- CodeBehind , CodeFile properties
How Code-Behind Files Are Connected to Pages?
ASP.Net page life cycle
View State Chunking
XHTML compliance
Discuss important page properties
How to get context or read context info in a page?
How to read values posted in a request?
How to read query string values?
How to send multiple values in query string?
Request.Url and Request.Urlreferrer
Response.Redirect() Vs Server.Transfer vs Server.Execute()
How to get error occurred in a web application? Server.GetLastError()

usercontrol vs custom server control
usercontrol vs webpage  -- usage, declaration, events etc...
why usercontrol has page_load event?
how to register a usercontrol in webpage and web.config
How to convert a page in to user control?
How to read a value set in view state of usercontrol from a web page?
page.page_load vs user control page_load -- which one is called first, and finishes execution?
What is the use of customized eventargs?
dynamic loading of usercontrols  -- webparts in building a portal
How to set caching on a user control? 1. Outputcache 2 ParticalCaching attribute on usercontrol class
Explain 'VaryByControl' in caching? How it can be used and where it is used?
Is it possible to have pages having different languages in a project?
Where would you attach events in code file in VS 2.0?
Discuss and compare -- project less development (web site) vs  project (web application) mode
Code Behind in VS 1.1  Vs CodeFile in VS 2.0
No. of ways in setting a break point
Which controls requires AutoPostBack="true" for posting the page back to server wrt their events?
Page class useful properties -- Session, Cache, Application, Request, Response, Server, User, Trace
Discuss HTML and URL Encoding
Page class hierarchy --  Page -> TemplateControl -> Control
How to declare a hidden control?   <input type="hidden">
RegisterClientScriptBlock() and RegisterStartupScript() method
How to set focus on a control when page loads
Use of Default Button property
How to set a validation property for user control / custom control?  
-- set [ValidationProperty("Text")] for the control class
How to logically group a set of validation controls in a page?
CausesValidation is property of webcontrol
Difference between # and $ expressions in asp.net

control.ClientId
HtmlContainerControl  innerHTML and innerText properties
Discuss the ServerClick and ServerChange Events of html controls
Html control vs web control
How to perform input validation?
How to perform selective validation in a web page for a group of controls ?
Discuss RequiredField, Range, Compare, RegularExpressionValidators
How to write a customvalidator?
What is ValidationSummary control and how to use it?
When validation is performed at server side?

Use of Global.asax file? What are the events inside global.asax?
what is min number of web.config files required in a web application?
Discuss ProcessModel and machinekey elements in config file
Different config sections in a web.config?
How to create and register a custom config section?
How to set different config settings for a folder?
How to turn off overriding config settings in web.config?
How to read config info programmatically? -- Use System.Web.Configuration.WebConfigurationManager
use of <location> elements    -- allowoverride property
CustomErrors - On, off, remote only
Use of WAT tool
How to encrypt config file ?  command line utility  -- aspnet_regiis -pe
What is the file extension of a module and httphandler?
Ways of registering httphandlers?
How to read session in httphandlers?
use of httpmodules?
httphandler vs httpmodule?

Compare different state management techniques:  ViewState, Session, ApplicationState, Cookie, QueryString, Profile
SessionState vs profile
When Data is read from and written to ViewState?
How to tamper proof ViewState? EnableViewStateMac
Is it required to be serializalbe for a custom object in order to store in ViewState and Session? Is it mandatory?
Discuss cross page posting and page events, IsPostback, IsCrossPagePostBack
How to accessing previous page in a page for cross page post back?
How to detect postback, crosspage postback and server.transfer() cases?
Validation in CrossPage PostBack situation
How to add cookie, store and read values from cookie?
When SessionId is created? How it is transferred back and forth?
Configuring SessionState for browsers which supprot cookie and do not support cookies in single configuration?
Discuss various session modes?
Whether SessionState cookie is different from authentication cookie?
Does view state is required to be enabled for a TextBox?
In case of http-post entire form (all controls) is submitted. If all controls state can be repopulated from view state, then why is it required to include all controls in post back

request rather than hidden view state field?
What are the properties of controls which do not need view state?
When Data is written to ViewState and read from ViewState?
Can ViewState store the change of control state happened in client side (by user / java script changes) ?
ViewState Chunking


What is the base class of a Master Page?
Execution order  -- Master page . page_load  , content page . Page_load?
How to communicate between master page and content page?
How many ways a master page can be set for a content page?
How to refer specific master page type in a content page code?  typecast page.master or <%@ MasterType VirtualPath="~/SiteTemplate.master" %>
How to access a control in Master Page from content page code? user master page FindControl() method
Discuss nesting of master pages?
What should be the url if Master page contains two content pages?
What happens if content page is not implementing all content place holders inside a master page?
How to resovle path issues in Master pages for images, files ...etc?
Compare a usercontrol vs master page?
Themes vs StyleSheets?
What is skin file? Is it possible for to have multiple skin files inside a theme folder? If so, what about conflicts in skin files?
How many skin files a theme folder can contain? Are there any restrictions on that?
What is skinid? How to use it? What is enablethemeing property?
How to set themes for web page, entire web application?
Compare -- Stylesheet file, inline style, control having style and theme -- which one wins?
Explain this situation and what style applied for a control if it has style specified in control itself, style through stylesheet and theme? Which one wins and why?
Handling theming conflicts -- explain StyleSheetTheme property?
Why themes are required? Why can't u use stylesheets in place of themes? Do themes replaces CSS stylesheets?
How to make specific control opt out of theming?
Named Skins... What happens if all skins are named, and no skin is specified in control?
How to set a theme for entire web site and disable it for a single web page?
Where Theme,StyleSheetTheme,SkinId, EnableTheming properties can be used? for Page or control?

ADO.Net  - Connected layer vs disconnected layer
Discuss Data Provider Factory
Storing a connecting string in AppSettings vs ConnectionStrings
DataReader vs DataAdapter
How to read row from DataReader? How to read second / multiple results from data reader?
If there is an error while executing sql statement / stored proc using ExecuteReader method ... when this error is visible in code? Is it when calling executereader() or Read()

method? explain in multiple results situation
Is it required to Open() the sqlconnection for DataReader and DataAdapter?
How to execute a UDF (function)  using SqlCommand?
is it possible to execute queries asnchronously using sqlcommand object?
how to read out param from stored proc in ADO.Net?
How to creat a DataRow for a given table?
DataRowState, DataRowVersion
How to filter data in DataTable? Sort data?
How to establish primary key - foreign key relationship in dataset tables? How to get child records?
CommandType.TableDirect of SqlCommand

Rich data contorls :
Discuss GridView, DetailsView,FormsView, ListView

How to set OutputCache?
Discuss varybyparam, varybyheader, varybycustom, varybycontrol properties             varybyparam='browser'
Fragment caching and post cache substitution
How to set cache profiles
DataCaching and datasource caching (Caching with the Data Source Controls)
Is the Cache object thread safe?
Discuss CacheDependencies?
Caching with sqldatasource, objectdatasource
File and Cache Item Dependencies
Handling Itemremoved callback
Custom Cache dependencies
Discuss Asynchronous pages

Authentication
Authorization
Profiles

Directory, File classes vs driveinfo, directoryinfo, fileinfo classes
How to upload a file to a website? FileUpload control

How to specify namespace in xml file?
Well formed xml document
xml schema vs .dtd file
How to read and write xml files programmatically?
Reading / navigating through xml files using xmldocument, xpathnavigator and xdocument (LINQ)
THE XMLDOCUMENT AND USER CONCURRENCY
Xmldocument  -> Load() vs LoadXml()
Searching xml elements with XPath
Xmldocument.Load() vs Xdocument.Load()
asp.net xml control vs asp.net xmldatasource

Themes

Compare CSS with Themes

how do you use these attributes CssClass, class, for CSS

what is a skin file, what does it contain,

how do you use attributes skinID, Theme, StylesheetTheme, EnableTheming

what happens if control and theme defines same property

C#

Different Output Options of the C# Compiler: /out /target:exe /target:library /target:module /target:winexe
Referencing external assemblies using CSC: 
csc /r:System.Windows.Forms.dll TestApp.cs      csc /r:System.Windows.Forms.dll;System.Drawing.dll *.cs
What is Response file when using CSC?
What are different variations of Main method? Discuss significance of return code of Main method?
How to specify command line arguments for Main method?    -arg1 -arg2
Discuss Variable Declaration and Initialization for value types and reference types
How to find out if given char is digit or letter or whitespace ? char.IsDigit(), char.IsLetter(), char.IsWhiteSpace()
String is reference type of value type? Why strings are immuatable?
Difference between System.String and System.Text.StringBuidler?
If a class contains value type members , where these members are stored ...in stack or heap?
What is boxing and unboxing?
.Equal  vs == ?
unchecked keyword?
System.Convert vs .Parse?
Difference between while and dowhile?
Does Switch allows fall through?
Discuss ref, out, params
Discuss passing by value and passing ref for value types and ref types
overload vs override
Different ways of overloading a method?
abstract override vs virtual override
Array -- is a ref type or value type?
If you store integers in Arrays - where they'll be stored?
How to create Multi dimensional , rectangular and jagged arrays?
What is the underlying storage type for enum? How to customize that?
value type vs reference type
structure vs class
Structures can implement interfaces? Can inherit from other struct ? Can have reference type members?
Structures can have default constructor? What is required to have a custom constructor in terms of parameters?
What are nullable types? How to compare if nullable type has value? Is it possible to reassign nullable type to a null?
?? dealing with nullable types
Static members vs instance members
Usage of static constructors
Discuss static classes? Can they inherit other classes?
Discuss Pillars of OOP? Encapuslation, Inheritance and Polymorphism
Encapsulation vs abstraction
Discuss Protected internal
How to define read-only or write-only properties? How to have public get and private set
What are static properties?
Default access modifiers for class, members
How to call a base class constructor? Overloaded constructor in same class?
How to read command line arguments ? Environment.GetCommandLineArgs()
System.Environment properites  -- ExitCode, MachineName, UserName,StackTrace
Formatting numeric data
checked vs unchecked keywords
for loop vs foreach loop
while vs do while loop
string vs strinbuilder
why strings are immutable?
memory size of DateTime and TimeSpan ?
Constant vs read only?
Static read only vs constant?
Advantages of partial types? Can partial type differnt inerfaces on differnt files?
NDoc
sealed
How to prevent derived class overriding a virtual method?
Abstract class vs interface
Discuss Member shadowing
Usage of 'is' and 'as' keywords
If Object.Equals() is overridden then override .GetHashCode() also
System.Exception vs System.ApplicationException vs SystemException
Explain HelpLink, StackTrace, TargetSite, Source of Exception, Data
What Methods / constructors needs to be implemented to write a custom exception?
How to throw and rethrow exceptions?
Discuss Garbage Collector and Object Generations
GC.Collect()  , SuppressFinalize(), WaitForPendingFinalizers()
Finalizable objects vs disposable objects
Can a class override Object.Finalize() ?
Can we override a protected virtual method?
How to provide finalization functionality in a class?
Can we add / modify / remove items for an ArrayList which is exposed as read only property in a class?
can we use is keyword to compare a interface and an object whose class implements that interface?
How to return interface types? Can we return null in such methods?
Discuss explicit interface implementation? Calling such methods, access modifiers for such methods?
Array.GetEnumerator()  --
Discuss Named Iterators and yield
IComparable vs IComparer
discuss IList, ICollection, and IDicitionary
Members of Queue type and Stack type?
Specialized collections objects -> CollectionsUtil, HybridDictionary, ListDictionary, NameValueCollection, StringCollection,

StringDictionary
where T : new()  in generics?
DynamicInvoke method of a delegate
Can delegates points to a method which takes out and ref parameters?
Contravariance and covariance in delegates
Exposing an event vs delegate
System.Predicate<T>  -- a delegate wrapping a method which returns bool
is it possible to create indexer with multiple dimensions? If so how?
Can interfaces define indexers?
Operator overloading? what are sets?
Explicit conversions using 'explicit' keyword
explain unsafe keyword
SizeOf -- can we use it on reference types?
use of preprocessor directives
What are the restrictions imposed on implicitly typed variables? var
Can we have nullable implicit types? (Implicit Typed Data Is Strongly Typed Data)
Automatic properties -- Is it possible to build read only / write only properties using automatic properties?
public string PetName { get; protected set; }   -- is it possible to define like this?
Usage of extension methods  --- versioning on extension methods?
Example of Extending Interface Types via Extension Methods
Discuss partial methods (implicitly private, returns void)  -- can they have out and ref parameters?
usage of partial methods  --- lightweight events
Explain object initializers and Anonymous types - what are limitations?
How to define namespace alias?
private assembly vs public assembly?
What is GAC? How to install an assembly in to GAC?
What is strong name key? How to generate one? Delay signing
Parts of an assembly
Assembly probing
BindingRedirect -- config
can we re-use a key for different versions of same assembly .. or for multiple assemblies?
Discuss publisher policy
codebase element
How to read appsettings programmatically?
How to read a key and value in appsettings in a config file?
Practical usage of reflection?
Early binding vs late binding
System.Activator   --- createInstance
MethodInfo -- how to invoke a method at run time and get the result?
How to start a process / service? process, ProcessStartInfo
Discuss process, appdomain and object context boundary
Context agile and context bound types
How to handle the error which is thrown in a method, when calling this method asnychronously?
What happens to a worker thread execution if unhandled error ocurrs?
thread exception and completed events can be registered and handled
Foreground thread vs background thead
Different System.IO clasess and methods used to create a file, read a file, write a file
FileStream,  MemoryStream and BufferedStream
StreamWriter, Stream, StringWriter, StringReader, TextWriter, TextReader,BinaryWriter , BinaryReader
FileSystemsWatcher
Code Access Security
[Serializable]  -- if a class is decorate with this attribute -- all private, public memebers are serialized?
What formatter will be used in above case?
Binary formmater namespace, xml and soap formatters namespaces?
Are there any common set of members between these 3 formatters? What is the base class for each one of these formatters?
The IFormatter and IRemotingFormatter Interfaces
TypeFidelity among formatters?
Serializtion attribute vs ISerialization
How to customize the process of serialization 
1. ISerialization 2. Attributes [OnSerializing], [OnSerialized], [OnDeserializing], or [OnDeserialized]  from .net 2.0 onwards

ADO.Net  - Connected layer vs disconnected layer
Discuss Data Provider Factory
Storing a connecting string in AppSettings vs ConnectionStrings
DataReader vs DataAdapter
How to read row from DataReader? How to read second / multiple results from data reader?
If there is an error while executing sql statement / stored proc using ExecuteReader method ... when this error is visible in

code? Is it when calling executereader() or Read() method? explain in multiple results situation
Is it required to Open() the sqlconnection for DataReader and DataAdapter?
How to execute a UDF (function)  using SqlCommand?
is it possible to execute queries asnchronously using sqlcommand object?
how to read out param from stored proc in ADO.Net?
How to creat a DataRow for a given table?
DataRowState, DataRowVersion
How to filter data in DataTable? Sort data?
How to establish primary key - foreign key relationship in dataset tables? How to get child records?

LINQ

What is LINQ? Why do we need LINQ? Discuss Advantages and disadvantages of LINQ?
Compare ADO.Net vs LINQ to SQL
Compare LINQ to SQL vs LINQ to Entities
Compare XML API to LINQ to XML
Compare LINQ to Xml characteristics vs XML DOM Characteristics
Compare Differed loading (executing) vs immediate loading?
How to read from .mdf file?
What are lamba expressions?
Compare lambda expressions with anonymous methods?
How to write a lambda expression which takes two parameters? Where is the return type specified?
SelectMany  vs Select
Selecting Authors when querying books?
Design Patterns in LINQ?
Discuss few query operators like Where, Select, Join, OrderBy, GroupBy, Skip, Take, Except, Distinct, All, Any,OfType,
Interset, Union,DefaultIfEmpty, Empty, Range, Repeat, First, Last,Single, SingleOrDefault
How to write left outer join? Expalin DefaultIfEmpty
What are ExpressionTrees?
Discuss IQueryable  .. Compare it with IEnumerable
Discuss accessing Array and ArrayList using LINQ
How to write Nested Queries in LINQ?
Explicit and implicit casting when using ArrayList in LINQ
Explain Grouping by multiple criteria
How to parameterize a LINQ query?
How to call custom methods in LINQ expression?
Explain creating a query at runtime using ExpressionTree
Discuss LINQ to TextFiles
Design Patterns: The Functional Construction pattern, The ForEach pattern
What operators execute immediately?
Answer  -- Aggregate, Average, Count, LongCount, Max, Min, and Sum    OrderBy, OrderByDescending, and Reverse
How to write a join query with out using 'join' keyword?
How to map a Table to a class ?
How to represent primary, foreign key and constraints?
How to load details when loading a (master)table?  DataLoadOptions?
DataLoadOptions.LoadWith<Subject>
Discuss ObjectTrackingEnabled  of DataContext?
ChangeConflictException
How to handle transactions?
use of TransactionScope object
How to execute sql queries from Datacontext?
CompiledQuery.Compile
ADO.Net Entity Framework , Entity Data Model
XElement Vs XDocument
How to Create an XElement from an existing XmlReader? from a fragment of XML contained within an XmlReader?
Descendants vs DescendantsAndSelf
ancestors, ElementsAfterSelf, NodesAfterSelf, ElementsBeforeSelf, and NodesBeforeSelf