الاثنين، 14 أبريل 2008

interview quesetion

C# and ASP.NET Projects By Shivprasad Koirala Sham Shaikh Visit us http://www.questpond.com for free interview question ebook. Mail bpb@bol.net.in to buy the book Wri te to the author directly at shiv_koirala@yahoo.com The eBook is free but below are the limitation of this free ebook: - -- The book has only 5 projects which are far less than what the actual book contains. -- Practical Videos and code walkthrough of the projects is not available for download. -- The book also has lot of installations provided in CD even that is not available for Download. Finally hard copy is a hard copy if you are interested below are th e ways you can buy the book:- Buy directly from the Author call 09867628636. If you are buying from the Author you get a chance to meet him and believe us you will enjoy it. Please send DD of rupees 300 in favor of ( Please send us detail that you want a hard copy or Ebook CD) Shivprasad Bist E – 8 , Amar Nager , Hoechst Colony , Opposite Shriram towers Mulund West Mumbai 80. Call your city book shop MUMBAI-22078296/97/022-22070989,KOLKATA-22826518/19,HYDERABAD-24756967,24756400,BANGALORE-25587923,25584641,AHMEDABAD-26421611, BHATINA(PUNJAB)-2237387,CHENNAI-28410796,28550491,DELHI/NEWDELHI-23254990/91,23325760,26415092,24691288 Are you a Pakistani reader then contact M/s. Vanguard Books P Ltd, 45 The Mall, Lahore, Pakistan (Tel: 0092-42-7235767, 7243783 and 7243779 and Fax: 7245097) E-mail: vbl@brain.net.pk If you are not from india or pakistan : - Page 1 of 215
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,info@mlbduk.com,www.mlbduk.com mail at bpb@bol.net.in Other books written by the Shivprasad Koirala and Team Prakash books http://www.prakashbooks.com/details.php3?id=17875&c=Computer Books Amazon Page 2 of 215
http://www.amazon.co.uk/NET-Interview-Questions-Shivprasad-Koirala/dp/8183331475/sr=1-1/qid=1171080126/ref=sr_1_1/026-1891118-8556445?ie=UTF8&s=books You can buy the above book from Prakash books http://www.prakashbooks.com/details.php3?id=19008&c=Computer Books Amazon http://www.amazon.co.uk/exec/obidos/ASIN/8183331033/qid%3D1136610981/026-1344994-2263615#product-details Page 3 of 215
You can buy the above book from Prakash books http://www.prakashbooks.com/details.php3?id=23073&c=Computer%20Books If you want to buy from Amazon http://www.amazon.co.uk/JAVA- interview-Questions-Koirala-Shivprasad/dp/8183331734/ref=pd_ecc_rvi_2/203-1007750-6035147 Page 4 of 215
Page 5 of 215
Table of Contents INTRODUCTION...........................................................................................................................................................10 Dedication ................................................................................................................................................................10 Foreword ..................................................................................................................................................................10 About the authors....................................................................................................................................................10 Who should read this book ....................................................................................................................................11 Details of the book ..................................................................................................................................................11 What’s in the CD.....................................................................................................................................................12 PART I – THE FUNDAMENTALS ...........................................................................................................................13 CHAPTER 1 SDLC AND PROJECT DOCUMENTATION .......................................................................................13 What does this book target ....................................................................................................................................13 The growth of a software professional ................................................................................................................13 SDLC (Software development Life Cycle) ..........................................................................................................16 Waterfall ................................................................................................................................................................ 17 Iterative model ...................................................................................................................................................... 18 Evolutionary model ............................................................................................................................................... 19 V-model ................................................................................................................................................................ 19 Which is the best model? ...................................................................................................................................... 21 Essential documentation in projects....................................................................................................................22 UML...........................................................................................................................................................................22 Three views of the project from UML perspective............................................................................................... 23 Structure diagram.................................................................................................................................................. 23 Behavior diagram.................................................................................................................................................. 24 Model management diagram................................................................................................................................. 24 Overall Explanation of the UML diagrams........................................................................................................... 25 Class diagram........................................................................................................................................................ 25 Object diagram...................................................................................................................................................... 25 Composite structure diagram ................................................................................................................................ 25 Deployment diagram............................................................................................................................................. 26 Component diagram.............................................................................................................................................. 26 Package diagram ................................................................................................................................................... 26 Activity diagram................................................................................................................................................... 26 Use case diagram.................................................................................................................................................. 26 State machine diagram / Protocol state machine diagram .................................................................................... 26 Overview diagram................................................................................................................................................. 26 Sequence diagram ................................................................................................................................................. 26 Communication diagram....................................................................................................................................... 26 Timing diagram..................................................................................................................................................... 26 Which diagram is important.................................................................................................................................. 26 Use case diagram over view.................................................................................................................................. 27 Actors and Goals................................................................................................................................................... 27 Detail Explanation of the Use Case template ........................................................................................................ 28 Included and Extended use case............................................................................................................................ 30 Differentiate between Included use case and extended use cases?....................................................................... 32 Class diagram........................................................................................................................................................ 32 Associations in Class diagrams ............................................................................................................................. 32 Multiplicity............................................................................................................................................................ 33 Aggregation and composition............................................................................................................................... 34 Composite structure diagram ................................................................................................................................ 35 Reflexive associations........................................................................................................................................... 36 Generalization and specialization ......................................................................................................................... 36 Estimation in projects............................................................................................................................................ 37 Introduction to Function Points............................................................................................................................. 37 Basics of Function Points...................................................................................................................................... 38 Application Boundary........................................................................................................................................... 38 Page 6 of 215
Elementary Process............................................................................................................................................... 38 Dynamic and static elementary process................................................................................................................ 39 Elements of Function Points ................................................................................................................................. 39 Internal Logical Files (ILF)................................................................................................................................... 39 External Interface File (EIF) ................................................................................................................................. 40 Record Element Type (RET)................................................................................................................................ 40 DET (Data element types)..................................................................................................................................... 41 Data Communications........................................................................................................................................... 43 Distributed data p rocessing................................................................................................................................... 43 Performance .......................................................................................................................................................... 44 Heavily used configuration ................................................................................................................................... 44 On-Line data entry ................................................................................................................................................ 45 End-user efficiency ............................................................................................................................................... 46 On-Line update..................................................................................................................................................... 46 Complex processing.............................................................................................................................................. 47 Reusability ............................................................................................................................................................ 47 Installation ease..................................................................................................................................................... 48 Operational ease.................................................................................................................................................... 48 Multiple sites......................................................................................................................................................... 49 Facilitate change ................................................................................................................................................... 49 Function point template explanation...................................................................................................................63 Testing Document....................................................................................................................................................64 UPDATE ADDRESS....................................................................................................................................................65 CHAPTER 2 OOPS PRIMER....................................................................................................................................65 Why OOPs................................................................................................................................................................65 Fundamentals of OOPS..........................................................................................................................................66 Abstract classes and Interfaces.............................................................................................................................68 CHAPTER 3 UNDERSTANDING THE IDE..............................................................................................................69 The IDE.....................................................................................................................................................................69 Windows form Code walk through.......................................................................................................................72 The IIS .......................................................................................................................................................................74 Web Application Code walk through...................................................................................................................74 CHAPTER 4 DATABASES AND ADO.NET............................................................................................................81 MSDE Basics ...........................................................................................................................................................81 Difference between SQL and MSDE....................................................................................................................81 Installation of MSDE..............................................................................................................................................82 Basic SQL Commands............................................................................................................................................85 ADO.NET basics .....................................................................................................................................................86 Introducing the .NET Data Providers .................................................................................................................88 OLE DB.NET data provider..................................................................................................................................88 SQL Server.NET data provider.............................................................................................................................88 ODBC.NET data provider.....................................................................................................................................88 The Command Object .............................................................................................................................................90 The Command Object’s Methods.........................................................................................................................91 Understanding DataReader ..................................................................................................................................93 Understanding Dataset ..........................................................................................................................................95 Sample code.............................................................................................................................................................95 Microsoft Data Application blocks......................................................................................................................96 PART II – THE FUN PART.........................................................................................................................................98 INTRODUCTION TO THE FUN PART.......................................................................................................................98 CHAPTER 5 – LETS ROCK : - THE MANDELBROT PROJECT .............................................................................98 What will you learn in this project.......................................................................................................................98 Overview of Mandelbrot project...........................................................................................................................98 How to start the Mandelbrot project ................................................................................................................ 100 Code explanation.................................................................................................................................................. 101 CHAPTER 6 – FILE SEARCH MODULE ................................................................................................................ 107 What will you learn in this project.................................................................................................................... 107 Page 7 of 215
Overview of File search Application................................................................................................................ 107 Fundamentals to complete the project.............................................................................................................. 108 File System............................................................................................................................................................ 108 Threading Concepts............................................................................................................................................. 109 Delegates and event concept.............................................................................................................................. 111 Class Diagram of File search Application ...................................................................................................... 114 Code Explanation................................................................................................................................................. 115 Enhancement in File Search Project ................................................................................................................ 118 PART III – PROFESSIONAL PROJECTS.......................................................................................................... 119 CHAPTER 7 – RELIABLE COMPUTER CHAT APPLICATION .......................................................................... 119 What will you learn in this project.................................................................................................................... 119 Deliverables in CD for this Project .................................................................................................................. 119 Overview of Chat application ............................................................................................................................ 119 How to start the chat application...................................................................................................................... 120 Starters Chat code................................................................................................................................................ 120 Whats wrong with the above code..................................................................................................................... 124 Estimation of the Chat Application................................................................................................................... 125 External Input (EI) explanation......................................................................................................................... 125 External Inquiry (EQ) explanation................................................................................................................... 125 Internal Logical File (ILF) explanation........................................................................................................... 126 Explanation of Total Estimation........................................................................................................................ 127 Use Case ................................................................................................................................................................ 130 Details of the Use Case ....................................................................................................................................... 130 Caching fundamentals in ASP.NET .................................................................................................................. 132 Class diagram....................................................................................................................................................... 133 Code explanation.................................................................................................................................................. 137 Consuming the class library............................................................................................................................... 137 Auto refresh fundamentals.................................................................................................................................. 138 Login page explanation....................................................................................................................................... 139 Login button click logic....................................................................................................................................... 139 Displaying the chat message and the users..................................................................................................... 140 Change room and Send messages..................................................................................................................... 142 CHAPTER 8 – JOB S ITE APPLICATION.............................................................................................................. 143 What will you learn in this project.................................................................................................................... 143 Deliverables in CD for this Project .................................................................................................................. 143 How to load the jobsite....................................................................................................................................... 143 Overview of the Job Site Application................................................................................................................ 148 Estimation of the Job Site Application............................................................................................................. 149 Explanation of ILF ............................................................................................................................................... 149 Explanation of EIF and EO................................................................................................................................ 149 Explanation for EQ.............................................................................................................................................. 150 Explanation for EI ................................................................................................................................................ 150 Explanation for GSC ........................................................................................................................................... 150 Final Estimation................................................................................................................................................... 151 Use Case Explanation ......................................................................................................................................... 152 E-R Diagram Explanation.................................................................................................................................. 157 Architecture Explanation.................................................................................................................................... 159 Class Diagram Explanation............................................................................................................................... 161 Code Explanation................................................................................................................................................. 163 Entity collection relation ship............................................................................................................................ 163 Explanation of clsMenu and clsMenus............................................................................................................. 163 Explanation of the user class ............................................................................................................................. 164 Calling the validation bridge............................................................................................................................. 165 Explanation of the businessvalidation bridge................................................................................................. 165 Explanation of the reflection.............................................................................................................................. 166 Page 8 of 215
Explanation of Validation library..................................................................................................................... 167 Setobject to validate............................................................................................................................................. 168 Explanation of Data access................................................................................................................................ 169 Explanation of UI ................................................................................................................................................. 170 CHAPTER 9 – QUADRA CLIENT W EB SERVICES............................................................................................ 171 What will you learn in this project.................................................................................................................... 171 Deliverables in CD for this Project .................................................................................................................. 171 How to start the Quadra client .......................................................................................................................... 172 Web service Fundamentals................................................................................................................................. 173 Overview of the Quadra Client Application.................................................................................................... 178 Estimation of the Quadra Client Application.................................................................................................. 178 Use Case Explanation ......................................................................................................................................... 181 Class Diagram Explanation............................................................................................................................... 183 Setting up the quadra client webservice...........................................................Error! Bookmark not defined. Code Explanation................................................................................................................................................. 184 CHAPTER 10 – POINTS TO BE NOTED IN PROJECTS....................................................................................... 185 PROJECTS COMING UP IN SECOND EDITION.................................................................................................... 189 Call centre project ............................................................................................................................................... 189 MSC Accounting package................................................................................................................................... 190 INTERVIEW QUESTIONS....................................................................................................................................... 190 .NET Interview Questions Book......................................................................................................................... 190 SQL Server Interview Questions Book ............................................................................................................. 199 JAVA Interview Questions Book........................................................................................................................ 206 Page 9 of 215
Introduction Dedication From Shivprasad koirala This book is dedicated to my kid Sanjana, whose dad’s play time has been stolen and given to this book.I am thankful to my wife for constantly encouraging me and also to BPB Publication to give new comer a platform to perform. Finally at the top of all thanks To two old eyes my mom and dad for always blessing me. I am blessed to have Raju as my Brother who always keeps my momentum moving on. From Shaam This book is dedicated to my mom and dad for all the hard work done to see this day where I am today. Foreword From Shivprasad Koirala First thing I never thought that I will be able to complete this book. It was the worst phase of career which I had gone through.Thanks to my family to support me, give me confidence to make this book a success. This book has seen its own ups and downs to reach the final light. I started this book with one of my friends Rajesh Nair and Pravin Joshi. Rajesh nair is almost the co-author of the book. But because of their own software project dead lines they had to fall of in between. But yes that does not upset me a bit. The value they had put in the initial stages has made this book matured to a huge extent. I am also grateful to Mr. Sainath to put his experience which has brought the value of book to an elite level. Thanks to Shaam for all the effort. It was his tiresome three months of continuous writing that we have finally made it. I hope this book really serves as a good bed for freshers to make hands on and feel how projects are accomplished in international companies. About the authors Shivprasad Koirala He works in a big multinational company and has over 8 years of experience in software industry. He is working presently as project lead and in past has led projects in Banking, travel and financial sectors. But on the top of all, I am a simple developer like you all guys there doing an 8 hour job. Writing is something I do extra and I love doing it. No one is perfect and same holds true for me .So anything you want to comment, suggest, point typo / grammar mistakes or Page 10 of 215
Technical mistakes regarding the book you can mail me at shiv_koirala@yahoo.com. Believe me guys your harsh words would be received with love and treated to the top most priority. Without all you guys I am not an author. Who should read this book Developers who want to understand how project are completed using SDLC and proper documentation. Developers who want to know how estimation, use cases, requirement analysis, test cases and design documents are executed in live projects. Programmers who are looking for quick hands on projects. Senior and junior developers who are looking of how to do practical implementation of OOPS in project. Developers who are looking at practically implementing UML. Developers who are looking at how estimation is done practically in software projects. Details of the book Book has in all six projects (Job Site, Chat application, File search, Job Site client, Mandel brot and batch uploading) with three professional projects completed with proper controlled SDLC and documentation. This book will give you a three dimension view of the project i.e from the developer, architecture and project manager perspective. Full source code of all six projects with proper documentation included in the CD. All professional projects have Use cases, UML, Estimation and proper test plan. This not only makes you practically confortable from coding point but also from project point of view. There are decent videos which explain the source code and some basic fundamentals in a detail fashion thus making you comfortable for real projects. MSDE is provided in the CD so that you can exploit sql server to the maximum during database projects. Other than technical aspects this book also provides important points to be noted in the project. For instance your attitude and behavior during the project. This book shows in depth of how to increase reusability by using Microsoft Application blocks. This is excercised by using microsft data application blocks in the job site project. Interview questions to judge yourself during interview. After completing the project you would like to have a glance through the questions so that you are in a better position during .NET interviews. Threading, Session management, webservices, ADO.NET and many such features are explained with a project implementation which gives clearer idea of the subject. Page 11 of 215
Before the projects detail theory explanation of UML, Estimation, and SDLC and design documentation is provided to the reader which will make him more confortable while executing the project. Some applications are coded from two perspective one from an ok developer perspective and the other from a good programmer perspective. Thus giving two view points of the development perspective. What’s in the CD The CD has stuffs which will make you rock. Source code folder: - This folder has basically all the source code of projects present in this book. o Mandelbrot project o Windows file search project o Chat application project. o Job site project ( Quadra job site) o Job site client project ( Quadra client ) Videos folder: - This folder contains videos from the perspective of this book. Watching those videos will make you confident about the project. Below are the various videos with what they explain : - o IISPractical: - Gives a practical understanding of what exactly IIS is. o IISTheoryExplanation : - Gives you theoritcial explanation of IIS. o WindowsIDE : - Explains how to use VS.NET IDE in a efficient way. o FunctionPointTemplate : - Explains how to use the function point template for estimation. o MandelBrotCodeWalkthrough : - Explains the Mandel brot code walkthrough. o BadChatApplicationCodeWalkThrough : - Explains the bad chat code walkthrough. o StarttheJobSiteProject : - This video will help you to make job site project up and running. o JobWebSiteFunctionalWalkThrough : - Gives functionality walkthrough for the Job site application. o JobSiteCodeUnderstanding : - Gives a code walkthrough of the jobsite application. o QuadraClientExplanation : - Gives a detail functionality explanation of the quadr client project. o QuadraClientCodeUnderstaing : - Gives a code walkthrough of the quadra client code walkthrough. Note: - In the installable folder windows media player is provided in case you have issues viewing the videos. Page 12 of 215
Installable folder: - This folder contains following necessary installable required for this project. o Windows Media player and codec installable to view videos of this book. o Data access application blocks for the DAL component of the project. o MSDE 2000 Database (MSDE2000A.exe) as a database for this book. o SQL Server 2000 Evaluation version. This software is in the CD so that we can install the SQL Client to connect to MSDE 2000. Part I – The fundamentals

ليست هناك تعليقات: