This PDF has sample questions which is extracted from my two
books .NET Interview questions and SQL Server interview
questions.
This PDF is only a small glimpse of the two books its much
more that what you see in this PDF. I have ensured that both
the books are really at a very cheap cost so that every one will
be benefited. Any of my book do not exceed 200 INR. For more
details mail at [email protected]
Second the books also have CD’
get with this sample PDF
who stops you...Happy Job Hunting.
How to buy the book
incase its not near to your place mail [email protected].
If you are from India you can contact one of the shops below:-MUMBAI-22078296/97/022-22070989 KOLKATA-22826518/19 HYDERABAD-24756967,24756400 BANGALORE-25587923,25584641 AHMEDABAD-26421611 BHATINA(PUNJAB)-2237387, CHENNAI-28410796,28550491 DELHI/NEW DELHI-23254990/91,23325760,26415092,24691288
Second the books also have CD’s with them which you will not
get with this sample PDF....But still if you want to enjoy free
who stops you...Happy Job Hunting.
How to buy the book
BPB has done a great job of making this book reach to places where i can hardly imagine. But just incase its not near to your place mail [email protected].
If you are from India you can contact one of the shops below:-MUMBAI-22078296/97/022-22070989 KOLKATA-22826518/19 HYDERABAD-24756967,24756400 BANGALORE-25587923,25584641 AHMEDABAD-264216111 BHATINA(PUNJAB)-2237387, CHENNAI-28410796,28550491 DELHI/NEW DELHI-23254990/91,23325760,26415092,24691288 Pakistan
M/s. Vanguard Books P Ltd, 45 The Mall, Lahore, Pakistan (Tel: 0092-42-7235767, 7243783 and 7243779 and Fax: 7245097)
E-mail: [email protected]
If you are not from india or pakistan
:-Ray McLennan, director,Motilal (UK) Books of India,367 High Street. London Colney,
St.Albans, Hertfordshire,AL2 1EA, U.K. Tel. +44 (0)1727 761 677,Fax.+44 (0)1727 761 357,[email protected],www.mlbduk.com
Want to buy from online
:-.NET Interview Questions From Prakash books
http://www.prakashbooks.com/details.php3?id=17875&c=Computer Books.prakashbooks.com/details.php3?id=17875&c=Computer Books
Amazon .amazon.co.uk/exec/obidos/ASIN/8183330770/qid%3D1 .prakashbooks.com/details.php3?id=19008&c=Computer Books Amazon .amazon.co.uk/exec/obidos/ASIN/8183331033/qid%3D1 .prakashbooks.com/details.php3?id=17875&c=Computer Books Amazon .amazon.co.uk/exec/obidos/ASIN/8183330770/qid%3D1 If you want to buy from AmazonAmazon
.amazon.co.uk/exec/obidos/ASIN/8183330770/qid%3D1
http://www.amazon.co.uk/exec/obidos/ASIN/8183330770/qid%3D1139594062/026-8105897-7667603
SQL Server Interview Questions From Prakash books
http://www.prakashbooks.com/details.php3?id=19008&c=Computer Books
If you want to buy from Amazon
http://www.amazon.co.uk/exec/obidos/ASIN/8183331033/qid%3D1 2263615#product-details
[email protected] or [email protected]
Books written by Shivprasad Koirala
-- .NET Interview questions
-- SQL Server Interview questions
-- Java Interview questions
-- How to prepare software quotation?.(
you can get it from www
http://www.prakashbooks.com/details.php3?id=19008&c=Computer Books
If you want to buy from Amazon
http://www.amazon.co.uk/exec/obidos/ASIN/8183331033/qid%3D1136610981/026-1344994-2263615#product-details
If you want to purchase the book directly through BPB Publication's delhi , India :[email protected] or [email protected]
Books written by Shivprasad Koirala
-- .NET Interview questions
-- SQL Server Interview questions
-- Java Interview questions
-- How to prepare software quotation?.( This book is on estimation
you can get it from www.questpond.com as free download)
-- C# Projects
-- Software testing Interview questions
-- Understanding Hackers Mind
.NET Interview Questions
Sample book
(Including SQL Server,UML,Architecture,Pr
Management , ASP.NET 2.0 , Sample pr
and General Interview Questions )
Sample book
By:- Shivprasad koirala
Mail:- [email protected]
(Including SQL Server,UML,Architecture,Project
Management , ASP.NET 2.0 , Sample project ,XML
and General Interview Questions )
ASP
Happy job hunting...
Do not forget that database is also important. Buy my SQL
Server Interview questions to crack any database related
questions.
From the Author
First thing thanks to all those who have sent me complaints and also appreciation for what ever titles i have written till today. But interview question series is very near to my heart as i can understand the pain of searching a job. Thanks to my publishers (BPB) , readers and reviewers to always excuse all my stupid things which i always do.
So why is this PDF free ?. Well i always wanted to distribute things for free specially when its a interview question book which can fetch a job for a developer. But i am also bounded with publish-ers rules and regulations. And why not they have a whole team of editor, printing guys, designpublish-ers, distributors, shopkeepers and including me. But again the other aspect, readers should know of what they are buying , the quality and is it really useful to buy this book. So here are sample free ques-tions which i am giving out free to the readers to see the worth of the book.
W
And why not they have a whole team of editor
I can be contacted at [email protected] its bit difficult to answer all answers but as i get time i do it.
We have recently started a career counselling drive absolutely free for new comers and experienced guys. So i have enlisted the following guys on the panel. Thanks to all these guys to accept the panel job of consulting. Feel free to shoot them questions just put a title in the mail saying “Question about Career”. I have always turned up to them when i had some serious career decision to take.
Shivprasad Koirala :- Not a great guy but as i have done the complete book i have to take up one of the positions. You can contact me at [email protected] for technical career aspect.YY
Y
Tapan Das :- If you think you are aiming at becoming a project manager he is the right person to consult. He can answer all your questions regarding how to groom your career as a project manager [email protected].
Kapil Siddharth :- If you are thinking to grow as architect in a company then he is a guy. When it comes to role model as architect i rate this guy at the top. You can contact him at
Second if you think you can help the developers mail me at [email protected] and if i find you fitting in the panel i will display your mail address. Please note there are no financial rewards as such but i am sure you will be proud of the work you are doing and whos knows what can come up.
Career Path Institute
Author runs the “Software Career Path Institute” personally in mumbai. If you are interested you can contact him regarding admissions at [email protected]. Please note i do not have cur-rently any huge setup. So if you are looking for some cozy institute forget it. But yes you will defi-nitely get the in-depth knowledge which you will not get anywhere.
rently any huge setup. So if you are looking for some cozy institute for nitely get the in-depth knowledge which you will not get anywhere.
from mumbai people.
rently any huge setup. So if you are looking for some cozy institute for nitely get the in-depth knowledge which you will not get anywhere.
from mumbai people.
nitely get the in-depth knowledge which you will not get anywhere.
from mumbai people.
So want to join my small institute then call me at 9892966515. Please note currently its only from mumbai people.
www.questpond.com
www
Contents
How to buy the book ... 67
ow to buy the book ...
rom the Author ...
areer Path Institute ...
ntroduction...
oftware Company hierarchy ...esume Preparation Guidelines ... alary Negotiation ... oints to remember ...
. Basic .NET Framework ...
hat is a IL? ...
wist :- What is MSIL or CIL , What is JIT? ...
y the book ...
Author ...
th Institute ...
ion...
any hierarchy ... ation Guidelines ... ion ... ber ...ET Framework ...
...MSIL or CIL , What is JIT? ...
From the Author ... 70
Career Path Institute ... 71
Institute ...
n...
y hierarchy ... on Guidelines ... n ... er ...T Framework ...
...Introduction... 85
Software Company hierarchy ... 89
Resume Preparation Guidelines ... 91
Salary Negotiation ... 93...
...
Framework ...
... or CIL , What is JIT? ... ... ... Points to remember ... 951. Basic .NET Framework ... 98
What is a IL? ... 98
Twist :- What is MSIL or CIL , What is JIT? ... 98
What is a CLR? ... 98
What is a CTS? ... 98
What is a CLS(Common Language Specification)? ... 99
What is a Managed Code? ... 99
What is a Assembly? ... 99
What are the different types of Assembly? ... 100
What is NameSpace? ... 100
What is Difference between NameSpace and Assembly? ... 100
If you want to view a Assembly how do you go about it ? ... 100
Twist : What is ILDASM ? ... 100
What is Manifest? ... 102
Where is version information stored of an assembly ? ... 103
Is versioning applicable to private assemblies? ... 103
What is GAC ? ... 103
Twist :- What are situations when you register .NET assembly in GAC ? ... 103
What is the concept of strong names ? ... 103
Twist :- How do we generate strong names or what is the process of generating strong names, What is use the of SN.EXE , How do we apply strong names to assembly, How do you sign an assem-bly? ... 103
How to add and remove an assembly from GAC? ... 107
What is Delay signing ? ... 108
What is garbage collection? ... 109
Can we force garbage collector to run ? ... 109
What is reflection? ... 109
What are different types of JIT ? ... 110
What are Value types and Reference types ? ... 111
What is concept of Boxing and Unboxing ? ... 111
What is the difference between VB.NET and C# ? ... 112
What is the difference between System exceptions and Application exceptions? ... 113
How to prevent my .NET DLL to be decompiled?... 114
What is the difference between Convert.toString and .toString() method What is Native Image Generator (Ngen.exe)? ... We have two version of the same assembly in GAC? I want my client to assembly to choose? ... What is CodeDom? ...
2..NET Interoperability ...
How can we use COM Components in .NET? ... Twist : What is RCW ? ... Once I have developed the COM wrapper do I have to still register the C How can we use .NET components in COM? ... Twist :- What is CCW (COM callable wrapper) ?, What caution needs to components is compatible with COM ? ... What is the difference between Convert.toString and .toString() method ? ... 114What is Native Image Generator (Ngen.exe)? ... We have two version of the same assembly in GAC? I want my client to mak assembly to choose? ... What is CodeDom? ...
2..NET Interoperability ...
How can we use COM Components in .NET? ... Twist : What is RCW ? ... Once I have developed the COM wrapper do I have to still register the COM How can we use .NET components in COM? ... Twist :- What is CCW (COM callable wrapper) ?, What caution needs to be ta components is compatible with COM ? ... How can we make Windows API calls in .NET? ... When we use windows API in .NET is it managed or unmanaged code ? ... What is COM ? ... What is Reference counting in COM ? ... Can you describe IUKNOWN interface in short ? ... Can you explain what is DCOM ? ... How do we create DCOM object in VB6? ... How to implement DTC in .NET ? ... How many types of Transactions are there in COM + .NET ? ... What is Native Image Generator (Ngen.exe)? ... 115What is Native Image Generator (Ngen.exe)? ... We have two version of the same assembly in GAC? I want my client to make assembly to choose? ... hat is CodeDom? .....NET Interoperability ...
How can we use COM Components in .NET? ... wist : What is RCW ? ... Once I have developed the COM wrapper do I have to still register the COM i ow can we use .NET components in COM? ... wist :- What is CCW (COM callable wrapper) ?, What caution needs to be ta components is compatible with COM ? ... ow can we make Windows API calls in .NET? ... hen we use windows API in .NET is it managed or unmanaged code ? ... hat is COM ? ... What is Reference counting in COM ? ... What is Native Image Generator (Ngen.exe)? ... We have two version of the same assembly in GAC? I want my client to make assembly to choose? ... hat is CodeDom? .....NET Interoperability ...
How can we use COM Components in .NET? ... wist : What is RCW ? ... Once I have developed the COM wrapper do I have to still register the COM i ow can we use .NET components in COM? ... wist :- What is CCW (COM callable wrapper) ?, What caution needs to be tak components is compatible with COM ? ... ow can we make Windows API calls in .NET? ... hen we use windows API in .NET is it managed or unmanaged code ? ... hat is COM ? ... What is Reference counting in COM ? ... Can you describe IUKNOWN interface in short ? ... an you explain what is DCOM ? ... We have two version of the same assembly in GAC? I want my client to assembly to choose? ... What is CodeDom? ...2..NET Interoperability ...
How can we use COM Components in .NET? ... Twist : What is RCW ? ... Once I have developed the COM wrapper do I have to still register the C How can we use .NET components in COM? ... Twist :- What is CCW (COM callable wrapper) ?, What caution needs to components is compatible with COM ? ... How can we make Windows API calls in .NET? ... When we use windows API in .NET is it managed or unmanaged code ? .. What is COM ? ... What is Reference counting in COM ? ... Can you describe IUKNOWN interface in short ? ... Can you explain what is DCOM ? ... How do we create DCOM object in VB6? ... How to implement DTC in .NET ? ... How many types of Transactions are there in COM + .NET ? ... How do you do object pooling in .NET ? ... What are types of compatibility in VB6? ... What is equivalent for regsvr32 exe in .NET ? ...3. Threading ...
What is Multi-tasking ? ... What is Multi-threading ? ... What is a Thread ? ... Did VB6 support multi-threading ? ... Can we have multiple threads in one App domain ? ... We have two version of the same assembly in GAC? I want my client to make choice of which assembly to choose? ... 116What is CodeDom? ... 124
2..NET Interoperability ...
How can we use COM Components in .NET? ... Twist : What is RCW ? ... Once I have developed the COM wrapper do I have to still register t2..NET Interoperability ... 128
How can we use COM Components in .NET? ... 128
Twist : What is RCW ? ... 128
Once I have developed the COM wrapper do I have to still register the COM in registry? ... 129
How can we use .NET components in COM? ... 129
Twist :- What is CCW (COM callable wrapper) ?, What caution needs to be taken in order that .NET components is compatible with COM ? ... 129
How can we make Windows API calls in .NET? ... 132
When we use windows API in .NET is it managed or unmanaged code ? ... 134
What is COM ? ... 134
What is Reference counting in COM ? ... 134
Can you describe IUKNOWN interface in short ? ... Can you explain what is DCOM ? ... How do we create DCOM object in VB6? ... How to implement DTC in .NET ? ... How many types of Transactions are there in COM + .NET ? ... How do you do object pooling in .NET ? ... Can you describe IUKNOWN interface in short ? ... 134ou describe IUKNOWN interface in short ? ... u explain what is DCOM ? ... o we create DCOM object in VB6? ... implement DTC in .NET ? ... any types of Transactions are there in COM + . o you do object pooling in .NET ? ... re types of compatibility in VB6? ... s equivalent for regsvr32 exe in .NET ? ...
reading ...
s Multi-tasking ? ... s Multi-threading ? ... s a Thread ? ... 6 support multi-threading ? ... e have multiple threads in one App domain ? ... namespace has threading ? ... Can you explain what is DCOM ? ... 135How do we create DCOM object in VB6? ... 136
How to implement DTC in .NET ? ... 136
How many types of Transactions are there in COM + .NET ? ... 138
How do you do object pooling in .NET ? ... 139
What are types of compatibility in VB6? ... 140
What is equivalent for regsvr32 exe in .NET ? ... 141
3. Threading ... 142
hreading ...
is Multi-tasking ? ... is Multi-threading ? ... is a Thread ? ... B6 support multi-threading ? ... e have multiple threads in one App domain ? ... namespace has threading ? ... What is Multi-tasking ? ... What is Multi-threading ? ... What is a Thread ? ... Did VB6 support multi-threading ? ... Can we have multiple threads in one App domain ? ... Which namespace has threading ? ... Can you explain in brief how can we implement threading ? ... How can we change priority and what the levels of priority are provided by . What is Multi-tasking ? ... 142What is Multi-threading ? ... 142
What is a Thread ? ... 142
Did VB6 support multi-threading ? ... 142
Can we have multiple threads in one App domain ? ... 142
Which namespace has threading ? ... 142
Can you explain in brief how can we implement threading ? ... 142
How can we change priority and what the levels of priority are provided by .NET ? ... 143
What does AddressOf operator do in background ? ... 144
How can you reference current thread of the method ? ... 144
What's Thread.Sleep() in threading ? ... 144
How can we make a thread sleep for infinite period ? ... 144
What is Suspend and Resume in Threading ? ... 144
What the way to stop a long running thread ? ... 145
How do I debug thread ? ... 145
What is Thread.Join() in threading ? ... 146
What are Daemon threads and how can a thread be created as Daemon? ... 146
When working with shared data in threading how do you implement synchronization ? ... 146
What is a monitor object? ... 147
What are wait handles ? ... 148ndles ? ... mutex object ? ... esetEvent and AutoResetEvent ? riter Locks ? ... id deadlock in threading? ... ence between thread and process? Twist :- What is a mutex object ? ... 148hat is a mutex object ? ... anualResetEvent and AutoResetEvent ? ... eaderWriter Locks ? ... you avoid deadlock in threading? ... he difference between thread and process? ...
oting and Webservices ...
n application domain? ... NET Remoting ? ... ass does the remote object has to inherit ? ... two different types of remote object creation mode in .N in detail Basic of SAO architecture of Remoting? ... the situations you will use singleton architecture in rem undamental of published or precreated objects in Remoti What is ManualResetEvent and AutoResetEvent ? ... 148What is ReaderWriter Locks ? ... 148
How can you avoid deadlock in threading? ... 149
What is the difference between thread and process? ... 149
4. Remoting and Webservices ... 150
What is an application domain? ... 150t is an application domain? ... at is .NET Remoting ? ... ich class does the remote object has to inherit ? ... at are two different types of remote object creation mode in .NET ? ... cribe in detail Basic of SAO architecture of Remoting? ... at are the situations you will use singleton architecture in remoting ? ... at is fundamental of published or precreated objects in Remoting ? ... at are the ways in which client can create object on server in CAO model ? ... CAO stateful in nature ? ... AO model when we want client objects to be created by “NEW” keyword is th ions to be taken ? ... t a good design practice to distribute the implementation to Remoting Client ? .. at are LeaseTime, SponsorshipTime, RenewonCallTime and LeaseManagerPoll ich config file has all the supported channels/protocol ? ... can you specify remoting parameters using Config files ? ... Non-Default constructors be used with Single Call SAO? ... t :- What are the limitation of constructors for Single call SAO ? ... can we call methods in remoting Asynchronously ? ... at is Asynchronous One-Way Calls ? ... at is marshalling and what are different kinds of marshalling ? ... at is ObjRef object in remoting ? ... What is .NET Remoting ? ... 150
Which class does the remote object has to inherit ? ... 151
What are two different types of remote object creation mode in .NET ? ... 151erent types of remote object creati l Basic of SAO architecture of Rem ations you will use singleton archit ntal of published or precreated obje s in which client can create object in nature ? ... hen we want client objects to be cr en ? ... n practice to distribute the impleme ime, SponsorshipTime, RenewonC has all the supported channels/pro Describe in detail Basic of SAO architecture of Remoting? ... 151
What are the situations you will use singleton architecture in remoting ? ... 156
What is fundamental of published or precreated objects in Remoting ? ... 156What is fundamental of published or precreated objects in Remoting ? ... What are the ways in which client can create object on server in CAO model ? ... Are CAO stateful in nature ? ... In CAO model when we want client objects to be created by “NEW” keyword is tions to be taken ? ... Is it a good design practice to distribute the implementation to Remoting Client What are LeaseTime, SponsorshipTime, RenewonCallTime and LeaseManagerP Which config file has all the supported channels/protocol ? ... How can you specify remoting parameters using Config files ? ... Can Non-Default constructors be used with Single Call SAO? ... wist :- What are the limitation of constructors for Single call SAO ? ... How can we call methods in remoting Asynchronously ? ... What is Asynchronous One-Way Calls ? ... What is marshalling and what are different kinds of marshalling ? ... What is ObjRef object in remoting ? ... What is a Web Service ? ... What is UDDI ? ... What is DISCO ? ... What is WSDL? ... What are the ways in which client can create object on server in CAO model ? ... 156
Are CAO stateful in nature ? ... 157
In CAO model when we want client objects to be created by “NEW” keyword is there any precau-tions to be taken ? ... 157
Is it a good design practice to distribute the implementation to Remoting Client ? ... 158
What are LeaseTime, SponsorshipTime, RenewonCallTime and LeaseManagerPollTime? ... 158
Which config file has all the supported channels/protocol ? ... 159
How can you specify remoting parameters using Config files ? ... 160
Can Non-Default constructors be used with Single Call SAO? ... 162
Twist :- What are the limitation of constructors for Single call SAO ? ... 162
How can we call methods in remoting Asynchronously ? ... 163
What is Asynchronous One-Way Calls ? ... 163
What is marshalling and what are different kinds of marshalling ? ... 163
What is ObjRef object in remoting ? ... 164
What is a Web Service ? ... 164
What is UDDI ? ... 165
What is DISCO ? ... 165
What is WSDL? ... 165
What the different phase/steps of acquiring a proxy object in Webservice ? ... 165
Following are the different steps needed to get a proxy object of a webservice at the client side :- 165 What is file extension of Webservices ? ... 166
Which attribute is used in order that the method can be used as WebService ? ... 167
What are the steps to create a webservice and consume it ? ... 167
Do webservice have state ? ... 176
5. Caching Concepts ... 178
What is an application object ? ... 178
What’s the difference between Cache object and application object ? ... 178
How can get access to cache object ? ... 178
What are dependencies in cache and types of dependencies ? ... 178
What is scavenging ? ... 180
What are different types of caching using cache object of ASP.NET? ... 180
How can you cache different version of same page using ASP.NET cache o How will implement Page Fragment Caching ? ... What are ASP.NET session and compare ASP.NET session with classic A Which various modes of storing ASP.NET session ? ... Is Session_End event supported in all session modes ? ... What are the precautions you will take in order that StateServer Mode wor What are the precautions you will take in order that SQLSERVER Mode w Where do you specify session state mode in ASP.NET ? ... What are the other ways you can maintain state ? ... What are benefits and Limitation of using Hidden fields ? ... What is ViewState ? ... Does the performance for viewstate vary according to User controls ? ... What are benefits and Limitation of using Viewstate for state management How can you use Hidden frames to cache client data ? ... What are benefits and limitations of using Hidden frames? ... What are benefits and limitations of using Cookies? ... What is Query String and What are benefits and limitations of using Query
6. OOPS ...
What is Object Oriented Programming ? ... What’s a Class ? ... How can you cache different version of same page using ASP.NET cache ob How will implement Page Fragment Caching ? ... What are ASP.NET session and compare ASP.NET session with classic AS Which various modes of storing ASP.NET session ? ... Is Session_End event supported in all session modes ? ... What are the precautions you will take in order that StateServer Mode work What are the precautions you will take in order that SQLSERVER Mode wo Where do you specify session state mode in ASP.NET ? ... What are the other ways you can maintain state ? ... What are benefits and Limitation of using Hidden fields ? ... What is ViewState ? ... Does the performance for viewstate vary according to User controls ? ... What are benefits and Limitation of using Viewstate for state management? . How can you use Hidden frames to cache client data ? ... What are benefits and limitations of using Hidden frames? ... What are benefits and limitations of using Cookies? ... What is Query String and What are benefits and limitations of using Query S6. OOPS ...
What is Object Oriented Programming ? ... What’s a Class ? ... What’s an Object ? ... How can you cache different version of same page using ASP.NET cache object ? ... 180How can you cache different version of same page using ASP.NET cache object How will implement Page Fragment Caching ? ... What are ASP.NET session and compare ASP.NET session with classic ASP s Which various modes of storing ASP.NET session ? ... Is Session_End event supported in all session modes ? ... What are the precautions you will take in order that StateServer Mode work pro What are the precautions you will take in order that SQLSERVER Mode work p Where do you specify session state mode in ASP.NET ? ... What are the other ways you can maintain state ? ... What are benefits and Limitation of using Hidden fields ? ... What is ViewState ? ... Does the performance for viewstate vary according to User controls ? ... What are benefits and Limitation of using Viewstate for state management? ... How can you use Hidden frames to cache client data ? ... What are benefits and limitations of using Hidden frames? ... What are benefits and limitations of using Cookies? ... What is Query String and What are benefits and limitations of using Query Strin. OOPS ...
What is Object Oriented Programming ? ... What’s a Class ? ... How will implement Page Fragment Caching ? ... 181What are ASP.NET session and compare ASP.NET session with classic ASP session variables? 181 Which various modes of storing ASP.NET session ? ... Is Session_End event supported in all session modes ? ... What are the precautions you will take in order that StateServer Mode w What are the precautions you will take in order that SQLSERVER Mode Where do you specify session state mode in ASP.NET ? ... What are the other ways you can maintain state ? ... What are benefits and Limitation of using Hidden fields ? ... What is ViewState ? ... Does the performance for viewstate vary according to User controls ? .... What are benefits and Limitation of using Viewstate for state manageme How can you use Hidden frames to cache client data ? ... What are benefits and limitations of using Hidden frames? ... What are benefits and limitations of using Cookies? ... Which various modes of storing ASP.NET session ? ... 181
Is Session_End event supported in all session modes ? ... 182Is Session_End event supported in all session modes ? ... What are the precautions you will take in order that StateServer Mod What are the precautions you will take in order that SQLSERVER M Where do you specify session state mode in ASP.NET ? ... What are the other ways you can maintain state ? ... What are benefits and Limitation of using Hidden fields ? ... What is ViewState ? ... Does the performance for viewstate vary according to User controls What are benefits and Limitation of using Viewstate for state manag How can you use Hidden frames to cache client data ? ... What are benefits and limitations of using Hidden frames? ... What are benefits and limitations of using Cookies? ... What is Query String and What are benefits and limitations of using
. OOPS ...
What is Object Oriented Programming ? ... What’s a Class ? ... What’s an Object ? ... What is the relation between Classes and Objects ? ... What are different properties provided by Object-oriented systems ? . wist :- Can you explain different properties of Object Oriented Syste ote:- Difference between abstraction and encapsulation is one of th and quiet confusing as both the terminology look alike. Best is if y What are the precautions you will take in order that StateServer Mode work properly ? ... 182What are the precautions you will take in order that SQLSERVER Mode work properly ? ... 182
Where do you specify session state mode in ASP.NET ? ... 183
What are the other ways you can maintain state ? ... 183
What are benefits and Limitation of using Hidden fields ? ... 183
What is ViewState ? ... 184
Does the performance for viewstate vary according to User controls ? ... 184
What are benefits and Limitation of using Viewstate for state management? ... 184
How can you use Hidden frames to cache client data ? ... 185How can you use Hidden frames to cache client data ? ... What are benefits and limitations of using Hidden frames? ... What are benefits and limitations of using Cookies? ... What is Query String and What are benefits and limitations of using Query String
. OOPS ...
What is Object Oriented Programming ? ... What’s a Class ? ... What’s an Object ? ... What are benefits and limitations of using Hidden frames? ... 185What are benefits and limitations of using Cookies? ... 186
What is Query String and What are benefits and limitations of using Query Strings? ... 186
6. OOPS ... 200
What is Object Oriented Programming ? ... 200
What’s a Class ? ... 200
What’s an Object ? ... 200
What is the relation between Classes and Objects ? ... 200
What are different properties provided by Object-oriented systems ? ... 200
Twist :- Can you explain different properties of Object Oriented Systems? ... 200
Note:- Difference between abstraction and encapsulation is one of the favorite interview question and quiet confusing as both the terminology look alike. Best is if you can brainstorm with your friends or do a little reading. ... 200
Twist :- What is difference between Association, Aggregation and Inheritance relationships? ... 201
How can we acheive inheritance in VB.NET ? ... 202
What are abstract classes ? ... 203
What is a Interface ? ... 205
What is difference between abstract classes and interfaces? ... 207
What is a delegate ? ... 207
What are events ? ... 208
Do events have return type ? ... 210
Can event’s have access modifiers ? ... 210
Can we have shared events ? ... 210
What is shadowing ? ... 210
What is the difference between Shadowing and Overriding ? ... 211
What is the difference between delegate and events? ... 211
If we inherit a class do the private variables also get inherited ? ... 212
What are the different accessibility levels defined in .NET ? ... 212
Can you prevent a class from overriding ? ... 212
What are similarities between Class and structure ? ... 213
What is the difference between Class and structure’s ? ... 213t is the difference between Class and structure’s ? ... t does virtual keyword mean ? ... t are shared (VB.NET)/Static(C#) variables? ... t is Dispose method in .NET ? ... t is the use of “OverRides” and “Overridable” keywords ? ... re are all .NET Collection classes located ? ... t is ArrayList ? ... t’s a HashTable ? ... :- What’s difference between HashTable and ArrayList ? ... t are queues and stacks ? ... t is ENUM ? ... t is nested Classes ? ... What does virtual keyword mean ? ... 213What does virtual keyword mean ? ... What are shared (VB.NET)/Static(C#) variables? ... What is Dispose method in .NET ? ... What is the use of “OverRides” and “Overridable” keywords ? ... Where are all .NET Collection classes located ? ... What is ArrayList ? ... What’s a HashTable ? ... wist :- What’s difference between HashTable and ArrayList ? ... What are queues and stacks ? ... What is ENUM ? ... What is nested Classes ? ... hat is Operator Overloading in .NET? ... In below sample code if we create a object of class2 which construct hat is the significance of Finalize method in .NET? ... at does virtual keyword mean ? ... at are shared (VB.NET)/Static(C#) variables? ... at is Dispose method in .NET ? ... at is the use of “OverRides” and “Overridable” keywords ? ... ere are all .NET Collection classes located ? ... at is ArrayList ? ... at’s a HashTable ? ... t :- What’s difference between HashTable and ArrayList ? ... at are queues and stacks ? ... at is ENUM ? ... at is nested Classes ? ... t is Operator Overloading in .NET? ... elow sample code if we create a object of class2 which constructor will t is the significance of Finalize method in .NET? ... is it preferred to not use finalize for clean up? ... can we suppress a finalize method? ... t is the use of DISPOSE method? ... do I force the Dispose method to be called automatically, as clients can ethod? ... hat instances you will declare a constructor to be private? ... we have different access modifiers on get/set methods of a property ? .... s virtual keyword mean ? ... shared (VB.NET)/Static(C#) variables? ... ispose method in .NET ? ... e use of “OverRides” and “Overridable” keywords ? ... all .NET Collection classes located ? ... rrayList ? ... HashTable ? ... hat’s difference between HashTable and ArrayList ? ... queues and stacks ? ... NUM ? ... ested Classes ? ... perator Overloading in .NET? ... sample code if we create a object of class2 which constructor e significance of Finalize method in .NET? ... referred to not use finalize for clean up? ... s virtual keyword mean ? ... shared (VB.NET)/Static(C#) variables? ... ispose method in .NET ? ... e use of “OverRides” and “Overridable” keywords ? ... all .NET Collection classes located ? ... rrayList ? ... HashTable ? ... hat’s difference between HashTable and ArrayList ? ... queues and stacks ? ... NUM ? ... ested Classes ? ... perator Overloading in .NET? ... sample code if we create a object of class2 which constructor wil e significance of Finalize method in .NET? ... referred to not use finalize for clean up? ... What are shared (VB.NET)/Static(C#) variables? ... What is Dispose method in .NET ? ... What is the use of “OverRides” and “Overridable” keywords ? ... Where are all .NET Collection classes located ? ... What is ArrayList ? ... What’s a HashTable ? ... Twist :- What’s difference between HashTable and ArrayList ? ... What are queues and stacks ? ... What is ENUM ? ... What is nested Classes ? ... What is Operator Overloading in .NET? ... In below sample code if we create a object of class2 which constructor will fire first What is the significance of Finalize method in .NET? ... Why is it preferred to not use finalize for clean up? ... How can we suppress a finalize method? ... What is the use of DISPOSE method? ... How do I force the Dispose method to be called automatically, as clients can forget t method? ... In what instances you will declare a constructor to be private? ... Can we have different access modifiers on get/set methods of a property ? ... If we write a goto or a return statement in try and catch block will the finally block What are shared (VB.NET)/Static(C#) variables? ... 213
What is Dispose method in .NET ? ... 215
What is the use of “OverRides” and “Overridable” keywords ? ... 215
Where are all .NET Collection classes located ? ... 215
What is ArrayList ? ... 216at is ArrayList ? ... at’s a HashTable ? ... t :- What’s difference between HashTable and ArrayList ? ... at are queues and stacks ? ... at is ENUM ? ... at is nested Classes ? ... t is Operator Overloading in .NET? ... elow sample code if we create a object of class2 which constructor wil t is the significance of Finalize method in .NET? ... is it preferred to not use finalize for clean up? ... can we suppress a finalize method? ... t is the use of DISPOSE method? ... do I force the Dispose method to be called automatically, as clients ca ethod? ... hat instances you will declare a constructor to be private? ... What’s a HashTable ? ... 216
Twist :- What’s difference between HashTable and ArrayList ? ... 216
What are queues and stacks ? ... 216
What is ENUM ? ... 216
What is nested Classes ? ... 216
What is Operator Overloading in .NET? ... 217
In below sample code if we create a object of class2 which constructor will fire first ? ... 217
What is the significance of Finalize method in .NET? ... 217
Why is it preferred to not use finalize for clean up? ... 218
How can we suppress a finalize method? ... 219
What is the use of DISPOSE method? ... 219e of DISPOSE method? ... e the Dispose method to be called automatically, as clients c ... ces you will declare a constructor to be private? ... ifferent access modifiers on get/set methods of a property ? . oto or a return statement in try and catch block will the fina er ? ... tatic indexer in C# ? ... here are multiple catch blocks so can it happen that two catc ifference between System.String and System.StringBuilder c
ET ...
equence in which ASP.NET events are processed ? ... t are the controls fully loaded ? ... How do I force the Dispose method to be called automatically, as clients can forget to call Dispose method? ... 220In what instances you will declare a constructor to be private? ... 220
Can we have different access modifiers on get/set methods of a property ? ... 221
If we write a goto or a return statement in try and catch block will the finally block execute ? .... 221
What is Indexer ? ... 221
Can we have static indexer in C# ? ... 221e have static indexer in C# ? ... ogram there are multiple catch blocks so can it happen that two catch bl 1 is the difference between System.String and System.StringBuilder class
SP.NET ...
’ is the sequence in which ASP.NET events are processed ? ... ich event are the controls fully loaded ? ... can we identify that the Page is PostBack ? ... In a program there are multiple catch blocks so can it happen that two catch blocks are executed ? 221 What is the difference between System.String and System.StringBuilder classes? ... 2217. ASP.NET ... 222
What’ is the sequence in which ASP.NET events are processed ? ... 222quence in which ASP.NET events are processed ? ... t are the controls fully loaded ? ... entify that the Page is PostBack ? ... .NET maintain state in between subsequent request ? .... bubbling ? ... In which event are the controls fully loaded ? ... 222
How can we identify that the Page is PostBack ? ... 222
How does ASP.NET maintain state in between subsequent request ? ... 222
What is event bubbling ? ... 222
How do we assign page specific attributes ? ... 223
Administrator wants to make a security check that no one has tampered with ViewState, how can he ensure this ? ... 223
What is the use of @ Register directives ? ... 223
What’s the use of SmartNavigation property ? ... 223
What is AppSetting Section in “Web.Config” file ? ... 223
Where is ViewState information stored ? ... 223
What is the use of @ OutputCache directive in ASP.NET? ... 224
How can we create custom controls in ASP.NET ? ... 224
How many types of validation controls are provided by ASP.NET ? ... 224
What’s the use of “GLOBAL.ASAX” file ? ... 225
What is the difference between “Web.config” and “Machine.Config” ? ... 225
What is a SESSION and APPLICATION object ? ... What is the difference between Server.Transfer and response.Redirec What is the difference between Authentication and authorization? ... What is impersonation in ASP.NET ? ... Can you explain in brief how the ASP.NET authentication process w What are the various ways of authentication techniques in ASP.NET? How does authorization work in ASP.NET? ... What’s difference between Datagrid, Datalist and repeater ? ... From performance point of view how do they rate ? ... What is the method to customize columns in DataGrid? ... How can we format data inside DataGrid? ... How to decide on the design consideration to take a Datagrid, datali Difference between ASP and ASP.NET? ... What are major events in GLOBAL.ASAX file ? ... What order they are triggered ? ... Do session use cookies ? ... How can we force all the validation control to run ? ... How can we check if all the validation control are valid and proper ? . If client side validation is enabled in your Web page, does that mean Which JavaScript file is referenced for validating the validators at the How to disable client side script in validators? ... What is a SESSION and APPLICATION object ? ... What is the difference between Server.Transfer and response.Redirect ? ... What is the difference between Authentication and authorization? ... What is impersonation in ASP.NET ? ... Can you explain in brief how the ASP.NET authentication process works? ... What are the various ways of authentication techniques in ASP.NET? ... How does authorization work in ASP.NET? ... What’s difference between Datagrid, Datalist and repeater ? ... From performance point of view how do they rate ? ... What is the method to customize columns in DataGrid? ... How can we format data inside DataGrid? ... What is a SESSION and APPLICATION object ? ... 226
What is the difference between Server.Transfer and response.Redirect ? ... 226
What is the difference between Authentication and authorization? ... 226
What is impersonation in ASP.NET ? ... Can you explain in brief how the ASP.NET authentication process works? . What are the various ways of authentication techniques in ASP.NET? ... How does authorization work in ASP.NET? ... What’s difference between Datagrid, Datalist and repeater ? ... From performance point of view how do they rate ? ... What is the method to customize columns in DataGrid? ... How can we format data inside DataGrid? ... How to decide on the design consideration to take a Datagrid, datalist or r Difference between ASP and ASP.NET? ... What are major events in GLOBAL.ASAX file ? ... What order they are triggered ? ... What is impersonation in ASP.NET ? ... 227
Can you explain in brief how the ASP.NET authentication process works? ... 227
What are the various ways of authentication techniques in ASP.NET? ... How does authorization work in ASP.NET? ... What’s difference between Datagrid, Datalist and repeater ? ... From performance point of view how do they rate ? ... What is the method to customize columns in DataGrid? ... How can we format data inside DataGrid? ... How to decide on the design consideration to take a Datagrid, datalist or re Difference between ASP and ASP.NET? ... What are major events in GLOBAL.ASAX file ? ... What order they are triggered ? ... Do session use cookies ? ... How can we force all the validation control to run ? ... How can we check if all the validation control are valid and proper ? ... If client side validation is enabled in your Web page, does that mean server Which JavaScript file is referenced for validating the validators at the client How to disable client side script in validators? ... How can I show the entire validation error message in a message box on the You find that one of your validation is very complicated and does not fit in a what will you do ? ... What is Tracing in ASP.NET ? ... How do we enable tracing ? ... What exactly happens when ASPX page is requested from Browser? ... What are the various ways of authentication techniques in ASP.NET? ... 228
How does authorization work in ASP.NET? ... 230
What’s difference between Datagrid, Datalist and repeater ? ... 231
From performance point of view how do they rate ? ... What is the method to customize columns in DataGrid? ... How can we format data inside DataGrid? ... How to decide on the design consideration to take a Datagrid, datalist or re Difference between ASP and ASP.NET? ... What are major events in GLOBAL.ASAX file ? ... What order they are triggered ? ... Do session use cookies ? ... How can we force all the validation control to run ? ... How can we check if all the validation control are valid and proper ? ... If client side validation is enabled in your Web page, does that mean server Which JavaScript file is referenced for validating the validators at the client How to disable client side script in validators? ... How can I show the entire validation error message in a message box on the You find that one of your validation is very complicated and does not fit in what will you do ? ... What is Tracing in ASP.NET ? ... How do we enable tracing ? ... What exactly happens when ASPX page is requested from Browser? ... How can we kill a user session ? ... How do you upload a file in ASP.NET ? ... From performance point of view how do they rate ? ... 232
What is the method to customize columns in DataGrid? ... 232
How can we format data inside DataGrid? ... 232
How to decide on the design consideration to take a Datagrid, datalist or repeater ? ... 232
Difference between ASP and ASP.NET? ... 232
What are major events in GLOBAL.ASAX file ? ... What order they are triggered ? ... Do session use cookies ? ... How can we force all the validation control to run ? ... How can we check if all the validation control are valid and proper ? ... If client side validation is enabled in your Web page, does that mean server sid Which JavaScript file is referenced for validating the validators at the client sid How to disable client side script in validators? ... How can I show the entire validation error message in a message box on the cli You find that one of your validation is very complicated and does not fit in any what will you do ? ... What is Tracing in ASP.NET ? ... How do we enable tracing ? ... What exactly happens when ASPX page is requested from Browser? ... How can we kill a user session ? ... How do you upload a file in ASP.NET ? ... How do I send email message from ASP.NET ? ... What are different IIS isolation levels? ... What are major events in GLOBAL.ASAX file ? ... 234
What order they are triggered ? ... 235
Do session use cookies ? ... 236
How can we force all the validation control to run ? ... 236
How can we check if all the validation control are valid and proper ? ... 236
If client side validation is enabled in your Web page, does that mean server side code is not run? 236 Which JavaScript file is referenced for validating the validators at the client side ?... 236
How to disable client side script in validators? ... 237
How can I show the entire validation error message in a message box on the client side? ... 237
You find that one of your validation is very complicated and does not fit in any of the validators, what will you do ? ... 237
What is Tracing in ASP.NET ? ... 238
How do we enable tracing ? ... 238
What exactly happens when ASPX page is requested from Browser? ... 238
How can we kill a user session ? ... 242
How do you upload a file in ASP.NET ? ... 243
How do I send email message from ASP.NET ? ... 243
What are different IIS isolation levels? ... 243
ASP used STA threading model, what is the threading model used for ASP.NET ? ... 245
What is the use of <%@ page aspcompat=true %> attribute ? ... 245
Explain the differences between Server-side and Client-side code? ... 246
Can you explain Forms authentication in detail ? ... 246
How do I sign out in forms authentication ? ... 248
If cookies are not enabled at browser end does form Authentication work? ... 248
How to use a checkbox in a datagrid? ... 248
What are the steps to create a windows service in VB.NET ? ... 249
What is the difference between “Web farms” and “Web garden”? ... 250
How do we configure “WebGarden”? ... 253
What is the main difference between Gridlayout and FlowLayout ? ... 256
8..NET Architecture ... 257
What is MVC pattern? ... 261
Twist: - How can you implement MVC pattern in ASP.NET? ... 261- How can you implement MVC pattern in ASP.NET? ... an we implement singleton pattern in .NET? ... o you implement prototype pattern in .NET? ... - How to implement cloning in .NET ? What is shallow copy and deep co re the situations you will use a Web Service and Remoting in projects? .. u give a practical implementation of FAÇADE patterns? ... an we implement observer pattern in .NET? ... s three tier architecture? ... ou ever worked with Microsoft Application Blocks, if yes then which? .. s Service Oriented architecture? ... re different ways you can pass data between tiers? ... s Windows DNA architecture? ... an you implement MVC pattern in ASP.NET mplement singleton pattern in .NET? ... plement prototype pattern in .NET? ... o implement cloning in .NET ? What is shal ituations you will use a Web Service and Re a practical implementation of FAÇADE patt implement observer pattern in .NET? ... tier architecture? ... r worked with Microsoft Application Blocks e Oriented architecture? ... rent ways you can pass data between tiers? How can we implement singleton pattern in .NET? ... 263
How do you implement prototype pattern in .NET? ... 264
Twist: - How to implement cloning in .NET ? What is shallow copy and deep copy ? ... 264
What are the situations you will use a Web Service and Remoting in projects? ... 264
Can you give a practical implementation of FAÇADE patterns? ... 264
How can we implement observer pattern in .NET? ... 266
What is three tier architecture? ... 266
Have you ever worked with Microsoft Application Blocks, if yes then which? ... 267
What is Service Oriented architecture? ... 267
What are different ways you can pass data between tiers? ... 270
What is Windows DNA architecture? ... 270
What is aspect oriented programming? ...
9. ADO.NET ...
What is the namespace in which .NET has the data functionality classes ? ... Can you give a overview of ADO.NET architecture ? ... What are the two fundamental objects in ADO.NET ? ... What is difference between dataset and datareader ? ... What are major difference between classic ADO and ADO.NET ? ... What is the use of connection object ? ... What is the use of command objects and what are the methods provided by the co What is aspect oriented programming? ... 2729. ADO.NET ... 281
What is the namespace in which .NET has the data functionality classes ? ... 281
Can you give a overview of ADO.NET architecture ? ... 281
What are the two fundamental objects in ADO.NET ? ... 283
What is difference between dataset and datareader ? ... 283
What are major difference between classic ADO and ADO.NET ? ... 283
What is the use of connection object ? ... 283e use of connection object ? ... e use of command objects and what are the methods provided b e use of dataadapter ? ... What is the use of command objects and what are the methods provided by the command object ? 284 What is the use of dataadapter ? ... 284
What are basic methods of Dataadapter ? ... 284
What is Dataset object? ... 285
What are the various objects in Dataset ? ... 285
How can we connect to Microsoft Access , Foxpro , Oracle etc ? ... 285can we connect to Microsoft Access , Foxpro , Oracle etc ? ... do we connect to SQL SERVER, which namespace do we use ? ... do we use stored procedure in ADO.NET and how do we provide parame ocedures? ... can we force the connection object to close after my datareader is closed t to force the datareader to return only schema of the datastore rather than can we fine tune the command object when we are expecting a single row 2 How do we connect to SQL SERVER, which namespace do we use ? ... 286
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures? ... 291
we use stored procedure in ADO.NET and how do we provide para dures? ... we force the connection object to close after my datareader is close force the datareader to return only schema of the datastore rather t we fine tune the command object when we are expecting a single r How can we force the connection object to close after my datareader is closed ? ... 292
I want to force the datareader to return only schema of the datastore rather than data ? ... 292
How can we fine tune the command object when we are expecting a single row or a single value ? 292 Which is the best place to store connectionstring in .NET projects ? ... 292
What are the steps involved to fill a dataset ? ... 293
Twist :- How can we use dataadapter to fill a dataset ? ... 293
What are the various methods provided by the dataset object to generate XML? ... 294
How can we save all data from dataset ? ... 294
How can we check that some changes have been made to dataset since it was loaded ? ... 295
Twist :- How can we cancel all changes done in dataset ? How do we get values which are changed in a dataset ? ... 295
How can we add/remove row’s in “DataTable” object of “DataSet” ? ... 295
What is basic use of “DataView” ? ... 296
How can we load multiple tables in a DataSet ? ... 297
How can we add relation’s between table in a DataSet ? ... 298
What is the use of CommandBuilder ? ... 298
What’s difference between “Optimistic” and “Pessimistic” locking ? ... How many ways are there to implement locking in ADO.NET ? ... How can we perform transactions in .NET? ... What is difference between Dataset. clone and Dataset. copy ? ... Can you explain the difference between an ADO.NET Dataset and an ADO Recor ... Explain in detail the fundamental of connection pooling? ... What is Maximum Pool Size in ADO.NET Connection String? ... How to enable and disable connection pooling? ...
10. SQL SERVER ...
What is normalization? What are different types of normalization? ... What is denormalization ? ... What is a candidate key ? ... What are the different types of joins? What is the difference between them ? ... What are indexes? What is the difference between clustered and nonclustered inde How can you increase SQL performance ? ... What is the use of OLAP ? ... What is a measure in OLAP ? ... What are dimensions in OLAP ? ... What are levels in dimensions ? ... What are fact tables and dimension tables in OLAP ? ... Twist :- Can you explain the star schema for OLAP ? ... What is DTS? ... What’s difference between “Optimistic” and “Pessimistic” locking ? ... 298How many ways are there to implement locking in ADO.NET ? ... How can we perform transactions in .NET? ... What is difference between Dataset. clone and Dataset. copy ? ... Can you explain the difference between an ADO.NET Dataset and an ADO ... Explain in detail the fundamental of connection pooling? ... What is Maximum Pool Size in ADO.NET Connection String? ... How to enable and disable connection pooling? ...
10. SQL SERVER ...
What is normalization? What are different types of normalization? ... What is denormalization ? ... What is a candidate key ? ... What are the different types of joins? What is the difference between them ? What are indexes? What is the difference between clustered and nonclustere How can you increase SQL performance ? ... What is the use of OLAP ? ... What is a measure in OLAP ? ... What are dimensions in OLAP ? ... What are levels in dimensions ? ... What are fact tables and dimension tables in OLAP ? ... How many ways are there to implement locking in ADO.NET ? ... 299How can we perform transactions in .NET? ... 299
What is difference between Dataset. clone and Dataset. copy ? ... 300
Can you explain the difference between an ADO.NET Dataset and an ADO Reco ... Explain in detail the fundamental of connection pooling? ... What is Maximum Pool Size in ADO.NET Connection String? ... How to enable and disable connection pooling? ...
10. SQL SERVER ...
What is normalization? What are different types of normalization? ... What is denormalization ? ... Can you explain the difference between an ADO.NET Dataset and an ADO Recordset? ... 300ifference between an ADO. ... fundamental of connection p ol Size in ADO.NET Conne sable connection pooling? ....VER ...
n? What are different types o ion ? ... ey ? ... t types of joins? What is the hat is the difference between e SQL performance ? ... AP ? ... OLAP ? ... in OLAP ? ... ... 300Explain in detail the fundamental of connection pooling? ... 301
What is Maximum Pool Size in ADO.NET Connection String? ... 302
How to enable and disable connection pooling? ... 302
10. SQL SERVER ...
What is normalization? What are different types of normalization? ... What is denormalization ? ... What is a candidate key ? ... What are the different types of joins? What is the difference between them ? . What are indexes? What is the difference between clustered and nonclustered How can you increase SQL performance ? ... What is the use of OLAP ? ... What is a measure in OLAP ? ... What are dimensions in OLAP ? ... What are levels in dimensions ? ... What are fact tables and dimension tables in OLAP ? ... Twist :- Can you explain the star schema for OLAP ? ... What is DTS? ... What is fillfactor ? ...10. SQL SERVER ... 303
What is normalization? What are different types of normalization? ... 303
What is denormalization ? ... 305
What is a candidate key ? ... 306
What are the different types of joins? What is the difference between them ? ... 306
What are indexes? What is the difference between clustered and nonclustered indexes? ... 307
How can you increase SQL performance ? ... 307
What is the use of OLAP ? ... 308
What is a measure in OLAP ? ... 308
What are dimensions in OLAP ? ... 308
What are levels in dimensions ? ... 309
What are fact tables and dimension tables in OLAP ? ... 309
Twist :- Can you explain the star schema for OLAP ? ... 309
What is DTS? ... 309
What is fillfactor ? ... 309
Twist :- When does page split occurs ? ... 309- When does page split occurs ? ... s RAID and how does it work ? ... s the difference between DELETE TABLE and TRU re the problems that can occur if you do not impleme What is RAID and how does it work ? ... 310
What is the difference between DELETE TABLE and TRUNCATE TABLE commands? ... 311
What are the problems that can occur if you do not implement locking properly in SQL SERVER ? 311 What are different transaction levels in SQL SERVER? ... 312
Twist :- What are different types of locks in SQL SERVER ? ... 312
What are the different locks in SQL SERVER ? ... 313
Can we suggest locking hints to SQL SERVER ? ... 315
What is LOCK escalation? ... 315
What are the different ways of moving data/databases between servers and databases in SQL Server? 315 What are advantages of SQL 2000 over SQl 7.0 ? ... 316
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? ... 317
What is the difference between UNION and UNION ALL SQL syntax ? ... 317
How can you raise custom errors from stored procedure ? ... 317
What is ACID fundamental? What are transactions in SQL SERVER ? ... 319
What is DBCC? ... 320
What is BCP utility in SQL SERVER ? ... 323
What are the different types of triggers in SQl SERVER 2000 ? ... 325
If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ? .. 326f we have multiple AFTER Triggers on table how can we define the sequence of the hat is SQl injection ? ... hat is the difference between Stored Procedure (SP) and User Defined Function (U
1. UML ...
What is UML? ... How many types of diagrams are there in UML ?... wist :- Explain in short all types of diagrams in UML ? ... What are advantages of using UML? ... wist: - What is Modeling and why UML ? ... hat is the sequence of UML diagrams in project? ... wist: - How did you implement UML in your project? ... ust a small Twist: - Do I need all UML diagrams in a project? ... ive a small brief explanation of all Elements in activity diagrams? ... Explain Different elements of a collaboration diagram ? ... Explain Component diagrams ? ... Explain all parts of a deployment diagram? ... Describe the various components in sequence diagrams? ... What are the element in State Chart diagrams ? ... What is SQl injection ? ... 326Ql injection ? ... e difference between Stored Procedure (SP) and User Defined FL ...
ML? ... y types of diagrams are there in UML ?... xplain in short all types of diagrams in UML ? ... advantages of using UML? ... hat is Modeling and why UML ? ... e sequence of UML diagrams in project? ... ow did you implement UML in your project? ... ll Twist: - Do I need all UML diagrams in a project? ... all brief explanation of all Elements in activity diagrams? ... ifferent elements of a collaboration diagram ? ... What is the difference between Stored Procedure (SP) and User Defined Function (UDF)? ... 32711. UML ... 342
What is UML? ... How many types of diagrams are there in UML ?... Twist :- Explain in short all types of diagrams in UML ? ... What are advantages of using UML? ... Twist: - What is Modeling and why UML ? ... What is the sequence of UML diagrams in project? ... Twist: - How did you implement UML in your project? ... Just a small Twist: - Do I need all UML diagrams in a project? ... Give a small brief explanation of all Elements in activity diagrams? ... Explain Different elements of a collaboration diagram ? ... Explain Component diagrams ? ... Explain all parts of a deployment diagram? ... Describe the various components in sequence diagrams? ... What are the element in State Chart diagrams ? ... Describe different elements in Static Chart diagrams ? ... Explain the different elements of a Use Case ? ... Twist: - What is the difference between Activity and sequence diagrams?(I leave thi 364
12. Project Management ...
What is project management? ... Is spending in IT projects constant through out the project? ... Who is a stakeholder ? ... Can you explain project life cycle ? ... Twist :- How many phases are there in software project ? ... Are risk constant through out the project ? ... Can you explain different software development life cycles ? ... What is UML? ... 342How many types of diagrams are there in UML ?... 342any types of diagrams are there in UML ?... - Explain in short all types of diagrams in UML ? ... are advantages of using UML? ... - What is Modeling and why UML ? ... s the sequence of UML diagrams in project? ... - How did you implement UML in your project? ... small Twist: - Do I need all UML diagrams in a project? ... small brief explanation of all Elements in activity diagrams? ... Twist :- Explain in short all types of diagrams in UML ? ... 342
What are advantages of using UML? ... 344
Twist: - What is Modeling and why UML ? ... 344
What is the sequence of UML diagrams in project? ... 344
Twist: - How did you implement UML in your project? ... 344
Just a small Twist: - Do I need all UML diagrams in a project? ... 345
Give a small brief explanation of all Elements in activity diagrams? ... 349
Explain Different elements of a collaboration diagram ? ... 351
Explain Component diagrams ? ... 352
Explain all parts of a deployment diagram? ... 354
Describe the various components in sequence diagrams? ... 356
What are the element in State Chart diagrams ? ... 358
Describe different elements in Static Chart diagrams ? ... 360
Explain the different elements of a Use Case ? ... 362
Twist: - What is the difference between Activity and sequence diagrams?(I leave this to the readers) 364
12. Project Management ... 365
What is project management? ... 365...
stant through out the proj ... ycle ? ... there in software project the project ? ... ware development life cy ... Is spending in IT projects constant through out the project? ... 365
Who is a stakeholder ? ... 366
Can you explain project life cycle ? ... 366
Twist :- How many phases are there in software project ? ... 366
Are risk constant through out the project ? ... 368
Can you explain different software development life cycles ? ... 369
Spiral Model ... 371
What is triple constraint triangle in project management ? ... 372
What is a project baselines ? ... 373
What is effort variance? ... 373
How is normally a project management plan document organized ? ... 373
How do you estimate a project? ... 373
What is CAR (Causal Analysis and Resolution)? ... 374
What is DAR (Decision Analysis and Resolution) ? ... 374
What is a fish bone diagram ? ... 374
Twist:- What is Ishikawa diagram ? ... 374
What is pareto principle ? ... 375
Twist :- What is 80/20 principle ? ... 376
What is difference between SITP and UTP in testing ? ... 376
What is the software you have used for project management? ... 376
What are the metrics followed in project management? ... 377
Twist: - What metrics will you look at in order to see the project is moving successfully? ... 377
You have people in your team who do not meet there deadlines or do not per actions you will take ? ... Twist :- Two of your resources have conflicts between them how would you s What is black box testing and White box testing? ... What’s the difference between Unit testing, Assembly testing and Regressio What is V model in testing? ... How do you start a project? ... How did you do resource allocations? ... How will you do code reviews ? ... What is CMMI? ... What are the five levels in CMMI? ... What is continuous and staged representation? ... Can you explain the process areas? ... What is SIX sigma? ... What is DMAIC and DMADV ? ... What are the various roles in Six Sigma implementation? ... What are function points? ... Twist: - Define Elementary process in FPA? ... What are the different types of elementary process in FPA? ... What are the different elements in Functions points? ... Can you explain in GSC and VAF in function points? ... You have people in your team who do not meet there deadlines or do not perform what are the actions you will take ? ... 380
Twist :- Two of your resources have conflicts between them how would you sort it out ? ... 380
What is black box testing and White box testing? ... What is black box testing and White box testing? ... 380
What’s the difference between Unit testing, Assembly testing and Regression testing? ... 381
What is V model in testing? ... How do you start a project? ... How did you do resource allocations? ... How will you do code reviews ? ... What is CMMI? ... What are the five levels in CMMI? ... What is continuous and staged representation? ... Can you explain the process areas? ... What is SIX sigma? ... What is DMAIC and DMADV ? ... What are the various roles in Six Sigma implementation? ... What are function points? ... Twist: - Define Elementary process in FPA? ... What are the different types of elementary process in FPA? ... What are the different elements in Functions points? ... Can you explain in GSC and VAF in function points? ... What are unadjusted function points and how is it calculated? ... Can you explain steps in function points? ... What is the FP per day in your current company? ... What is V model in testing? ... 383
How do you start a project? ... 386
How did you do resource allocations? ... 386
How will you do code reviews ? ... 386
What is CMMI? ... 386
What are the five levels in CMMI? ... What is continuous and staged representation? ... Can you explain the process areas? ... What are the five levels in CMMI? ... 386
What is continuous and staged representation? ... 390
Can you explain the process areas? ... 394
What is SIX sigma? ... 412
What is DMAIC and DMADV ? ... 413
What are the various roles in Six Sigma implementation? ... 414
What are function points? ... What are function points? ... 415
Twist: - Define Elementary process in FPA? ... 415
What are the different types of elementary process in FPA? ... 415
What are the different elements in Functions points? ... 415
Can you explain in GSC and VAF in function points? ... 421
What are unadjusted function points and how is it calculated? ... 423
Can you explain steps in function points? ... 424
What is the FP per day in your current company? ... 424
Twist :- What is your company’s productivity factor ? ... 424
Do you know Use Case points? ... 424o you know Use Case points? ... hat is COCOMO I, COCOMOII and COCOMOIII? ... What is SMC approach of estimation? ... ow do you estimate maintenance project and change requests? ...
3. XML ...
What is COCOMO I, COCOMOII and COCOMOIII? ... 424What is SMC approach of estimation? ... 424
How do you estimate maintenance project and change requests? ... 425
13. XML ... 426
What is XML? ... 426
What is the version information in XML? ... 426
What is ROOT element in XML? ... 426
If XML does not have closing tag will it work? ... 426
Is XML case sensitive? ... 427
What is the difference between XML and HTML? ... 427
Is XML meant to replace HTML? ... 427
Can you explain why your project needed XML? ... 427
What is DTD (Document Type definition)? ... 427
What is well formed XML? ... 427
