.NET INTERVIEW QUESTIONS

_______________________________________________________________________________________________________ Su****d Interview questions. 2-Oct-2009 _______________________________________________________________________________________________________ 1) What kind of OOP’s used in your project? 2) What is constructor overloading ? 3) What is private constructor ? 4) Explain your projects technically ? 5) What is viewstate and sessions ? 6) If there are two interfaces I1 & I2 Interface I1:I2 { .. } Interface I2 { .. } What if        Class A : I1 { …… } Class A : I1 :I2{ …… } 7)Explain features of ASP.NET 2.0 8)Diffrence betwwen Abstract class and Interface ? 9) Explain Exception Handling ? 10) Explain How can achieve custome exception ? 11) Explain execution of catch block? 12) Tell me sequence of IOException Filenot found exception Exception 13)What if exception occur in Finally block? Catch { … } Finally{ ! Exceptoin Occur } How to handle ? 14) Explain Access Modifires in C#? 15)What is iterator? 16)When we defined Internal variable and Protected Internal variable which variable can be accessible in derived class? 17) ASP.NET page life cycle or Whan viewastate data acctually loaded ? 18)What is Generics? SQL 1) Explain     all joins? 2) Can we use INNER JOIN and OUTER JOIN in one query? 3)    Diffrence between inner join and outer join? 4)Any use of SQL Other than simple queries ? 5) What is view , how it works ? 6)  What is stored Procedure and how can call a stored procedure from stored procedure? 7) Jot down how to return out parameter from stored procedure ? 8) Explain Transaction management in SQL ? 9) Which side is best for transaction management , In SQL or Program ? Expain Why? _______________________________________________________________________________________________________ 17_Sep_2009 Questions _______________________________________________________________________________________________________ Explain ADO in VB 6? Vb Connection working behind? Locking types in VB? Serialization concept? Discconected architechture in VB? How to maintain state in ASP.NET ? Tell me about Cookies,Session etc. Expain SQL Joins? Types of Cursors? What is API? how API works? Expain youself? Family background? Reason for job change? _______________________________________________________________________________________________________ Ni****nt Interview Questions _______________________________________________________________________________________________________ HR Explain yourself? Explain your family in brief Define your relationship with existing company Expain your dependency in company? Technical Round 1 C# and .NET interview question which file is created when main method is called is c#? What is partial class? How can be partial class will used from diffrent geographical location? What is XML? How can xml authunticated from client side? What is Webservice and proxy for webservice? what is diffrence betwwen 1.0,1.1,2.0,3.0,3.5,4.0? What is diffrence between machine.config and web.config SQL What is SQL views? What is Stored procedures? What is temp table? What is global temp table ? What are diffrent types of indexes? HTML 1)Can we do html pagging.if yes please do. 2)Differentiate web 2.0. with web 1.0 3)What is Semantic HTML? _______________________________________________________________________________________________________ Interview Question for Software engineer _______________________________________________________________________________________________________ SQL Table      Exam Column    Student        John        Mike        Bob        Lisa        Mary Marks        97                  82            76           91            76 A) 1. Write a SQL to return the name of student who scored max marks B) 2. Write a SQL to return the name of stident who scored 2nd higest marks. C) 3. Logic from 1 st jan 2009 to 31st mar 2009, how many days are weekends? e.g. between 15th aug anf 25th aug 4 days are weekends wrtie code in any programming language. D)    SQL Employee            John    Mike    Bob        Lisa Supervisor          Mike    Bob      blank    Mary .NET/SQL write code to draw/plot the employee tree? E)    Table     Ranins Column     Months        3    4     5       6       7         8 Rainfall     5    10    50    80    200    250 SQL how many months had rainfalls less than the annual average? F).NET Without using SQL,Code the logic as above c/c++/VB any language Write one paragraph each about the following G)    1    When to use SQL views? H)    2    When to use SQL Stored procedures? I)    3    When to use SQL Inline Tables? J)    4    When to use SQL Temp tables? K)    5    What are diffrent types of indexes? L)    6    What method of Data Adapter is used fill Dataset? M)    7    What are Satellite Assembilies? N)    Why are looking for new job? O)    What are your favourite TV channels and TV shows? and why? J)    Tell us about your family _______________________________________________________________________________________________________ ASP .Net Page Life Cycle

1. Page Request2. Start 3. Page Initialization 4. Load 5. Validation 6. Postback and event Handling 7. Rendering 8. Unload For The Page Execution Life Cycle Just Remember SILVER. S-Start I-Page Initialization L-Load V-Validation E-Postback event handling R-Rendering _______________________________________________________________________________________________________