IQS

1.     Difference between Buld,Rebuild and Clean solution?

Ø  Build: This will perform an incremental build. In other words it will only build code files which have changed. If they have not changed those files will not be touched.

Ø  Re-Build:This will delete all currently compiled files (i.e., exe and DLLs) and will build everything from scratch, irrespective of if there is code change in the file or not.

Ø  Clean Solution: This menu will delete all compiled files (i.e., EXE’s and DLL’s) from the bin/obj directory.

   Rebuild = Clean + Build

2.     Difference between debug and realease?

Ø  Debug has extra checking, extra initialisaton and other features which makes locating problems easier, it is also not optimised to make debugging make more sense. Because of all of these settings though, the debug mode version runs at a fraction of the speed of the release mode.

Ø  Release mode has none of the initialisation of released mode. Where debug mode allocates memory, sets it to a value (which is never null, so it is always a good idea to initialise it yourself anyway) and then gives it to you, release mode just allocates the memory and gives it to you. Release mode also has none of the extra checking of debug mode. Finally release mode is optimised. All of these added together gives a large speed boost over debug mode.

3.     Difference between View data and View bag?

Data	ViewBag	TempData
It is Key-Value Dictionary collection	It is a type object	It is Key-Value Dictionary collection
ViewData is a dictionary object and it is property of ControllerBase class	ViewBag is Dynamic property of ControllerBase class.	TempData is a dictionary object and it is property of controllerBase class.
ViewData is Faster than ViewBag	ViewBag is slower than ViewData	NA
Type Conversion code is required while enumerating	In depth, ViewBag is used dynamic, so there is no need to type conversion while enumerating.	Type Conversion code is required while enumerating
It value become null if redirection is occurred.	Same as ViewData	TempData is used to pass data between two consecutive requests.
It lies only during the current request.	Same as ViewData	TempData is only work during the current and subsequent request

4.     Difference between Throw and Throw ex?

Ø  Throw: In Throw, the original exception stack trace will be retained. To keep the original stack trace information, the correct syntax is 'throw' without specifying an exception.

Ø  Throw ex: In Throw ex, the original stack trace information will get override and you will lose the original exception stack trace. I.e. 'throw ex' resets the stack trace.

5.     Difference between View and Temptable?

Ø  View is just a definition, it is not storing any data. So every time it is used, it queries data from the real source table. If the data in source table changes, you will see the changes from the view as well. In terms of performance, it is not going to help, maybe worse? BTW, a view exists after the session.

Ø   Temp table is really storing the data, so it faster the performance, but it only exist within the session. And if the data in source table changes, you won't automatically see the changes from the temp table unless you re-create it.

6.     Difference between Finalize and Dispose?

Dispose:

Ø  It is used to free unmanaged resources like files, database connections etc. at any time.

Ø  Explicitly, it is called by user code and the class which is implementing dispose method, must has to implement IDisposable interface.

Ø  It belongs to IDisposable interface.

Ø  There is no performance costs associated with Dispose method.

Finalize:

Ø  It can be used to free unmanaged resources (when you implement it) like files, database connections etc. held by an object before that object is destroyed.

Ø  Internally, it is called by Garbage Collector and cannot be called by user code.

Ø  It belongs to Object class.

Ø  There is performance costs associated with Finalize method since it doesn't clean the memory immediately and called by GC automatically.

7.     Page life cycle

8.     In which event View state load?

Ø  It's loaded into memory between init and load.

9.     What is Preinit?

10. Isolation levels in sql

Ø  Following are the different types of isolations available in SQL Server.

·         READ COMMITTED

·         READ UNCOMMITTED

·         REPEATABLE READ

·         SERIALIZABLE

·         SNAPSHOT

·          

11.   CTS?